SIA Error Failed to Decrypt object 100

[Former Member]

Hi Folks,

I am new to Data Services and trying to pick it up. We have a Setup of Data Services done by a contractor. We have a distributed setup of the BOBJ and Data Services components separate from the SQL Server installation.

We started facing problems after the SQL Server user password expired. The contractor did not set it up a Non Expiring. I remember the password which was set so I changed the user to non Expiring and gave the same password. Also the ODBC connection from the BOBJ server to SQL works fine but when the SIA agent logs give error. " Failed to retrieve cluster name from the database. Reason : Failed to decrypt object 100 using cryptographic ID: 4. '

I get the same error when I open the Configuration tab. I am trying to use the Specify option but there it asks me for a cluster key which I don't know.

Any help.

BTW : This is not a clustered installation, we have only one node.

regards

Yogesh

[Former Member]

I got the same issue , i have fixed with the below option .

Is the CMS DB a new one or are you using an existing CMS DB? IF already exists

try selecting the option 'reset cms database' while installing.

[Former Member]

Hi Yogesh,

We are facing same issue here..

The ODBC connection from the BOBJ server to SQL works fine. But when the SIA agent logs give error. " Failed to retrieve cluster name from the database. Reason : Failed to decrypt object 100 using cryptographic ID: 4. '

I get the same error when I open the Configuration tab and try to change the Cluster Key or any other option.

Were you able resolve your issue? Any feedback would be helpful.

Thanks,

Guest user

[manikantan_velayuthan2]

Hi!

In the Primary CMS - stop the SIA, reset the CMS Cluster Key Configuration and retry the steps in the secondary BO server. This should resolve the issue.

Thanks!

Mani

[Former Member]

Hi Yogesh,

Did you find a solution for this problem are experiencing a similar behaviour in our BO environment.

Will be really helpful if you can share your experience,

Thanks,

Vibhav

[DayaJha]

HI Vaibhav,

Please share the SAP Business Objects Application Version or else refer below KBA

1639053 - BI 4.0 Installation Error when adding a node in cluster.
https://service.sap.com/sap/support/notes/1639053

1613058 - How to change or reset Cluster key in a SAP BI4.0
https://service.sap.com/sap/support/notes/1613058

Thanks,

Daya