Symptom
Replication Agent for MS SQL Server (RAM) received below exception after adding datetime columns to replication definition. The column datatype is datetime for which rs_msss_datetime2 for the column is used in replication definition:
WARNING com.sybase.ra.lti.rs.LTLSession Replication Server refused the following invalid LTL command found in batch. Resending commands individually.
WARNING com.sybase.ra.lti.rs.LTLSession null
INFORMATION com.sybase.ra.lti.rs.LTLSession Changing batch mode to <FALSE>.
ERROR com.sybase.ra.lti.rs.LTLSession Replication Server refused the following invalid LTL command; LTI thread is now stopping.
....
ERROR com.sybase.ra.lti.rs.LTLSession The Translation Engine unexpectedly encountered the end of temporal value [20170927 00:00:00.000] while matching temporal mask [CCYYMMDD HH:mm:ss.ttttttt] at position 22.
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.jdbc.SybSQLException: The Translation Engine unexpectedly encountered the end of temporal value [20170927 00:00:00.000] while matching temporal mask [CCYYMMDD HH:mm:ss.ttttttt] at position 22.
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4084)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3174)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2593)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.rstds.RSStatement.execute(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.rstds.RSStatement.write(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.rs.LTLSession.executeLTLBuffer(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.rs.LTLSession.rs_send_ltl_command(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.rs.LTLSession.rs_send_ltl_commands(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.rs.LTLSession.rs_send_ltl_batch(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.rs.LTLSession.distribute(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.LTIDistributeThread.sendBatch(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.ra.lti.LTIDistributeThread.run(Unknown Source)
ERROR com.sybase.ra.lti.rs.LTLSession java.lang.Thread.run(Thread.java:791) See attached file for complete log file
Read more...
Environment
SAP Replication Agent all versions for MS SQL Server (RAM)
Product
Keywords
RAM,Repagent, Rep Agent, repagent for MS , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.