CTlib.pm error

"Sabherwal, Balvinder (MBS)" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <FD09F5C4F598CB4DAB9453CDC42AD6F101DF28EE@mbs-mail-17.mortgagesvcs.com>
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 >
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.