SAP Data Services Jobs fail with the following error:
Cannot retrieve <Index List> from the repository. Additional database information: <SQL submitted to ODBC data source < > resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'AL_INDEX'.>. The SQL submitted is <select * from AL_INDEX where TABLEKEY = 4 order by NAME, COLPOSITION asc>.>.
AL_INDEX table gets dropped from the Data Services repositories.
- Microsoft SQL Server
- SAP Information Platform Services 4.2 SP6
- SAP Data Services 4.2 SP11
- SAP Information Steward 4.2 SP11
job, error, repository, corrupt, AL_INDEX, update, bods, ds, dataservices, bobj , KBA , EIM-DS-SVR , Data Services Administration/Server , Problem
About this pageThis 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.