cancel
Showing results for 
Search instead for 
Did you mean: 

PowerBI Scheduled Refresh error

Hi there,

 

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.

 

Thanks,

Clarisse

Status: New
Comments
v-lili6-msft
Community Support

hi

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.

 

Regards,

Lin

clarissecansino
New Member

Hi Lin,

 

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.

 

Thanks,

clarissecansino
New Member

Hi there,

 

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.

 

Thanks,

Clarisse