06-26-2017 01:10 PM - edited 06-26-2017 01:30 PM
Hi there,
When installing Apollo 2016, I get in the log "Failed to execute[CREATE INDEX IX_CI_CO_FILE_URI ON CATALOG_ITEM (CO_FILE_URI)]
[java] java.sql.SQLException: ORA-01450". Oracle doesn't index varchar2(4000) fields.
Also Sql select are tried for table CATALOG_SYS_PARAMS which doesn't exist.
The service is working even with these errors.
Anyone encoutered those problems ?
Solved! Go to Solution.
06-27-2017 04:02 AM - edited 06-28-2017 06:27 AM
From the error it looks like you are using Oracle database as catalog.
Please check the following community KB to install ODAC on Apollo server if you haven't:
Also make sure the default table space is “USERS” instead of “SYSTEM”, you will not be able to use “SYSTEM” tablespace at all.
So there is updated script that you can try:
CREATE USER [APOLLO_USER_NAME] IDENTIFIED BY [PASSWORD]; ALTER USER "[APOLLO_USER_NAME]" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ; GRANT RESOURCE, CONNECT, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE MATERIALIZED VIEW to [APOLLO_USER_NAME]; GRANT UNLIMITED TABLESPACE TO [APOLLO_USER_NAME]; COMMIT;
Hope it helps.
haiyan
06-28-2017 06:09 AM
Haiyan,
thanks for your answer.
The schema is created partially in the databse so it's not a connectivity issue (BTW the link you provided doesn't work)
Also, the tablespace we use is dedicated to the user, its size is more than enough and all the grants are given.
Can you tell me at what point the table CATALOG_SYS_PARAMS is created ?
I get messages in the log stating that the table doesn't exist. I got all the sql statement from oracle and there's no create table for CATALOG_SYS_PARAMS.
Thanks
06-28-2017 06:29 AM
I updated the link.
Double check the ODAC, and install ODAC, drop the user schema, create user schema again, and run config-wizard.
CATALOG_SYS_PARAMS is created during Apollo configuration wizard.
hope it helps.
haiyan
06-28-2017 06:30 AM
Also check the following KB for creating user schema in Oracle.
06-28-2017 12:10 PM
Haiyan,
I dropped the schema and recreated it. I also installed ODAC.
As stated it's not a connectivity with Oracle issue. The result is the same : the table CATALOG_SYS_PARAMS is not created and no signs of a create table statement for this table in the log. All I can see in the log that's related to CATALOG_SYS_PARAMS are SQL select statements. For example :
select STRING_VALUE FROM CATALOG_SYS_PARAMS WHERE PARAM_CATEGORY = 'TOKENS' AND PARAM_NAME = '${apollo.product.name}' AND NODE_ID = 'server_name'
Those statements return, with no surprise, a ORA-00942 error.
The other errors are :
Failed to execute[CREATE INDEX IX_CI_CO_FILE_URI ON CATALOG_ITEM (CO_FILE_URI)] java.sql.SQLException: ORA-01450
System.IO.IOException: The process cannot access the file 'C:\Program Files\Common Files\Hexagon\Services\Supporting Services\CapabilitiesService\C5.dll' because it is being used by another process
System.IO.IOException: The process cannot access the file 'C:\Program Files\Common Files\Hexagon\Services\Supporting Services\QualityMonitorService\Castle.Core.dll' because it is being used by another process.
The only process running is Configuration Wizard
Thanks
06-28-2017 03:50 PM
Be able to connect to oracle doesn't mean you can install oracle table. Please double check the user tablespace for your Apollo user, make sure it is not using system tablespace.
06-29-2017 06:17 AM
Haiyan,
one again, it's definitely not a connectivity issue with Oracle : the configuration wizard is not only able to connect to Oracle, it's also able to CREATE many tables, triggers, indexes, etc ...
The tablespace used is not SYSTEM. This information has already been provided.
There's problems with the schema creation.
For example the statement CREATE INDEX IX_CI_CO_FILE_URI ON CATALOG_ITEM (CO_FILE_URI) will never be executed on a varchar2(4000) column in UTF-8. Here we get ORA-01450 maximum key length (12958) exceeded.
Indexing such a large column is not a good practice. In this case, the Oracle optimizer will prefer a full table scan instead of invoking an index anyway.
The schema creation is flawed and should be reviewed/corrected.
This information should not be argued. It should be submitted to your dev team to improve the product.
06-29-2017 06:34 AM
Are you using Oracle with Extended Max_string_size?
06-29-2017 10:31 AM
Yes