DB2 Deski report failure - Driver error?

scheduling XI Scheduler
1

Hi All,

Have installed BOXI 11.5 on Windows 2003 server. Everything is going well but I have hit on an issue when scheduling reports based on a DB2 universe.

The issue is as follows (sorry horribly long).

I open the Universe in designer on the server and check that the universe connection works using native DB2 driver. Save it and export it. I then run three tier deski and write a report - it works fine no issues. Save it and export the report.

I schedule the Deski report and it fails as follows…

Connection or SQL sentence error: (DA0005): [Exception: CS, DBDriver failed to load : D:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\dbd_db2cli.dll (The specified module could not be found. )] A connection required to refresh this document is unavailable. (DA0004): [] The following data providers have not been successfully refreshed: Query 1 with MIDAS Live. (DMA0007):

I open the report in Infoview and refresh it - it fails the same - no surprise there.

I checked the path and file portion of the error and both path and file: dbd_db2cli.dll are correct.

I went back to designer and created a new connection using a generic ODBC driver, tested it - it works - saved it, and exported it. Ran a Deski three tier report against it - worked fine. Exported that - and scheduled it.

Now get this error:

Connection or SQL sentence error: (DA0005): [Exception: DBD, [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failedState: IM004] A connection required to refresh this document is unavailable. (DA0004): [] The following data providers have not been successfully refreshed: Query 1 with MIDAS Live. (DMA0007):

I checked the connection server within CMC and it seems that, amongst others, the following drivers are available:

IBM iSeries Access 
      DB2 for iSeries v4:   Not Loaded 
DB2 UDB for iSeries v5:   Not Loaded 
 
 
IBM DB2 Client 
      DB2 UDB v8:   Loaded 
DB2 UDB v7:   Loaded 
DB2 UDB for z/OS v8:   Loaded 
DB2 UDB for OS/390 v7:   Loaded 
DB2 UDB for OS/390 v6:   Loaded 
DB2 UDB for iSeries v5:   Loaded 
 
 
Essbase Provider 
      Hyperion Essbase 7.0:   Not Loaded 
 
 
Informix ODBC Driver 
      Informix Dynamic Server 2000:   Not Loaded 
Informix Dynamic Server 7.3:   Not Loaded 
Informix XPS 8.4:   Not Loaded 
Informix XPS 8.5:   Not Loaded 
 
 
ODBC Drivers 
      Generic ODBC datasource:   Loaded 
Generic ODBC3 datasource:   Not Loaded 
MS Access 2002:   Not Loaded 
MS Access 2000:   Loaded 
MS SQL Server 7.x:   Not Loaded 
MS SQL Server 2000:   Not Loaded 
MS SQL Server 2005:   Not Loaded 
Sybase ASIQ 12:   Not Loaded 
Red Brick Decision Server 6.x:   Not Loaded 
MySQL 4:   Not Loaded 
MySQL 5:   Not Loaded 
Data Federator Server:   Not Loaded 
Netezza Server:   Not Loaded

For the hell of it I decided to try and create a Webi report based on the DB2 universe - and unsurprisingly it cannot connect.

So I am now at the point where I am pretty sure my inability to schedule Deski reports or run Webi reports is DB2 connection related - but I cannot see a way to remedy it - any ideas - please - thanks!!!

Denise (BOB member since 2006-03-09)

2

Hi All,

Found the problem - it was permissions.

I stopped the Deski Job Server and amended the properties - unchecked the log on as system account, and entered a network account/password (which happens to have administrator privileges).

Restarted the service and off the scheduler goes.

Probably a schoolgirl error - but just glad that it works.

Denise (BOB member since 2006-03-09)