User Profile
Steve_Lang
New Member
Joined 3 years ago
User Widgets
Contributions
Re: Oracle Server Down
HI, It seems to error when calling Oracle.Database(...) let Source = Oracle.Database("..server.."), TestForError = try Source, Output = if TestForError[HasError] then Table.FromRecords({}, {..Field names..}) else let Source2 = Oracle.Database("..server..", [Query="..SQL..", HierarchicalNavigation=true]), #"Changed Type" = Table.Transf... etc #"Final Transformation" = Table.AddCol.. in #"Final Transformation" in Output I have created a pararmeter to switch on or off and if it does not try the Oracle Server i have no Error, when the Parameter ServerUp is set to False if ServerUp = true then try Oracle.Dat....886Views0likes1CommentOracle Server Down
I'm using Power BI to monitor multiple oracle environments for payrolls. The problem comes when one of the environments is down and the transfer of data from all environments stops. I'm using Report server. Is it possible to ignore an environment when it's down but still connect to the other environments, cheers for any help Hi have tried a lightweight check = try Oracle.Database(OraEnv, [Query="SELECT 1 FROM DUAL"]) otherwise null Where OraEnv is the Oracle server. And i still get the error message. DataSource.Error: Oracle: ORA-12541: TNS:no listener Details: DataSourceKind=Oracle DataSourcePath=****** Message=ORA-12541: TNS:no listener ErrorCode=-2147467259 I know the server is offline and i should not be able to connect, but i don't want the fact that this one server is down stop the monitoring of the other servers. I can't see anything in Report Server to set ignore if errored.Solved968Views0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.