JPG079
Design Dabbler

K2 4.7 Posting duplicate transaction in MS Sql DB

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 

0 Kudos
Reply
9 Replies
HulisaniN
Nintex Newbie

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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

 

 

0 Kudos
Reply
JPG079
Design Dabbler

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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

0 Kudos
Reply
JPG079
Design Dabbler

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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

0 Kudos
Reply
YUDI2
Nintex Newbie

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

JPG079 wrote:

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 ?

0 Kudos
Reply
JPG079
Design Dabbler

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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

0 Kudos
Reply
YUDI2
Nintex Newbie

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

JPG079 wrote:

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”

0 Kudos
Reply
JPG079
Design Dabbler

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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. 

0 Kudos
Reply
kateV1
Nintex Newbie

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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.
 

0 Kudos
Reply
JPG079
Design Dabbler

Re: K2 4.7 Posting duplicate transaction in MS Sql DB

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    

0 Kudos
Reply