WEBI Error: "SQL generation failed. See your administrator.Could not resolve prompt answer: ++11300. (IES 00013) (Error: INF)"

[Former Member]

Hi All,

SAP Business Objects 4.1 SP6 Patch 1.

WEBI Report using BEx Query through BICS connection.

Issue when use hyperlink from summary to detail report.

Getting the Error Message

"SQL generation failed. See your administrator.Could not resolve prompt answer: ++11300.  (IES 00013) (Error: INF)"

Thanks & Regards,

  Asya

[former_member59613 · Accepted solution]

1) Can you manually run an OpenDocument URL to the Detail report and have it successfully load?

2) Can you run the Detail report through BI Launch Pad and enter the prompt value manually?

3) Have you tried using Fiddler to capture the URL that is being sent?  Maybe there is a bad character being submitted.

Can you give more details on the formula used to construct the opendocument URL?

Did this work previously?

Are you using a load balancer, proxy, web server or any other layers in between the client and the app server?

thanks

Jb

[Former Member · Accepted solution]

Thanks a lot for your replay, Jonathan!

The reason for the error was in the leading spaces in the master data. This problem occurs only after installing SP6. We installed patches and error fixed too

Best regards!

Asya

[former_member59613 · Accepted solution]

Great! thanks for the update.