Java Stack Upgrade issue

[Former Member]

Hi All,

We are upgrading our NW 7.0 Dual Stack system to NW 7.31 Dual Stack.

In Java stack upgrade during configuration phase we are facing issue when SUM is trying to configure Server nodes for Shadow Java instance.

Error says -

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

Cannot configure shadow AS Java Server

Caused by: com.sap.sql.log.OpenSQLException: Error while accessing secure store: Could not find a record with key "VALUE_NOT_RESOLVED" in the store

Analyzing log files shows that when trying to initiate configtool for shadow SUM is getting error.

Log files are  -

1)         An error has occurred during the execution of the Configure server nodes step with action pre-execute. Service com.sap.sdt.j2ee.services.servicesimpl.TaskExecutorService failed with the following m

essage:

Error while executing Task with input file ExecuteTasksSwitch.xml and task CONFIGURE_SERVER_NODES.

You can find more information in the files /usr/sap/install/SUM/sdt/log/SWITCH/CONFIGURE-SERVER-NODES_05.LOG and ProcessOverview.html.

Use the information provided to trouble-shoot the problem. There might be an OSS note providing a solution to this problem. Search for OSS notes with the following search terms:

SWITCH,pre-execute,install-shadow,configure-server-nodes,com.sap.sdt.j2ee.services.servicesimpl.TaskExecutorService,class com.sap.sdt.util.diag.DiagException

2)   more CONFIGTOOL_CONFIGTaskExecutorService_06.ERR

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

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

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

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

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:309)

        at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:59)

        at com.sap.engine.configtool.batch.BatchConfig.go(BatchConfig.java:49)

        at com.sap.engine.configtool.batch.BatchConfig.execBatchConfig(BatchConfig.java:67)

        at com.sap.engine.configtool.batch.BatchConfig.main(BatchConfig.java:84)

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

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:497)

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

Caused by: com.sap.sql.log.OpenSQLException: Error while accessing secure store: Could not find a record with key "VALUE_NOT_RESOLVED" in the store..

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:143)

        at com.sap.sql.connect.OpenSQLDataSourceImpl.setDataSourceName(OpenSQLDataSourceImpl.java:143)

        at com.sap.sql.connect.OpenSQLDataSourceImpl.setDataSourceName(OpenSQLDataSourceImpl.java:115)

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

        ... 12 more

Caused by: com.sap.security.core.server.secstorefs.NotFoundException: Could not find a record with key "VALUE_NOT_RESOLVED" in the store.

        at com.sap.security.core.server.secstorefs.StorageHandler.getValue(StorageHandler.java:685)

        at com.sap.security.core.server.secstorefs.SecStoreFS.getStringValue(SecStoreFS.java:2669)

        at com.sap.sql.connect.OpenSQLConnectInfo.lookup(OpenSQLConnectInfo.java:784)

        at com.sap.sql.connect.OpenSQLDataSourceImpl.setDataSourceName(OpenSQLDataSourceImpl.java:128)

Please suggest what could be reason of this problem.

Regards,

Shivam Mittal

[Former Member · Accepted solution]

Hi,

we had a similar problem, the resolution was:

go to the SUM directory  SUM/.../sdt/tmp

Edit the "BatchConfigServerNodes.xml" and replace the value:

<property value="VALUE_NOT_RESOLVED" key="rdbms.connection">

with

<property value="jdbc/pool/<SID>" key="rdbms.connection">

Then continue the SUM processing.

[former_member185239]

Hi Shivam,

Which is system are you upgarding?

Apart from PI and solution manager , Dual system is not supported for business suites (ECC,SRM,SCM,SRM)

With Regards
Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

We are upgrading NW 7.0 to NW731. This dual stack upgrade is supported.

So this is not reason of this problem.

Thanks,

Shivam

[Former Member]

When I manually execute command used by SUM -

/usr/sap/install/SUM/jvm/jre/bin/java -cp /usr/sap/install/SUM/sdt/lib/sap.com~tc~bl~offline_launcher~impl.jar:. com.sap.engine.offline.OfflineToolStart com.sap.engine.configtool.batch.BatchConfig /usr/sap/install/SUM/sdt/data/install/lib:/usr/sap/install/SUM/sdt/system/DFG/SYS/global/security/lib:/usr/sap/install/SUM/sdt/data/jdbc/new/ojdbc6.jar/usr/sap/install/SUM/sdt/tmp/BatchConfigServerNodes.xml

It gives message -

   INFO: Loading tool launcher...

   INFO: [OS: HP-UX] [VM vendor: SAP AG] [VM version: 1.8.0_51] [VM type: SAP Java Server VM]

  FATAL: Current VM is not supported according to the specified compatibility list.

  FATAL: com.sap.engine.offline.OfflineToolStart will abort now with exitcode 3

Not sure if this could be reason as I am executing manually this command while I think when using SUM ...It should automatically be taken care SAPJVM related issue.

[Former Member]

Hi Shivam,

On seeing the error, my first guess would be to open config tool and check the secure store connection string and ' /jdbc/pool 'properties.

Do you see anything wrong or missing ?

Thanks,

Suneeth

[Former Member]

Hi Suneeth,

Thank you for your response.

I checked configtools parameters but could not find any issue -

admin/host/DFG	< host Name >
admin/Password/DFG	<Password>
admin/port/DFG	50104

admin/user/DFG                                  j2ee_admin

jdbc/pool/DFG/ClassName

oracle:jdbc:driver:OracleDriver

jdbc/pool/DFG/password                    <Password>

jdbc/pool/DFG/URL                          jdbc:oracle:thin:@<hostname>:1527:DFG

jdbc/pool/DFG/User	SAPDFGDB

Checked Java Schema password also and it is working fine.

Do you see any issue in any parameter, What SUM needs to configure server nodes for Shadow Java Instance.

Checked Java Schema for shadow instance is also created and it's password is also working which i gave during configuration phase of SUM.

Also notice one thing, not sure if it makes any sense -

SecStore.properties file at location -/usr/sap/install/SUM/sdt/system/DFG/SYS/global/security/data

does not contain the Shadow Instance Java Schema details.

Do you think that could be issue or what could be other reason of this error.

Regards,

Shivam

[Former Member]

Just to Add, I also see below error in one trace file -

Fatal: com.sap.ASJ.cft.000001 Error occurred: Error while connecting to DB.