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 for Me (Login required).

Search for additional results

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