SAP Knowledge Base Article - Preview

3053850 - Msg 208 - Level 16 - Table not found in trigger after upgrade to ASE16SP03PL09

Symptom

  • Customer is getting after upgrade to ASE16SP03PL09.

insert into MXMC_db_test_bil.SNG_REPORT_bil.SNG_REPORT_USERS values (1,'zz',GETDATE(),GETDATE(),'hgf',12)
go
Msg 208, Level 16, State 1:
Server 'ase25435', Procedure 'SNG_REPORT_bil./1LT/00005389INS', Line 2:
/1CADMC/00005389 not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).

  • The reason is the trigger on insertion

CREATE TRIGGER SNG_REPORT_bil.[/1LT/00005389INS] ON SNG_REPORT_bil.SNG_REPORT_USERS
FOR INSERT AS SET NOCOUNT ON INSERT INTO [/1CADMC/00005389]( IUUC_TIMESTAMP , IU
UC_PROCESSED ,USER_ID , ATTRNAME , BEGDATE , ENDDATE , IDM_CHANGENUMBER , IUUC_OPERAT_F                LAG )
SELECT  CONVERT(VARCHAR(11), GETUTCDATE(),23) || CONVERT(VARCHAR, GETUTCDATE(),20 ), ' ', USER_ID, ATTRNAME,  BEGDATE,  ENDDATE,  IDM_CHANGENUMBER,   'I' FROM inserted

  • If the table is named with owner.table "ON INSERT INTO OUT_HANA_bil2.[/1CADMC/00005389]"
    instead of "ON INSERT INTO [/1CADMC/00005389]", issue does not happen.


Read more...

Environment

  • SAP Adaptive Server Entreprise (ASE) 16 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Msg 208,208,upgrade,trigger , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.