2503102 - ODBC: Msg 208 Temporal table not found when using user datatypes and default. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2503102 - ODBC: Msg 208 Temporal table not found when using user datatypes and default.

Symptom

  • After ASE16.0 was upgraded to ASE16 SP02 PL06, a query running in Business Objects (using ODBC driver and prepared statement=ON) and also using user defined datatype with binding default gives error 

Msg 208, Severity 16, State 6 #S not found. Specify owner.objectname

  • See query example

CREATE TABLE #S(ID T_ID)

INSERT INTO #S (ID) values (1)

select ID From #S  

returns error – temporary table #S  not found.  

  • If we use any standard datatype for ID column (int for example) the same query works well.  

CREATE TABLE #S(ID int)

INSERT INTO #S (ID) values (1)

select ID From #S  

result - 1   


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16 SP02 PL06
  • SAP Adaptive Server Enterprise (ASE) 16 SP03
  • SAP Sybase ASE SDK 16 SP02 PL06
  • SAP Sybase ASE SDK 16 SP03
  • Adaptive Server Enterprise ODBC Driver by Sybase 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Msg. 208,208,ODBC,809819,CR809819,CR#809819,Temporal table not found , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.