Number formatter timeout error

[Petram PVC]

Your Task History ID

IjU3NjMwNTY5MDYzMzA0M2Q1MjZjNTUzNjUxMzM1MTZiNTQzOCI_3D_pc

Hello,

I'm having an issue with a number formatter step suddenly not working due to a timeout error.

I have a number formatter performing a spreadsheet formula:

mid('2. Result : _status_history","value":{"1695228089":"pending","1695228105":"on-hold","1695234540":"completed"',find("%",substitute('2. Result : _status_history","value":{"1695228089":"pending","1695228105":"on-hold","1695234540":"completed"',char(34),"%",(len(SUBSTITUTE('2. Result : _status_history","value":{"1695228089":"pending","1695228105":"on-hold","1695234540":"completed"',char(34),' '))-len(trim(SUBSTITUTE('2. Result : _status_history","value":{"1695228089":"pending","1695228105":"on-hold","1695234540":"completed"',char(34),' '))))-4))+1,10)

This formula extracts the last 10 digit time stamp from a string. Until recently it was performing as expected but in the last day it has stopped working and reports the following error:

Response not received in 25 seconds.
Learn more: https://forum.pabbly.com/threads/pa...rror-response-not-received-in-25-seconds.855/

after tinkering with it i sometimes get an http 500 error as well.

I have other steps that are performing similar operations but just this one does not work. I have tried to refresh the data and reestablish the variables but to no affect.

Any advice on what may be the issue?

Thank you!

 

[ArshilAhmad]

Hi @Petram PVC,

Please try adding a Delay between two number formatters and see if that fixes the issue for you.

 

[Petram PVC]

okay i will try that but this issue occurs also when just doing a test request and save. additionally, if i change the variables to static text it does the same?

 

[Pabblymember11]

but this issue occurs also when just doing a test request and save. additionally, if i change the variables to static text it does the same?

What is the step number of the number formatter you are using in your workflow? Also, please try using the Delay action step before the Number formatter action step.