Skip to Content
0
Former Member
Jun 09, 2009 at 03:30 PM

XIR2-SP4 and SQL Server 2005 = 10901: Database error

26 Views

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