It's all about the answers!

Ask a question

torubleshooting rationa team concert data collection job failure


marina delunas (711316) | asked Sep 03 '14, 8:14 a.m.
The environment is CLM 4.0.3 and application server WebSphere and DB2 database.

It is possible to find or investigate what attribute or workitem create the error on ccm etl job log and the workitems data collection job failure? Is there any other logs file that I can check?

Where can I try to find this wrong value? "22555555555555556"    Tables? log files?

Many thanks for any suggestions.



the abstrat of ccm etc log file is:

2014-09-01 01:21:35,452 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: ***Started Build WorkItemHisCustomAttr at 9/1/14 1:21 AM***

2014-09-01 01:21:42,455 [ccm: AsynchronousTaskRunner-0 @@ 00:02] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService  - [jcc][t4][1037][11190][4.14.121] Exception occurred during BigDecimal conversion.  See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null

com.ibm.db2.jcc.am.SqlException: [jcc][t4][1037][11190][4.14.121] Exception occurred during BigDecimal conversion.  See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null

                at com.ibm.db2.jcc.am.ed.a(ed.java:661)

                at com.ibm.db2.jcc.am.ed.a(ed.java:60) 

.................

....................


com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:119)

                at java.lang.Thread.run(Thread.java:769)

Caused by: com.ibm.db2.jcc.a.ConversionException: [jcc][converters][608][10994]Overflow occurred during numeric data type conversion of "22555555555555556".

                at com.ibm.db2.jcc.a.d.a(d.java:61)

                at com.ibm.db2.jcc.t4.db.a(db.java:1822)

                ... 77 more

2014-09-01 01:21:51,833 [ccm: AsynchronousTaskRunner-0 @@ 00:02] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: Records Selected: 4111




2 answers



permanent link
Adam Wereszczynski (92811632) | answered Sep 03 '14, 8:21 a.m.
edited Sep 03 '14, 8:21 a.m.
Hi Marina,

Please open the Jazz Inst. Dir.\server\conf\ccm\log4j.properties file.
There is a section on ETL jobs, please follow the instructions there to enable additional logging.
To enable logging without restarting the CCM server, please visit the following page in your browser:
https://<rtc_server_name>:<port>/ccm/admin?internal#action=com.ibm.team.repository.admin.reloadLoggingSettings and click on the button

Now when you run the ETL jobs you will have an additional log file ccm-etl-driver.log with more low-level information.

If this is not enough information to solve your problem, please open a support ticket.

permanent link
Rhishikesh Patil (1311227) | answered Oct 31 '14, 11:18 a.m.
We have similar problem with insight. Our ETL jobs are failing and in the log file we come to below error
Run context: 
JobStream 'CLM4.0.1_All' 
        JobStream 'RTC_ODS4.0.1_DeltaLoad' 
                JobStream 'RTC_ODS4.0.1' 
                        JobStream 'RTC_Workitem4.0.1' 
                                JobStream 'RTC_WorkitemCustomAttribute' 
                                        Build 'RTC_CustomAttr3'  

[PROGRESS   - 23:32:13] Fact Build 'RTC_CustomAttr3' 
[PROGRESS   - 23:32:13] Parsing Reference Definition 
[PROGRESS   - 23:32:13] Validating Build Specification 
[PROGRESS   - 23:32:21] Checking Fact Data existence 

DM-DBM-0400 UDA driver reported the following on connection RTC Work Item: 

UDA-SQL-0107 A general exception has occurred during the operation "fetch". 

CRRRE9000E : Erreur Java interne, consultez le fichier ri_jdbc.log pour plus de détails 


[PROGRESS   - 23:32:49] Build 'RTC_CustomAttr3' Failed 
databuild -- failed (28-Oct-2014 23:32:49)

From information given above i need to find i need get ccm-etl-driver.log

To be sure which all lines to be uncommented and commented from below line

################################
#            ETL's             #
################################
#Turn off Rational XML JDBC driver logging by default. This is only needed for troubleshooting the ETLs
log4j.logger.com.ibm.rational.drivers.jdbc.xml=OFF
log4j.logger.com.ibm.rational.etl=OFF
#Comment the above 2 lines and uncomment the lines below to turn on logging
#log4j.logger.com.ibm.rational.drivers.jdbc.xml=INFO, etlDriver
#log4j.logger.com.ibm.rational.etl=INFO, etlDriver
log4j.additivity.com.ibm.rational.drivers.jdbc.xml=false
log4j.additivity.com.ibm.rational.etl=false
#log4j.appender.etlDriver=org.apache.log4j.RollingFileAppender
#log4j.appender.etlDriver.MaxFileSize=10MB
#log4j.appender.etlDriver.MaxBackupIndex=5
#log4j.appender.etlDriver.File=logs/ccm-etl-driver.log
#log4j.appender.etlDriver.layout=org.apache.log4j.PatternLayout
#log4j.appender.etlDriver.layout.ConversionPattern=%d{ISO8601} [%30t] %5p %-50.50c  - %m%n

Thanks for your help in advance

Regards,

Rhishikesh Patil




Your answer


Register or to post your answer.