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

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

SAP Adaptive Server Entreprise (ASE) 16 

Msg 208,208,upgrade,trigger , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem