WebCenter Interaction - Error Starting Portal Application Due to a Failure Connecting to the Database (Doc ID 980812.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

The following error appears either in the portal diagnostic utility or in a browser when the portal url is hit for the first time after start up of the WCI application. In the case of the error during the portal startup, a more detailed description of the problem can be found by collecting a ptspy taken during the initial page load.

Task #1 (InitPortalObjects) | +--Step #4

--------------------------------------------------------------------------------

error: PortalObjectsFactory Initialization Failure (.NET)

Platform: Windows (.NET)

--------------------------------------------------------------------------------
Recommendation Summary
failure FATAL: PortalObjectsFactory Initialization Failure (.NET)
recommendation RECOMMENDATION: Review the exception listed below for more details. Since OpenKernel initialized correctly, this usually means that the portal database is not scripted or properly configured, or there is an installation problem related to .NET assemblies. This may mean the search libraries are not on your path. Try running ptverify.
exception OKConfigException OpenKernel configuration failure. This usually means INVALID DATABASE SETTINGS. Run ptconfig to verify your database connection. If this fails, check the web application server user's access rights to the file system. Finally, verify the XML settings files are not corrupt.

The complete stack trace for the error, which can be found in the ptspy output is below -

Exception acquiring database connection
DDTek.SQLServer.SQLServerException: Login failed for user '<USER_NAME>'.
  at DDTek.SQLServer.Tds.SQLServerTDSRequest.processReply()
  at DDTek.SQLServer.Tds.SQLServerTDSLoginRequest.execute(SQLServerCommand cmd)
  at DDTek.SQLServer.SQLServerSession.dbConnect(SQLServerTDSCommunication comm)
  at DDTek.SQLServer.SQLServerSession.Connect()
  at DDInt.Common.CommonSession.Open()
  at DDInt.Common.CommonSessionPool.Fill()
  at DDInt.Common.CommonSessionFactory.GetMatchedPool(CommonConnectionOptions connectionOptions, CommonIdentity identity)
  at DDInt.Common.CommonSessionFactory.GetSession(Object owningObject, CommonConnectionOptions connectionOptions, Boolean skipLicCheck)
  at DDTek.SQLServer.SQLServerConnection.Open()
  at com.plumtree.openkernel.impl.db.DatabaseService.GetConnection()

Database connect exception, URL: Host=<DB_HOSTNAME>;Port=<DB_PORT>;User ID=<DB_USERNAME>;Database=<DATABASE>;Min Pool Size=2;Max Pool Size=32;Clone connection if Needed=true
com.plumtree.openkernel.exceptions.OKDBException: Login failed for user '<USER_NAME>'.
com.plumtree.openkernel.exceptions.OKDBException: Login failed for user '<USER_NAME>'.
  at com.plumtree.openkernel.impl.db.DatabaseService.GetConnection()
  at com.plumtree.openkernel.impl.db.DatabaseService.DoConnect()
  at com.plumtree.openkernel.impl.db.DatabaseService.init(IOKComponent configComponent, IOKLogService ioklsMyLogService, IOKCounterSystem iokcsMyCounterSystem)
  at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
  at com.plumtree.openfoundation.reflect.XPReflect.InvokeMethod(Object target, String methodName, Type[] paramTypes, Object[] paramValues)
  at com.plumtree.openfoundation.reflect.XPReflect.InvokeMethod(Object target, String methodName, Object[] paramValues)
  at com.plumtree.openkernel.factory.AOKFactory.createAndInitializeInstance(String sClassName, String sAssemblyName, Object[] arrInitArgs)
  at com.plumtree.openkernel.factory.AOKFactory.createAndInitializeCachedInstance(String sClassName, String sAssemblyName, IOKComponent componentConfig, Type clsKey, Object[] arrInitArgs)
  at com.plumtree.openkernel.factory.AOKFactory.getInstance(IOKComponent componentConfig, Type clKey, String sClassName, String sAssemblyName, Object[] arrInitArgs)
  at com.plumtree.openkernel.factory.OKDBFactory.getInstance(IOKContext icmContext)
  at com.plumtree.server.impl.core.InternalSession.Init(IOKContext context)
  at com.plumtree.server.PortalObjectsFactory.Init(IOKContext context)
  at com.plumtree.uiinfrastructure.application.startup.InitPortalObjects.InitPortalObjectsStep()
  at com.plumtree.uiinfrastructure.application.startup.InitPortalObjects.executeStep(Int32 sequentialStepID)
  at com.plumtree.uiinfrastructure.application.AppWarmUp.LoopStartupTasks(String _strApplicationName, Boolean bPreflightForProgress)
  at com.plumtree.uiinfrastructure.application.AppWarmUp.RunStartupTasks(String _strApplicationName)
  at com.plumtree.uiinfrastructure.application.AppWarmUp.Init(String _strApplicationName)
  at com.plumtree.portaluiinfrastructure.application.ApplicationStartup.init()
  at portal.Global.Application_Start(Object sender, EventArgs e)
  at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
  at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
  at System.Web.HttpApplication.ProcessSpecialRequest(HttpContext context, MethodInfo method, Int32 paramCount, Object eventSource, EventArgs eventArgs, HttpSessionState session)
  at System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext context)
  at System.Web.HttpApplicationFactory.EnsureAppStartCalled(HttpContext context)
  at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
  at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
  at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
  at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
Caused by: DDTek.SQLServer.SQLServerException: Login failed for user 'xxxxx'.
  at DDTek.SQLServer.Tds.SQLServerTDSRequest.processReply()
  at DDTek.SQLServer.Tds.SQLServerTDSLoginRequest.execute(SQLServerCommand cmd)
  at DDTek.SQLServer.SQLServerSession.dbConnect(SQLServerTDSCommunication comm)
  at DDTek.SQLServer.SQLServerSession.Connect()
  at DDInt.Common.CommonSession.Open()
  at DDInt.Common.CommonSessionPool.Fill()
  at DDInt.Common.CommonSessionFactory.GetMatchedPool(CommonConnectionOptions connectionOptions, CommonIdentity identity)
  at DDInt.Common.CommonSessionFactory.GetSession(Object owningObject, CommonConnectionOptions connectionOptions, Boolean skipLicCheck)
  at DDTek.SQLServer.SQLServerConnection.Open()
  at com.plumtree.openkernel.impl.db.DatabaseService.GetConnection()

Changes

If this is an existing, previously working portal instance, there may have been a change to the database connection parameters.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.