crashId,date,user,version,exceptionname,message,stacktrace,screen,collectionId,ismainexception
System.Int32,System.DateTime,System.String,System.String,System.String,System.String,System.String,System.String,System.Int32,System.Boolean
1,637987615214200000,'2','1.2.13.14','TaxLib.DB.DBQueryFailedException','An attempt to query the database failed: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Transacti__Batch__4E53A1AA". The conflict occurred in database "ProjectTax"\2C table "dbo.Batches"\2C column 'batch_SK'.\0D\0AThe statement has been terminated.\0D\0ASQL Query = "IF NOT EXISTS (select * from Transactions where collectionId = @collectionId AND Receipt_Number = @Receipt AND PayCode_FK = @PaymentCode AND Amount = @Amount\0D\0A				AND Reason = @Reason AND Reason_Private = @PrivateReason AND Installment_Code = @InstallmentCode AND parcelId = @ParcelId AND paidby_FK = @PaidByKey)\0D\0A\0D\0A                INSERT INTO Transactions(Transaction_Date\2C Pay_Date\2C Receipt_Number\2C PayCode_FK\2C Amount\2C Reason\2C Reason_Private\2C PaidWhere_FK\2C PaidBy_FK\2C UserId_FK\2C JurisdictionId\2C \0D\0A                CollectionId\2C ParcelId\2C Batch_FK\2C IsOverpayment\2C Protest\2C BadCheckFlag\2C Installment_Code\2C Org_Trans_FK)\0D\0A                values (@transactionDate\2C @PayDate\2C @Receipt\2C @PaymentCode\2C @Amount\2C @Reason\2C @PrivateReason\2C @PaidWhere\2C @PaidByKey\2C @UserId\2C @Jurisdiction\2C @CollectionId\2C \0D\0A                @ParcelId\2C @BatchKey\2C @IsOverpayment\2C @Protest\2C @BadCheckFlag\2C @InstallmentCode\2C @OrgTransKey)".','   at TaxLib.DB.DBNonQuery.NonQuery(String sQueryText\2C Database db\2C SqlTransaction transaction) in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CTaxLib\5CDB\5CDBNonQuery.cs:line 168\0D\0A   at TaxLib.DB.DBQuery.NonQuery(SqlTransaction transactionObj) in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CTaxLib\5CDB\5CDBQuery.cs:line 85\0D\0A   at TaxLib.Data.Transactions.AddTransaction(Nullable`1 BatchKey\2C Int32 ReceiptNumber\2C Int32 payCode\2C Decimal amount\2C String reason\2C String privateReason\2C DateTime payDate\2C Nullable`1 paidByKey\2C Nullable`1 iPaidWhere\2C Int32 iProtest\2C Int32 InstallmentCode\2C Int32 parcelId\2C Boolean isOverpayment\2C Boolean badCheckFlag\2C Nullable`1 orgTransKey) in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CTaxLib\5CData\5CTransactions.cs:line 1488\0D\0A   at TaxLib.TaxPayments.AbstractTaxPayments.AddToDatabase(DataTable dtAmounts\2C Boolean bIsInstallPmt\2C Boolean bIsImport) in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CTaxLib\5CTaxPayments\5CAbstractTaxPayments.cs:line 226\0D\0A   at ProjectDonut.Parceldata.Collect() in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CParceldata.cs:line 745\0D\0A   at ProjectDonut.Parceldata.btnCollectReceipt_Click(Object sender\2C EventArgs e) in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CParceldata.cs:line 1366\0D\0A   at System.Windows.Forms.Control.OnClick(EventArgs e)\0D\0A   at System.Windows.Forms.Button.OnClick(EventArgs e)\0D\0A   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)\0D\0A   at System.Windows.Forms.Control.WmMouseUp(Message& m\2C MouseButtons button\2C Int32 clicks)\0D\0A   at System.Windows.Forms.Control.WndProc(Message& m)\0D\0A   at System.Windows.Forms.ButtonBase.WndProc(Message& m)\0D\0A   at System.Windows.Forms.Button.WndProc(Message& m)\0D\0A   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd\2C Int32 msg\2C IntPtr wparam\2C IntPtr lparam)','Parceldata',100,T
2,637987615218870000,'2','1.2.13.14','System.Data.SqlClient.SqlException','The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Transacti__Batch__4E53A1AA". The conflict occurred in database "ProjectTax"\2C table "dbo.Batches"\2C column 'batch_SK'.\0D\0AThe statement has been terminated.','   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception\2C Boolean breakConnection\2C Action`1 wrapCloseInAction)\0D\0A   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj\2C Boolean callerHasConnectionLock\2C Boolean asyncClose)\0D\0A   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior\2C SqlCommand cmdHandler\2C SqlDataReader dataStream\2C BulkCopySimpleResultSet bulkCopyHandler\2C TdsParserStateObject stateObj\2C Boolean& dataReady)\0D\0A   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds\2C RunBehavior runBehavior\2C String resetOptionsString\2C Boolean isInternal\2C Boolean forDescribeParameterEncryption\2C Boolean shouldCacheForAlwaysEncrypted)\0D\0A   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior\2C RunBehavior runBehavior\2C Boolean returnStream\2C Boolean async\2C Int32 timeout\2C Task& task\2C Boolean asyncWrite\2C Boolean inRetry\2C SqlDataReader ds\2C Boolean describeParameterEncryptionRequest)\0D\0A   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior\2C RunBehavior runBehavior\2C Boolean returnStream\2C String method\2C TaskCompletionSource`1 completion\2C Int32 timeout\2C Task& task\2C Boolean& usedCache\2C Boolean asyncWrite\2C Boolean inRetry)\0D\0A   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion\2C String methodName\2C Boolean sendToPipe\2C Int32 timeout\2C Boolean& usedCache\2C Boolean asyncWrite\2C Boolean inRetry)\0D\0A   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\0D\0A   at TaxLib.DB.DBNonQuery.NonQuery(String sQueryText\2C Database db\2C SqlTransaction transaction) in C:\5CUsers\5Cjessi\5CSource\5CWorkspaces\5Ctax\5CProjectDonut\5CTaxLib\5CDB\5CDBNonQuery.cs:line 164','Parceldata',100,F
