SAP Knowledge Base Article - Preview

3468469 - SQL Server Msg 5074 and 4922 happened when upgrading repository DB version.

Symptom

When trying to upgrade SAP data service repository using SAP data services repository manager, the following SQL Server error happened.  

ALTER TABLE AL_TABLEPROFILE ALTER COLUMN COLUMN_NAME nvarchar(384) NOT NULL 
>. The message from the underlying database is: <SQL submitted to ODBC data source < > resulted in error <[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statistics 'COLUMN_NAME' is dependent on column 'COLUMN_NAME'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]ALTER TABLE ALTER COLUMN COLUMN_NAME failed because one or more objects access this column.>. The SQL submitted is <
ALTER TABLE AL_TABLEPROFILE ALTER COLUMN COLUMN_NAME nvarchar(384) NOT NULL 
>.>.


Read more...

Environment

  • SAP Data Services 4.3 
  • Windows
  • SQL server repository DB

Product

SAP Data Services 4.3

Keywords

BODI-300056, Msg 5074, Msg 4922 , KBA , EIM-DS-DEP , Deployment, Installation, Upgrade , How To

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.