Data not inserted into Oracle DB
Posted: Sat May 03, 2014 11:21 am
I am trying to change my db from HSQL DB to the Oracle DB.
But I have been facing a lot of problem doing so even after following what has been mentioned in the docs.
The major problem was that the data is not imported to the Oracle DB automatically though all the tables were created.
So, I did it manually from the sql files..
I changed true to 1 and false to 0 and also updated the timestamp and every thing worked fine. There is no problem with the sql.
The site is being opened and working pretty fine
But the admin site is not being opened. Though I was able to login, I am getting the following message.
I think this might be due to that some some tables aren't filled up with data.
I've gone through the development-shared.properties file and got this sql file list.
But I couldn't find those the first three sql files and so I have downloaded them from the broadleaf master.
Now, my problem is that I could see some -ve values in the sql files.
like as -1 here. Are they really negative or do I have to convert them to +ve.
Also when I am trying to execute these sql files in order, I am getting integrity-constraint violated error.
Kindly, reply me.
But I have been facing a lot of problem doing so even after following what has been mentioned in the docs.
The major problem was that the data is not imported to the Oracle DB automatically though all the tables were created.
So, I did it manually from the sql files..
/sql/load_admin_security.sql,\
/sql/load_admin_users.sql,\
/sql/load_code_tables.sql,\
/sql/load_table_sequences.sql,\
/sql/load_catalog_data.sql,\
/sql/load_content_structure.sql,\
/sql/load_content_data.sql
I changed true to 1 and false to 0 and also updated the timestamp and every thing worked fine. There is no problem with the sql.
The site is being opened and working pretty fine
But the admin site is not being opened. Though I was able to login, I am getting the following message.
Please see your site administrator. Your account does not have access to any admin
functionality.
I think this might be due to that some some tables aren't filled up with data.
I've gone through the development-shared.properties file and got this sql file list.
/config/bc/sql/load_admin_permissions.sql,\
/config/bc/sql/load_admin_roles.sql,\
/config/bc/sql/load_admin_menu.sql,\
/sql/load_admin_users.sql,\
/sql/load_code_tables.sql,\
/sql/load_table_sequences.sql,\
/sql/load_content_structure.sql,\
/sql/load_catalog_data.sql,\
/sql/load_catalog_pricesplit_data.sql,\
/sql/load_content_data.sql,\
/sql/load_content_structure_i18n.sql,\
/sql/load_content_data_i18n.sql,\
/sql/load_catalog_i18n_data_FR.sql,\
/sql/load_catalog_i18n_data_ES.sql,\
/sql/load_sitemap_data.sql
But I couldn't find those the first three sql files and so I have downloaded them from the broadleaf master.
Now, my problem is that I could see some -ve values in the sql files.
Code: Select all
INSERT INTO BLC_ADMIN_USER (ADMIN_USER_ID, EMAIL, LOGIN, NAME, PASSWORD, ACTIVE_STATUS_FLAG) VALUES (-1,'admin@yourdomain.com','admin','Administrator','d033e22ae348aeb5660fc2140aec35850c4da997', 1);like as -1 here. Are they really negative or do I have to convert them to +ve.
Also when I am trying to execute these sql files in order, I am getting integrity-constraint violated error.
Kindly, reply me.