SAP Knowledge Base Article - Preview

2491940 - Error 12822 "Cannot create temporary table..." when executing a stored procedure twice - SAP ASE


ASE errorlog reports the following message:

Msg 12822, Level 16, State 1 Cannot create temporary table '%.*s'. Prefix name '%.*s' is already in use by another temporary table '%.*s'.



  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


CR809098, CR#809098, 809098, orphan, orphantables, abort, cleanup, clean-up , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.