Error while initializing database

[Former Community Member]

Hi,

am trying to configure and deploy Livecycle 8 with Websphere 6.1.0.13 and DB2. I used the configuration manager to configure and deploy the three ears. But i get the errors ALC-TTN-103-000 and ALC-TTN-011-021 while trying to bootstrap the database.



The ES and websphere application are in one machime and the db2 is installed in anoter machine. The ip and port are valid. I ran the script in the installation and configuration manual also.



The log from the application server's SystemOut.log is as follows.



[5/19/08 22:10:16:921 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapPrincipals: called createFoundationRolesAndSysPerms

[5/19/08 22:10:17:156 IST] 0000002c WSRdbManagedC I DSRA0095I: A database transaction that is not tracked by WebSphere is found, attemping to rollback before cleaning connection. This message will be logged once for each DataSource. Subsequent implicit transactions will be resolved automatically.

[5/19/08 22:10:19:734 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapPrincipals: called create administrator

[5/19/08 22:10:19:812 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapPrincipals: called create allprin group

[5/19/08 22:10:19:859 IST] 0000002c SystemOut O Creating bootstrap principals successful....

[5/19/08 22:10:19:859 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapPrincipals: assigned role to admin

[5/19/08 22:10:19:875 IST] 00000034 UMBootstrappe A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] Creating remote credential stuff ....

[5/19/08 22:10:19:875 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: gotFactory

[5/19/08 22:10:19:921 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: GOT DM

[5/19/08 22:10:19:921 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: got am

[5/19/08 22:10:19:937 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: inmem objects

[5/19/08 22:10:19:953 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: finished inmemobj

[5/19/08 22:10:20:046 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: called create remote cred

[5/19/08 22:10:20:062 IST] 0000002c SystemOut O Creating remote credential stuff successful....

[5/19/08 22:10:20:078 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: assigned role to remotecred user

[5/19/08 22:10:20:093 IST] 00000034 BootstrapperM A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] bootstrapRemCred: finished successfully

[5/19/08 22:10:20:109 IST] 00000034 UMBootstrappe A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] Syncing bootstrap data ....

[5/19/08 22:10:20:218 IST] 0000002c UMBootstrappe A com.adobe.livecycle.bootstrap.bootstrappers.UMBootstrapper bootstrap Bootstrap completed.

[5/19/08 22:10:20:234 IST] 00000034 UMBootstrappe A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 830878086] Syncing bootstrap data successful....

[5/19/08 22:10:20:281 IST] 00000034 UMBootstrappe A com.adobe.idp.common.errors.Logger$LogConsumer run UserM:: [Thread Hashcode: 83

[Alberto_Pedroza]

Did you solve this?



I have the same problem, the only difference is i'm using Oracle 10g instead of DB2.

[Former Community Member]

- Do you have a clustered environment?

- Did you follow the docs on what privileges you should give to the DB user?

- Try testing the connection from you Websphere datasource

- I think after the first failure you must drop the database schema and recreate it. Deleting the tables only is not sufficient. You must drop the whole thing.