Using the download to Excel button (vvOut_execSQLtoSS) in an app created using Nitro Auto Code. The data source is complex. I have the result set on my screen, but when I attempt to download
I get the following error - I'm guessing it takes longer than 60 seconds to retrieve the dataset? How can i fix this?
Procedure:
PROCESSDIRECTIVE
Message Text:
Timeout encountered during processing of remote database command
Help Text:
No response was found in data queue VV156544O within timeout value of 60 seconds. If job VRMT156544, which is responsible for processing remote DB calls and populating the data queue, is no longer running then you must restart the VALENCE52P server instance before any more remote DB commands can be processed. If the job is running then there may be an excessive delay in processing the remote DB request on the remote server (mode=EXSQL).
Valence Login ID:
GWILBURN
IBM i User:
GWILBURN
Timestamp:
2020-04-02-13.19.43.835000
Job Number:
156544
Calling Program:
VVRMTDB
Call Stack:
VVCALL[VVCALL]-->AC1008[AC1008]-->AC1008[GETRECS]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOSS]-->VVRMTDB[VVRMTDB]-->VVRMTDB[PROCESSDIRECTIVE]
I get the following error - I'm guessing it takes longer than 60 seconds to retrieve the dataset? How can i fix this?
Program: | VVRMTDB | Statement: | |
Module: | VVRMTDB | Message ID: | VV00068 |
PROCESSDIRECTIVE
Message Text:
Timeout encountered during processing of remote database command
Help Text:
No response was found in data queue VV156544O within timeout value of 60 seconds. If job VRMT156544, which is responsible for processing remote DB calls and populating the data queue, is no longer running then you must restart the VALENCE52P server instance before any more remote DB commands can be processed. If the job is running then there may be an excessive delay in processing the remote DB request on the remote server (mode=EXSQL).
Valence Login ID:
GWILBURN
IBM i User:
GWILBURN
Timestamp:
2020-04-02-13.19.43.835000
Job Number:
156544
Calling Program:
VVRMTDB
Call Stack:
VVCALL[VVCALL]-->AC1008[AC1008]-->AC1008[GETRECS]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOSS]-->VVRMTDB[VVRMTDB]-->VVRMTDB[PROCESSDIRECTIVE]
Comment