Install driver oracle failed Error

We are using Teamsite 6.7 SP1.We have inline calls in our datacapture.cfg that connects the oracle database for data.The script executes successfully from the command line.However,it gives the following error when we do New Form Entry:

Root cause:
The system cannot find the path specified. install_driver(Oracle) failed: Can't load 'C:/IWO/iw-perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD: Smiley Surprised

racle: load_file:The specified module could not be found at C:/IWO/iw-perl/lib/DynaLoader.pm line 229. at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at C:/IWO/iw-perl/lib/PampersVillage.pm line 24

The following article on the support site provides the solution:
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=58608
However,even after adding the environment variables in the script the problem is not solved.Attached is the snapshot of the error.
Please provide some solution.

Find more posts tagged with

Comments

Phanie

Missing attachment

ISCBorisB

We are using Teamsite 6.7 SP1.We have inline calls in our datacapture.cfg that connects the oracle database for data.The script executes successfully from the command line.However,it gives the following error when we do New Form Entry:

Root cause:
The system cannot find the path specified. install_driver(Oracle) failed: Can't load 'C:/IWO/iw-perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD:racle: load_file:The specified module could not be found at C:/IWO/iw-perl/lib/DynaLoader.pm line 229. at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at C:/IWO/iw-perl/lib/PampersVillage.pm line 24

The following article on the support site provides the solution:
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=58608
However,even after adding the environment variables in the script the problem is not solved.Attached is the snapshot of the error.
Please provide some solution.

Modify your code to encapsulate ENV assignments into BEGIN Brackets. Make sure you do that before 'use DBI'. Like that:

use strict;
BEGIN {
$ENV{'PATH'} = q(Your System Path Value);
$ENV{'SystemRoot'} = q(C:\WINNT);
};
use DBI;
...

Jyoti12

we tried with the suggested changes still it does not work.However the error has changed and it cannot locate the database server.Below is the error:

Root cause:
DBI connect('host=PG-STAGEDB-01.ISC.SAVVIS.NET;sid= pgdev;port=1521','PAMPERS',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at C:/IWO/iw-perl/lib/PampersVillage.pm line 18 Can't call method "prepare" without a package or object reference at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 27.

Details...

com.interwoven.ui.datacapture.core.dct.InlineCallout$InlineCalloutException: DBI connect('host=PG-STAGEDB-01.ISC.SAVVIS.NET;sid= pgdev;port=1521','PAMPERS',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at C:/IWO/iw-perl/lib/PampersVillage.pm line 18
Can't call method "prepare" without a package or object reference at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 27.

Attached is the script for reference.

From the command line the same script gives the following error:
The procedure entry point DnsGetIpAddressList could not be loacted in the dynamic link library DNSAPI.DLL

But a simple database connection script works.
Please provide some help.

ISCBorisB

we tried with the suggested changes still it does not work.However the error has changed and it cannot locate the database server.Below is the error:

Root cause:
DBI connect('host=PG-STAGEDB-01.ISC.SAVVIS.NET;sid= pgdev;port=1521','PAMPERS',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at C:/IWO/iw-perl/lib/PampersVillage.pm line 18 Can't call method "prepare" without a package or object reference at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 27.

Details...

com.interwoven.ui.datacapture.core.dct.InlineCallout$InlineCalloutException: DBI connect('host=PG-STAGEDB-01.ISC.SAVVIS.NET;sid= pgdev;port=1521','PAMPERS',...) failed: ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach) at C:/IWO/iw-perl/lib/PampersVillage.pm line 18
Can't call method "prepare" without a package or object reference at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 27.

Attached is the script for reference.

From the command line the same script gives the following error:
The procedure entry point DnsGetIpAddressList could not be loacted in the dynamic link library DNSAPI.DLL

But a simple database connection script works.
Please provide some help.

Uncomment other Environment Variables and move them within "Begin" Bracketing as well.

Note that you absolutely can not use substitution notation (like %name%) when you assign PATH (or any other) %ENV Variable.
Normally it gets evaluated by shell upon forking, it's too late for that in the code! It is your responsibility to expand names and provide
*ready-to-go* components

Jyoti12

We carried out the suggested steps .However we are still facing problems from "New Form Entry" in Teamsite.Below is the error:

Root cause:
DBI connect('host=156.150.113.81;sid=SCHLSDB;port=1521','PAMPERS',...) failed: ORA-12560: TNS Smiley Tongue

rotocol adapter error (DBD ERROR: OCIServerAttach) at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 32 Can't call method "prepare" without a package or object reference at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 49.

Attached is the script for your reference.
When executing the script through command line we are getting the following error:

The application has failed to start because OCI.dll was not found.Re-installing the application may fix this problem.

The "Target host not found" problem through Teamsite "New Form Entry" is solved now.

Please provide us help for the error explained above.

ISCBorisB

We carried out the suggested steps .However we are still facing problems from "New Form Entry" in Teamsite.Below is the error:

Root cause:
DBI connect('host=156.150.113.81;sid=SCHLSDB;port=1521','PAMPERS',...) failed: ORA-12560: TNSrotocol adapter error (DBD ERROR: OCIServerAttach) at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 32 Can't call method "prepare" without a package or object reference at Y:\default\main\Pampers_Village\WORKAREA\jyoti\Perl\contentIdGeneration.pl line 49.

Attached is the script for your reference.
When executing the script through command line we are getting the following error:

The application has failed to start because OCI.dll was not found.Re-installing the application may fix this problem.

The "Target host not found" problem through Teamsite "New Form Entry" is solved now.

Please provide us help for the error explained above.

12560 is generic transport error. Various issues may cause it. So...

Verify that you can connect to Oracle on port 1521 as a client from the machine running that script.

Does your Environment have 'ORACLE_SID' Environment variable? If the answer is "Yes", set it within code's
BEGIN bracket as well.

On the server that is running the database check that the service named 'OracleService<SID>' is running.
Note that your code SID Value and the SIDs shown in error messages differ - something is wrong here. Talk to
your DBA to make sure that you use correct SID.

You've indicated before that "script executes successfully from the command line". What changed?

Vishakha

I and Jyoti are working on the same project.
We are able to connect to the server through command line using sqlplus and through the script. But are not able to connect from the DCT.
After we add the ENV variables to the script, it does not connect through the DCT(New Form Entry) nor does it connect through command line.

I hope I have not confused you.

Adam Stoller

I and Jyoti are working on the same project.
We are able to connect to the server through command line using sqlplus and through the script. But are not able to connect from the DCT.
After we add the ENV variables to the script, it does not connect through the DCT(New Form Entry) nor does it connect through command line.

I hope I have not confused you.

This is usually a symptom of:

of debugging to your script to print out pretty much everything into a log file - run it once from the command line, run it once from the DCT, and compare every bit of data you collect.

Vishakha

Thanks a lot everyone for the inputs.
Our problem is resolved.
We just needed to add three environment variables PATH, SYSTEMROOT and NLS_LANG as below.

#Module to make connections
use DBI;

BEGIN {
$ENV{'SYSTEMROOT'} = q(C:\WINDOWS);
$ENV{'PATH'} = q(/instantclient/instantclient10_1;/IWO/iw-perl/bin;/Perl/site/bin;/Perl/bin;/WINDOWS/system32;/WINDOWS;/WINDOWS/System32/Wbem;/Program Files/Microsoft SQL Server/80/Tools/Binn/;/Program Files/Microsoft SQL Server/90/Tools/binn/;/Program Files/Common Files/Interwoven/lib;/IWO/iw-perl/bin;/IWO/bin);
$ENV{'NLS_LANG'}=q(.WE8ISO8859P15);

}

We were adding "C:\WINNT" as the systemroot whereas it should have been "C:\WINDOWS". Both the paths exist on the server.
However when we print the ENV variables through CGI we realised this and our problem has ulitmately been solved.
:-)

Thanks again!!