SAP Knowledge Base Article - Preview

2680870 - MSSQL Rep Agent Down the Translation Engine unexpectedly encountered the end of temporal value - SR

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

SAP Replication Server, option for Microsoft SQL Server all versions

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.