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'.
- Message from server: Message: 7788, State 1, Severity 10 -- 'WARNING: An explicit or implicit
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.
SAP Knowledge Base Article - Preview