SAP Knowledge Base Article - Preview

2763446 - DA job returns java.lang.NumberFormatException - SRS

Symptom

Attempt to change column comparison between literal and row_hash, job run failed with the following error:

AGENT RowCompareExecutor.execute@45754 daObj=dbo.loads@conn_XXXX; po=XXX.YYY.com:5000/xxxx; sql=

select <columns> from dbo.loads where (((pro_num>=?)) and ((pro_num<?)))

JZ009: Error encountered in conversion. Error message: java.lang.NumberFormatException
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:763)
at com.sybase.jdbc4.tds.TdsJdbcInputStream.getInt(TdsJdbcInputStream.java:1649)
at com.sybase.jdbc4.jdbc.SybResultSet.getInt(SybResultSet.java:461)
at com.sybase.da.agent.dbadapter.ASEResultAdapter.adaptObject(Unknown Source)

The JDBC driver failed to convert a column value to an INT.


Read more...

Environment

SAP Replication Server (SRS) Data Assurance (DA) option 16.0

Product

SAP Replication Server 16.0

Keywords

Data Assurance; compare_mode; row_hash; literal , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

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.