Configtool connecting to DB issue

[Former Member]

I'm having issues connecting the configtool to the DB for one of our systems. A little history of the system is that it was just moved to a new LPAR (OS400) and converted to use an iASP. Since the system was restored I have been into the tool, but something was changed and now it won't connect. I've verified the SAP<SID>DB user password in the secure store, but that didn't change anything.

I am seeing this as an issue, but haven't found anything on it:

com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection

Pool.createConnection(DBConnectionPool.java:364)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:129)

at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)

at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots

trapImpl.init(ConfigurationManagerBootstrapImpl.java:236)

at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots

trapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)

at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigTool.java:116)

at com.sap.engine.configtool.visual.ConfigTool.initScan(ConfigTool.java:98)

at com.sap.engine.configtool.visual.ConfigTool.<init>(ConfigTool.java:87)

at com.sap.engine.configtool.visual.ConfigTool.main(ConfigTool.java:1000)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: com.sap.engine.frame.core.configuration.ConfigurationException: Error

during initialization of DBConnection.

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection

.<init>(DBConnection.java:50)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection

Pool.createConnection(DBConnectionPool.java:362)

... 14 more

Caused by: java.sql.SQLException: SQL0204] J2EE_CONFIG in SAP<SID>DB type *FILE not found.

at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)

at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)

at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1481)

at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:185)

at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1880)

at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1703)

at com.sap.sql.jdbc.basic.BasicConnection.prepareStatement(BasicConnection.java:138)

at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:279)

at com.sap.sql.jdbc.direct.DirectConnection.prepareStatement(DirectConnection.java:219)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBAccessDefault.init(DBAccessDefault.java:449)

at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection.<init>(DBConnection.java:46)

... 15 more

The one that sticks out for me is : Caused by: java.sql.SQLException: SQL0204] J2EE_CONFIG in SAP<SID>DB type *FILE not found. I can't find anything on the J2EE_CONFIG file, is that a kernel file?

Any ideas on this one? Thanks.

[Former Member · Accepted solution]

Did you try R3trans -x/d to check the connectivity to database from OS level??.I am not sure/guessing but the error "file not found" could be referring to instance.properties/config.properties under /usr/sap/SID/Instance/j2ee/configtool/cluster.Check to see if these files are in place and has the right parameters.

[Former Member]

Lesson learned - keeping a back-up of the file before any changes are made can save you a lot of time. I had forgot about the SecStore.properties file back-up I had. Thanks.

-Ryan