SAP Knowledge Base Article - Preview

3333193 - System Copy [Error SQL318]sysstatistics catalog was read and an inconsistency was found, please run update statistics - SAP ASE

Symptom

  • The "ASE Error SQL318" time of importing system copy in new server.
  • during import system copy following error is raised

A1EEIMP 008 ON "tablename" (  "AGIDV" ,  "TRTYP" ,  "FCODE"  )

A1EEIMP 008 

A1EEIMP 008 with consumers = 3, statistics hashing)

A1EEIMP 008 DbSlExecute: rc = 99

A1EEIMP 008 (SYB) (SQL error 318)

A1EEIMP 008  Error message returned by DbSl:

A1EEIMP 008 (SYB) SQL error = 318

A1EEIMP 008 (SYB) [ASE Error SQL318]sysstatistics catalog was read and an inconsistency was found, please run update statistics and contact SAP Technical Support.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP NetWeaver (NW) - All versions
  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise all versions ; SAP NetWeaver all versions

Keywords

delete statistics , update statistics , statistics inconsistency , SQL318,Msg 2706,SAPSR3 , KBA , 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.