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

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

  
Forge Component
(16)
Published on 2013-02-21 by Rúben Gonçalves
16 votes
Published on 2013-02-21 by Rúben Gonçalves
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: http://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

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