Mittwoch, 31. Juli 2013

Update BI-Publisher from 11.1.1.5 to 11.1.1.6.9 fails: he target EJB for the ejb-ref could not be found

After updating Weblogic Server 10.3.5 and BI-Publisher 11.1.1.5(the whole BI suite) to Weblogic Server 10.3.6 an BI-Publisher 11.1.1.6.9 I got the following errors in managed server log:


<Jul 30, 2013 1:18:41 PM CEST> <Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'bipublisher [Version=11.1.1]'.weblogic.application.ModuleException: Could not setup environmentat weblogic.servlet.internal.WebAppModule.activateContexts(WebAppModule.java:1505)at weblogic.servlet.internal.WebAppModule.activate(WebAppModule.java:440)at weblogic.application.internal.flow.ModuleStateDriver$2.next(ModuleStateDriver.java:375)      at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)      at weblogic.application.internal.flow.ModuleStateDriver.activate(ModuleStateDriver.java:95)      Truncated. see log file for complete stacktraceCaused By: weblogic.deployment.EnvironmentException: [J2EE:160101]Error: The ejb-link 'MetadataServiceBean' declared in the ejb-ref or ejb-local-ref 'ess/metadata' in the application module 'xmlpserver.war' could not be resolved. The target EJB for the ejb-ref could not be found. Please ensure the link is correct.      at weblogic.deployment.BaseEnvironmentBuilder.addEJBLinkRef(BaseEnvironmentBuilder.java:469)      at weblogic.deployment.EnvironmentBuilder.addEJBReferences(EnvironmentBuilder.java:496)      at weblogic.servlet.internal.CompEnv.activate(CompEnv.java:157)      at weblogic.servlet.internal.WebAppServletContext.activate(WebAppServletContext.java:3145)      at weblogic.servlet.internal.WebAppModule.activateContexts(WebAppModule.java:1503)      Truncated. see log file for complete stacktrace


After "updating" and restarting the application via weblogic console, the error was gone and BI-Publisher runs fine.

OIM 9.1.0 - Error after changing database connection details in GTC Database Application Table Connector (java.sql.SQLException: No suitable driver)

After changing the database hostname, port and SID of a database which is used for provisioning, I got the following error in OIM log:

13/07/30 17:21:48 Running GENERICADAPTER13/07/30 17:21:48 Target Class =com.thortech.xl.gc.runtime.GCAdapterLibraryDEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBReconFormatProvider/formatData entered.DEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize entered.DEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: driver - Value:oracle.jdbc.driver.OracleDriverDEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: url - Value:oimdb.hostname.de:1521:oimdbDEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: username - Value: oimDEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: password - Value:*******DEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: parentContainerName -Value: APP.UsersDEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBReconTransportProvider/convertCSVToArraylist entered.DEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBReconTransportProvider/convertCSVToArraylist - Data: Run TimeParameters - Value: []DEBUG,30 Jul 2013 17:21:48,854,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data:childContainerTableNames - Value: []DEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data:parentContainerUniqueKey - Value: USERIDDEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: statusField - Value:DEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: statusFieldLookup -Value:DEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize left.DEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/initialize - Data: dbDateFormat - Value:
DEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBProvisioningTransportProvider/sendData entered.DEBUG,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBFacade/getConnectionProp entered.ERROR,30 Jul 2013 17:21:48,855,[OIMCP.DATC],Class/Method:DBFacade/getConnection encounter some problems: No suitable driver java.sql.SQLException: No suitable driver

After checking the whole configuration it turned out the whole jdbc url has to be specified, for example:

jdbc:oracle:thin:@oimdb.hostname.de:1521:oimdb
No restart is needed after this change.