Symptom
- When trying to insert a stored procedure in the universe that uses temp tables it returns an error.
- Exception: DBD,[Microsoft][SQL Native Client][SQL Server]Invalid object name'##ProcedureName':State:42502
- Insert Stored Procedures Error
- An Error occurred while drying to insert stored procedure in the data foundation layer
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform
- Information Design Tool (IDT)
- Universe Design Tool (UDT)
Product
SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2
Keywords
udt, universe, designer, stored procedure, temp, table, error , KBA , BI-BIP-SL , Semantic Layer , BI-BIP-IDT , Information design tool , BI-BIP-UDT , Universe Design Tool , Problem
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.