WEBI Report Error After Adding 2 New Servers to BOE

[Former Member]

There were two new servers added to the existing BO enterprise application. Both these servers have the Web Intelligence job server and Web Intelligence report server services running on them. Eversince these servers have been added we have been encountering the following error

Creation Time: 1/11/2009 11:40 PM

Start Time: 1/11/2009 11:40 PM

End Time: 1/11/2009 11:40 PM

Server Used: LXW0D38C.Web_IntelligenceJobServer

Error Message: 0: (CS) :DBDriver failed to load : D:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\dbd_oci8.dll (The specified module could not be found. ) An internal error occurred while calling the 'processDPCommands' API. (Error: WIS 30270) BOException caught:RESULT=80004005;WHAT=RefreshBatch failed

The job server mentioned in error message may not necessarily be job server created on the new servers. In the above example the server listed with the job server running on it has BOE installed on the C drive

I do want to point out that when I turn off the job servers and report servers on the newly installed machines this problem goes away

I am assuming that an old job server may assign a task the the new webi intelligence report server to execute a query and the problem shows up

Am I possibly missing a setting in the WEB Intelligence report server?

Is there something that can be done to fix the issue?

We are currently at BOXIR2 SP3.6 which is installed on Windows 2000 Server with SP4

Thank You

Shariq

[Former Member · Accepted solution]

Hi Shariq,

Have you checked the connections from the new servers to the report database. What db are you connecting to. If Oracle ensure that you have the necessary client tool on those servers, if it is SQL then ensure that the same ODBC connections are available.

Regards

Alan

[Former Member · Accepted solution]

Alan,

I used remote desktop to access each of the servers and I am able connect to the oracle databases that the BOW accesses from both SQLPLUS as well as ODBC. I also opened up designer and was able to successfully connect to each of the universes

I have placed the -trace option on the WEB Intelligence Report servers and going to try to find what kind of output this newly installed BOE software generates

Can you think of anything else?

Thank You

Shariq

[Former Member · Accepted solution]

Hi Shariq,

The only other thing I can think of would be the accounts the servers are running under. Again this will affect whether they can connect to your dbs. Ensure the WebI Report Services are running under the same account as those on the working servers

Regards

Alan

[Former Member · Accepted solution]

Alan,

Your suggestion helped immesnsely in getting the problem fixed. The services added were using system account and it seems that there was a security mismatch between the servers. This caused the error I specified in the thread. I went to each Report server and made each one use a generic user account that had access to all the servers and I believe this has fixed the problem

Thank You for your help

Shariq