Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Jul 20, 2009 at 12:29 PM

    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é

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 08, 2009 at 05:38 PM

    Hi,

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

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

    • 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..#

  • Posted on Jun 10, 2010 at 09:57 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 10, 2010 at 10:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2011 at 01:15 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.