Mashup Container fails to initialize when setting Oracle FetchSize

[Thor89]

I'm trying to set an gateway wide overwrite for the Oracle FetchSize to increase the performance of loading data from Oracle.

Working of this community thread.

I setup a test gateway on the side to test it and everything worked fine.

When I set the same config on my production gateway (3 node cluster running in distribution mode) the Mashup container always fails to initalize for all refreshes comming in. This shows up in the event log as "Configuration system failed to initialize" errors.

The test gateway is the same version and running the same Oracle client.

The Microsoft.Mashup.Container.NetFX45.exe.config content

<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>
</startup>
<oracle.dataaccess.client>
<settings>
<add name="FetchSize" value="1000000"/>
</settings>
</oracle.dataaccess.client>
</configuration>

The error from the event viewer
Application: Microsoft.Mashup.Container.NetFX45.exe
Framework Version: v4.0.30319
Description: The application requested process termination through System.Environment.FailFast(string message).
Message: Configuration system failed to initialize
Stack:
at System.Environment.FailFast(System.String, System.Exception)
at Microsoft.Mashup.Container.EvaluationContainerMain+ExceptionHandler.TryHandleException(System.Exception)
at Microsoft.Mashup.Evaluator.SafeThread2.HandleException(System.Exception)
at Microsoft.Mashup.Evaluator.SafeThread2+<>c__DisplayClass9_0.<CreateAction>b__0(System.Object)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(System.String[])
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(System.String[])

[v-yanjiang-msft]

Hi @Thor89 ,

Please see if the solutions in the below article can help, which has the similar scenario with you:

Fixing "Configuration System Failed to Initalize" Exception – Kevin McNeish Blog (msmvps.com)

Best regards,

Community Support Team_kalyj

[Thor89]

Hi @v-yanjiang-msft, I read through it. To be thorough I C/P the config from the working test gateway to my main one but the same problem arrises. Imedietly after the config is set the refreshes that come in fail during the initalization of the Mashup engine.

Since the original config is setup in a single line

<configuration><startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/></startup></configuration>

I also tried setting the confing into a single line 

<configuration><startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/></startup><oracle.dataaccess.client><settings><add name="FetchSize" value="1000000"/></settings></oracle.dataaccess.client></configuration>

but that also causes the same error.

I've also looked at the EnterpriseGatewayConfigurator.exe.config, Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config and Microsoft.PowerBI.EnterpriseGateway.exe.config files to see if there is a discrepancy between my test gateway and the main one there and there are none.

[Thor89]

Issue is solved.

In case someone has this issue.

With help from the Microsoft serivice desk the problem was tracked down to a missing GAC registration of the ODP.NET, unmanaged drivers. Running "[System.Data.Common.DbProviderFactories]::GetFactoryClasses()" in Powershell did not give an entry. The original install of the Oracle driver was therefore not compleated correctly.

Registering the DLL following this guide resolved the issue.

[v-yanjiang-msft]

Hi @Thor89 ,

Glad your problem was solved and thanks for your root solution sharing! Others who has the same problem will benefit from here. Then I will close the thread.

Best regards,

Community Support Team_yanjiang