on 10-02-2015 7:54 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.