on 10-01-2013 4:36 AM
Hi
I am facing the below issue when publishing a relational HANA connection to the repository from my client tool. Please let me know if anyone has faced similar issue and were able to find a work around for it. I have checked the Data Federation Services from CMC and they seem to be up and running.
Unable to find servers in CMS <CMS> and cluster @<cms>with kind pjs and service DataFederatorService. All such servers could be down or disabled by the administrator. (FWM 01014)
Error:
[Data Federator Driver] No data federation service was found. Reported error: 'com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Unable to find servers in CMS <CMS> and cluster @i<cms> with kind pjs and service DataFederatorService. All such servers could be down or disabled by the administrator. (FWM 01014)
Also when I create a connection by logging on to the server box and using client tool (IDT) I am not able to see the tables being fetched despite the test connection being successful and connection being published to repository from server machine.
Any pointers will be greatly helpful.
Thanks,
Anil
In addition to what Henry has said, make sure that the database user defined in the DS connection has permission to access the tables and views that it needs to.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anil,
Just to add what Henry mentioned in detail, you can test following steps:
1. Log into the Central Management Server (CMC).
2. Stop the APS contains data federation service.
3. Under Host Identifiers, Select Hostname.
4. Enter the machine name where the Adaptive processing server installed.
5. Start the Adaptive processing server.
Regards,
Nakul Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you search for known solutions at www.service.sap.com/notes with your keywords "IDT connection : Unable to find servers in CMS " ... there are a great number of solutions suggested.
Usually, this is related to server name not getting resolved on client (host file), APS needed restarting/recreating, or APS needs HostName/Host Identifier explicitly declared in the properties.
Regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.