Hi I have a scenario wherein, a Process model is exposed as a web ser

Prateek Bhati over 9 years ago

Hi

I have a scenario wherein, a Process model is exposed as a web service which I am calling from Call Web Service node from another Process model, which is acting as the main process model. In the 1st process model if I insert data using Query Database or Write to Data Store Entity node then data gets inserted in the table. Now in the main process model if again I use query database to fetch the same values that got inserted in the previous step, then I don't get an instant response; the response is received after a short gap of time. I am not able to figure out why this delay is happening and what is the possible solution for this.

Discussion posts and replies are publicly visible

0 pavithrac over 9 years ago

Hi prateekb, when you are fetching the same values it is taking time right, so try storing the values in a variable from stored values of the smart service an try to display in second form instead of fetching....check whether this approach is feasible for your situation
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Prateek Bhati over 9 years ago

Hi pavithrac, thank you for replaying . In my scenario the write to store data node is present in the process model which is exposed as web service. I can't take the stored values of the smart service outside that process model. I am attaching the screen shots of both the process models.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavithrac over 9 years ago

OK....are you facing the same delay with both services. Do you need to use only Query Db for fetching values? I think delay is due to the usage of query DB
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Prateek Bhati over 9 years ago

According to me, the delay occurs only after the call web service node in the main process.I have tried to fetch the value using a query rule in a script task immediate next to the call web service node ,but still it is delaying to display the result.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 9 years ago

Hi Prateek, can you check the time when the web service node is completed and the write to data store is invoked inside the process which is exposed as web service. I feel the web service mode is proceeding further without waiting as Appian web services will just return the process ID
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavithrac over 9 years ago

Yes prateek, actually in your main process model you are using two smart services immediately after one. As both are connecting to data base to read / write values...may be this is a expected time delay...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavithrac over 9 years ago

Yes I agree with @narasimhaaditya. Since the webservice just invokes the process and the flow will continue forward, try setting scheduling to run the Query DB service node after some gap allowing the data store entity service to write values to DB which is in webservice.Just check if its working, may be it will retrive fast once we query after writing to Db before trying to do so....not sure what will happen, can give a try
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Prateek Bhati over 9 years ago

Hi narasimhaaditya and pavithra , I have tried to run Query DB node after short span of time using a timer and in that case I got response from Query Database node but it breaks the activity chaining, so I can't go for it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavithrac over 9 years ago

Ok, just to fill that time gap can you place one or two dummy script tasks in between your two smart services and check whether the flow is continuing without breaking
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Pavan over 9 years ago

Hi prateekb, are you using any custom data types in the process model which is published as webservice?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel