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
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.