|
Description |
|
Data corruption issue with a view/grid that seems to have bugged out. It appears to be active and inactive at the same time. When trying to deactivate the grid , the following error appears: "This record cannot be deleted because it is associated with another record in the system." When attempting to change the description to deactivate it, I get this error: "The FROM clause contains at least one table that does not exist U5SFK1." Finally, when trying to deactivate the view U5SFK1, weI see this error: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ORA-06512: at 'O7USERDEFINEDVIEW', line 30 ORA-06512: at line 1." When looking in the database, the view U5SFK1 does not exist. But the view record itself does exist: select * from R5USERVIEWS where uvw_code ='U5SFK1' the Active checkbox is + View: U5SFK1 Grid: ZUSFK2 Steps to reproduce : Grid designer - select grid 100076 - try modifying the description. Grid designer | Validation - uncheck Active checkbox and save. Views - select view U5SFK1 - uncheck Active checkbox and save. Expected behavior - Changes can be done. Current behavior - no errors occur. |