You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Intermitent Error - Data Integrity Error

1 reply [Last post]
Guest's picture
Guest

Getting this error intermitently - Data Integrity Error (124,85). Occuring in different pages but if you go in and do it again i.e. new hire. Error may not appear.

Any suggestions?

CompShack's picture
User offline. Last seen 6 years 1 week ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Intermitent Error - Data Integrity Error

Data Integrity Error happens when you are trying to update data that someone else did while you are on that page. I would try clearing cache on your server and browser then try again. If you are still getting the above error your next step is to turn on SQL trace before you log on. Navigate to the page and try to invoke the error again. When done, get your trace file from the app server and try to identify the SQL causing the error. Tracing will be your best bet, you should find something in that file that will help you out.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog