I am also facing same issue “F_JD22D3 DBMS error [Communication link failure. comm rc=8413 – CWBCO1054 – A user-specified time-out occurred while sending or receiving data]. DBMS error number . SQL State [08S01]. DBMS version [*******] Last query [‘*******’]”.
I have tried using SQL_PREPARE_TIMEOUT=30000 as environment variable. In general very high value. But, no luck.
Can you help to know , what is value for this HVR_ODBC_CONNECT_STRING_ADD?
How can we add SQL_PREPARE_TIMEOUT to it?
What is purpose of QUERYTIMEOUT ? Does this also need to be add in HVR_ODBC_CONNECT_STRING_ADD? If yes, what is recommended value for it?
Oops! Looks like you're using an outdated browser...
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.