sybperl-l Archive

From: "Sabherwal, Balvinder (MBS)" <Balvinder dot Sabherwal at mortgagefamily dot com>
Subject: CTlib.pm error
Date: Nov 9 2004 7:30PM

Hi list,

I'm getting error upon running one of my scripts as below. This happens asap
the sql is sent to the ASE for execution via ct_sql() method.

The same script is working fine for another ASE and is failing for this ASE
server. Any pointers on this? Below is the debug output.

Thanks

main::(/opt/sybasescripts/DB_Admin/MT_Arch_Dev.pl:388):
388:            $execsql .= "exec $opt_D..proc_arch_mt $glun\n";
  DB<3> 
main::(/opt/sybasescripts/DB_Admin/MT_Arch_Dev.pl:389):
389:            $btchctr++;
  DB<3> 
main::(/opt/sybasescripts/DB_Admin/MT_Arch_Dev.pl:391):
391:         if ( $btchctr == $opt_B && $opt_B )
392:         {
  DB<3> 
main::(/opt/sybasescripts/DB_Admin/MT_Arch_Dev.pl:393):
393:            print LF "Archiving batch of GLUN's\n$execsql ...\n";
  DB<3> p $execsql
exec middletierdb..proc_arch_mt 10185042
exec middletierdb..proc_arch_mt 10201849
exec middletierdb..proc_arch_mt 10218656
exec middletierdb..proc_arch_mt 10235463
exec middletierdb..proc_arch_mt 10252270
exec middletierdb..proc_arch_mt 10269077
exec middletierdb..proc_arch_mt 10274540
exec middletierdb..proc_arch_mt 10285884
exec middletierdb..proc_arch_mt 10302691
exec middletierdb..proc_arch_mt 10319498

  DB<4> 
main::(/opt/sybasescripts/DB_Admin/MT_Arch_Dev.pl:394):
394:            my $dbdata = $dbhS->ct_sql("$execsql");  ## Archive batch of
these GLUN's
  DB<4> 
ct_res_info() failed at
/usr/local/ActivePerl-5.6/lib/site_perl/5.6.1/sun4-solaris-thread-multi/Syba
se/CTlib.pm line 906.
ct_cancel() failed - dying at
/usr/local/ActivePerl-5.6/lib/site_perl/5.6.1/sun4-solaris-thread-multi/Syba
se/CTlib.pm line 918.
Debugged program terminated.  Use q to quit or R to restart,
  use O inhibit_exit to avoid stopping after program termination,
  h q, h R or h O to get additional info.  
  DB<4> q
unixnetmgr /opt/sybasescripts/CronScripts >