Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Error while setting up Weblogic Portal(10.3.6) db connection

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
\Oracle\Middleware\user_projects\domains\domain1>create_db.cmd
database.properties=D:\Oracle\Middleware\user_projects\domains\domain1\database.properties
Buildfile: \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
\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml:97: The following error occurred while executing this line:
\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml:104: The following error occurred while executing this line:
\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml:68: Java returned: -1
Total time: 48 seconds
====================================================================================================
ERROR!
CALL TO ant -cp \Oracle\MIDDLE~1\WLSERV~1.3\server\lib\weblogic.jar; -f
\Oracle\Middleware\wlportal_10.3\p13n\db\build_createdatabase.xml FAILED!
====================================================================================================
Looking forward for some inputs....
Thanks in Advance,
Varun Arora
Best Answer
-
Strange, ran the same command after few hours and BUILD SUCCESSFUL
Answers
-
Strange, ran the same command after few hours and BUILD SUCCESSFUL
-