AEM Forms 6.3 Configuration with Weblogic and Oracle

Avatar

Avatar

nirmalperumal

Avatar

nirmalperumal

nirmalperumal

06-09-2018

We are installing and configuring AEM Forms 6.3 Server with Weblogic 12.2.1.3 and Oracle 12.1.0.2 database in Centos linux. The configuration is performed using non-interactive mode with ConfigurationManager script. The 'initializeLiveCycle' step is failing with following below error. The creation of database is done as specified in documentation and right privileges are granted for the user as well. I would appreciate community help to resolve this issue. 

Server log Error –

####<Sep 5, 2018 4:03:10,041 PM UTC> <Info> <com.adobe.livecycle.bootstrap.bootstrappers.UMBootstrapper> <adls> <Server-3> <[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-00000057> <1536163390041> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Initializing DB ....>

####<Sep 5, 2018 4:03:10,045 PM UTC> <Info> <com.adobe.idp.um.businesslogic.bootstrapper.UMBootstrapperClient> <adls> <Server-3> <[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-00000057> <1536163390045> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <================================== Bootstrapping User Manager component ==================================>

####<Sep 5, 2018 4:03:10,045 PM UTC> <Info> <com.adobe.idp.um.businesslogic.bootstrapper.UMBootstrapperClient> <adls> <Server-3> <[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-00000057> <1536163390045> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Creating/Updating the database>

####<Sep 5, 2018 4:03:45,707 PM UTC> <Error> <com.adobe.idp.storeprovider.jdbc.DBStoreFactory> <adls> <Server-3> <Thread-1461> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-0000004e> <1536163425707> <[severity-value: 8] [rid: 0:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <UserM:DB_SCHEMA_INCONSISTENT: [Thread Hashcode: 453167320] Class com.adobe.idp.um.entity.PrincipalDomainEntity inconsistent with database table>

####<Sep 5, 2018 4:03:45,709 PM UTC> <Warning> <com.adobe.idp.common.errors.exception.IDPLoggedException> <adls> <Server-3> <Thread-1461> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-0000004e> <1536163425709> <[severity-value: 16] [rid: 0:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <UserM:GENERIC_WARNING: [Thread Hashcode: 453167320] com.adobe.idp.common.errors.exception.IDPLoggedException| [com.adobe.idp.storeprovider.jdbc.DBStoreFactory] errorCode:12290 errorCodeHEX:0x3002 message:schema inconsistent for com.adobe.idp.um.entity.PrincipalDomainEntity>

####<Sep 5, 2018 4:03:45,710 PM UTC> <Warning> <com.adobe.idp.common.errors.exception.IDPLoggedException> <adls> <Server-3> <Thread-1461> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-0000004e> <1536163425710> <[severity-value: 16] [rid: 0:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <UserM:GENERIC_WARNING: [Thread Hashcode: 453167320] com.adobe.idp.common.errors.exception.IDPLoggedException| [com.adobe.idp.storeprovider.jdbc.DBStoreFactory] errorCode:12290 errorCodeHEX:0x3002 message:initialization failurecom.adobe.idp.common.errors.exception.IDPLoggedException| [com.adobe.idp.storeprovider.jdbc.DBStoreFactory] errorCode:12290 errorCodeHEX:0x3002 message:schema inconsistent for com.adobe.idp.um.entity.PrincipalDomainEntity>

####<Sep 5, 2018 4:03:45,710 PM UTC> <Error> <com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean> <adls> <Server-3> <[ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <5ce1cbeb-41f5-4778-b629-109ddda22685-00000057> <1536163425710> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Error occured while creating database.

  1. com.adobe.idp.common.errors.exception.IDPLoggedException| [com.adobe.idp.storeprovider.jdbc.DBStoreFactory] errorCode:12290 errorCodeHEX:0x3002 message:initialization failurecom.adobe.idp.common.errors.exception.IDPLoggedException| [com.adobe.idp.storeprovider.jdbc.DBStoreFactory] errorCode:12290 errorCodeHEX:0x3002 message:schema inconsistent for com.adobe.idp.um.entity.PrincipalDomainEntity

                at com.adobe.idp.storeprovider.jdbc.DBStoreFactory.Initialize(DBStoreFactory.java:961)

                at com.adobe.idp.storeprovider.jdbc.DBStoreFactory.Initialize(DBStoreFactory.java:784)

                at com.adobe.idp.storeprovider.database.DBProviderCache.initialize(DBProviderCache.java:175)

                at com.adobe.idp.storeprovider.database.DBProviderCache.createDatabaseSchema(DBProviderCache.java:144)

                at com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean.createDatabase(BootstrapperManagerBean.java:299)

                at com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean_58tjk0_EOImpl.__WL_invoke(Unknown Source)

                at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54)

                at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21)

                at com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean_58tjk0_EOImpl.createDatabase(Unknown Source)

                at com.adobe.idp.um.businesslogic.bootstrapper.UMBootstrapperClient.performBootstrapping(UMBootstrapperClient.java:77)

                at com.adobe.livecycle.bootstrap.bootstrappers.UMBootstrapper.bootstrap(UMBootstrapper.java:103)

                at com.adobe.livecycle.bootstrap.framework.ManualBootstrapInvoker.invoke(ManualBootstrapInvoker.java:78)

                at com.adobe.livecycle.bootstrap.framework.BootstrapServlet.doGet(BootstrapServlet.java:167)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

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

Configuration Manager Error –

Progress: [0%, Bootstrapping [localhost:7009]]

Progress: [100%, Initialization failed]

  1. com.adobe.livecycle.lcm.core.LCMException[ALC-LCM-000-000]: Failed on step 'Invoking component bootstrapper' for task 'Bootstrapping UserManager'

ALC-TTN-103-000: Bootstrapping request failed on server.  Message from server:

ALC-TTN-011-003: Bootstrapping failed for platform component [UserManager].  The wrapped exception's message

reads:

Failed to load default configuration. error:javax.ejb.EJBException: EJB Exception: : java.lang.RuntimeException:

nullgetProvider failure: factory not initialized

                at com.adobe.idp.config.AdobePreferenceFactory.systemRoot(AdobePreferenceFactory.java:178)

                at com.adobe.idp.config.PreferencesBean.importConfigNodeFromXML(PreferencesBean.java:339)

                at com.adobe.idp.config.PreferencesBean_7ioni8_ELOImpl.__WL_invoke(Unknown Source)

                at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:33)

                at com.adobe.idp.config.PreferencesBean_7ioni8_ELOImpl.importConfigNodeFromXML(Unknown Source)

                at com.adobe.idp.um.config.util.UMConfigManager.importConfigFromXML(UMConfigManager.java:1811)

                at com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean.loadDefaultConfiguration(BootstrapperManagerBean.java:275)

                at com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean_58tjk0_EOImpl.__WL_invoke(Unknown Source)

                at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54)

                at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21)

                at com.adobe.idp.um.businesslogic.bootstrapper.BootstrapperManagerBean_58tjk0_EOImpl.loadDefaultConfiguration(Unknown Source)

                at com.adobe.idp.um.businesslogic.bootstrapper.UMBootstrapperClient.performBootstrapping(UMBootstrapperClient.java:91)

                at com.adobe.livecycle.bootstrap.bootstrappers.UMBootstrapper.bootstrap(UMBootstrapper.java:103)

                at com.adobe.livecycle.bootstrap.framework.ManualBootstrapInvoker.invoke(ManualBootstrapInvoker.java:78)

                at com.adobe.livecycle.bootstrap.framework.BootstrapServlet.doGet(BootstrapServlet.java:167)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)

                [Message truncated - see logs for details.]

Check application server logs for details.Bootstrapping Error: ALC-TTN-103-0000

                at com.adobe.livecycle.lcm.headless.HeadlessLCMImpl.bootstrapPlatform(HeadlessLCMImpl.java:400)

                at com.adobe.livecycle.lcm.headless.HeadlessLCMImpl.bootstrapPlatform(HeadlessLCMImpl.java:282)

                at com.adobe.livecycle.lcm.cli.InitializeLiveCycleCLI.executeCommandLineImpl(InitializeLiveCycleCLI.java:81)

                at com.adobe.livecycle.lcm.cli.LCMCLI.execute(LCMCLI.java:329)

                at com.adobe.livecycle.lcm.cli.LCMCLI.main(LCMCLI.java:374)

Caused by: com.adobe.livecycle.bootstrap.BootstrapException: ALC-TTN-103-000: Bootstrapping request failed on server.  Message from server:

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Daryl_Dean

Employee

Avatar

Daryl_Dean

Employee

Daryl_Dean
Employee

13-09-2018

This issue was resolved through a support ticket with Adobe AEM Forms support.

To summarize the solution in this instance:

  1. Use the default ojdbc.jar that ships with the AEM Forms installer.
  2. Created JMX policies for database initialization: https://help.adobe.com/en_US/AEMForms/PrepareInstallSingle/WS0b373c8e7f652f146c64946513248e62799-800...

Answers (5)

Answers (5)

Avatar

Avatar

nirmalperumal

Avatar

nirmalperumal

nirmalperumal

13-09-2018

We also did more step which helped to resolve the issue -

3. Rename/Delete the oracle drivers shipped with weblogic in oracle/middleware/oracle_common/modules/oracle.jdbc and copy the driver from AEM Forms installer to this location - oracle/middleware/oracle_common/modules/oracle.jdbc

Thanks,

Nirmal

Avatar

Avatar

kjaeggin

Employee

Avatar

kjaeggin

Employee

kjaeggin
Employee

07-09-2018

"schema inconsistent for com.adobe.idp.um.entity.PrincipalDomainEntity" indicates the Oracle DB has not been configured correctly for AEM Forms requirements. please review the database creation steps in the prepare installing guide here:

https://helpx.adobe.com/pdf/aem-forms/6-3/prepare-install-single-server.pdf

Avatar

Avatar

Mayank_Gandhi

Employee

Avatar

Mayank_Gandhi

Employee

Mayank_Gandhi
Employee

06-09-2018

Can you please drop the schema and run the Configuration Manager again.

Thanks,

Mayank

Avatar

Avatar

nirmalperumal

Avatar

nirmalperumal

nirmalperumal

06-09-2018

Thank you Daryl for your response.

We did copy ojdbc.jar from install folder (lib/db/oracle/ojdbc.jar) to below weblogic locations

1. oracle/middleware/wlserver/server/lib

2. oracle/middleware/oracle_common/modules/oracle.jdbc

Classpath of managed server is also set to include -

/datadrive1/aemformsweblogic63/lib/db/oracle/ojdbc.jar:/datadrive1/oracle/middleware/wlserver/server/lib/weblogic.jar:/apps/java/java/lib/tools.jar/:/datadrive1/aemformsweblogic63/lib/weblogic/pop3.jar

initializeLiveCycle step creates 46 tables to the database while bootstrapping process and it fails with error -

errorCodeHEX:0x3002 message:schema inconsistent for com.adobe.idp.um.entity.PrincipalDomainEntity

Avatar

Avatar

Daryl_Dean

Employee

Avatar

Daryl_Dean

Employee

Daryl_Dean
Employee

06-09-2018

You appear to be using the incorrect ojdbc.jar file for this database connection.

In your CLI Property File, you set the datasource.local.driverPath to be where the required ojdbc.jar driver resides.  Yours is likely set to /apps/AEMForms/lib/db/oracle/ojdbc.jar (or similar based on your install location) as that's where we put it when you first unpack everything.  You can also find it on your install media in /third_party/db/oracle

That JAR needs to be copied to your app server /lib directory, usually [WLS_HOME]/[Servername]/lib so it is available to the application server.  (If there is already an ojdbc.jar there, remove it or rename it so it will not be used.)

This happens because when you're first verifying the database the Configuration Manager will do that itself using the JAR you specify with datasource.local.driverPath, but when we are trying to bootstrap the connection is now being made through the app server.  And if it has the wrong JAR, the connection will fail.  (You do need to use the JAR we supply.)

Once you've done that, the bootstrap should succeed.

I hope this helps.  Let us know your results.