Forum Stats

  • 3,855,215 Users
  • 2,264,477 Discussions
  • 7,905,930 Comments

Discussions

Error while setting up Weblogic Portal(10.3.6) db connection

c20d84d4-cebf-49b2-9ad5-1174f92b18f8
edited May 7, 2015 10:36AM in WebLogic Portal

HI All,

I am a newbie to Weblogic Portal so kindly correct me if im wrong anywhere...

I am trying to set up a new instance for Weblogic Portal 10.3.6

While setting up a new domain i got the error below:

CFGFWK-60850:  Test Failed!

Later wheni tried running the command create_db.cmd, below is the error generated

Kindly help me where am i going wrong

D:\Oracle\Middleware\user_projects\domains\domain1>create_db.cmd

database.properties=D:\Oracle\Middleware\user_projects\domains\domain1\database.properties

Buildfile: D:\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml

init_props:

appendDomainSqlAuth:

init_tasks:

setup_create_database_objects:

create_database_objects:

     [echo] ***** Calling JDBCDataLoader ** to create database objects and insert seed data

Warning: Reference createdb.classpath has not been set at runtime, but was found during

build file parsing, attempting to resolve. Future versions of Ant may support

referencing ids defined in non-executed targets.

Warning: Reference cwiz.jars has not been set at runtime, but was found during

build file parsing, attempting to resolve. Future versions of Ant may support

referencing ids defined in non-executed targets.

     [java] Loading Database...

     [java]

     [java]

     [java] logFile=create_db.log

     [java] user=WEBLOGIC

     [java] password=********

     [java] url=jdbc:derby:weblogic_eval;create=true

     [java] files=D:\Oracle\Middleware\wlportal_10.3/p13n/db/derby/jdbc_index/jdbc.index,D:\Oracle\Middleware\wlportal_10.3/content-mgmt/db/derby/jdbc_index/jdbc.index,D:\Oracle\Middleware\wlportal_10.3/portal/db/derby/jdbc_index/jdbc.index,D:\Oracle\Middleware\user_projects\domains\domain1/security/jdbc.index

     [java] driver=org.apache.derby.jdbc.EmbeddedDriver

     [java] saltFile=D:\Oracle\Middleware\user_projects\domains\domain1/security/SerializedSystemIni.dat

     [java] prodDir=D:\Oracle\Middleware\wlportal_10.3

     [java] Processing file 'D:\Oracle\Middleware\wlportal_10.3\p13n\db\derby\jdbc_index\jdbc.index'

     [java] Files=

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/seq_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/rdbms_security_store_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/seq_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/data/required/p13n_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/er_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/data/required/er_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/bt_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/rdbms_security_store_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/data/required/bt_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/data/required/bt9_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/lease_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n9_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n9_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n9_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/lease_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n9_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n9_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/data/required/p13n9_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n102_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/p13n102_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/data/required/p13n102_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/p13n/db/derby/job_manager_create_tables.sql

     [java] Processing file 'D:\Oracle\Middleware\wlportal_10.3\content-mgmt\db\derby\jdbc_index\jdbc.index'

     [java] Files=

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm10_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv10_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv9_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/data/required/cmv_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm9_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/data/required/cm9_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv9_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv9_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/data/required/cm_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/data/sample/cm_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm10_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv10_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cmv102_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/derby/cm102_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/data/sample/cm102_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/content-mgmt/db/data/sample/cm102_update_system_data.sql

     [java] Processing file 'D:\Oracle\Middleware\wlportal_10.3\portal\db\derby\jdbc_index\jdbc.index'

     [java] Files=

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf10_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf10_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_drop_views.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_drop_views.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_drop_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_drop_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_drop_constraints.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_drop_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/wps_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/wps_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_views.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_create_indexes.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/comm_create_triggers.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/comm_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_drop_columns.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_create_fkeys.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf9_create_views.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/pf_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/pf9_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/bt_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/bt9_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf10_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/data/required/pf10_insert_system_data.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf102_create_tables.sql

     [java]     file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf102_drop_tables.sql

     [java] Error = SQLException when executing file file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_tables.sql

     [java] Load Failed

     [java] java.lang.Exception: SQLException when executing file file:/D:/Oracle/Middleware/wlportal_10.3/portal/db/derby/pf_create_tables.sql

     [java]     at com.oracle.cie.domain.jdbc.JDBCDataLoader.load(JDBCDataLoader.java:183)

     [java]     at com.oracle.cie.domain.jdbc.JDBCDataLoader.main(JDBCDataLoader.java:1321)

     [java] Caused by: java.sql.SQLException: Table/View 'L10N_INTERSECTION' already exists in Schema 'WEBLOGIC'.

     [java]     at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)

     [java]     at com.oracle.cie.domain.jdbc.JDBCDataLoader.loadData(JDBCDataLoader.java:749)

     [java]     at com.oracle.cie.domain.jdbc.JDBCDataLoader.load(JDBCDataLoader.java:167)

     [java]     ... 1 more

     [java] Caused by: java.sql.SQLException: Table/View 'L10N_INTERSECTION' already exists in Schema 'WEBLOGIC'.

     [java]     at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

     [java]     at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)

     [java]     ... 12 more

     [java] Caused by: ERROR X0Y32: Table/View 'L10N_INTERSECTION' already exists in Schema 'WEBLOGIC'.

     [java]     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

     [java]     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown Source)

     [java]     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown Source)

     [java]     at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown Source)

     [java]     at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)

     [java]     at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)

     [java]     at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

     [java]     ... 6 more

BUILD FAILED

D:\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml:97: The following error occurred while executing this line:

D:\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml:104: The following error occurred while executing this line:

D:\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml:68: Java returned: -1

Total time: 48 seconds

====================================================================================================

ERROR!

CALL TO ant -cp D:\Oracle\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar; -f D:\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml FAILED!

====================================================================================================

Looking forward for some inputs....

Thanks in Advance,

Varun Arora

Best Answer

Answers

This discussion has been closed.