We have a scheduled PowerBI report that is connected via NetSuite ODBC which intermittently fails. The error that NetSuite Support found on their backend says "ORA-02396: exceeded maximum idle time, please connect again."
Please investigate the cause of this issue.
I don't have NetSuite on my side.
for the error "ORA-02396: exceeded maximum idle time, please connect again."
try to increase the idle_time on the server for the profiles.
We have no control over the idle time. NetSuite will time out after 90 minutes of idle time. Is there another way to avoid this issue? It is baffling that this issue is intermittent. This error comes from a report that is scheduled to refresh at 1 AM daily but there is no pattern of when the error is thrown. All other scheduled reports work fine.
This is still an issue for us. As an additional question, what is meant by idle time? Does it mean the time difference between the refresh request and response from the server? Or does it mean the amount of time it takes to process a request? If it is the latter then there is something we can do about it.