Home > Oracle, Siebel > Siebel Open Variable Analyzer

Siebel Open Variable Analyzer

Siebel OVA Utility:

Siebel OVA utility performs following function

  1. Analyzes eScript variables that has been opened but not closed (“null” are not assigned to variable) in the script
  2. Searches for objects that has been opened using the following functions such as GetAssocBusComp, GetPicklistBusComp, this.BusObject, ActiveBusObject, GetBusObject, GetService, NewPropertySet but not nullified
  3. Skipped eScript comments in code
  4. Takes under consideration multiple variables assignments like : var1 = var2 = var3 = <Something>

 

How to get it working?
I was not able to make it work out of the box due to problem with paths specified in Perl Script and the batch file. The Path in these files follow Unix Path convention and I had to change it to windows path. Here are the steps to make this utility work

  1. Download the RAR file and extract it in C Drive (you can extract it anywhere but extracting in root folder makes path simpler in scripts)
  2. Edit tnsnames.ora file in the folder and add the connection details. You can add any Siebel DB details it will extract the scripts from the DB provided in tnsnames.ora. Your tnsnames should look something like this
    SIEBDB =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = siebelqa.server.name)(PORT = 1525))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = QADB)
    )
    )
  3. Edit run.bat file and change the path to the where you extracted the files. Below is how your run.bat will look like assuming you extracted the files in c:\SiebelOVAAnalyer directory
    @echo off
    set ORACLE_HOME=C:\SiebelOVAnalyzer\oraclnt
    set TNS_ADMIN=C:\SiebelOVAnalyzer
    set LOGIN=siebel/password@SIEBDB
    echo Downloading eScripts from Oracle Database…
    echo C:\SiebelOVAnalyzer\oraclnt\sqlplus.exe -s %LOGIN% C:\SiebelOVAnalyzer\getlst.sql
    echo Analysing eScripts for open variables…
    echo set TERM=dumb
    C:\SiebelOVAnalyzer\perl\perl.exe C:\SiebelOVAnalyzer\parselst.pl
  4. Create a folder called tmp inside the SiebelOVAnalyzer folder
  5. Finally edit parselst.pl and change the following line to reflect the path where you extracted the files
  6. my $dir = “.\\tmp”;   —> Change to —–> my $dir = “C:\\SiebelOVAnalyzer\\tmp”;

Now Run the batch file and if everything runs successfully then you should start seeing a set of .lst files in your tmp folder and a out.csv file your root folder.

image image

And the out.csv shows following details

image

Now,you can start cleaning up your repository. I tested it myself and findings were pretty accurate. It took around 5 mins for this utility to download all the scripts in Siebel repository and create a output CSV file. There were some false positives but those were few and far.

You can download it from the link below and the password to extract files is “siebelunleashed.com”(without quotes)

Download Siebel OVA Utility

 

Advertisements
  1. January 8, 2014 at 10:59 pm
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: