cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

com.sap.security.tools.UMConfiguratorLoad, Error while connecting to DB

Go to solution
former_member187565
Active Contributor

on ‎05-24-2016 9:59 AM

0 Kudos

Hello All,

We have installed our SCS instance is Windows environment,

   Installed database instance in Oracle RAC ASM, linux environment.

Now when trying to install the CI or PAS on windows environment, don't see the RAC option. I am using SWPM 09 & then try with SWPM10 in both don;t find it.


If I go ahead with without RAC option and giving details of node1 details in the database host, it will give error after giving oracle client details

An error occurred while processing option SAP NetWeaver 7.4 Support Release 2 > Oracle > SAP Systems > Application Server Java > Distributed System > Primary Application Server Instance( Last error reported by the step: Error when running UMConfiguratorLoad. DIAGNOSIS: See output of log file umconfigurator_loadtype.log: ' INFO: Loading tool launcher... INFO: [OS: Windows Server 2008 R2] [VM vendor: SAP AG] [VM version: 1.6.0_81] [VM type: SAP Java Server VM] INFO: Main class to start: "com.sap.security.tools.UMConfiguratorLoad" INFO: Loading 63 JAR files: [\\ppppppppeeee01\sapmnt\PP1\SYS\global\security\lib\tools\iaik_jce.jar, \\ppppppppeeee01\sapmnt\PP1\SYS\global\security\lib\tools\iaik_jsse.jar, \\ppppppppeeee01\sapmnt\PP1\SYS\global\security\lib\tools\iaik_smime.jar, \\ppppppppeeee01\sapmnt\PP1\SYS\global\security\lib\tools\iaik_ssl.jar, \\ppppppppeeee01\sapmnt\PP1\SYS\global\security\lib\tools\w3c_http.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jaas.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jdbc.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jperflib.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jsizecheck.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jstart71.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jstartupapi.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\jstartupimpl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~sl.inst.sysidentity.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~sl.ut.infoprovider_lib.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~sl.ut.manager.offline.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~sl~ctc~import.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~antlr~runtime.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~config~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~deploy~offline~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~iqlib~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~jco_sapj2ee~runtime.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~jdsr~jdsr.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~jkernel_dummy~frame_dummy.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~jkernel_dummy~kernel_dummy.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~jkernel_util~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~jrfc~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~offline_launcher~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~opensql~implStandalone.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~bl~sl~utility~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~cim~objmgr_lib.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~cim~service_lib.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~dd~db~catalog~implCatalog.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~dd~db~dictionarydatabase~implDictionaryDatabase.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~exception~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~i18n~cp~jar~IMPL.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~bootstrap~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~cfs~container~standalone_impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~clientlib~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~configtool.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~extramile.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~offlineconfiguration~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~offlinelicense.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~offline_deploy.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~je~webcontainer~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~logging~java~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sdt~cvl~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sec~csi.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sec~destinations~lib~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sec~installertools~impl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sec~likey~likey_assembly.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sec~secstorefs~java~core.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sld~sldclient_lib.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sap.com~tc~sld~sldstdapi_lib.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sdt_jcopy_common.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sdt_jcopy_jload.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sdt_jcopy_jmigmon.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sdt_jcopy_jmigtime.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\sdt_jcopy_jpkgctl.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\servlet.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\systemHistory.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\install\lib\tc~je~cl_deploy.jar, C:\Program Files\sapinst_instdir\NW740SR2\ORA\INSTALL\DISTRIBUTED\JAVA\APP1\instantclient\ojdbc6.jar] INFO: Start May 24, 2016 10:51:05 AM Info: UME configurator (com.sap.security.tools.UMConfiguratorLoad) called for action "checkClean" May 24, 2016 10:51:06 AM Error: main() [EXCEPTION] com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB. at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPoolImpl. (DBConnectionPoolImpl.java:171) at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandlerImpl. (PersistenceHandlerImpl.java:50) at com.sap.engine.core.configuration.impl.cache.ConfigurationController. (ConfigurationController.java:139) at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:309) at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl. (ConfigurationManagerBootstrapImpl.java:87) at com.sap.security.tools.UMConfiguratorLoad$UMConfigModel. (UMConfiguratorLoad.java:994) at com.sap.security.tools.UMConfiguratorLoad.main(UMConfiguratorLoad.java:232) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) 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 "jdbc/pool/PP1" 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. (DBConnectionPoolImpl.java:164) ... 11 more Caused by: com.sap.security.core.server.secstorefs.NotFoundException: Could not find a record with key "jdbc/pool/PP1" in the store. at com.sap.security.core.server.secstorefs.StorageHandler.getValue(StorageHandler.java:685) at

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎05-24-2016 10:43 AM
0 Kudos

Hi,

Check the file

usr/sap/<sid>/SYS/global/security/data/SecureStore.properties if it has correct entries.

jdbc/pool/<SID>/User (usually SAPSR3DB)

jdbc/pool/<SID>/Password

jdbc/pool/<SID>/Url (DB server or IP address, port, SID are here)

Regards,

Prithviraj

Show replies
Show replies
former_member187565
Active Contributor
‎05-24-2016 11:10 AM
0 Kudos

No, i don't see those mentioned parameter in it.

these are the details in the SecureStore.properties

*********

#SAP Secure Store file - Don't edit this file manually!

#Sat May 21 00:49:08 AST 2016

$internal/version=Ny4wMC4wMDAuMDAx

$internal/mode=encrypted

jdbc/pool/PP1=uhAeI6qykSRppU9T35umHK1eYb4bALUwqZXngaWQiArLCuTy9VquuE/Gjjvvp98E\r\nfCSym3og01Thh2li1XfO3Qsra0KTtPklnsAGKDbNZs6L3dJb8Ba5yPXm/KTFsiKW\r\nYaU4/nNMaWzARwmUOryy+yQCx63PVzlUINn7DwgyTF6Yc70FEA4oPdwHkVk5DlIT\r\nol7wItHQ+cONecYOVZ2V0l3jUbEGcMOFGB5Hsx25fdYOqAKJkD8SvQ\=\=

$internal/check=92c5TQJxngq3MBx20I1qoQzHInkV7GxR

**************

Regards,

former_member185239
Active Contributor
‎05-24-2016 11:25 AM
0 Kudos

Hi Rafikul,

The parameters are mentioned in the secure storage .

Take the backup of the secure storage and prepare the file as mentioned below in the sapnote

2126229 - Recreating the SecStore.properties and SecStore.key for 7.3/7.4 J2EE Netweaver Systems

Also attach the umeconfigload.properties file from the sapinst installation directory.

With Regards

Ashutosh Chaturvedi

former_member187565
Active Contributor
‎05-24-2016 11:47 AM
0 Kudos

Dear Ashutosh,

I am in the mid of my CI\PAS installation, so don't find that this note helpful to configure the scurestore properties file.

Please find below details from umeconfigload.properties

system.name=PP1

rdbms.connection=jdbc/pool/PP1

rdbms.driverLocation=C\:\\Program Files\\sapinst_instdir\\NW740SR2\\ORA\\INSTALL\\DISTRIBUTED\\JAVA\\APP1\\instantclient\\ojdbc6.jar

secstorefs.lib=\\\\ppppppppeeeee01/sapmnt/PP1/SYS/global/security/lib

secstorefs.secfile=\\\\ppppppppeeeee01/sapmnt/PP1/SYS/global/security/data/SecStore.properties

secstorefs.keyfile=\\\\ppppppppeeeee01/sapmnt/PP1/SYS/global/security/data/SecStore.key

rdbms.initial_connections=1

rdbms.maximum_connections=5

Let me know if we have to maintain some details in the securestore properties file.

Regards,

Rafikul

former_member185239
Active Contributor
‎05-24-2016 9:01 PM
0 Kudos

Hi Rafikul,

There might be some formatting issue with the SecStore.properties file and so prepare the file using the configtool of some different java server and move the new file to the server where you are facing problem.

Before making any changes take the backup of the security folder.

With Regards

Ashutosh Chaturvedi

Answers (0)

Ask a Question