This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,926 Users
  • 2,269,775 Discussions
  • 7,916,823 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.