SAP Knowledge Base Article - Preview

2651601 - The database 'saptempdb' does not exist or is not a user created temporary database (db code 18946) - SAP ASE for Business Suite

Symptom

During a system upgrade using SUM, you are facing an error in the phase: PREP_INSTALL/SHDINST_DB_PREP

  • A short dump with the following error message which also appear in SM21 system log:

           3 ETQ398 SQL: select $EXEC(
           3 ETQ398XSQL: 'sp_tempdb 'bind','LG','SAPSR3SHD','DB','saptempdb',NULL,'hard' ')
           4 ETQ010 Date & Time: 20180530134617
           1EETQ008 Error message: DBSL error 99 (db code 18946):
           1EETQ008 [ASE Error SQL18946][SAP][ASE ODBC
           1EETQ009X Driver][Adaptive Server Enterprise]The database 'saptempdb' does not exist or
           1EETQ009X is not a user created temporary database.
           1EETQ003 exit code: "20"


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 all versions
  • SAP Adaptive Server Enterprise (ASE) 16.0 all versions
  • SAP NetWeaver (NW) - All versions
  • SAP Solution Manager 7.x

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver Application Server all versions

Keywords

Database 'saptempdb' does not exist, ASE Error SQL18946, db code 18946, PREP_INSTALL/SHDINST_DB_PREP, exit code: "20" , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.