SAP Knowledge Base Article - Preview

3213515 - Error: 4846 State: 3 while BULK INSERT data into APL table

Symptom

 After deadlock information, 'Error: 4846 State: 3' in ASE errorlog 

00:0004:00000:03418:2022/06/14 06:43:43.67 server  Deadlock Id 6 detected
Deadlock Id 6 detected. 1 deadlock chain(s) involved.

Deadlock Id 6: Process (Familyid 0, Spid 3592, Suid 10) was executing a UPDATE command in the procedure 'objid 306' at line 1 at nested level 2.
Deadlock Id 6: Process 3592 was involved in application 'KFSQL'.
Deadlock Id 6: Process 3592 was involved on host name 'ivapp1182198.iadvantage.ms.com'.
Deadlock Id 6: Process 3592 was involved in transaction '$upd'.
SQL Text: UPDATE 
Deadlock Id 6: Process (Familyid 0, Spid 3418, Suid 10) was executing a BULK INSERT command at line 1.
Deadlock Id 6: Process 3418 was involved in application 'genericDataLoad.pl'.
Deadlock Id 6: Process 3418 was involved on host name 'ivapp1182201.ggateway.ms.com'.
Deadlock Id 6: Process 3418 was involved in transaction 'equityDerivativeStress'.
Deadlock Id 6: Process 3418 was doing a bulk copy.
SQL Text: BULK INSERT
Deadlock Id 6: Process (Familyid 0, Spid 3418) was waiting for a 'exclusive page' lock on page 7612997 of table 'equityDerivativeStress' in database 'staging' but process (Familyid 0, Spid 3592) already held a 'exclusive page' lock on it.
Deadlock Id 6: Process (Familyid 0, Spid 3592) was waiting for a 'exclusive page' lock on page 3275850 of table 'equityDerivativeStress' , indid 4 in database 'staging' but process (Familyid 0, Spid 3418) already held a 'exclusive page' lock on it.

Deadlock Id 6: Process (Familyid 0, Spid 3418) was chosen as the victim. 
Victim process host = `ivapp1182201.ggateway.ms.com', user = `bkpbs' program name = `genericDataLoad.pl' host processes = `27592' . 

End of deadlock information.

00:0004:00000:03418:2022/06/14 06:43:43.68 server  Error: 4846, Severity: 20, State: 3
00:0004:00000:03418:2022/06/14 06:43:43.68 server  Bulk copy failed. Error occurred while updating the last page of the table.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR826714 , CR#826714 , 826714, State: 4, State4, Error: 4864 State: 4, Error 4864 State 4, Error 4864 State 3,  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.