Error in Execute DML : Main Error: Thread was being aborted
I have error in my application during execute query .
This query is execute for 1000 difference id s in sequence.
some of these id have error Error in Execute Query
and Thread was being aborted
.
11/12/2018 10:29:58 ق.ظ Info GetCardType...
11/12/2018 10:29:59 ق.ظ Error Error in Execute DML
Error in Execute Query
select * from . . . .
Main Error: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error InnerException1: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet, ParamCollection queryParams)
at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet)
at Kishware.DataAccess.Oracle.OracleDbRequestExecutor.RunQuery(String queryText, DataSet resultDataSet)
at Kishware.Card.DA.CardDAO.GetAccountCards(EfCard filter)
at Kishware.Card.Logic.CardMngr.DoDefCard(Int16 switchCode, CardIssueInfo cardIssueInfo, CardStatus cardStatus, IssueCardData issueCardData, Int64 groupNumber, Int16 templateId, String buyerName, Decimal prepaidAmount, String description, DateTime expireDate, DateTime effectiveDate, Int16 maxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, Boolean licenseControlCardCount, LoggerEnhancer logger, String printerSerial, String clientIpAddress, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, Boolean offlineIssue, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, DateTime requestDate, CardMediaType mediaType, Nullable`1 needToConfirm, EbContact holder, PaymentApplicationType paymentApplicationType, Nullable`1 minChargeAmount, String inputPan, String inputTrackCVV)
at Kishware.Card.Logic.CardMngr.IssueCard(Int64 customerId, Nullable`1 cardHolderId, CardIssueInfo cardIssueInfo, Nullable`1 status, String clientIpAddress, Int16 templateId, Int16 mainAcountHostId, Nullable`1 isoCardAccountType, Nullable`1 depositAccountType, String depositNumber, String preCardPan, String buyerName, Decimal prepaidAmount, EbCreditAccount creditAccount, String creditFileID, String creditTemplateID, Nullable`1 requestBranchCode, Nullable`1 requestDate, Nullable`1 requestServiceCode, Nullable`1 cardExpireDate, Nullable`1 cardEffectiveDate, Nullable`1 cardMaxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, String printerSerial, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, EbServiceCall serviceCall, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, Nullable`1 groupNumber, Boolean offlineIssue, CardMediaType validMediaTypes, Nullable`1 needToConfirm, DepositTemplateConstraintErrorEntity depositTemplateConstraintErrorEntities, String holderId, Nullable`1 minChargeAmount, String prepaidTemplateId, String requesterIpAddress, Boolean isNeginCore, Nullable`1 personalizerId, String inputPan, String inputTrackCVV, EbSmartAppData smartAppData)
sql oracle11g threadpool dml
add a comment |
I have error in my application during execute query .
This query is execute for 1000 difference id s in sequence.
some of these id have error Error in Execute Query
and Thread was being aborted
.
11/12/2018 10:29:58 ق.ظ Info GetCardType...
11/12/2018 10:29:59 ق.ظ Error Error in Execute DML
Error in Execute Query
select * from . . . .
Main Error: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error InnerException1: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet, ParamCollection queryParams)
at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet)
at Kishware.DataAccess.Oracle.OracleDbRequestExecutor.RunQuery(String queryText, DataSet resultDataSet)
at Kishware.Card.DA.CardDAO.GetAccountCards(EfCard filter)
at Kishware.Card.Logic.CardMngr.DoDefCard(Int16 switchCode, CardIssueInfo cardIssueInfo, CardStatus cardStatus, IssueCardData issueCardData, Int64 groupNumber, Int16 templateId, String buyerName, Decimal prepaidAmount, String description, DateTime expireDate, DateTime effectiveDate, Int16 maxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, Boolean licenseControlCardCount, LoggerEnhancer logger, String printerSerial, String clientIpAddress, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, Boolean offlineIssue, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, DateTime requestDate, CardMediaType mediaType, Nullable`1 needToConfirm, EbContact holder, PaymentApplicationType paymentApplicationType, Nullable`1 minChargeAmount, String inputPan, String inputTrackCVV)
at Kishware.Card.Logic.CardMngr.IssueCard(Int64 customerId, Nullable`1 cardHolderId, CardIssueInfo cardIssueInfo, Nullable`1 status, String clientIpAddress, Int16 templateId, Int16 mainAcountHostId, Nullable`1 isoCardAccountType, Nullable`1 depositAccountType, String depositNumber, String preCardPan, String buyerName, Decimal prepaidAmount, EbCreditAccount creditAccount, String creditFileID, String creditTemplateID, Nullable`1 requestBranchCode, Nullable`1 requestDate, Nullable`1 requestServiceCode, Nullable`1 cardExpireDate, Nullable`1 cardEffectiveDate, Nullable`1 cardMaxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, String printerSerial, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, EbServiceCall serviceCall, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, Nullable`1 groupNumber, Boolean offlineIssue, CardMediaType validMediaTypes, Nullable`1 needToConfirm, DepositTemplateConstraintErrorEntity depositTemplateConstraintErrorEntities, String holderId, Nullable`1 minChargeAmount, String prepaidTemplateId, String requesterIpAddress, Boolean isNeginCore, Nullable`1 personalizerId, String inputPan, String inputTrackCVV, EbSmartAppData smartAppData)
sql oracle11g threadpool dml
Possible duplicate of Why am i getting "Thread was being aborted" in asp.net? - I think this is more related to the platform (ASP, I guess?) than Oracle. The query is just terminated because the tread is terminated, but it would as well be if this was not an Oracle query, but any other long running task.
– GolezTrol
Nov 13 '18 at 10:42
add a comment |
I have error in my application during execute query .
This query is execute for 1000 difference id s in sequence.
some of these id have error Error in Execute Query
and Thread was being aborted
.
11/12/2018 10:29:58 ق.ظ Info GetCardType...
11/12/2018 10:29:59 ق.ظ Error Error in Execute DML
Error in Execute Query
select * from . . . .
Main Error: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error InnerException1: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet, ParamCollection queryParams)
at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet)
at Kishware.DataAccess.Oracle.OracleDbRequestExecutor.RunQuery(String queryText, DataSet resultDataSet)
at Kishware.Card.DA.CardDAO.GetAccountCards(EfCard filter)
at Kishware.Card.Logic.CardMngr.DoDefCard(Int16 switchCode, CardIssueInfo cardIssueInfo, CardStatus cardStatus, IssueCardData issueCardData, Int64 groupNumber, Int16 templateId, String buyerName, Decimal prepaidAmount, String description, DateTime expireDate, DateTime effectiveDate, Int16 maxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, Boolean licenseControlCardCount, LoggerEnhancer logger, String printerSerial, String clientIpAddress, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, Boolean offlineIssue, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, DateTime requestDate, CardMediaType mediaType, Nullable`1 needToConfirm, EbContact holder, PaymentApplicationType paymentApplicationType, Nullable`1 minChargeAmount, String inputPan, String inputTrackCVV)
at Kishware.Card.Logic.CardMngr.IssueCard(Int64 customerId, Nullable`1 cardHolderId, CardIssueInfo cardIssueInfo, Nullable`1 status, String clientIpAddress, Int16 templateId, Int16 mainAcountHostId, Nullable`1 isoCardAccountType, Nullable`1 depositAccountType, String depositNumber, String preCardPan, String buyerName, Decimal prepaidAmount, EbCreditAccount creditAccount, String creditFileID, String creditTemplateID, Nullable`1 requestBranchCode, Nullable`1 requestDate, Nullable`1 requestServiceCode, Nullable`1 cardExpireDate, Nullable`1 cardEffectiveDate, Nullable`1 cardMaxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, String printerSerial, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, EbServiceCall serviceCall, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, Nullable`1 groupNumber, Boolean offlineIssue, CardMediaType validMediaTypes, Nullable`1 needToConfirm, DepositTemplateConstraintErrorEntity depositTemplateConstraintErrorEntities, String holderId, Nullable`1 minChargeAmount, String prepaidTemplateId, String requesterIpAddress, Boolean isNeginCore, Nullable`1 personalizerId, String inputPan, String inputTrackCVV, EbSmartAppData smartAppData)
sql oracle11g threadpool dml
I have error in my application during execute query .
This query is execute for 1000 difference id s in sequence.
some of these id have error Error in Execute Query
and Thread was being aborted
.
11/12/2018 10:29:58 ق.ظ Info GetCardType...
11/12/2018 10:29:59 ق.ظ Error Error in Execute DML
Error in Execute Query
select * from . . . .
Main Error: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error InnerException1: Thread was being aborted.
11/12/2018 10:29:59 ق.ظ Error at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet, ParamCollection queryParams)
at Kishware.DataAccess.Library.DbRequestExecutor.RunQuery(String queryText, DataSet resultdataSet)
at Kishware.DataAccess.Oracle.OracleDbRequestExecutor.RunQuery(String queryText, DataSet resultDataSet)
at Kishware.Card.DA.CardDAO.GetAccountCards(EfCard filter)
at Kishware.Card.Logic.CardMngr.DoDefCard(Int16 switchCode, CardIssueInfo cardIssueInfo, CardStatus cardStatus, IssueCardData issueCardData, Int64 groupNumber, Int16 templateId, String buyerName, Decimal prepaidAmount, String description, DateTime expireDate, DateTime effectiveDate, Int16 maxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, Boolean licenseControlCardCount, LoggerEnhancer logger, String printerSerial, String clientIpAddress, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, Boolean offlineIssue, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, DateTime requestDate, CardMediaType mediaType, Nullable`1 needToConfirm, EbContact holder, PaymentApplicationType paymentApplicationType, Nullable`1 minChargeAmount, String inputPan, String inputTrackCVV)
at Kishware.Card.Logic.CardMngr.IssueCard(Int64 customerId, Nullable`1 cardHolderId, CardIssueInfo cardIssueInfo, Nullable`1 status, String clientIpAddress, Int16 templateId, Int16 mainAcountHostId, Nullable`1 isoCardAccountType, Nullable`1 depositAccountType, String depositNumber, String preCardPan, String buyerName, Decimal prepaidAmount, EbCreditAccount creditAccount, String creditFileID, String creditTemplateID, Nullable`1 requestBranchCode, Nullable`1 requestDate, Nullable`1 requestServiceCode, Nullable`1 cardExpireDate, Nullable`1 cardEffectiveDate, Nullable`1 cardMaxRetryCount, Boolean repeatConfrimIsOk, String additionalInfo, String printerSerial, String requesterUserCode, String requesterBranchCode, String issuerUserCode, String issuerBranchCode, EbServiceCall serviceCall, Nullable`1 cardSerial, Boolean replicateCardWithPrePan, Nullable`1 groupNumber, Boolean offlineIssue, CardMediaType validMediaTypes, Nullable`1 needToConfirm, DepositTemplateConstraintErrorEntity depositTemplateConstraintErrorEntities, String holderId, Nullable`1 minChargeAmount, String prepaidTemplateId, String requesterIpAddress, Boolean isNeginCore, Nullable`1 personalizerId, String inputPan, String inputTrackCVV, EbSmartAppData smartAppData)
sql oracle11g threadpool dml
sql oracle11g threadpool dml
asked Nov 13 '18 at 10:00
Mahsa ehsaniMahsa ehsani
537
537
Possible duplicate of Why am i getting "Thread was being aborted" in asp.net? - I think this is more related to the platform (ASP, I guess?) than Oracle. The query is just terminated because the tread is terminated, but it would as well be if this was not an Oracle query, but any other long running task.
– GolezTrol
Nov 13 '18 at 10:42
add a comment |
Possible duplicate of Why am i getting "Thread was being aborted" in asp.net? - I think this is more related to the platform (ASP, I guess?) than Oracle. The query is just terminated because the tread is terminated, but it would as well be if this was not an Oracle query, but any other long running task.
– GolezTrol
Nov 13 '18 at 10:42
Possible duplicate of Why am i getting "Thread was being aborted" in asp.net? - I think this is more related to the platform (ASP, I guess?) than Oracle. The query is just terminated because the tread is terminated, but it would as well be if this was not an Oracle query, but any other long running task.
– GolezTrol
Nov 13 '18 at 10:42
Possible duplicate of Why am i getting "Thread was being aborted" in asp.net? - I think this is more related to the platform (ASP, I guess?) than Oracle. The query is just terminated because the tread is terminated, but it would as well be if this was not an Oracle query, but any other long running task.
– GolezTrol
Nov 13 '18 at 10:42
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53278386%2ferror-in-execute-dml-main-error-thread-was-being-aborted%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53278386%2ferror-in-execute-dml-main-error-thread-was-being-aborted%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Possible duplicate of Why am i getting "Thread was being aborted" in asp.net? - I think this is more related to the platform (ASP, I guess?) than Oracle. The query is just terminated because the tread is terminated, but it would as well be if this was not an Oracle query, but any other long running task.
– GolezTrol
Nov 13 '18 at 10:42