Create BusinnesObjects Users error

[CMCN1982]

Hi,

 

we are seeing this job fail in our (14.2) Dev environment.

In the bg logs it shows the following:

 

ERROR 2015-07-27 07:04:50,878 [Dispatch pool-5-thread-1 : bg@APPSERVER (tenant=clarity)] niku.reporting (clarity:admin:199934089__CFEB1532-5C90-4ED4-A283-6688863A066D:Create BusinessObjects Users) Login failed, Server maybe down, ensure that BO server service is up and running.

 

Caused by: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Server REPORTSERVER:6400 not found or server may be down (FWM 01003)

cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$NotFoundInDirectory: Server REPORTSERVER:6400 not found or server may be down (FWM 01003)

 

The server is up and running.

 

I have checked the CMC and the SIA and the Tomcat instance are up and running.

Tried restarting both.

 

Is there anything else I should be trying?

[Suman Pramanik]

Is the ODBC connection working fine on the BO server? From the error it looks the app server is unable to communicate to the reporting server.

 

Regards

Suman Pramanik

[CMCN1982]

Ok,

 

I cannot get access to the CMC using the usual credentials which definitely have not been changed.

 

When I test the ODBC connection on the BO server it connects successfully.

[Suman Pramanik]

Did you imported the new Biar file of 14.2?

 

Regards

Suman Pramanik

[CMCN1982]

Hi Suman,

 

yes I have imported the BIAR file of 14.2

[Suman Pramanik]

Ah, you hit a known bug CLRT-74140 Business Object Administration Password is overwritten after imporing the BIAR files

 

Workaround : Don't click select all but only select all groups

 

But now as its imported, please reset the cmc password using the below steps

 

Open the Central Configuration Manager (CCM).

Stop the Server Intelligence Agent (SIA).

Run the following SQL statements against the CMS database:

DELETE FROM cms_infoobjects6 WHERE (ObjectID=12);

COMMIT;

This will delete the record that belongs to the "Administrator" account.

From the CCM, restart the Server Intelligence Agent (SIA).  This will recreate the Administrator account with a blank password.

Now you can log on to the Central Management Console (CMC) using the Administrator account and a blank password.

 

Note:   We strongly recommend testing this in your test environment first.  Also please involve a DBA before making these required changes.

 

Regards
Suman Pramanik

[CMCN1982]

Thank you for the info Suman.

 

It does look like this is the case as we are now seeing some other jobs failing.

I don't have SQL installed on my BO server however so i am unsure where I can run the command to delete the record that belongs to the Administrator account.

[CMCN1982]

I also checked the event log on the BO server are there are numerous warnings and errors with regard to SIA and Business Objects:

 

e.g.

The description for Event ID 7939 from source Crystal OLAP Client cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

 

Server Intelligence Agent is forcing server REPORTSERVER.MultiDimensionalAnalysisServicesServer to terminate.

 

Server Intelligence Agent: server REPORTSERVER.PredictiveAnalysisServer failed to launch. It is possible the working directory or file path is invalid. Cannot run program "D:/Program Files (x86)/CA/SC/CommonReporting3/BusinessObjects Enterprise 12.0//win32_x86/AADMining.exe" (in directory "D:\Program Files (x86)\CA\SC\CommonReporting3\BusinessObjects Enterprise 12.0\win32_x86"): CreateProcess error=2, The system cannot find the file specified

 

No servers were found in the CMS for this Server Intelligence Agent.

The CMS cluster seems to be missing the Server Intelligence objects for this Server Intelligence Agent.

 

 

Would it be better just to try a clean uninstall and reinstall?

[Suman Pramanik]

Hi Colin,

 

If you have BO then it should have a database attached, if its not there then you may need to reinstall Business Objects

 

Regards

Suman Pramanik

[CMCN1982]

Hi Suman,

 

I think I have managed to resolve it.

 

Steps:

 

1, Went into the CCM and stopped the SIA service.

2. Clicked on Startup tab and in Remote CMS Servers I clicked on the entry and hit remove.

3. Then in Configuration I ticked 'Change Cluster Name to' and chose another name.

4. Clicked ok and cheched that there was no entry in the Remote CMS Servers field.

 

After this I was able to log into the CMC and I tested the Create BusinessObjects Users job. This time it successfully completed.

[Suman Pramanik]

Great. there was problem with BO set up only

 

Regards

Suman

[Anon Anon]

Trusted Authentication Shared Key ?