There was an unknown error executing the application. The engine reported status Error

I am getting an error on an application. I have it scheduled to run nightly and it fails with the message "There was an unknown error executing the application. The engine reported status Error". If I re-run it on the server manually, it succeeds. The workflow pulls data from several different SQL tables and writes yxdb's to a local drive. Before its has been runned server many time and got the result but now am getting the error

Has anyone run up against this before? Any suggestions on where to look for more information? Output result.JPG

Error Message

Accepted answers

fharper

the others are correct in that there is some issue at the time it is trying to run. show all macro messages may help you see exactly what....a file, a DB or some resource is unavailable most likely in the middle of the night. If SQL most DBs that are maintained by back end systems update a refresh table as to when a table or DB was most recently update/refreshed. you can enhance you logic to test for the resources currency and or availability.

All comments

DanM

@surendar,

This error can typically mean that something on your network is causing the error. Since the workflow has run in the past and runs manually this typically can mean either a network change or maintenance may be happening at the time of the scheduled run. To troubleshoot the issue, I would recommend taking a look at the Server logs to see if there are any details in the logs that show a network situation. I would also work with your network team to see if they are running any maintenance at that time or see problems with the network.

If you continue to have issues after investigating please reach out to our Support for assistance.

DanM

surendar

@DanM

I Checked the logs its showing there is 0 errors,0 warning

fharper

Normally i would expect more info on error. the error may be in a macro. make sure you enable "Show all Macro messages"

fharper

yuriy

We are getting this error on the first run on the server. It works fine on local machine. We do not see anything in the logs even though Show macros was checked. Any advise?

thank you

fharper

Can u provide the output log? Turn logging on and capture the right log file, zip it and put in the post here. Make sure show macro messages is on.

AnshumanKumar

While doing Run I got this error whereas while scheduling it was working fine.

When we schedule then it prompts for password.

I have changed my password last week so it was picking the old password.

Then run the workflow and it worked fine.

delrocd

Hello, this issue is happening because you might have changed your password in your laptop login. Just update/edit it in the server to match your laptop login details. Usually works in our team 😁

curator_at_work

it may be password issue, may you changed your sys password recently and that is not in synch with gallery passowrd, so you must contact IT team. or there are some other possibilities as well.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703