SAP Knowledge Base Article - Preview

1868307 - Error SQL4997 "ALTER TABLE xxx failed..." when implementing data collector - SAP ASE for Business Suite


Error 4997 is raised when altering tables saptools..DB_SNAP_DATACACHE and saptools..DB_SNAP_SYSLOAD:

SQL Message: [ASE Error SQL4997]
ALTER TABLE 'saptools..DBH_SNAP_SYSLOAD' failed.
Default clause is required in order to add non-NULL column 'ThreadID'



SAP Adaptive Server Enterprise (ASE) for Business Suite - All versions


SAP Adaptive Server Enterprise all versions


'allow nulls by default', SQL4997, 4997 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

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.