Forum Discussion

HeirsPowerBi's avatar
HeirsPowerBi
Helper I
3 years ago

Scheduled Refresh Failing

Hello, The scheduled refresh on one of my datasets keeps failing and i cannot for the life of me figure out why. There are two datasources on the dataset. One from an onPrem Oracle Database and one...
Need Help
PaulusD's avatar
PaulusD
Resolver II
3 years ago

then i would suggest deleting the report and the dataset in the service, refresh in the desktop and re-publish to the service.

 

If that doesn't work you could try deleting the source from the gateway and re-adding that, but as you have a oracle on prem source i'm guessing that you have more reports linked to that source. This would be a last option that you probably don't want to use. it would require re-linking the source to the gateway for all reports using this source.

HeirsPowerBi's avatar
HeirsPowerBi
Helper I
3 years ago

Hello,

I downloaded a personal gateway to try and see if the refresh would work. but i now get this Error

 

ORA-03135: connection lost contact Process ID: 2956 Session ID: 195 Serial number: 52488

 

Any ideas please.

 

I have tried to increase SQLNET.EXPIRE_TIME in my SQLNET.ora fille but nothing works

Please help me