DB2 - Problem description
Problem IT34929 | Status: Closed |
ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
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. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 deployed in Azure envs * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Local Fix: | |
Upgrade to the fixpack inclusive of this APAR and use the new environment variable to override the path to the CommonAppData. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 deployed in Azure envs * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.5.5.1 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.11.2020 06.04.2021 06.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |