BI Query Wizard error 32010 (400) bad http request

[MichaelTe]

Hello,

if we try to preview the result of a query in the BI Query Wizard of VC we get following error:

"Error -32010: Cannot execute query. No

result returned or XML returned in the result

contains an error. Service call exception;

nested exception is:

com.sap.engine.services.webservices.jaxrpc.ex

Invalid Response Code: (400) bad http

request.."

In the trace file of the ICM in the BW system we found the following error:

"[Thr 10] Wed Apr 26 16:14:45 2006

[Thr 10] *** ERROR => Error in HTTP Request: 11 [http_plg_mt.c 4014]

[Thr 10] *** ERROR => PlugInHandleNetData: HttpParseRequestHaeder failed (rc=-701) [http_plg_mt. 1917]"

I've searched the forum for an error like this but the only errors I could find were about the Http-error 404.

We have the following configuration:

- EP 6.0.11.3.0 SPS 11 Patch 3

- BW 3.5 Support Package 15

What is wrong with this?

Any help would be appreciated.

Best regards, Michael

[Former Member]

Hi Michael,

Try the following steps -

In Portal Side:

Deploy the following sda files :-

com.sap.visualcomposer.portalcontent.sda

com.sap.visualcomposer.sda

BIUDISystems.sda

com.sap.visualcomposer.BIKit.sda

com.sap.visualcomposer.BIKitQV.ear

Note : deploy the sda files those are compatible for EP 6.0 SP 11.

In BW Sever Side :

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.

If this doesn't work then -

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.

To verify the URL , open the portal tab in the option dialog box in VC Storyboard.

But it's just a suggestion, if you want to use VC 6.0, upgrade your EP 6.0 to SP13, and deploy all the sda files mentioned above, available in the portal addons folder when you download VC 6.0 Patch 6.0 from service market-place.

Thanks in advance,

Deep.

[MichaelTe]

Hello Deep,

we did the steps you mention in your solution. But the error remains the same.

What can we do further?

Is it necessary to upgrade to EP6 SP13 for using VC 6?

Regards, Michael

[Former Member]

Hi Michael,

The best solution is to use VC 6.0 Patch 6 and Ep 6.0 SP 13, then deploy the portal addons.

refer this :

Thanks in advance.