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.
SAP Knowledge Base Article - Preview