FATAL SQLException

I got this error on sunday and it has been driving me crazy The sql log files show maintance going on at the time. (Image of SQL log attached.)

H E L P!!!

here is the error i got.

2013-09-01 04:58:16,959 FATAL [org.xcxcx.txs.SQLServerTxSDAO] [S1028] SQLException executing a stored procedure:
Snapshot isolation transaction failed in database 'TWIATDW' because the object accessed by the statement has been modified by a
DDL statement in another concurrent transaction since the start of this transaction.  It is disallowed because the metadata is not
versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation..  
SQL statement = {call TWIATDW.dbo.Document_Request_pdf(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}.  SQLServer error code = 3,961.
Steve SamsonAsked:
Who is Participating?
ArgentiConnect With a Mentor Commented:
Info about the error.

Change the snapshot isolation level to a non-snapshot isolation level such as read committed before querying metadata, inside your stored procedure code.

Steve SamsonAuthor Commented:
dead on with what the problem was.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.