Db2 uses the Windows Registry to manage some settings, including
the path to the CommonAppData which is where licensing
information is
kept. In Azure environments, the Windows Registry is restricted
so Db2 can not override this path, causing Db2 to fail to
read the license information.
This can cause a failure when trying to connect similar to the
following:
ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has
occurred in Process: 8136 Thread 114 AppDomain: Name:DB_TEST_API
There are no context policies. Function: AESEncryptADONET
(Encryption Info)
CallStack: at System.Environment.get_StackTrace()
at IBM.Data.DB2.Core.DB2ConnPool.HandleUnknownErrors(String
strFncMsg, Exception exception, Boolean bThrow)
at IBM.Data.DB2.Core.DB2ConnPool.EncryptString(String value)
at
IBM.Data.DB2.Core.DB2ConnPool.ReplaceConnectionStringParms(DB2Co
nnection connection, String szValue, DB2ConnSettings& pSettings,
DB2ConnSettingsInternal& pSettingsInternal, Boolean bAttach,
Boolean pushDownStrAppended)
at IBM.Data.DB2.Core.DB2Connection.set_ConnectionString(String
value)
at DB_TEST_API.Controllers.DB2Controller.Execute(String q,
String uid, String pwd, String db, String ser) in
E:
epoDB_TEST_APIDB_TEST_APIDB_TEST_APIControllersDB2Contr
oller.cs:line 51
at lambda_method(Closure , Object , Object[] )
at
Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Objec
t target, Object[] parameters)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.Syn
cObjectResultExecutor.Execute(IActionResultTypeMapper mapper,
ObjectMethodExecutor executor, Object controller, Object[]
arguments)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
g__Logged|12_1(ControllerActionInvoker
invoker)
at
System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TSt
ateMachine](TStateMachine& stateMachine)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
g__Logged|12_1(ControllerActionInvoker
invoker)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
InvokeActionMethodAsync()
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
Next(State& next, Scope& scope, Object& state, Boolean&
isCompleted)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
InvokeNextActionFilterAsync()
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
Next(State& next, Scope& scope, Object& state, Boolean&
isCompleted)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
InvokeNextActionFilterAsync()
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
Next(State& next, Scope& scope, Object& state, Boolean&
isCompleted)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.
InvokeInnerFilterAsync()
at
Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(Sta
te& next, Scope& scope, Object& state, Boolean& isCompleted)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFi
lterPipelineAsync()
at
Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker)
at
System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TSt
ateMachine](TStateMachine& stateMachine)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Logged|17_1(ResourceInvoker invoker)
at
Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeAs
ync()
at
Microsoft.AspNetCore.Mvc.Routing.ActionEndpointFactory.c__Disp
layClass7_0.b__0(HttpContext context)
at
Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpConte
xt httpContext)
at
Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invok
e(HttpContext context)
at
System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TSt
ateMachine](TStateMachine& stateMachine)
at
Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invok
e(HttpContext context)
at
Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(Ht
tpContext httpContext)
at
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewar
e.Invoke(HttpContext context)
at
System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TSt
ateMachine](TStateMachine& stateMachine)
at
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewar
e.Invoke(HttpContext context)
at
Microsoft.AspNetCore.HostFiltering.HostFilteringMiddleware.Invok
e(HttpContext context)
at
Microsoft.AspNetCore.Hosting.HostingApplication.ProcessRequestAs
ync(Context context)
at
Microsoft.AspNetCore.Server.IIS.Core.IISHttpContextOfT`1.Process
RequestAsync()
at
System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TSt
ateMachine](TStateMachine& stateMachine)
at
Microsoft.AspNetCore.Server.IIS.Core.IISHttpContextOfT`1.Process
RequestAsync()
at
Microsoft.AspNetCore.Server.IIS.Core.IISHttpContext.HandleReques
t()
at
System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TSt
ateMachine](TStateMachine& stateMachine)
at
Microsoft.AspNetCore.Server.IIS.Core.IISHttpContext.HandleReques
t()
at Microsoft.AspNetCore.Server.IIS.Core.IISHttpContext.Execute()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
InnerException Message: AESEncryptADONET - Encryption - no error
information available Check InnerException property for more
detail. SQLSTATE=58005
A new environment variable is being added as an alternative to
using the Windows Registry to manage
the CommonAppData path. |
