Error while publishing BO full client report in WEBI

building reports webintelligence legacy 1/2
1

Hi

I am getting below error while publishing BO full client report in WEBI

Automation exception BusinessObjects server process raised an automation exception. (BOMGR0060) IDispatch error #109 Connection or SQL sentence error: (DA0005): [ORA-00911: invalid character :-911] The following data providers have not been successfully refreshed: Stock. (DMA0007): [] (chrcin10corpge.corporate.ge.com)
(returned by function Refreshing Document) )

Please suggest

Regards
KRG

krgodbole (BOB member since 2003-02-24)

2

in continuation there is weird problem.

I tried to send same report to me in WEBI. When i send with data it get refreshed properly in WEBI, but when i purge the data in BO full client and send it gives me same error while refreshing in WEBI.

Also can we publish BO full client report with Refresh when open option?

Thanks & Regards
KRG

krgodbole (BOB member since 2003-02-24)

3

This is the strongest clue – so maybe you can give us a little more information.

Does this document use PROMPT in a condition? If so, what are you entering for the condition? Is there a character (say a quote mark, or some other special value) that could cause the SQL to get “confused”?

Yes.

Anita Craig :us: (BOB member since 2002-06-17)