It's all about the answers!

Ask a question

Data Collection job for Workitem in RTC


Raj Kapoor (2741930) | asked Oct 28 '12, 7:51 a.m.
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)


Comments
Raj Kapoor commented Oct 30 '12, 5:34 a.m.

Does anybody have any clue on an issue? 

One answer



permanent link
Sandy Grewal (1.6k1123) | answered Mar 27 '13, 2:11 p.m.
JAZZ DEVELOPER
This is a defect Validate Timestamp and Date values (208858) 
This has been fixed in 3014 and 4.0

Your answer


Register or to post your answer.