Cannot access external SQL files. (USR0042)

Before I reload Business Objects I thought I’d see if there were any other suggestions.

Everything was fine Friday, Monday I got this error. One suggestion in the error guide is to check middleware, however I have no problem with Toad.

BO 5.4
Oracle SQLNET

Thanks,


Bill Frillman (BOB member since 2002-07-12)

Being able to get in with Toad is not equivalent.

BO uses the Oracle_Home variable. Make sure you only have 1 version o of Oracle client installed.

I’ve not ever see the message you are referrring to. Something is very strange. Let us know if a simple reinstall fixes it. Make sure you do the middleware check at the end of the install.


Steve Krandel :us: (BOB member since 2002-06-25)

Steve,
I bit the bullet and did a reinstall and everything worked again!

So I’m completely stumped as to the cause.

I did a middleware check both before and during the install. Both reported no problem.

Yet after the install everything was fine. Since I still support a few lost souls who are running V4.1 ! (yes, I know!) I supect an Oracle issue as the reinstall of 5 fixed the 4 problem.

thanks again,


Bill Frillman (BOB member since 2002-07-12)