Question

K2 4.7 Posting duplicate transaction in MS Sql DB

  • 13 October 2020
  • 9 replies
  • 198 views

Badge +1

I recently did a deployment in to a production environment  for  k2 4.7 and afterwards the production environment started posting repeated transactions in the SQL tables.This happens randomly but when it happens the client has a lag for a couple of seconds. This does not happen on the dev environment where the package was compiled form. The host server log has a number of timeout issues at the same time the duplicate transactions are posted. 

 


"101538149","2020-10-05 14:37:27","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101538149","6d1948c93302474096b9ad494ad3463d",""
"101538477","2020-10-05 14:37:35","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101538477","4e379532d72749e3b50b0b7308ab5ccb",""
"101538486","2020-10-05 14:37:50","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101538486","49b4e915fd2249c9919675b4013938a0",""
"101538717","2020-10-05 14:38:02","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101538717","81c3455d8fed4a5b9a302246d6587cc5",""
"101538721","2020-10-05 14:38:14","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101538721","8910d66e86ab4078ab72732466e5e295",""
"101538927","2020-10-05 14:38:17","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101538927","b2552a7a9f604ef7969b788800093a08",""
"101539141","2020-10-05 14:38:31","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the ROC_Application_DB Service Instance. Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR:C:\Program Files (x86)\K2 blackpearl\Host Server\Bin","101539141","3606b0586e4a480eb15c1ae6a88faebb",""
"101539175","

 

We also recently updated the Instance timeout on the production environment I am not sure this could be the issue.  Any help appreciated 


9 replies

Userlevel 2
Badge +4

Hi there,

 

Please have a look at the following KB that address a similar issue.

https://help.k2.com/support-services/kbt137483

 

Hope this helps

 

Best Regards

HulisaniN

 

 

Badge +1

The issue is happening while running a form and not when running the WF, The current pack is the CUM March 2018.

Badge +1

This issue is happening in the application form. The current patch is the cumulative 2018 March 

Userlevel 1
Badge +4

This issue is happening in the application form. The current patch is the cumulative 2018 March 

 

is this anonymous user have access to perform execute smartobject to database ?

Badge +1

We are not using anonymous users, Users from the active directory

Userlevel 1
Badge +4

We are not using anonymous users, Users from the active directory

 

As the issue happen randomly and on the logs seems anonymous user is executing the task. It could be other issue as well but I would suggest maybe you may want to check it first if the smartform anonymous properties is not checked.  

https://help.k2.com/onlinehelp/k2blackpearl/icg/4.7/default.htm#Configure/SF_AnonViewForms.htm

 

“The timeout period elapsed prior to completion of the operation or the server is not responding.","anonymous","0.0.0.0","WEU-SRV-POS01PR”

Badge +1

I checked the offending form and there doesn't seem to be any checkbox  checked. Is there maybe a way to identify which form this error is referring to. 

Userlevel 2
Badge +5

Hi JPG079,

 

Is the ROC_Application_DB Service Instance a “SQL Server Service” service type ?

From the error it seems like it’s having a timeout issue. You may want to try out the below 

 

  • K2 Management page > Integration > Service Instances > Locate your  “ROC_Application_DB” Service instance > Edit > 
  • There is a commandtimeout value, increase that from 30 seconds to 60, 90, 120 seconds (exact value may be different for different environments):
  • always start from smaller value and increase only if necessary and then save 
  • Refresh the service instance then try to access your smartform again

Hope this helps

 

Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such 
using the 'Best Answer', 'Like' and\or ‘Me Too’ options.

 

Cheers,
Kate

 

K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.
 

Badge +1

At the moment it is at 90 seconds. If the timeout is incorrect would that cause duplicate records? I am asking cause the main issue is the duplicate records. At the same time, I found these errors in the log but they could be just a coincidence. Thanks    

Reply