Oracle Connectivity Error

Hello All,

I am unable to connect to oracle database instance from a presentation template. It just gives me a error message

as
===================
iwtmplpreview Error:

Could not process template: /data/iwmnt/default/main/www.xxxxx.com/WORKAREA/skoppise/templatedata/health_and_lifestyle/rm_beauty/presentation/rm_beauty.tpl
:/default/main/www.xxxxx.com/WORKAREA/skoppise/templatedata/health_and_lifestyle/rm_beauty/presentation/rm_beauty.tpl
===================

Here is the Code of Presentation Template file.

=-===============
<?xml version="1.0" encoding="UTF-8"?>
<iw_pt name="health_and_lifestyle_beauty">

<iw_perl>
<![CDATA[
$ENV{ORACLE_HOME} = '/opt/oracle';
$ENV{PATH} = '/opt/oracle/bin';
$ENV{LD_LIBRARY_PATH} = '/opt/oracle/lib';
$ENV{SID} = 'cmsdb';
$ENV{ORA_SID} = 'cmsdb';
]]>
</iw_perl>

<iw_sql_open data_source = "dbi Smiley Surprised

racle:host=cmsdb;port=1521;sid=cmsdb"
user_name = "child"
password = "child"
connection = "dbh"
aux_env = "ORACLE_HOME => '/opt/oracle'">

<iw_sql_query stmt = "select membername from userprofiles'"
connection = 'dbh'
result_set = 'rs'/>

<iw_sql_iterate var='row' result_set='rs'>
<iw_value name='$row->{membername}'/><br/>
</iw_sql_iterate>

</iw_sql_open>
</iw_pt>

================

Any help please...

Thanks,
Srinivas'

Find more posts tagged with

Comments

Sri

Hi,

It seems like you are doing either preview/generate with this presentation template from the UI. preview/generate operations in the UI actually call this command line tool to do the page generation. It'd be helpful to run the iwpt_compile.ipl (in <iw-home>/bin) on the command line to see if you can reproduce the problem. This tool also has some debug options as well. (use -h for a lis tof options)

Hope this helps,
Sri

Migrateduser

Has this TPL ever worked? If this is happening on a development box I recommend adding the following to iwpt_compile.ipl right before the call to main() (change lfile on windows):

use File::Basename;

my ${lfile} = '/tmp/' . File::Basename::basename( ${0} ) . '.log';

if ( open( LOG, '>>' . ${lfile} ))
{
print LOG join( ' ', getppid(), ':', ${$}, ':', scalar( localtime( time())), ':', ${0}, @{ARGV} ) . "\n\n";
close( LOG );
chmod( 0666, ${lfile} );
}
else
{
print join( ' ', 'ERROR :', ${0}, ' : unable to open', ${lfile}, 'for append :', ${!} ) . "\n";
}

Then iwpt_compile.ipl will log what it's doing to this file, you can get the line that is throwing the error and run it on the command line, then again with -ocode to see what lines are causing the problems. If you can't reproduce the error on the command line it probably has something to do with the environment. If you are on Windows one common problem is creating User DSN instead of System DSN.

Migrateduser

John,

I took all the Oracle DB and other Presentation stuff of this tpl file. I narrowed it to this code. Looks like this itself is not working.

I am using Solaris and Teamsite 5.0.

I dont know where to start debugging this. I wrote direct call to Oracle database using DBI in perl and executed the code using iwperl. Interestingly the code is working from command line. It just os not working when I use it in presentation template file.

Are there any Env variables that needs to be set to get this rolling.

Thanks in Adv for your help.

Srinivas'

Migrateduser

Could it be ORACLE_HOME is not set in the TPL's environment?

Migrateduser

John,

I thought this line will do the trick.

<b>$ENV{ORACLE_HOME} = '/opt/oracle'; </b>

This is already there in the code that was not working. Is there any other way to set Oracle_home.

Thanks,
Srinivas'

Migrateduser

Yes that looks right.

This may sound like a hassle but my next suggestion would be to rename your existing tpl (leave the file in place, just rename it, for instance from generate.tpl to generate.orig.tpl) and make a new TPL in the same directory with the original TPL file name (generate.tpl). In an <iw_perl> block in this new TPL do something like:

iwpt_output( `{cmd} 2>&1` );

where {cmd} is the line copied from the iwpt_compile.ipl.log (just change the presentation template name generate.tpl to the new/renamed generate.orig.tpl in this line so you don't have an infinite loop - it doesn't have to be in templating.cfg). Then work with the renamed template until you solve the error as you should be able to see the messages that your original TPL is generating in the environment where it has problems (these may already be logged somewhere I just don't know about).

Someone else may have a better suggestion.