Tridion Asked by krishna garikapati on September 30, 2021
Post content sync from PROD to stage we are facing ORA-01403: no data found error for Stored Procedure "EDA_ITEMS.READ_ITEM"
A database error occurred while executing Stored Procedure "EDA_ITEMS.READ_ITEM".
ORA-01403: no data found
ORA-06512: at "TRIDION_CM.EDA_ITEMS", line 1136
ORA-06512: at "TRIDION_CM.EDA_ITEMS", line 1315
ORA-06512: at line 1
The issue fixed after redoing the content sync.
we checked and found procedures are missed. SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('PROCEDURE') and OBJECT_NAME like'%ITEM_READ%';
Answered by krishna garikapati on September 30, 2021
This looks like something you should take up with your Oracle DBA. IF there's "no data found", it seems likely that your "content sync" hasn't gone well.
Answered by Dominic Cronin on September 30, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP