While using Xtraction, following error is received: "An error has occurred during processing. Please try again. If this continues to occur, please contact the application administrator."

Document ID : KB000007513
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

While using Xtraction, following error message might be displayed within the user interface:

 "An error has occurred during processing. Please try again. If this continues to occur, please contact the application administrator."

Environment:
CA Service Desk Manager 12.9 and 14.1All Supported Xtraction versions
Cause:

This error might occur when an user keeps Xtraction opened for long time.  In such cases, looking into the Xtraction logs there might be a SQL error related to the user workstation (search for the workstation's IP address):

Machine User Id : NT AUTHORITY\NETWORK SERVICE 

System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 245) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 

at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) 

at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) 

at System.Data.SqlClient.SqlDataReader.Read() 

at 0.i.0(GroupComponentStandardSeries , Int32 , IndexedDataTable , ComponentParameterCollection ) 

at 0.i.0(GroupComponent ) 

at 0.i.GetDataXml(GroupComponent component) 

at SqlDataEngine.Services.Components.GroupComponentService.GetDataXml(GroupComponent component) 

at Xtraction.Service.SqlDataEngineService.GetGroupComponentData(GroupComponent component) 

at Xtraction.Web.Services.SqlDataEngineWebService.GetGroupComponentData(GroupComponent component) 

ClientConnectionId:3f6b7f88-798f-4a77-974e-572295c98e82 

Error Number:1205,State:51,Class:13 

The reason why the issue is occurring is that the query is sent from Xtraction, reaches the SQL server, is given a transaction ID and then is chosen as a deadlock victim due to other (higher priority) transactions happening simultaneously. This is all happening on the SQL side. Afterward, it returns that error to Xtraction to explain why the query was unable to be processed.

Resolution:

Please run the following against the MDB database after stopping applications that access the MDB: 

ALTER DATABASE MDB 

SET ALLOW_SNAPSHOT_ISOLATION ON

Additional Information:

The solution was provided after consulting with Xtraction support team.

Xtraction support team is not aware of any adverse side effects from making the change. 

As always, we recommend testing all changes in a non-PROD environment first. 

If you want to know the snapshot isolation state of a SQL database, run the below SQL script: 

 SELECT name 

, s.snapshot_isolation_state 

, snapshot_isolation_state_desc 

, is_read_committed_snapshot_on 

FROM sys.databases s 

 

Upon running the above script, it will return the results describing the status of the isolation level. 

By default MDB database has snapshot_isolation_state set to OFF. 

If you are seeing the error message during the Xtraction login, check technical document TEC1126449.