No Record Found error??

[nikki360h]

When I try to open an INC in my queue I get error message that says "Record not found" I am not able to delete it as when I search for it , it does not show up in production,but it is in my queue? How do i get rid of this? What happened? Why is it saying no record found?

[tlhlt]

Hi

When you click on the "Assigned to Me" application menu module does the ticket appear?

Has the incident been closed?

Do you have the ability to view the 'Deleted Records' option to check if the inc is there? normally requires admin role

Cheers

Toby

[nikki360h]

The incident is still in open status. It is not actually assigned to me, it is in a group queue not assigned to anyone. I gave a user admin rights that is in the group and tryed to deleted it as them, it still will not delete. It does not pull up any way else except in there queue on there homepage, it I search the ticket under there group it does not show up

[Pradeep Sharma]

Hi Nicole Hollihan

Go to incident form->Personalize->Dictionary->Filter to have only field of type "Reference"(for "incident" table)

Now check if all the reference fields refers to the another table.

Kindly let me know if you have any questions.

[Jacob_Andersen]

One thing t check is if an admin has recently deleted records using a bg script or if there is a scheduled job or business rule doing this.   If you delete a record from a parent table but not from the child table (or visa versa) in script using gs.sql, you will get this error as a record will exist in one table but not the other.

Be very careful when using gs.sql. I'd stay away from it unless you really know what you're doing with it.