Custom Menu & DBI

sdohar

I am calling a perl script via a Teamsite Customized Menu. I've noticed that when I run the script from the custom menu, the DBI transaction for insert does not work. It does not return an error, it simply does nothing. However, when I run the script from the Solaris command line, the insert works just fine.

Any ideas?

Adam Stoller

In your Perl script - put a little loop like this:

if (open(OUT, ">/tmp/env.$$")){
    foreach (sort(keys(%ENV))){
        print OUT "$_ => '$ENV{$_}'\n";
    }
    close(OUT);
}

Run this again from both the GUI and from the command line.
Compare the results in the two files that are created.
I believe you'll find that there are a number of differences between the environment variables and several which are specifically related to the DB. You generally need to explicitly import / set those environment variables within your script so that they are there when run from the GUI. (I believe there are a number of threads on this topic in these forums - so you might be able find additional information by searching them)

--fish
(Interwoven Senior Technical Consultant)