Unknown Number:Object Does not exists Error

Hi ,

I have a item under ECR affected items, when I clicked on the item, The Error pop ups with the message below,please see attached error screen shot.
Unknown Number: Object does not exist.

is item hard deleted ? I cannot find it in the Recycle bin,also if the item is deleted , how can it be visible under affected items section of ECR ? if it is deleted.
Is it something wrong in DB level, please help .

Thanks,
Surya

Agile Talent Asked on June 26, 2018 in Agile PLM (v9),   Product Collaboration.
Add Comment
3 Answer(s)

I would definitely check the Database it see if there’s anything wrong with either the ECR affected items tab or that item itself. 

Oracle Doc ID 1668825.1 might help you a bit here but the Oracle support website indicates that it could be a bunch of different issues. Try looking up the error message on the Oracle Support site and you’ll see what I’m talking about.

Agile Angel Answered on June 27, 2018.
Add Comment

Can you search on the item number you highlighted and find it?  Since it is displaying the item number for the ECR, it being actually hard-deleted is not likely. But it might be something about the item record that is causing the issue (such as the ECO linked to the latest revision of the part).

 First thing to do is run Averify, and if there are actual errors listed, send the log file to Oracle Support and find out what they have to say about the errors. Otherwise it could be a number of things, and you would need to someone who knows the database look at it.

If nothing else, start SQL debug logging on your database (during a quiet period), open the ECR, click on the item, close the SQL debugging log, and then start running queries from the log file against the database that are linked to either the ECR or the item number. If you get an error on an specific SQL query, you can look further at it to see what the problem is.

Agile Angel Answered on June 27, 2018.
Add Comment

If you have access to agile schema, connect with agile user & run this query:

select delete_flag from item where item_number = ‘AS72613’;

If it returns zero rows, that means the item has been hard deleted. If the delete_flag is set to 1, it means it’s in soft deleted state but sometimes in doesn’t show up in the recycle bin. Set it to 0 to make it visible by search again.

Agile Expert Answered on July 1, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.