Skip to main content

[Integrate] Error Trying to Import the Recording

Ben Bauer
  • Updated

NOTE:  This article is listed in the following 'checklist' guides: [Integrate] Errors while Recording, Posting, or Importing

Versions:  All released versions of DSP

Issue:

Getting an error while trying to do recording in Integrate and when clicked on Save in SAP GUI.  The user in the error message is the SQL Login used by DSP.

Cause:

There is a special character in the password of the SQL Login being used by DSP.  This must be removed.  So far, the following special character(s) have been found to cause this issue:

  • +
  • /
  • =

Additionally, the following special character(s) have not caused any issue:

  • !
  • #

Resolution:

Here is the process for changing the SQL password of a DSP site (from the application server):

  1. in DSP, disable any [password] column encryption that might be configured for the CranSoft or DSPCommon data sources
  2. find cmd
    1. right-click and run as administrator
    2. enter iisreset -stop
  3. stop the DSP service (from the Windows Services console)
  4. in SSMS, navigate to Security -> Logins
    1. double-click the SQL Login being used by DSP (the one from the error message)
    2. change the password so that it contains none of the special character(s) listed above
  5. in Windows Explorer, navigate to <DSP Install Directory>\BOA\DSP\Web\bin
    1. find CranBerryConfigurator (the exe application)
    2. right-click and run as administrator
    3. enter the new password and click the 'Save' button
  6. run these scripts in SSMS:
    • UPDATE CranSoft.dbo.DataSource SET [password] = '<newpassword>' WHERE [password] = '<oldpassword>'
    • UPDATE DSPCommon.dbo.ttDataSourceRegistry SET [password] = '<newpassword>' WHERE [password] = '<oldpassword>'
  7. start the DSP service
  8. find cmd
    1. right-click and run as administrator
    2. enter iisreset -start
  9. in DSP, enable any [password] column encryption that was disabled in step 1

Related articles