Dear all,
I'm trying to analyze and fix a strange behavior from my scheduler on XIR2-SP4 (CMS on SQLS2005 and DB is Netezza).
- I have on report which is scheduled weekly for 40 users (this user is also carrying a mail-list)
- Each user has a different access restriction into the univers
(Country = US or Department = Sales or job = Manager ...) and
granted rights to refresh this report.
- I use an admin user to create scheduled task and use "schedule on
behalf" for this list of 40
When I did it first, it was working perfect then since the project is growing I have more and more failure. It means sometimes is working fine but some other I have this error
"10901: Database error: [Gestionnaire de pilotes ODBC] Échec SQLAllocHandle du pilote sur SQL_HANDLE_DBC. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901) "
Any feedback would be greatly appreciated.
Rgds,
Nicolas