Since the recent update, I have had the following error when trying to access a remote sql database.
Procedure:
PROCESSDIRECTIVE
Message Text:
Timeout encountered during processing of remote database command
Help Text:
No response was found in data queue VV050193O within timeout value of 60 seconds. If job VRMT050193, which is responsible for processing remote DB calls and populating the data queue, is no longer running then you must restart the VALENCE52 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:
MEH
IBM i User:
MEH
Timestamp:
2019-08-28-10.38.33.403000
Job Number:
50193
Calling Program:
VVRMTDB
Call Stack:
VVCALL[VVCALL]-->VVDATASRC[VVDATASRC]-->VVDATASRC[GETDATA]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOJSON]-->VVRMTDB[VVRMTDB]-->VVRMTDB[PROCESSDIRECTIVE]
Error ID 118 | REMOVE |
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 VV050193O within timeout value of 60 seconds. If job VRMT050193, which is responsible for processing remote DB calls and populating the data queue, is no longer running then you must restart the VALENCE52 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:
MEH
IBM i User:
MEH
Timestamp:
2019-08-28-10.38.33.403000
Job Number:
50193
Calling Program:
VVRMTDB
Call Stack:
VVCALL[VVCALL]-->VVDATASRC[VVDATASRC]-->VVDATASRC[GETDATA]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOJSON]-->VVRMTDB[VVRMTDB]-->VVRMTDB[PROCESSDIRECTIVE]