Forum Stats

  • 3,855,210 Users
  • 2,264,475 Discussions
  • 7,905,930 Comments

Discussions

Problem while changing DB from Pointbase to Oracle

661505
661505 Member Posts: 14
edited Oct 16, 2008 1:35PM in WebLogic Portal
Hi All,
I dont know whether this is right place to ask this question, but I am newbie, on weblogic, and would like some assistance,

I am trying to point my DB in weblogic from Pointbase to Oracle, I have updated the database.properties file to point @ Oracle. Now when I go and try to exectue the create_db.cmd file to execute all the scripts and thereby load/create the DB, I get the below error when all the .sql files are executed.


Buildfile: C:\bea\WLSERV~1.0\common\p13n\db\build_createdatabase.xml

init_props:

init_tasks:

main:

setup_create_database_objects:

init_props:

init_tasks:

create_database_objects:
echo ***** Calling JDBCDataLoader ** to create database objects and insert seed data
java Loading Database...


java logFile=create_db.log
java user=akulas
java password=******
java url=jdbc:oracle:thin:@hpcad144.qwest.net:1524:dnets_d
java files=C:\bea\WLSERV~1.0/common/p13n/db/oracle/jdbc_index/jdbc.index,C:\bea\WLSERV~1.0/cm/db/oracle/jdbc_index/jdbc.index,C:\bea\WLSERV~1.0
/portal/db/oracle/jdbc_index/jdbc.index
java driver=oracle.jdbc.driver.OracleDriver
java saltFile=C:\bea\user_projects\domains\VenkatDomain/security/SerializedSystemIni.dat
java prodDir=C:\bea\WLSERV~1.0
java Processing file 'C:\bea\WLSERV~1.0\common\p13n\db\oracle\jdbc_index\jdbc.index'
java Files=
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/seq_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/seq_create_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_create_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/data/required/p13n_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_create_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/er_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/data/required/er_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_create_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/bt_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/data/required/bt_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/data/required/bt9_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n9_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n9_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n9_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n9_create_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n9_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/data/required/p13n9_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n102_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/oracle/p13n102_create_tables.sql
java file:/C:/bea/WLSERV~1.0/common/p13n/db/data/required/p13n102_insert_system_data.sql
java Processing file 'C:\bea\WLSERV~1.0\cm\db\oracle\jdbc_index\jdbc.index'
java Files=
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm10_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv10_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv9_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/cm/db/data/required/cmv_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm9_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/cm/db/data/required/cm9_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv9_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv9_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/cm/db/data/required/cm_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/cm/db/data/sample/cm_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm10_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv10_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cmv102_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/oracle/cm102_create_tables.sql
java file:/C:/bea/WLSERV~1.0/cm/db/data/sample/cm102_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/cm/db/data/sample/cm102_update_system_data.sql
java Processing file 'C:\bea\WLSERV~1.0\portal\db\oracle\jdbc_index\jdbc.index'
java Files=
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf10_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf10_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_drop_views.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_drop_views.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_drop_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_drop_indexes.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_drop_constraints.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_drop_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_create_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/wps_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/wps_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_create_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_create_views.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_create_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_create_indexes.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/comm_create_triggers.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/comm_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_drop_columns.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_create_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_create_fkeys.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf9_create_views.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/pf_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/pf9_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/bt_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/bt9_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf10_create_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/data/required/pf10_insert_system_data.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf102_create_tables.sql
java file:/C:/bea/WLSERV~1.0/portal/db/oracle/pf102_drop_tables.sql
java Error = SQLException when executing file file:/C:/bea/WLSERV~1.0/portal/db/data/required/pf_insert_system_data.sql
java java.lang.Exception: SQLException when executing file file:/C:/bea/WLSERV~1.0/portal/db/data/required/pf_insert_system_data.sql
java at com.bea.plateng.domain.jdbc.JDBCDataLoader.load(JDBCDataLoader.java:182)
java at com.bea.plateng.domain.jdbc.JDBCDataLoader.main(JDBCDataLoader.java:1320)
java Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

java at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
java at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
java at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
java at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
java at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
java at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
java at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
java at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
java at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
java at com.bea.plateng.domain.jdbc.JDBCDataLoader.loadData(JDBCDataLoader.java:748)
java at com.bea.plateng.domain.jdbc.JDBCDataLoader.load(JDBCDataLoader.java:166)
java ... 1 more
java Load Failed

BUILD FAILED
C:\bea\WLSERV~1.0\common\p13n\db\build_createdatabase.xml:17: The following error occurred while executing this line:
C:\bea\WLSERV~1.0\common\p13n\db\build_createdatabase.xml:90: The following error occurred while executing this line:
C:\bea\WLSERV~1.0\common\p13n\db\build_createdatabase.xml:97: The following error occurred while executing this line:
C:\bea\WLSERV~1.0\common\p13n\db\build_createdatabase.xml:62: Java returned: -1

Total time: 3 minutes 55 seconds

I tried debugging the problem, and found that the table "PF_MARKUP_XML" was not created, the create script of that table is in the "pf_create_tables.sql" file. When I tried to manually execute the specific create script for that table it was executed successfully, and the table was created. So I dont know what is the problem then.

Any help on this would be highly appreciated.

Thanks,

Answers

  • 665334
    665334 Member Posts: 40
    Hi,
    not sure which version of WLP you are running, but take a look at [http://edocs.bea.com/wlp/docs92/db/oracle.html|http://edocs.bea.com/wlp/docs92/db/oracle.html]:

    "Note: A WebLogic Portal Oracle database user that has DBA privileges causes database create errors and upgrade issues. Before you create database objects or perform an upgrade, you should revoke the Oracle user's DBA privileges and replace them with the following privileges: GRANT CREATE TABLE, CREATE VIEW, CREATE TRIGGER, CREATE SEQUENCE, CREATE SESSION, UNLIMITED TABLESPACE TO <<WEBLOGIC>>."

    If the DB user you were using had DBA privileges then maybe this was the reason for your problem?

    Seems to be still valid even for 10.2.

    Hope this helps.

    Cheers,
    Petri
  • 661505
    661505 Member Posts: 14
    Hi Petri,

    Just to confirm wht i understood from your reply "the user(means the *oracle user* whose credentials are being passed in the database.properties file, has the appropriate privileges) if that is the case then the privileges/rights is not the issue, because if you look at the bottom of my original question, i have said, that I ran the specific create script for that table, and the table was created successfully, but its only when I execute it using the create_db.cmd file, it throws this error.

    let me know if I am wrong,
  • 665334
    665334 Member Posts: 40
    Hi,

    since documentation explicitly warns against running the script with an oracle user defined in database.properties who has dba privileges I thought it might be related. The symptom says "causes database create errors" so to me it seemed like it may be worth looking at.
    Cheers,
    Petri
This discussion has been closed.