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