SAP Webi: Error retrieve data from new CMS database

[#1]

Hello Expert,

we recently installed the:CMS database with new data access driver for BI 4.2 SP3

link:https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2+SP3

In D and Q environment we had no issue but when promoted in Production (connection, universe and report) we get this error while refreshing Webi report

Unable to retrieve network layer aliases : com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Unable to find servers in CMS [server]:6400 and cluster [server] with kind pjs and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014) cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$AllServicesDown: Unable to find servers in CMS [server]:6400 and cluster [server] with kind pjs and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014) detail:Unable to find servers in CMS [server]:6400 and cluster [server] with kind pjs and service CS_CORBA_NetworkLayer. All such servers could be down or disabled by the administrator. (FWM 01014) (Error: INF )

Any idea?

thanks so much for the support.

alessandro

[ayman_salem]

on your Production System, in CMC check if the servers are enabled or not.

[Former Member]

Which servers? and enabled to what?

[ayman_salem]

Log in to the CMC (http(s)://<server name>:<port>/BOE/CMC) and go to the Servers>Servers list and check the State and Enabled column

[Former Member]

The Server list is long, but if you mean the Central Management Server is ENABLED and RUNNING

[ayman_salem]

Hi,

I do not mean only the Centeral Management Server, but all others servers (connections, input, output, adaptive, ...... servers) .

can you share a screenshot of your servers list?

[Former Member]

Hello,

sure

[ayman_salem]

Sorry, I misunderstood what you are looking for.

You talked about the new CMS driver to access the repository.

So, to check if the driver is installed in production or not:

Under the directory "dataAccess\connectionServer" it should have a "cms" directory

and the file "cms.setup" under the directory "dataAccess\connectionServer\setup".

if not, then you can copy it from your other servers (QA, DEV), and restart the connection server.

or as Dell Stinnett-Christy said, install it with modify install