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