Symptom
Java query suddenly failing with the following error:
SQL state [ZZZZZ]; error code [12822]; Cannot create temporary table '#m'. Prefix name '#m' is already in use by another temporary table '#m'.
; nested exception is com.sybase.jdbc4.jdbc.SybSQLException: Cannot create temporary table '#m'. Prefix name '#m' is already in use by another temporary table '#m'.
Read more...
Environment
- SAP Adaptive Server Enterprise ASE 16.0
- jConnect (TM) for JDBC(TM)/16.0 SP03 PL08 (Build 27463)/P/EBF29225
Product
SAP Adaptive Server Enterprise 16.0
Keywords
Change new responsible to me since original responsible person left PS. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.