9:58:27 AM Tuesday, June 9, 2026 Snapshot isolation transaction failed in database 'tempdb' 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. 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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass12_0.b__0() in G:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1213 -------------------------------------------------- 10:46:14 AM Tuesday, June 9, 2026 Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at AppService.apiservice.getdashboarddata(String compid, String empid, String type, String usertype, String dt, String stateid) in G:\Dev\AppService\AppService\apiservice.svc.cs:line 11935 -------------------------------------------------- 11:38:25 AM Tuesday, June 9, 2026 Snapshot isolation transaction failed in database 'tempdb' 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. 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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass12_0.b__0() in G:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1213 -------------------------------------------------- 12:34:59 PM Tuesday, June 9, 2026 Violation of PRIMARY KEY constraint 'PK__ordermas__3213E83F59C55456'. Cannot insert duplicate key in object 'dbo.ordermaster'. The duplicate key value is (2f2a4d7e-2511-4c3b-85e2-ec219eaa5089). The statement has been terminated. 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppService.apiservice.uploadDatav4(DataObj obj) in G:\Dev\AppService\AppService\apiservice.svc.cs:line 2289 {"empid":"4157","companyid":"1","data":[{"id":"9e8a48fd-1a3a-4e31-8d17-191ac8070a2b","type":2,"dataid":"2f2a4d7e-2511-4c3b-85e2-ec219eaa5089","dataObj":{"id":"2f2a4d7e-2511-4c3b-85e2-ec219eaa5089","orderno":"55887","companyid":"1","orderdate":"2026-06-09","marketid":"597","distributorid":"8b8faefa-d337-47f5-a9cf-31a819f0fbff","retailerid":"be463698-0e6a-4dff-ad90-5d694aea3cce","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2026-06-09 12:31:43","createdBy":"4157","status":"1","locationEnabled":1,"latitude":28.9935869,"longitude":77.6978095,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[],"location":"144, Sadar Bazaar, Meerut, Uttar Pradesh 250001, India\n"}},{"id":"28276481-1826-4145-b0a8-e46e715ccb46","type":2,"dataid":"2f2a4d7e-2511-4c3b-85e2-ec219eaa5089","dataObj":{"id":"2f2a4d7e-2511-4c3b-85e2-ec219eaa5089","orderno":"55888","companyid":"1","orderdate":"2026-06-09","marketid":"597","distributorid":"8b8faefa-d337-47f5-a9cf-31a819f0fbff","retailerid":"be463698-0e6a-4dff-ad90-5d694aea3cce","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2026-06-09 12:31:53","createdBy":"4157","status":"1","locationEnabled":1,"latitude":28.9935869,"longitude":77.6978095,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[],"location":"144, Sadar Bazaar, Meerut, Uttar Pradesh 250001, India\n"}},{"id":"58ac4c72-8e46-4fc8-b3b4-885a018e0022","type":2,"dataid":"2f2a4d7e-2511-4c3b-85e2-ec219eaa5089","dataObj":{"id":"2f2a4d7e-2511-4c3b-85e2-ec219eaa5089","orderno":"55889","companyid":"1","orderdate":"2026-06-09","marketid":"597","distributorid":"8b8faefa-d337-47f5-a9cf-31a819f0fbff","retailerid":"be463698-0e6a-4dff-ad90-5d694aea3cce","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2026-06-09 12:32:02","createdBy":"4157","status":"1","locationEnabled":1,"latitude":28.9935869,"longitude":77.6978095,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[],"location":"144, Sadar Bazaar, Meerut, Uttar Pradesh 250001, India\n"}},{"id":"89b13301-f931-4d9e-8254-d4b3c236708d","type":2,"dataid":"84865197-bdbe-4632-9219-b13e19afb2f9","dataObj":{"id":"84865197-bdbe-4632-9219-b13e19afb2f9","orderno":"55890","companyid":"1","orderdate":"2026-06-09","marketid":"597","distributorid":"8b8faefa-d337-47f5-a9cf-31a819f0fbff","retailerid":"76732787-f996-48c4-8569-3c1d1dca8432","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2026-06-09 12:34:25","createdBy":"4157","status":"1","locationEnabled":1,"latitude":28.9937246,"longitude":77.6976051,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[],"location":"135, Sadar Bazaar, Meerut, Uttar Pradesh 250001, India\n"}},{"id":"94c6623b-1a1b-4527-a3c1-0d31cac13834","type":2,"dataid":"84865197-bdbe-4632-9219-b13e19afb2f9","dataObj":{"id":"84865197-bdbe-4632-9219-b13e19afb2f9","orderno":"55891","companyid":"1","orderdate":"2026-06-09","marketid":"597","distributorid":"8b8faefa-d337-47f5-a9cf-31a819f0fbff","retailerid":"76732787-f996-48c4-8569-3c1d1dca8432","calltype":0,"reasonid":"0d665003-a904-4e59-a041-8851dacf604a","grossamt":"0","discper":"","discamt":"","netamt":"0","comments":"","createdDate":"2026-06-09 12:34:35","createdBy":"4157","status":"1","locationEnabled":1,"latitude":28.9937246,"longitude":77.6976051,"gpsEnabled":1,"mockLocation":0,"netEnabled":1,"batteryLevel":"83","details":[],"location":"135, Sadar Bazaar, Meerut, Uttar Pradesh 250001, India\n"}}]} -------------------------------------------------- 3:10:29 PM Tuesday, June 9, 2026 Snapshot isolation transaction failed in database 'tempdb' 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. 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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at AppService.Classes.Dashboard.<>c__DisplayClass12_0.b__0() in G:\Dev\AppService\AppService\Classes\Dashboard.cs:line 1213 --------------------------------------------------