Did you check if all the BI Services are up? Regards

Hi Kavya, Can you please get the SQL which is running behind the Report and run it in SQL Developer/Toad and see how many records are getting returned from the Database? Regards

User Name: VALUEOF(NQ_SESSION.USER ) Password: VALUEOF(NQ_SESSION.PASSWORD)

So just wanted to know how ibot/agents uses the connection pool information because in adhoc the report is working fine for the user whereas an agent is not working

Hi Christian, * When i hardcode one schema in connection pool (not using switching of the schemas) and try to run an ibot it is working fine. No Errors. * There are no logs mentioned as when i try to run the ibot it gives me error in case of dynamic switching.

and using the same report in agent which he has created in adhoc

Hi Christian, Thanks for the reply. The same user when creating a report in adhoc is working fine as expected but when he is running an agent. It throws the error.