we have reports randomly completed with “Success”, but have no data with it.
this is extremely troubling. has anyone come across this issue?
we are running Busines Objects Enterprise XI R2 SP2… With the Business Objects XML data integration kit for JD Edwards. our database is AS400 ISeries.
Tanked 
(BOB member since 2005-12-13)
Have you tried running the reports manually without scheduling them? Have you tried running the SQL Code for the reports outside of the BO environment to see if rows are retrieved from the backend data source?
Have a great day!
MayhewM (BOB member since 2003-10-22)
Thanks for the reply.
no sure how running the SQL outside BO would help. there report pull data correctly about 90% of the time. This issue happens radomly. Usually when there is a lot of reports scheduled at the same time, but not always the case.
I think it has someone to do withe XML data integration kit connection timing out. I can’t get confirmation from business objects.
Tanked (BOB member since 2005-12-13)
Well, in your troubleshooting steps you have to ensure that you always get data. If you run the SQL outside BO and you don’t get any data, then the scheduled reports are correct.
Hope this helps.
Have a great day!
MayhewM (BOB member since 2003-10-22)
it was the Database session timeout setting that was causing the issue.
JD Edwards security session was closing out being data was completely retrieved.
running the query outside Crystal had on value in this case, because you could run the same report twice, once get data, and then get no data.
not a report issue.
Tanked (BOB member since 2005-12-13)