No server was available to process the request in SDK

sdk development
1

i am trying to get the SQL for WEBI reports using the SDK and i am succeeding in this , but i can’t get the SQL for all reports , i have a weird error with some reports

No server was available to process the request. Please try again later. (Error:RFC 00101)

this error still firing in open document() method .

what the solution of this problem .

thanks in advance

smsm-kw (BOB member since 2009-10-28)

2

Sometimes when we batch process Webi documents, we encounter strange issues w/ opendocument when invoked from documentinstance. Try:
[list]
[:758dbe41ba]go to your CMC and confirm that you have enough “maximum # of sessions” in the WebIntelligenceReportServer configured - perhaps you’re maxxed out from not properly closing ReportEngine or have hung threads
[:758dbe41ba]check the CMC metrics for WebiReportServer and see how many active connections (NOT CMC connections, but Webi requests) are present
[:758dbe41ba]try removing the prompts from the query - sometimes strange security errors are thrown w/ LOVs but are hidden behind your more generic error
[:758dbe41ba]opening the same webi report from Infoview itself and confirm it renders cleanly
[:758dbe41ba]turn off “refresh on open” if it’s set to ON
[:758dbe41ba]delete your document cache within the $BOBJ_HOME$\data folder (within the webi folders) and restart the WebIntelligenceReportServer services
[:758dbe41ba]make a COPY of the problematic report and try your program on the copy
[:758dbe41ba]double-check that you’re doing everything as Administrator to rule out permissions
[*:758dbe41ba]if you’re doing this within a clustered environment, migrate the report elsewhere, with data connections and valid datasource and see if the newly imported report works in a non-clustered configuration.
[/list]
Good luck!

Atul Chowdhury (BOB member since 2003-07-07)

3

You say you can get the SQL for Webi reports but not others, so is the problem with trying to get the SQL for Deski reports?

If so, do you have a Desktop Intelligence Report Server running?

jwhite9 :us: (BOB member since 2006-07-28)

4

in breif , my problem is : for webi reports i can’t get SQL for some reports
and my application firing the below error for these reports:

No server was available to process the request. Please try again later. (Error:RFC 00101)

for deski reports i have a problem in casting the dataprovider object to SQL dataprovider in the runtime and i can’t use the same methodology that i have been used in webi reports becuase its not working with deski :cry: .

finally , my Desktop Intelligence Report Server is running normally

and i am trying to take this problems one by one :hb:

smsm-kw (BOB member since 2009-10-28)