SAP Knowledge Base Article - Preview

3212777 - query suddenly stop working with the error saying the temp table cannot be created - SAP ASE

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

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.