SAP Knowledge Base Article - Preview

1428264 - Universe Error Temp Table in Stored Procedure

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.