Symptom
- dsi_bulk_copy is enabled on the target connection.
- dsi_isolation_level set to 0 on the target connection.
- bcp in data from primary, brought down DSI connection with the following warning message:
- Message from server: Message: 7788, State 1, Severity 10 -- 'WARNING: An explicit or implicit
HOLDLOCK/NOHOLDLOCK/READPAST was specified for table 'dbo.table'; however, since this is an isolation level 0 scan, the HOLDLOCK/NOHOLDLOCK/READPAST is ignored. - ERROR #1028 DSI EXEC(106(1) ASE157SP130.rdb304) - eneric/dsi/dsiutil.c(453)
Message from server: Message: 313, State 2, Severity 16 -- 'The optimizer could not find a unique index which it could use to perform an isolation level 0 scan
on table 'master.dbo.spt_values'. - 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(106(1) ASE157SP130.rdb304) - 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'.
Read more...
Environment
- SAP Replication Server (SRS) 15.7.1
- SAP Adaptive Server Enterprise (ASE) 15.7 - 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7
Keywords
error 7788, error 313, warning msg 7788, warning msg 313, 7788, 313, isolation level 0. , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.