SAP Knowledge Base Article - Preview

2384558 - Error 12336 and 3703 on GTT tables when running SWPM DB Export - SAP ASE for BS

Symptom

'ASE Error SQL12336' happened during SWPM DB export:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
R3szchk_SAPAPPL1.log showed following information:
ERROR: init_table: get_rowcnt failed
ERROR: Select for get_rowcnt failed (table "<table_name>")
[ASE Error SQL12336][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Definition time object 'database 'saptempdb' (6), object '##<table_name>xxxxxxxx' (xxxxxx)' found at run time as an attempt to drop the table had failed in a previous query. Please drop the above mentioned table using the DROP TABLE command.

ERROR: init_table: get_rowcnt failed
ERROR: Select for get_rowcnt failed (table "<table_name>")
[ASE Error SQL12336][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Definition time object 'database 'saptempdb' (6), object '##<table_name>xxxxxxxx' (xxxxxx)' found at run time as an attempt to drop the table had failed in a previous query. Please drop the above mentioned table using the DROP TABLE command.

ERROR: init_table: get_rowcnt failed
ERROR: Select for get_rowcnt failed (table "<table_name>")
[ASE Error SQL12336][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Definition time object 'database 'saptempdb' (6), object '##<table_name>xxxxxxxx' (xxxxxx)' found at run time as an attempt to drop the table had failed in a previous query. Please drop the above mentioned table using the DROP TABLE command.

ERROR: init_table: get_rowcnt failed
ERROR: Select for get_rowcnt failed (table "<table_name>")
[ASE Error SQL12336][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Definition time object 'database 'saptempdb' (6), object '<table_name>xxxxxxxx' (xxxxxx)' found at run time as an attempt to drop the table had failed in a previous query. Please drop the above mentioned table using the DROP TABLE command.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

It may be followed by Error:3703. This error displayed in ASE error log:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
00:0008:00000:00032:2016/09/30 21:49:12.18 server  Error: 3703, Severity: 11, State: 2
00:0008:00000:00032:2016/09/30 21:49:12.18 server  Cannot drop the table with object-id xxxxxx in database 6, because it doesn't exist in the system catalogs.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04 for Business Suite
  • SAP NetWeaver (NW) - All versions

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR796532, CR#796532, 796532, 12336, 3703, GTT tables, SWPM , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.