[MySQL Connector] Calling SP locking Table in case of error

Back to Forums

Pramod Jain

MVP

Question

Forge

Hi All,
i am calling an Stored Procedure using this extensin and in case of any error the table gets locke d and second time if i am doing the same thing getting below mentioned error.
I have to kill the database process manually in order to run it again.
----------------------------------Error Log----------------------------------

Lock wait timeout exceeded; try restarting transaction

Stack:

at ssBillingAPI.RssExtensionMySQLConnector.MssExecuteSP(HeContext heContext, String inParamConnectionName, String inParamCommand, Object inParamList, Int32 inParamTimeout)
at ssBillingAPI.Actions.ActionProceedInitiateBilling(HeContext heContext, Int32 inParamClientID, String inParamProjectLineItemIDs, String inParamPERIOD, String inParamBillingCycleStartDate, String inParamBillingCycleEndDate, Int32 inParamSUPERVISOR_ID, Int32 inParamIS_forecasted, RLInitiateBillingRecordList& outParamInitiateBillingID)
at ssTimesheetBilling.RsseSpaceBillingAPI.MssProceedInitiateBilling(HeContext heContext, Int32 inParamClientID, String inParamProjectLineItemIDs, String inParamPERIOD, String inParamBillingCycleStartDate, String inParamBillingCycleEndDate, Int32 inParamSUPERVISOR_ID, Int32 inParamIS_forecasted, RecordList& outParamInitiateBillingID)
at ssTimesheetBilling.Actions.ActionProceedInitiateBilling(HeContext heContext, Int32 inParamClientID, String inParamProjectLineItemIDs, String inParamPERIOD, String inParamBillingCycleStartDate, String inParamBillingCycleEndDate, Int32 inParamSUPERVISOR_ID, Int32 inParamIS_forecasted, RLInitiateBillingRecordList& outParamInitiateBillingID)
at ssTimesheetBilling.Flows.FlowBilling.ScrnInitialization.CommandProceedInitialization_Submit(HeContext heContext)
-Env-
eSpaceVer: 10 (Id=60, PubId=114, CompiledWith=7.0.1.9)
RequestUrl: https://cpro17215.publiccloud.com.br/TimesheetBilling/Initialization.aspx (Method: POST)
AppDomain: /LM/W3SVC/1/ROOT/TimesheetBilling-3-130270682314100000
FilePath: C:\...\PS\running\TimesheetBilling.694355357\Initialization.aspx
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 788 ('w3wp', Started='24/10/2013 06:00:32', Priv=119Mb, Virt=2864Mb)
TID: 3
Thread Name:
.NET: 2.0.50727.5466

24 Oct 2013

Ruben Goncalves

Hi Pramod,

Sorry for the laaaaaaaaaate reply, but have you been able to work around this?
If so, can you share the solution?

Thanks,

RG

22 Oct 2014

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines