Cannot execute Query

[Former Member]

Hello all,

when i'm trying to use the BI query wizard, i'm getting the following exception.

Error -32010: Cannot execute query. No result returned or XML returned in the result contains an error. Soap processing failure, error id = 1018.

Is there anybody who can help me out.

I'm using EP 6.0 sp 14, BW 3.5, Visual Composer 6 sp 6.

thanks in advance

Kurt

[Former Member · Accepted solution]

Geert,

Try the following:

1. Go to transaction SICF->External Aliases

2. Delete the alias /default_host/sap/bc/srt/rfc/sap/query_view_data

3. Recreate the alias and make sure it points to the service /default_host/sap/bc/srt/rfc/sap/query_view_data

4. make sure it is active

5. Go to transaction SE80 and choose “Edit Object”

6. Choose the “Enterprise Services” tab and specify the Web Service definition “query_view_data” and hit the Green Check.

7. Hit the “Activate” button to regenerate your Web Service Definition.

8. Hit the "Edit Object" button again and choose Virtual Interface.

9. Hit the "Activate" button to regenerate.

10. Goto transaction se37 and input the FM "RRW3_GET_QUERY_VIEW_DATA"

11. Activate the FM.

Cheers,

Scott

[Former Member · Accepted solution]

scott,

thanks allready,

it solved something but now i receive again a error 32010. but no specif exception.

Can you help me some more...

Thanks

[Former Member · Accepted solution]

I have same problem a error 32010 no specif exception.

I tried everything you mentioned above.

Anyone resolve this error ?

thanks

Rita

[Former Member · Accepted solution]

Hi Geert,

I assume that the back-end connectivity test at portal is successful. Try the following steps :-

In VC StoryBoard:-

Go to Tools-Options-Portal tab.

Check out the BW Query View WS URL Suffix - /sap/bw/xml/soap/queryview.

It should be same in the BW Server.

In BW Server -

Go to transaction WSCONFIG, to configure Query_view_data Service

Web service definition:- ‘query_view_data’ and then click on create Icon.

Provide the URL (in our case it is: /sap/bw/xml/

soap/queryview).This will also Create External aliases.

Thanks in advance,

Deep.

Message was edited by: Deep Chakrabarti

[gregory_root]

Hey all,

Don't forget, there is a great new document out which will step you through (with pictures) to resolve your connection issue. It's quite comprehensive.

Go to: https://www.sdn.sap.com/irj/sdn/visualcomposer , and click on "How To Guides" on the right-hand side.

Regards,

Greg

-

---

If an answer helps, don't forget to reward points. It's SDN's way of saying "Thank You!".

[Former Member]

Hi Friends...

Could you solve this issue? I have the same error, "32010 Cannot excecute the query... SOAP processing failure error id 1018

When I check the SM21 transaction in the source system, I saw the following error"SOAP Runtime SRT:ACCESS to web service Registry failed"

Any idea?