SAP Knowledge Base Article - Preview

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

Symptom

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'
.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise all versions

Keywords

'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.