SAP Knowledge Base Article - Preview

2200821 - BCP encountered error 820 in the errorlog.

Symptom

Whilst performing a BCP into a table which also has concurrent normal inserts being performed the BCP process raises an error 820 which can be seen in the errorlog:

Error: 820, Severity: 21, State: 6
Attempt to dirty non-log buffer BUF=0x0x000000284eb11c50, MASS=0x0x000000284eb11c50, Buf#=0, page=0x0x0000000ca9f8d000, dbid=14, Mass vdevno=8, vpage=13742251, Buf lpage=21170859, Mass stat=0x5111008, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0 which is in I/O.
WARNING: 1 buffer was found in a predirty state during the termination of spid 1635 (Pss: 0x0x00000001ac0ef978)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.5
  • SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

BCP,INSERT , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.