Sanae BEKKAR – My Blog –

Problème:

CFGFWK-60853:  Une connexion à la base de données a été établie, mais l’instruction SQL de test n’a renvoyé aucune ligne.

Explication :

The connection was valid but the test SQL still failed. Below is what the message was in the log file.

Component Schema=OWSM MDS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/XE
User=XE_MDS
Password=********
SQL Test=select 1 from schema_version_registry where
				owner=(select user from
				dual) and mr_type='MDS' and
				version='11.1.1.6.0'

CFGFWK-60850:  Test Failed!
CFGFWK-60853:  A connection was established to the database but no rows were 
returned from the test SQL statement.

Solution :

Error Resolution

The clue in determining the error was in the select statement (seen above) that is targeting version 11.1.1.6.0. In my prior installation of WebCenter I installed BPM 11.1.1.7.0 and that had installed several schemas that had a version number 11.1.1.7.0. I was able to discover this matter using SQL against the schemas. The SQL is:

select * from schema_version_registry
Since the versions were incompatible I decided to drop the existing repository 
schemas and then recreate them in the Repository Creation Utility. 
That solved my problem.

Solution:
This is most irritating error developers face while installing the software. I tried many different ways,and atlast with some deep thinking i came up with a solution.
Open the sql developer and connect the respective Schema User .First i will connect to
DEV_SOAINFRA
1. Now i used the query
select * from schema_version_registry;
to see the data in the table and figured out that there is a mismatch as the version in the table is less than the version it is comparing.
2. So i dropped the table
drop table schema_version_registry;
3. Then i created a new table and inserted a row :
create table schema_version_registry(owner varchar2(30),mrc_name varchar2(30),mr_type varchar2(10),version varchar2(50));

insert into schema_version_registry(owner,mrc_name, mr_type,version)values(‘DEV_SOAINFRA’,’SOAINFRA’,’11.1.1.6.0′);

insert into schema_version_registry(owner,mrc_name, mr_type,version)values(‘DEV_SOAINFRA’,’SOAINFRA’,’SOAINFRA’,’11.1.1.7.0′);
4. Finally committed it.
Repeat the same step for other users as well . change the “mr_type” accordingly
And most important while doing the same for DEV_MDS you need to  give the user admin rights like this:
select username from dba_users;
grant DBA to DEV_MDS;
then simply give this query :
update schema_version_registry set version=’11.1.1.6.0′; where owner= ‘dev_mds’;