WebCenter Interaction - Error Starting Portal Application Due To A Failure Connecting To The Database (Doc ID 980812.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle WebCenter Interaction - Version 6.0.1 to 10.3.3.0
Microsoft Windows (32-bit)
***Checked for relevance on 28-Jan-2014***

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 'xxxxxxxxxx'.
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() in e:\buildroot\Release\openmanagement\4.1.x\opendb\build\x86\src\csharp\com\plumtree\openkernel\impl\db\DatabaseService.cs:line 1348

Database connect exception, URL: Host=xxxxxxx.xxxxx.xxxxxxxx.com;Port=1433;User ID=plumdbuser1;Database=plum65db;Min Pool Size=2;Max Pool Size=32;Clone connection if Needed=true
com.plumtree.openkernel.exceptions.OKDBException: Login failed for user 'xxxxxxxxxx'.
com.plumtree.openkernel.exceptions.OKDBException: Login failed for user 'xxxxxxxxxx'.
at com.plumtree.openkernel.impl.db.DatabaseService.GetConnection() in e:\buildroot\Release\openmanagement\4.1.x\opendb\build\x86\src\csharp\com\plumtree\openkernel\impl\db\DatabaseService.cs:line 1374 at com.plumtree.openkernel.impl.db.DatabaseService.DoConnect() in e:\buildroot\Release\openmanagement\4.1.x\opendb\build\x86\src\csharp\com\plumtree\openkernel\impl\db\DatabaseService.cs:line 1181 at com.plumtree.openkernel.impl.db.DatabaseService.init(IOKComponent configComponent, IOKLogService ioklsMyLogService, IOKCounterSystem iokcsMyCounterSystem) in e:\buildroot\Release\openmanagement\4.1.x\opendb\build\x86\src\csharp\com\plumtree\openkernel\impl\db\DatabaseService.cs:line 356 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) in e:\buildroot\Release\openmanagement\4.1.x\common\build\x86\src\csharp\com\plumtree\openkernel\factory\AOKFactory.cs:line 231 at com.plumtree.openkernel.factory.AOKFactory.createAndInitializeCachedInstance(String sClassName, String sAssemblyName, IOKComponent componentConfig, Type clsKey, Object[] arrInitArgs) in e:\buildroot\Release\openmanagement\4.1.x\common\build\x86\src\csharp\com\plumtree\openkernel\factory\AOKFactory.cs:line 281 at com.plumtree.openkernel.factory.AOKFactory.getInstance(IOKComponent componentConfig, Type clKey, String sClassName, String sAssemblyName, Object[] arrInitArgs) in e:\buildroot\Release\openmanagement\4.1.x\common\build\x86\src\csharp\com\plumtree\openkernel\factory\AOKFactory.cs:line 311 at com.plumtree.openkernel.factory.OKDBFactory.getInstance(IOKContext icmContext) in e:\buildroot\Release\openmanagement\4.1.x\common\build\x86\src\csharp\com\plumtree\openkernel\factory\OKDBFactory.cs:line 53 at com.plumtree.server.impl.core.InternalSession.Init(IOKContext context) in e:\buildroot\Release\portalserver\10.3.0.x\portalobjects\build\x86\src\dotnet\com\plumtree\server\impl\core\InternalSession.cs:line 126 at com.plumtree.server.PortalObjectsFactory.Init(IOKContext context) in e:\buildroot\Release\portalserver\10.3.0.x\portalobjects\build\x86\src\dotnet\com\plumtree\server\PortalObjectsFactory.cs:line 51 at com.plumtree.uiinfrastructure.application.startup.InitPortalObjects.InitPortalObjectsStep() in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\uiinfrastructure\dotnet\prod\src\com\plumtree\uiinfrastructure\application\startup\InitPortalObjects.cs:line 304 at com.plumtree.uiinfrastructure.application.startup.InitPortalObjects.executeStep(Int32 sequentialStepID) in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\uiinfrastructure\dotnet\prod\src\com\plumtree\uiinfrastructure\application\startup\InitPortalObjects.cs:line 112 at com.plumtree.uiinfrastructure.application.AppWarmUp.LoopStartupTasks(String _strApplicationName, Boolean bPreflightForProgress) in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\uiinfrastructure\dotnet\prod\src\com\plumtree\uiinfrastructure\application\AppWarmUp.cs:line 872 at com.plumtree.uiinfrastructure.application.AppWarmUp.RunStartupTasks(String _strApplicationName) in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\uiinfrastructure\dotnet\prod\src\com\plumtree\uiinfrastructure\application\AppWarmUp.cs:line 783 at com.plumtree.uiinfrastructure.application.AppWarmUp.Init(String _strApplicationName) in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\uiinfrastructure\dotnet\prod\src\com\plumtree\uiinfrastructure\application\AppWarmUp.cs:line 183 at com.plumtree.portaluiinfrastructure.application.ApplicationStartup.init() in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\portal\dotnet\prod\src\web\common\ApplicationStartup.cs:line 53 at portal.Global.Application_Start(Object sender, EventArgs e) in e:\buildroot\Release\portalui\10.3.0.x\ptwebui\portal\dotnet\prod\src\web\Global.asax.cs:line 23 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() in e:\buildroot\Release\openmanagement\4.1.x\opendb\build\x86\src\csharp\com\plumtree\openkernel\impl\db\DatabaseService.cs:line 1348



Changes

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms