Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Data Collection job for Workitem in RTC

RTC 3.0.0.1

Data Collection job for Workitem  is failing, all other data collection jobs are running successfully.
 error in etllog-


 2012-10-28 01:55:28,436 [ ccm: AsynchronousTaskRunner-0] DEBUG e.workitem.internal.WorkItemsRemoteSnapshotService  - ETL: ***Started Build WorkItemHisCustomAttr at 28/10/12 01:55***
2012-10-28 01:12:10,224 [ ccm: AsynchronousTaskRunner-0] ERROR e.workitem.internal.WorkItemsRemoteSnapshotService  - The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (""): The supplied value is not a valid instance of data type datetime. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (""): The supplied value is not a valid instance of data type datetime. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)

0 votes

Comments

Does anybody have any clue on an issue? 



One answer

Permanent link
This is a defect Validate Timestamp and Date values (208858) 
This has been fixed in 3014 and 4.0

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121

Question asked: Oct 28 '12, 7:51 a.m.

Question was seen: 4,887 times

Last updated: Mar 27 '13, 2:11 p.m.

Confirmation Cancel Confirm