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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.