Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

clarissecansino

PowerBI Scheduled Refresh error

Submitted by on ‎04-20-2021 12:45 PM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-lili6-msft
Community Support
Community Support
‎04-20-2021 08:58 PM

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
‎04-21-2021 01:01 PM

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
‎05-04-2021 07:21 AM

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

Idea Statuses