Question Re: SIA Error Failed to Decrypt object 100 in Technology Q&A

SIA Error Failed to Decrypt object 100

Former Member — Tue, 10 Feb 2015 14:35:21 GMT

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

Re: SIA Error Failed to Decrypt object 100

Former Member — Mon, 13 Apr 2015 00:02:47 GMT

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

Re: SIA Error Failed to Decrypt object 100

DayaJha — Mon, 13 Apr 2015 08:27:53 GMT

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

Re: SIA Error Failed to Decrypt object 100

Former Member — Wed, 09 Dec 2015 14:49:40 GMT

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

Re: SIA Error Failed to Decrypt object 100

manikantan_velayuthan2 — Sun, 20 Dec 2015 22:54:14 GMT

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

Re: SIA Error Failed to Decrypt object 100

Former Member — Tue, 24 May 2016 00:42:52 GMT

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.