Resolution for “CFGFWK-60853” error while running Configuration Wizard.

When trying to create a Domain using Configuration Wizard, while testing the database schema connection, I am running into an error. The configuration wizard reports the following error.

Component Schema=SOA Infrastructure
Driver=oracle.jdbc.xa.client.OracleXADataSource
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_SOAINFRA
Password=********
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.2.0′

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

Reason: In the previous wizard screen, I have modified the User name to all the Schemas as SYSTEM and provided the Password as Welcome1.

Resolution: We should not modify the User name to the Schemas, Only Password need to be provided.

Advertisements
This entry was posted in Service Oriented Architecture (SOA 11g), WebLogic Server 11g and tagged , , , , , . Bookmark the permalink.

2 Responses to Resolution for “CFGFWK-60853” error while running Configuration Wizard.

  1. kman says:

    I am stuck with a similar kind of error at same step for testing the connection for “OSB JMS Reporting Provide”

    By default for this JMS Reporting Provide configuration tool was showing port 1527.I got this error
    Error with 1527 port:
    Component Schema=OSB JMS Reporting Provider
    Driver=org.apache.derby.jdbc.ClientDriver
    URL=jdbc:derby://localhost:1527/XE;create=true;ServerName=localhost;databaseName=XE
    User=KKDEV_SOAINFRA
    Password=*********
    SQL Test=SELECT 1 FROM SYS.SYSTABLES

    java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect.
    CFGFWK-60850: Test Failed!

    I changed the port to 1521 and i got the error..Any idea?
    ———
    Error :
    Component Schema=OSB JMS Reporting Provider
    Driver=org.apache.derby.jdbc.ClientDriver
    URL=jdbc:derby://localhost:1521/XE;create=true;ServerName=localhost;databaseName=XE
    User=KKDEV_SOAINFRA
    Password=*********
    SQL Test=SELECT 1 FROM SYS.SYSTABLES

    Insufficient data while reading from the network – expected a minimum of 6 bytes and received only 0 bytes. The connection has been terminated.
    CFGFWK-60850: Test Failed!

    Any idea what’s the error is..

    Kman

  2. imran khan says:

    use database as oracle database instead of derby if you are using oracle database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s