Project and Portfolio Management Practitioners Forum
cancel

Import Users Report not importing and error message shown after upgrade to 9.12

Highlighted
cat_gon0208
Trusted Contributor.

Import Users Report not importing and error message shown after upgrade to 9.12

Dear All,

 

We have recently upgraded from 7.5 to 9.12, we are getting 0 count and errors when running Import Users report.

 

Here is the information from the SERVERLOG and the report log

 

SERVERLOG

 

Caused by: DfException:: THREAD: TP-Processor8; MSG: [DM_QUERY_E_BAD_GROUP_SAVE]error:  "CREATE or ALTER GROUP:  Unable to save the group."; ERRORCODE: 100; NEXT: DfException:: THREAD: TP-Processor8; MSG: [DM_GROUP_E_CANT_ADD_USER_TWICE]error:  "Cannot add user NKELLEY to the ppm_dynamic_group group more than once."; ERRORCODE: 100; NEXT: null
 at com.kintana.dms.server.tools.DocumentumUtil.executeQuery(DocumentumUtil.java:1043)
 at com.kintana.dms.server.tools.DocumentumUtil.addUserIntoDynamicGroup(DocumentumUtil.java:785)
 at com.kintana.dms.documentum.DMSDocumentumDriver.getNewConnection(DMSDocumentumDriver.java:513)
 ... 18 more

 Filtered Out 163 Stack Trace Lines.
STATUS server:ppmLightServiceListenerContainer-1:com.kintana.core.scheduler:2012/06/19-01:30:13.737 SGT: These tasks are executed on: Tue Jun 19 01:30:13 SGT 2012
nextTime = null
 SCHEDULED_TASK_ID WORKER_CLASS     SCHEDULED_TIME  TASK_DATA_ID GROUP_ID SCHEDULED_TASK_RECUR_ID
 37055   com.kintana.core.server.scheduler.ReportSubmissionWorkerThread 2012-06-19 01:30:00.0 58808  null  null

STATUS server:ppmLightServiceListenerContainer-2:com.kintana.core.scheduler:2012/06/19-01:40:13.311 SGT: These tasks are executed on: Tue Jun 19 01:40:13 SGT 2012
nextTime = null
 SCHEDULED_TASK_ID WORKER_CLASS     SCHEDULED_TIME  TASK_DATA_ID GROUP_ID SCHEDULED_TASK_RECUR_ID
 37056   com.kintana.core.server.scheduler.ReportSubmissionWorkerThread 2012-06-19 01:40:00.0 58833  null  null

STATUS server:ppmLightServiceListenerContainer-2:com.kintana.core.scheduler:2012/06/19-01:50:13.040 SGT: These tasks are executed on: Tue Jun 19 01:50:13 SGT 2012
nextTime = null
 SCHEDULED_TASK_ID WORKER_CLASS     SCHEDULED_TIME  TASK_DATA_ID GROUP_ID SCHEDULED_TASK_RECUR_ID
 37057   com.kintana.core.server.scheduler.ReportSubmissionWorkerThread 2012-06-19 01:50:00.0 58834  null  null

STATUS server:ppmLightServiceListenerContainer-1:com.kintana.core.scheduler:2012/06/19-02:00:13.900 SGT: These tasks are executed on: Tue Jun 19 02:00:13 SGT 2012
nextTime = null
 SCHEDULED_TASK_ID WORKER_CLASS     SCHEDULED_TIME  TASK_DATA_ID GROUP_ID SCHEDULED_TASK_RECUR_ID
 30160   com.kintana.core.server.scheduler.ReportSubmissionWorkerThread 2012-06-19 02:00:00.0 58835  null  null

STATUS server:com.kintana.core.server.execution.ReportExecutionManager Batch ID: 2062878:SystemOut:2012/06/19-02:00:16.726 SGT: CheckUserLicense command
STATUS server:com.kintana.core.server.execution.ReportExecutionManager Batch ID: 2062878:SystemOut:2012/06/19-02:00:16.726 SGT: com.kintana.core.server.tools.CheckUserLicense "[TEMP_GROUP_ID]" -licenseList ""
STATUS server:com.kintana.core.server.execution.ReportExecutionManager Batch ID: 2062878:SystemOut:2012/06/19-02:00:16.727 SGT: tokens: 2

 

REPORTLOG

The following Command Step is not subject to timing out: com.kintana.core.server.execution.CLSetCommand

 

KSC Set

 

Source Command:Set the temp token

 

TEMP_GROUP_ID=32456

Succeeded

The following Command Step is not subject to timing out: com.kintana.core.server.tools.LdapPopulateInterfaceTable

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The page size for search results will be: -1

Importing records who satisfy the search filter: (uid=*)

The following Command Step is not subject to timing out: com.kintana.core.server.execution.CLStoreCommand

 

KSC Store

 

Source Command:Import users from LDAP server who satisfy the search filter

 

P_GROUP_ID="55025", "55025"

The following Command Step is not subject to timing out: com.kintana.core.server.execution.CLStoreCommand

 

KSC Store

 

Source Command:Import users from LDAP server who satisfy the search filter

 

P_SOURCE_CODE="LDAP_IMPORT", "LDAP_IMPORT"

Executing PL/SQL procedure KNTA_USER_INT.Run_Derive_And_Validate

Done executing PL/SQL procedure KNTA_USER_INT.Run_Derive_And_Validate

Out parameter p_group_id:  value: 55025 sqlType: INTEGER

Out parameter o_message_type:  value: 0 sqlType: INTEGER

Out parameter o_message_name:  value: null sqlType: VARCHAR

Out parameter o_message:  value: null sqlType: VARCHAR

The following Command Step is not subject to timing out: com.kintana.core.server.tools.CheckUserLicense

 

Num users adding 0 (KNTA-10654)

 

Source Command:Check for License

 

The following Command Step is not subject to timing out: com.kintana.core.server.tools.PasswordInterfaceTable

Executing PL/SQL procedure KNTA_USER_INT.Run_Import

Done executing PL/SQL procedure KNTA_USER_INT.Run_Import

Out parameter p_group_id:  value: 55025 sqlType: INTEGER

Out parameter o_message_type:  value: 0 sqlType: INTEGER

Out parameter o_message_name:  value: null sqlType: VARCHAR

Out parameter o_message:  value: null sqlType: VARCHAR

Running report/web/knta/sc/rpt/ImportUsers.jsp

Posting report request tohttp://10.99.5.179:8080/itg/servlet/RunJspReport

Post data= 'REPORT_JSP=%2Fweb%2Fknta%2Fsc%2Frpt%2FImportUsers.jsp&OUT_BASEFILE=rep_58835&USER_ID=30185&REPORT_ID=58835&KEYID=74860&KEY=1065361763'

Writing report fileD:\PPM\reports\rep_58835.html

Report request completed successfully with HTTP response code200

 

CL Local Exec

 

Source Command:Update Ldap Last Synch Timestamp

 

C:/oracle/Ora11202/bin/sqlplus.exe ppm_fit/#!#*****#!#@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=s-oscardb001p)(PORT=1700)))(CONNECT_DATA=(SERVICE_NAME=OSR1))) @./scripts/kntarpt_update_ldap_last_synch.sql "20120618180016Z" "30185"

 

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 19 02:00:25 2012

 

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

old   4: SET formatted_date = '&l_time_stamp',

new   4: SET formatted_date = '20120618180016Z',

old   6:     last_updated_by = to_number('&l_user_id'),

new   6:     last_updated_by = to_number('30185'),

 

PL/SQL procedure successfully completed.

 

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

exit code = 0

The following Command Step is not subject to timing out: com.kintana.core.server.execution.FlushCacheCommand

 

KSC Flush Cache

 

Source Command:Flush User Cache

 

Cache name:  user

Targets:  ALL