SecStore.properties file - need to regenerate-Sys Copy of SAP NetW BI 7.0

[former_member361252]

Hello Experts,

I'm having an issue with a follow up activity of a recent System Copy-> SAP NW 2004s ABAP & JAVA Stack ->System copy of our Production BI system to a Sandbox system. (HP-UX servers 11.23 / Oracle 10g) Our SecStore.properties file contains the Production Source system's credentials and I am unable to update the properties using the configtool.sh or offlinecfgeditor.sh scripts. I am receiving the following error:

system.log from offlinecfgeditor.sh

... #2#com.sap.sql.log.OpenSQLException#Error while accessing secure store: The encryption key (usually in the key file) is not the key that is required to decrypt the data in the secure store file or the system name (SID) is wrong..#

The SID in the below file contains our production sid (BWP) and needs to be (BWX-our target system)

/usr/sap/BWX/SYS/global/security/data/SecStore.properties

Is there anyway to reconfigure this property file other than the 2 scipts listed above?

Thanks,

Laurie

[Former Member]

Hi Desiree,

I have the same problem with ABAP+JAVA stack. But I couldn't understand your workaround, can you please explain?

I appreciate your help

Thanks,

Kris

[andreas_kaberger]

Hi Laurie,

i have the same problem with the wrong SID!

I need SecStore.properties and SecStore.key with the SID BWP!!

So is it possible to get your 2 files for trying to solve my problem!!

Thanks

Andreas

[andreas_kaberger]

Hi Laurie,

i have the same problem with the wrong SID!

I need a SecStore.properties and and SecStore.key with the SID BWP!

So is it possible to get your SecStore.properties and you SecStore.key to try to solve my problem!

Regards

Andreas

[desiree_matas]

Hello Laurie,

The SecStore.key is an encrypted file that contains the key to unlock the SecStore.conf. You cannot just copy this key if you changed something (SID for example) in your SecStore. The key won't be

correspondent to this SecStore anymore. You need to create a new key for your new SecStore.conf.

You can try the following as a workaround:

a) Take a SecStore.properties from another engine that uses the same version and database system.

(the DB URL is complex and differs from e.g. MSSQL to MaxDB). This file should NOT be encrypted.

b) Delete the "key" file (backup firstly, of course) and put the (a) file to the engine where it is missing from.

c) Use ConfigTool to edit the properties.

d) Use ConfigTool to encrypt the new file.

Best regards,

Désiré

[Former Member]

Hi,

We are trying to do the same. Can anyone confirm if this procedure really worked ?

Harshal

[mybasisimromssq]

Thanks Desiree Matas.

Your workaround really work on my issue (NW CE 7.1)

Edited by: Admin Basis on Feb 11, 2010 9:10 AM

[mybasisimromssq]

Thanks Desiree Matas.

Your workaround really work on my issue (NW CE 7.1)

[sunny_pahuja2]

Hi,

It looks like permission issue. Have you tried to give 777 permission on this file and directory.

Thanks

Sunny

[former_member361252]

Hi Sunny,

I have tried to set the file and directory permissions to 777; I'm still getting the same error message. Our properties file still has the source SID within the file (BWP). We want to use the offlinecfgeditor.sh script to change this but we get the error.

SecStore.properties

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

#Tue May 27 21:01:01 GMT 2008

$internal/version=Ni4zMC4wMDAuMDAx

$internal/check=l5PQW7LzpM6/ex0zzjUKpmSVAgOHr7gf

admin/user/BWP=VfUW5QqtI/HrmzIInT6Lnskt2xUjCyUJOpzyb4TGZKWZ+x3xYLrt2btZ5tdnOuYr

$internal/mode=encrypted

admin/host/BWP=VfUW5QqtI/HrmzIInT6Lnj4giRuI2sSBoQ+mr6k/2DLsHbFGjL2PJA\=\=

admin/password/BWP=VfUW5QqtI/HrmzIInT6LntkVESF9UMnViiA2lTWfexO6t6mYJNQK4A\=\=

jdbc/pool/BWP=VfUW5QqtI/HrmzIInT6LnuxhGH/NkdZMAllImaNmOR3dubXLMKSlGyEm9Si5R\r\nIla5Uiox5nlKhCOqbVEhHwi6ULWfvn24IcmSfOu6KAThx0KYgAom1DFyPl4zPeB\r\nD1IB1FF0ZXjxp/o9xaxsTdsN2ktSlLg2PtFbTyCnAOtofbXEIENUZGdL8K5uvFsw\r\npFquu7eMg9Nzgz/qP0gRn1o4m6657V

admin/port/BWP=VfUW5QqtI/HrmzIInT6LnrG3t8jvX0o50axAU6VW+jcF70sW3MmaJw\=\=

Any more suggestions?

Regards,

Laurie

Error:

Error while accessing secure store: The encryption key (usually in the key file) is not the key that is required to decrypt the data in the secure store file or the system name (SID) is wrong..#