Not fetching the required Fields - if connection is published using WEB_SERVICE

[former_member184871]

Hello Community,

I have created a relational connection which is of Generic type as I am using a web-service  (WSDL 1.1), to connect to the ECC system. Test connection is successful and published successfully.

While creating a Data - foundation on the same connection, the connection is not fetching any Fields/structure/tables.

Please guide on the same.

Regards

Kumar.

[Sujit]

Hi Mayuresh,

Were you able to see the data earlier. Check if there are any access issues or row / object level restrictions. Or is this happening for all the users?

Sujit Honrao

[former_member184871]

Hi Sujit,

Thanks for the quick reply, This is happening with all the users. Let me check with the ABAP team, and get back to you.

Regards

Kumar.

[Sujit]

Could you share some more details of the connection you have created, like middleware, data source etc. If you are using ECC to create this Universe, try referring this link http://scn.sap.com/docs/DOC-27686

Let me know if this helps...

[former_member184871]

Hi Sujit,

When I create the connection - for ECC function modules or any other objects it'working, but it fails to work upon using web-services.

Regards

Kumar.

[Sujit]

Mayuresh,

Could you detail out what you are doing in a step by step manner. I have never really published a connection as Web Service in IDT, so am bit lost now.

[Sujit]

Normally in IDT when you publish a connection it is exported to repository, then from respository you can import a shortcut for the same connection which will be indicated with a  .cns extension when imported into IDT, and use this connection to create your universe schema.

If you are able to see your published connection in repository, can you try importing it and using it?

Sujit

[Former Member]

Hi Kumar,

As you said that test connection become sucessful saved it properly. But connection not able to fetch the object or fields. Is that any other connection in data foundation?

It is seems like network problem. i suggest to create connection in odbc driver and check if it is work then no network issue, then you have to check from BO level (IDT) ...

Regards,

Dhaval

[former_member184871]

Hi Dave

No i am using the same - web-service connection in the Data foundation, also I created ODBC connection to cross check the network issue, but connections with ODBC driver connection runs fine.

Can you please elaborate :

then you have to check from BO level (IDT) ...

Regards

Kumar.

[former_member184871]

Hi Sujit.

I have tried importing and then creating another Data foundation but it remains same.

Regards

Kumar.

[former_member184871]

Sujit

Following are the steps:

1. Created a project
2. Then created a Relational connection
3. During driver selection screen - I selected "Generic" Type and Selected WSDL, provided all the necessary credentials - Tested the connection, published it to repository.

Refer the screenshot for generic type driver selection:

Let me know - if I have missed something.

Regards

Kumar

[Former Member]

Hi,

may i know which web services you are using ?

regards,

Dhaval

[former_member184871]

Dave web-service is using a RFC FM, from CRM system and is WSDL based.

Can you suggest, if we need to change the type of web service. ?

Regards

Kumar.

[Former Member]

Hi Kumar,

We can not change web service type from the BO application and connectivity ...

else I don't know how to change type of web service ....

Regards,

Dhaval