Error: schema config is not available
We have a jts and rqm 4.0.1 installed on the same server, based on WebSphere.
The data warehouse is configured correct.
Last week I added a ccm application 4.0.1 to the jts.
The ccm application is installed on an additional server, also based on WebSphere.
I configured this application to use the "old" data warehouse.
The setup was okay, but when I run the collection jobs in /ccm/admin, the job status page reports:
The ccm_etl.log shows only infos but the ccm.log reports something like
The schema 'CONFIG' is not available.
("Das Schema 'CONFIG' ist nicht vorhanden.")
jts_etl.log is also fine.
Any hints?
greetings georg.
The data warehouse is configured correct.
Last week I added a ccm application 4.0.1 to the jts.
The ccm application is installed on an additional server, also based on WebSphere.
I configured this application to use the "old" data warehouse.
The setup was okay, but when I run the collection jobs in /ccm/admin, the job status page reports:
The ccm_etl.log shows only infos but the ccm.log reports something like
The schema 'CONFIG' is not available.
("Das Schema 'CONFIG' ist nicht vorhanden.")
jts_etl.log is also fine.
Any hints?
greetings georg.
Accepted answer
@Georg the error suggests that the ccm data warehouse configuration is not correct. It can connect to the database configured, but it does not see the CONFIG schema, either the schema does not exist or the user specified in the connection URL does not have the rights to read from it.
First thing to check is if the URL is exactly the same for JTS and CCM.
First thing to check is if the URL is exactly the same for JTS and CCM.