Symptom
BCP Test
bcp database..table out table.bcp -Sservername -U<username> -P<password> -c -Jcp850
delete from table
-- Test the 'BCP in' with batch size of 5. This works and data is replicated through to the replicate database
bcp database..table in table.bcp -Sservername -U<username> -P<password> -c -Jcp850 -b5
-- Test the 'BCP in' with batch size of 10. This puts the data into the primary database but does not reach the replicate DB
bcp database..table in table.bcp -Sservername -U<username> -P<password> -c -Jcp850 -b10
connection is down
Replication errorlog shows the following:
ERROR #1028 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(453)
Message from server: Message: 195, State 0, Severity 15 -- '[[Message Iteration=1|Data Source Name=xxxxx|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'char_convert' is not a recognized SET option.]'.
ERROR #1028 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(453)
Message from server: Message: 207, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=xxxxx|SQLState=42S22|Native Error=207|Message=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'sysstat2'.[Message Iteration=2|SQLSt.
Open Client Client-Library error: Error: 16973838, Severity 0 -- 'blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.'.
ERROR #1027 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(453)
Open Client Client-Library error: Error: -99999, Severity 5 -- 'Failed to initialize bulk 'in' processing for table [table.]. blk_init failed'.
ERROR #5215 DSI EXEC(111(1) RDS.rdb) - eneric\dsi\dsiutil.c(502)
The interface function 'RCIPrepare' returns FAIL for database 'RDS.rdb'. The errors are retryable. The DSI thread will restart automatically. See messages from the interface function for more information.
Read more...
Environment
SAP Replication Server (SRS) 15.7.1
Product
Keywords
ERROR #1028 Message 207 bulk loading data primary batch size bcp Invalid column name , 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.