It's all about the answers!

Ask a question

dataMovementTasks problems


Nikolaus Utomo (113) | asked Feb 15 '11, 6:34 a.m.
Hello all,

I have problems when running the dataMovementTasks on insight 1.0.0.2. I schedule my Insight to run the dataMovementTasks everyday on 8pm. It took about 2 or 3 hours to finish the process. However all the result of the process are failed. I got this error message:

February 14, 2011 8:00:03 PM February 14, 2011 8:00:03 PM February 14, 2011 10:24:36 PM Failed

DPR-ERR-2009 A request to authenticate the user in Content Manager failed. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2011-02-14-22:24:29.226-#1

I believe this is because my insight server are stop when the dataMovementTasks is on progress. I'm not sure why the insight server is not stable.

Can someone help or advice about this problem? Thank you

The second problem is every time I run the dataMovementTasks, it takes a lot of hard drive space (about 1GB or 2GB). After I check about this, I found that this process create huge file every times it runs.

C:\Program Files\IBM\Rational Insight\AppServer\profiles\RationalInsight\core.20110215.093003.8112.0004.dmp

This is one of the example file. Is it possible to run dataMovementTasks more efficiently? (ex: auto delete the old files)

Can someone help or advice about this problem? Thank you

Best Regards
Nikolaus

3 answers



permanent link
Lawrence Mandel (51121) | answered Feb 15 '11, 3:39 p.m.
FORUM MODERATOR
Hi Nikolaus,

As far as I know the core dmp file that is being generated is a result of the ETL job failing. This file should not be created under normal operation.

Are you able to run the ETL job manually from within Data Manager?

Can you provide some more information about your Insight server being stopped or not stable?

permanent link
Nikolaus Utomo (113) | answered Feb 15 '11, 10:58 p.m.
Hi Lawrence,

So is it safe to delete the core dmp file?

I can run the ETL job manually from Data Manager. I run the RQM_ODS2.0 and below are the logs. I'm not sure what does the log means by "Succeeded -> Suspended".

RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 8910
Build Node 41 'JobResult'; Pending -> Executing
Build Node 41 'JobResult'; initializing
Build Node 41 'JobResult'; executing (pid 4860)
Build Node 41 'JobResult'; component 'JobResult', RunId 22, AuditId 8911
Build Node 41 'JobResult'; Executing -> Succeeded
Build Node 41 'JobResult'; succeeded
RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 8911
Condition Node 37 'hasMore'; Pending -> Executing
Condition Node 37 'hasMore'; executing (inline)
Condition Node 37 'hasMore'; Executing -> Succeeded
Condition Node 37 'hasMore'; succeeded (FALSE)
RESULT = TRUE
Build Node 2 'Contributor'; Succeeded -> Suspended
Build Node 3 'Configuration'; Succeeded -> Suspended
Build Node 4 'Requirement'; Succeeded -> Suspended
Build Node 5 'WorkItem'; Succeeded -> Suspended
Build Node 6 'TestSuiteLog'; Succeeded -> Suspended
Build Node 8 'TestSuite'; Succeeded -> Suspended
Build Node 9 'TestCase'; Succeeded -> Suspended
Build Node 11 'ExecutionResult2'; Succeeded -> Suspended
Build Node 12 'ExecutionWorkItem'; Succeeded -> Suspended
Build Node 14 'ExecutionRes_ExecWkItem_Lookup'; Succeeded -> Suspended
Build Node 15 'ExecutionRes_WorkItem_Lookup'; Succeeded -> Suspended
Build Node 16 'ExecutionWorkItem_Config_Lookup'; Succeeded -> Suspended
Build Node 17 'TestCase_Category_Lookup'; Succeeded -> Suspended
Build Node 19 'TestCase_Requirement_Lookup'; Succeeded -> Suspended
Build Node 20 'TestPlan_Iteration_Lookup'; Succeeded -> Suspended
Build Node 21 'TestPlan_Category_Lookup'; Succeeded -> Suspended
Build Node 22 'TestPlan_Requirement_Lookup'; Succeeded -> Suspended
Build Node 23 'TestPlan_TestCase_Lookup'; Succeeded -> Suspended
Build Node 25 'TestSuite_EWI_Lookup'; Succeeded -> Suspended
Build Node 26 'TestSuite_TestSuLog_Lookup'; Succeeded -> Suspended
Build Node 27 'TestSuLog_ExecRes_Lookup'; Succeeded -> Suspended
Build Node 28 'TestPlan'; Succeeded -> Suspended
Build Node 29 'ResourceGroup'; Succeeded -> Suspended
Build Node 30 'LabResource'; Succeeded -> Suspended
Build Node 31 'Reservation'; Succeeded -> Suspended
Build Node 32 'Category_stg'; Succeeded -> Suspended
Build Node 33 'Category'; Succeeded -> Suspended
Build Node 34 'TestPhase'; Succeeded -> Suspended
Procedure Node 36 'preparevar'; Succeeded -> Suspended
Build Node 38 'EWI_Iteration_Lookup'; Succeeded -> Suspended
Build Node 39 'WorkItemHistory'; Succeeded -> Suspended
Build Node 40 'Job'; Succeeded -> Suspended
Build Node 41 'JobResult'; Succeeded -> Suspended
Build Node 42 'WorkItemHistory_Stg'; Succeeded -> Suspended
Build Node 43 'RQMProjects'; Succeeded -> Suspended
Build Node 44 'TestScript'; Succeeded -> Suspended
Build Node 45 'TestCase_TestScript_Lookup'; Succeeded -> Suspended
Build Node 48 'BuildRecord'; Succeeded -> Suspended
Done - 0 02:22:10 elapsed
jobstream -- completed (20-Jan-2011 12:48:21)

----------------------------------------------------------------------------------------------------

This log below is from dataMovementTasks

RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 52
Build Node 41 'JobResult'; Pending -> Executing
Build Node 41 'JobResult'; initializing
Build Node 41 'JobResult'; executing (pid 5736)
Build Node 41 'JobResult'; component 'JobResult', RunId 1, AuditId 53
Build Node 41 'JobResult'; Executing -> Succeeded
Build Node 41 'JobResult'; succeeded
RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 53
Condition Node 37 'hasMore'; Pending -> Executing
Condition Node 37 'hasMore'; executing (inline)
Condition Node 37 'hasMore'; Executing -> Succeeded
Condition Node 37 'hasMore'; succeeded (FALSE)
RESULT = TRUE
Build Node 2 'Contributor'; Failed -> Suspended
Build Node 3 'Configuration'; Succeeded -> Suspended
Build Node 4 'Requirement'; Succeeded -> Suspended
Build Node 5 'WorkItem'; Succeeded -> Suspended
Build Node 6 'TestSuiteLog'; Succeeded -> Suspended
Build Node 8 'TestSuite'; Succeeded -> Suspended
Build Node 9 'TestCase'; Succeeded -> Suspended
Build Node 11 'ExecutionResult2'; Succeeded -> Suspended
Build Node 12 'ExecutionWorkItem'; Succeeded -> Suspended
Build Node 14 'ExecutionRes_ExecWkItem_Lookup'; Succeeded -> Suspended
Build Node 15 'ExecutionRes_WorkItem_Lookup'; Succeeded -> Suspended
Build Node 16 'ExecutionWorkItem_Config_Lookup'; Succeeded -> Suspended
Build Node 17 'TestCase_Category_Lookup'; Succeeded -> Suspended
Build Node 19 'TestCase_Requirement_Lookup'; Succeeded -> Suspended
Build Node 20 'TestPlan_Iteration_Lookup'; Succeeded -> Suspended
Build Node 21 'TestPlan_Category_Lookup'; Succeeded -> Suspended
Build Node 22 'TestPlan_Requirement_Lookup'; Succeeded -> Suspended
Build Node 23 'TestPlan_TestCase_Lookup'; Succeeded -> Suspended
Build Node 25 'TestSuite_EWI_Lookup'; Succeeded -> Suspended
Build Node 26 'TestSuite_TestSuLog_Lookup'; Succeeded -> Suspended
Build Node 27 'TestSuLog_ExecRes_Lookup'; Succeeded -> Suspended
Build Node 28 'TestPlan'; Succeeded -> Suspended
Build Node 29 'ResourceGroup'; Succeeded -> Suspended
Build Node 30 'LabResource'; Succeeded -> Suspended
Build Node 31 'Reservation'; Succeeded -> Suspended
Build Node 32 'Category_stg'; Succeeded -> Suspended
Build Node 33 'Category'; Succeeded -> Suspended
Build Node 34 'TestPhase'; Succeeded -> Suspended
Procedure Node 36 'preparevar'; Succeeded -> Suspended
Build Node 38 'EWI_Iteration_Lookup'; Succeeded -> Suspended
Build Node 39 'WorkItemHistory'; Succeeded -> Suspended
Build Node 40 'Job'; Succeeded -> Suspended
Build Node 41 'JobResult'; Succeeded -> Suspended
Build Node 42 'WorkItemHistory_Stg'; Succeeded -> Suspended
Build Node 43 'RQMProjects'; Succeeded -> Suspended
Build Node 44 'TestScript'; Succeeded -> Suspended
Build Node 45 'TestCase_TestScript_Lookup'; Succeeded -> Suspended
Build Node 48 'BuildRecord'; Succeeded -> Suspended
Done - 0 02:28:21 elapsed
jobstream -- completed (15-Feb-2011 22:30:36)

------------------------------------------------------------------------------------------------

I'm not sure why the server is not stable. Sometimes after long time (1 day or few hours), I can not open directly http://localhost:9080/insight/servlet/dispatch
I need to start the server manually first, then it can open without problem. I never stop the server manually. Do you where can I get the data to provide you with more detailed information about this?

Best Regards
Nikolaus

permanent link
Petroula Pantazopoulos (36612) | answered Mar 17 '11, 8:18 a.m.
JAZZ DEVELOPER
Hi Lawrence,

So is it safe to delete the core dmp file?

I can run the ETL job manually from Data Manager. I run the RQM_ODS2.0 and below are the logs. I'm not sure what does the log means by "Succeeded -> Suspended".

RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 8910
Build Node 41 'JobResult'; Pending -> Executing
Build Node 41 'JobResult'; initializing
Build Node 41 'JobResult'; executing (pid 4860)
Build Node 41 'JobResult'; component 'JobResult', RunId 22, AuditId 8911
Build Node 41 'JobResult'; Executing -> Succeeded
Build Node 41 'JobResult'; succeeded
RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 8911
Condition Node 37 'hasMore'; Pending -> Executing
Condition Node 37 'hasMore'; executing (inline)
Condition Node 37 'hasMore'; Executing -> Succeeded
Condition Node 37 'hasMore'; succeeded (FALSE)
RESULT = TRUE
Build Node 2 'Contributor'; Succeeded -> Suspended
Build Node 3 'Configuration'; Succeeded -> Suspended
Build Node 4 'Requirement'; Succeeded -> Suspended
Build Node 5 'WorkItem'; Succeeded -> Suspended
Build Node 6 'TestSuiteLog'; Succeeded -> Suspended
Build Node 8 'TestSuite'; Succeeded -> Suspended
Build Node 9 'TestCase'; Succeeded -> Suspended
Build Node 11 'ExecutionResult2'; Succeeded -> Suspended
Build Node 12 'ExecutionWorkItem'; Succeeded -> Suspended
Build Node 14 'ExecutionRes_ExecWkItem_Lookup'; Succeeded -> Suspended
Build Node 15 'ExecutionRes_WorkItem_Lookup'; Succeeded -> Suspended
Build Node 16 'ExecutionWorkItem_Config_Lookup'; Succeeded -> Suspended
Build Node 17 'TestCase_Category_Lookup'; Succeeded -> Suspended
Build Node 19 'TestCase_Requirement_Lookup'; Succeeded -> Suspended
Build Node 20 'TestPlan_Iteration_Lookup'; Succeeded -> Suspended
Build Node 21 'TestPlan_Category_Lookup'; Succeeded -> Suspended
Build Node 22 'TestPlan_Requirement_Lookup'; Succeeded -> Suspended
Build Node 23 'TestPlan_TestCase_Lookup'; Succeeded -> Suspended
Build Node 25 'TestSuite_EWI_Lookup'; Succeeded -> Suspended
Build Node 26 'TestSuite_TestSuLog_Lookup'; Succeeded -> Suspended
Build Node 27 'TestSuLog_ExecRes_Lookup'; Succeeded -> Suspended
Build Node 28 'TestPlan'; Succeeded -> Suspended
Build Node 29 'ResourceGroup'; Succeeded -> Suspended
Build Node 30 'LabResource'; Succeeded -> Suspended
Build Node 31 'Reservation'; Succeeded -> Suspended
Build Node 32 'Category_stg'; Succeeded -> Suspended
Build Node 33 'Category'; Succeeded -> Suspended
Build Node 34 'TestPhase'; Succeeded -> Suspended
Procedure Node 36 'preparevar'; Succeeded -> Suspended
Build Node 38 'EWI_Iteration_Lookup'; Succeeded -> Suspended
Build Node 39 'WorkItemHistory'; Succeeded -> Suspended
Build Node 40 'Job'; Succeeded -> Suspended
Build Node 41 'JobResult'; Succeeded -> Suspended
Build Node 42 'WorkItemHistory_Stg'; Succeeded -> Suspended
Build Node 43 'RQMProjects'; Succeeded -> Suspended
Build Node 44 'TestScript'; Succeeded -> Suspended
Build Node 45 'TestCase_TestScript_Lookup'; Succeeded -> Suspended
Build Node 48 'BuildRecord'; Succeeded -> Suspended
Done - 0 02:22:10 elapsed
jobstream -- completed (20-Jan-2011 12:48:21)

----------------------------------------------------------------------------------------------------

This log below is from dataMovementTasks

RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 52
Build Node 41 'JobResult'; Pending -> Executing
Build Node 41 'JobResult'; initializing
Build Node 41 'JobResult'; executing (pid 5736)
Build Node 41 'JobResult'; component 'JobResult', RunId 1, AuditId 53
Build Node 41 'JobResult'; Executing -> Succeeded
Build Node 41 'JobResult'; succeeded
RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 53
Condition Node 37 'hasMore'; Pending -> Executing
Condition Node 37 'hasMore'; executing (inline)
Condition Node 37 'hasMore'; Executing -> Succeeded
Condition Node 37 'hasMore'; succeeded (FALSE)
RESULT = TRUE
Build Node 2 'Contributor'; Failed -> Suspended
Build Node 3 'Configuration'; Succeeded -> Suspended
Build Node 4 'Requirement'; Succeeded -> Suspended
Build Node 5 'WorkItem'; Succeeded -> Suspended
Build Node 6 'TestSuiteLog'; Succeeded -> Suspended
Build Node 8 'TestSuite'; Succeeded -> Suspended
Build Node 9 'TestCase'; Succeeded -> Suspended
Build Node 11 'ExecutionResult2'; Succeeded -> Suspended
Build Node 12 'ExecutionWorkItem'; Succeeded -> Suspended
Build Node 14 'ExecutionRes_ExecWkItem_Lookup'; Succeeded -> Suspended
Build Node 15 'ExecutionRes_WorkItem_Lookup'; Succeeded -> Suspended
Build Node 16 'ExecutionWorkItem_Config_Lookup'; Succeeded -> Suspended
Build Node 17 'TestCase_Category_Lookup'; Succeeded -> Suspended
Build Node 19 'TestCase_Requirement_Lookup'; Succeeded -> Suspended
Build Node 20 'TestPlan_Iteration_Lookup'; Succeeded -> Suspended
Build Node 21 'TestPlan_Category_Lookup'; Succeeded -> Suspended
Build Node 22 'TestPlan_Requirement_Lookup'; Succeeded -> Suspended
Build Node 23 'TestPlan_TestCase_Lookup'; Succeeded -> Suspended
Build Node 25 'TestSuite_EWI_Lookup'; Succeeded -> Suspended
Build Node 26 'TestSuite_TestSuLog_Lookup'; Succeeded -> Suspended
Build Node 27 'TestSuLog_ExecRes_Lookup'; Succeeded -> Suspended
Build Node 28 'TestPlan'; Succeeded -> Suspended
Build Node 29 'ResourceGroup'; Succeeded -> Suspended
Build Node 30 'LabResource'; Succeeded -> Suspended
Build Node 31 'Reservation'; Succeeded -> Suspended
Build Node 32 'Category_stg'; Succeeded -> Suspended
Build Node 33 'Category'; Succeeded -> Suspended
Build Node 34 'TestPhase'; Succeeded -> Suspended
Procedure Node 36 'preparevar'; Succeeded -> Suspended
Build Node 38 'EWI_Iteration_Lookup'; Succeeded -> Suspended
Build Node 39 'WorkItemHistory'; Succeeded -> Suspended
Build Node 40 'Job'; Succeeded -> Suspended
Build Node 41 'JobResult'; Succeeded -> Suspended
Build Node 42 'WorkItemHistory_Stg'; Succeeded -> Suspended
Build Node 43 'RQMProjects'; Succeeded -> Suspended
Build Node 44 'TestScript'; Succeeded -> Suspended
Build Node 45 'TestCase_TestScript_Lookup'; Succeeded -> Suspended
Build Node 48 'BuildRecord'; Succeeded -> Suspended
Done - 0 02:28:21 elapsed
jobstream -- completed (15-Feb-2011 22:30:36)

------------------------------------------------------------------------------------------------

I'm not sure why the server is not stable. Sometimes after long time (1 day or few hours), I can not open directly http://localhost:9080/insight/servlet/dispatch
I need to start the server manually first, then it can open without problem. I never stop the server manually. Do you where can I get the data to provide you with more detailed information about this?

Best Regards
Nikolaus


What version of Cognos are you running? In the cognos directory, there is a cmplst.txt file that contains version information for all the components. Can you paste that information? Also have you applied any fix packs for cognos?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.