SAP Dashboards 4.1 BIWS Issue

[former_member199155]

Hi Guys,

I have developed a dashboard using "BIWS connectivity" with 16 web services and 9 universe queries using "Query browser".

Now my problem is, whenever am trying to view the dashboard using preview mode am getting following two errors.

1) Database error: SAP DBTech JDBC: [257] (at 222):sql syntax error:incorrect syntax near "@":line 9 col 40(at pos 222).(IES10901)

2) Cannot build the query or generate the report. (WIS 30351)

(Attached screenshots of error messages)

I don't have any issue with the queries in the Query browser panel. The only problem is with web services, few of my web services are not getting refreshed in preview mode.

Am using SAP Dashboards 4.1 Support Pack 1

Can anyone help me resolving this.

Thanks,

Vinod.

[mike_howles4 · Accepted solution]

Can you run an HTTP traffic monitor in the background to capture perhaps more details of what the requests and responses in the background are doing?  I use a shareware app called 'Charles' to do this, but there are others.  Examining the actual HTTP traffic that the QaaWS/BIWS calls issue usually helps hint at where the issue may lie.

[Former Member]

Hi,

What has been checked under Refresh options in Usage tab for web service connections?

Can you share screenshot for further clarity?

Regards,

Yuvraj

[former_member220628]

Did you solve the issue?

[Former Member]

Hi Vinod,

I encountered the same problem..Are you solved it?