REP-24300/ORA-24300 after resolving DLL-issue
schmidtSep 16 2008 — edited Sep 16 2008Hi
So I'm running the Oracle Application Server Forms And Reports 10g R2 on a Windows 2003 Server.
My application starts some rwserver processes and schedules reports on them with rwclient and srw.run()
I'm building a fresh installation and things were going well until I installed Acrobat Reader 9 and IBMs InfoPrint AFP Workbench. I don't know which of the two caused the problem - if any. What happened the next time I tried to start an rwserver was that I got an error alert saying "rwserver.exe - Unable To Locate Component / This applicaion has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem."
But when I OK out of the alert the server actually seems to be doing fine. Still I can't live with the error message of course, especially as at holds up the rwserver until OK'd and the installation is supposed to run automatically.
I tried to run sqlplus and got the same error, so I assume that it has to do with the Oracle Client. My rwserver.template specifies a jobStatusRepository class="oracle.reports.server.JobRepositoryDB" which connects to a remote database. BTW, sqlplus was also fine as soon as I OK'd the alert.
I found various references to the problem in Oracle context and they were about changing the PATH or copying the dll so it would be found. None explained why this problem would appear.
So I tried this (finding the missing dll in various places on the server). And when I made sure that rwserver would be able to find it, I got "Reports-server / REP-24300: java.sql. SQLException: ORA-24300: Bad value for mode" in stead. And now the server will exit as soon as I OK the alert.
Trying sqlplus again after altering PATH to make sure the dll would be found, everything seems fine. No ORA-24300 there.
Of course I could try uninstalling the Acrobat Reader and AFP Workbench as the rwserver was fine before they came around, but I'd like it better if I could have a real solution. I did try to re-install OAS F&R BTW. With some trouble since the de-install option in the Universal Installer ran into a lot of "MSVCR71.dll was not found". Anyway I managed to run a successful fresh install and it didn't change a thing.
Any ideas?
Jakob