Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: DBI MSSQL LongReadLen issue

by mje (Curate)
on Mar 25, 2014 at 11:29 UTC ( #1079665=note: print w/ replies, xml ) Need Help??


in reply to DBI MSSQL LongReadLen issue

What version of DBD::ODBC and DBI? If newer versions can you set DBI_TRACE=DBD=x.log and rerun your script then pastebin the log file for me to look at?


Comment on Re: DBI MSSQL LongReadLen issue
Re^2: DBI MSSQL LongReadLen issue
by simplelogic (Initiate) on Mar 27, 2014 at 16:14 UTC
    Here is the DBI log for the queries. As you can see the first query returns data an ID '8' and is used in the second query which is expected to return the "m_oGroupDefinition as OrigReportXML". This is the LOB and fails to fetch. Advance thanks.
    DBI 1.609-ithread default trace level set to 0x0/3 (pid 7264) at D +BI.pm line 273 via wsoWinExtractor.pl line 31 -> DBI->connect(dbi:ODBC:Driver={SQL Server Native Client 10.0};Pr +ovider=SQLNCLI10;Server=TestServer;Database=FCSData;Trusted_Connectio +n=yes, cttest$user, ****, HASH(0x2d87ff4)) -> DBI->install_driver(ODBC) for MSWin32 perl=5.010001 pid=7264 ru +id=0 euid=0 install_driver: DBD::ODBC version 1.23 loaded from N:/Perl/5.10 +.1/lib/DBD/ODBC.pm <- install_driver= DBI::dr=HASH(0x2da9dfc) !! warn: 0 CLEARED by call to connect method -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x2da9dfc)~0x2da9e7c 'D +river={SQL Server Native Client 10.0};Provider=SQLNCLI10;Server=NT-CH +CTTVC01\MDCTTEST1;Database=FCSData;Trusted_Connection=yes' 'cttest$us +er' **** HASH(0x1a0f47c)) thr#237014 !SQLError(30212a0,3021348,0) = (01000, 5701, [Microsoft][SQL Serve +r Native Client 10.0][SQL Server]Changed database context to 'FCSData +'.) !SQLError(30212a0,3021348,0) = (01000, 5703, [Microsoft][SQL Serve +r Native Client 10.0][SQL Server]Changed language setting to us_engli +sh.) !SQLError(30212a0,3021348,0) = (01S00, 0, [Microsoft][SQL Server N +ative Client 10.0]Invalid connection string attribute) <- connect= DBI::db=HASH(0x2da2b5c) at DBI.pm line 653 via at Wso +Lib.pm line 187 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'RaiseEr +ror' 1) thr#237014 !!DBD::ODBC unsupported attribute passed (RaiseError) STORE DBI::db=HASH(0x2daa28c) 'RaiseError' => 1 info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <- STORE= 1 at DBI.pm line 705 via at WsoLib.pm line 187 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'PrintEr +ror' 1) thr#237014 !!DBD::ODBC unsupported attribute passed (PrintError) STORE DBI::db=HASH(0x2daa28c) 'PrintError' => 1 info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <- STORE= 1 at DBI.pm line 705 via at WsoLib.pm line 187 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'AutoCom +mit' 1) thr#237014 info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <- STORE= 1 at DBI.pm line 705 via at WsoLib.pm line 187 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'Usernam +e' 'cttest$user') thr#237014 !!DBD::ODBC unsupported attribute passed (Username) STORE DBI::db=HASH(0x2daa28c) 'Username' => 'cttest$user' info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <- STORE= 1 at DBI.pm line 708 via at WsoLib.pm line 188 info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <> FETCH= 'cttest$user' ('Username' from cache) at DBI.pm line 708 + via at WsoLib.pm line 187 -> connected in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x2da2b +5c)~0x2daa28c 'dbi:ODBC:Driver={SQL Server Native Client 10.0};Provid +er=SQLNCLI10;Server=TestServer;Database=FCSData;Trusted_Connection=ye +s' 'cttest$user' '**** ' HASH(0x2d87ff4)) thr#237014 info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <- connected= undef at DBI.pm line 714 via at WsoLib.pm line 187 <- connect= DBI::db=HASH(0x2da2b5c) -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'dbi_con +nect_closure' CODE(0x2da9d3c)) thr#237014 !!DBD::ODBC unsupported attribute passed (dbi_connect_closure) STORE DBI::db=HASH(0x2daa28c) 'dbi_connect_closure' => CODE(0x2da9 +d3c) info: '' '[Microsoft][SQL Server Native Client 10.0][SQL Server +]Changed database context to 'FCSData'. (SQL-01000) [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language + setting to us_english. (SQL-01000) [state was 01000 now 01S00] [Microsoft][SQL Server Native Client 10.0]Invalid connection string at +tribute (SQL-01S00)' (err#0) <- STORE= 1 at DBI.pm line 723 via at WsoLib.pm line 188 !! info: '' CLEARED by call to prepare method -> prepare for DBD::ODBC::db (DBI::db=HASH(0x2da2b5c)~0x2daa28c ' SELECT MAX(m_lObjectId) ReportGroupID FROM FCSData..tblRequestGroup WHERE m_sGroupName = 'BankDebtCashProjectionExtract' ') thr#237014 SQLPrepare SELECT MAX(m_lObjectId) ReportGroupID FROM FCSData..tblRequestGroup WHERE m_sGroupName = 'BankDebtCashProjectionExtract' SQLPrepare = 0 <- prepare= DBI::st=HASH(0x2da2d8c) at wsoWinExtractor.pl line 211 + via at wsoWinExtractor.pl line 133 -> execute for DBD::ODBC::st (DBI::st=HASH(0x2da2d8c)~0x2da2b6c) t +hr#237014 +dbd_st_execute(1a4f41c) dbd_st_finish(1a4f41c) -dbd_st_execute(1a4f41c)=-1 <- execute= -1 at wsoWinExtractor.pl line 214 via at wsoWinExtrac +tor.pl line 213 -> fetchrow_hashref in DBD::_::st for DBD::ODBC::st (DBI::st=HASH( +0x2da2d8c)~0x2da2b6c) thr#237014 1 <- FETCH= [ 'ReportGroupID' ] at wsoWinExtractor.pl line 222 via +at wsoWinExtractor.pl line 133 1 <- fetch= [ '8' ] row1 at wsoWinExtractor.pl line 222 via at wsoW +inExtractor.pl line 133 <- fetchrow_hashref= HASH(0x2da2f4c)1keys row1 at wsoWinExtractor. +pl line 222 via at wsoWinExtractor.pl line 133 -> finish for DBD::ODBC::st (DBI::st=HASH(0x2da2d8c)~0x2da2b6c) th +r#237014 dbd_st_finish(1a4f41c) <- finish= 1 at wsoWinExtractor.pl line 227 via at wsoWinExtracto +r.pl line 133 <> DESTROY(DBI::st=HASH(0x2da2d8c)) ignored for outer handle (inne +r DBI::st=HASH(0x2da2b6c) has ref cnt 1) -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x2da2b6c)~INNER) thr#2 +37014 <- DESTROY= undef at wsoWinExtractor.pl line 133 via at wsoWinExt +ractor.pl line 133 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'LongRea +dLen' 50000) thr#237014 !!DBD::ODBC unsupported attribute passed (LongReadLen) STORE DBI::db=HASH(0x2daa28c) 'LongReadLen' => 50000 <- STORE= 1 at wsoWinExtractor.pl line 162 via at wsoWinExtractor +.pl line 143 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER 'LongTru +ncOk' 0) thr#237014 !!DBD::ODBC unsupported attribute passed (LongTruncOk) STORE DBI::db=HASH(0x2daa28c) 'LongTruncOk' => 0 <- STORE= 1 at wsoWinExtractor.pl line 163 via at wsoWinExtractor +.pl line 143 -> prepare for DBD::ODBC::db (DBI::db=HASH(0x2da2b5c)~0x2daa28c ' SELECT m_sGroupName, m_oGroupDefinition as OrigReportXML FROM tblRequestGroup WHERE m_lObjectId = 8 ') thr#237014 SQLPrepare SELECT m_sGroupName, m_oGroupDefinition as OrigReportXML FROM tblRequestGroup WHERE m_lObjectId = 8 SQLPrepare = 0 <- prepare= DBI::st=HASH(0x1a4f56c) at wsoWinExtractor.pl line 211 + via at wsoWinExtractor.pl line 164 -> execute for DBD::ODBC::st (DBI::st=HASH(0x1a4f56c)~0x2da2f4c) t +hr#237014 +dbd_st_execute(2da2e9c) dbd_st_finish(2da2e9c) -dbd_st_execute(2da2e9c)=-1 <- execute= -1 at wsoWinExtractor.pl line 214 via at wsoWinExtrac +tor.pl line 213 -> fetchrow_hashref for DBD::ODBC::st (DBI::st=HASH(0x1a4f56c)~0x2 +da2f4c) thr#237014 1 <- FETCH= [ 'm_sGroupName' 'OrigReportXML' ] at wsoWinExtractor.pl + line 222 via at wsoWinExtractor.pl line 164 !SQLError(30212a0,3021348,30218e0) = (01004, 0, [Microsoft][SQL Se +rver Native Client 10.0]String data, right truncation) !! ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]String data +, right truncation (SQL-01004)' (err#1) 1 <- fetch= undef row1 at wsoWinExtractor.pl line 222 via at wsoWin +Extractor.pl line 164 !! ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]String data +, right truncation (SQL-01004)' (err#1) <- fetchrow_hashref= undef row1 at wsoWinExtractor.pl line 222 via + at wsoWinExtractor.pl line 164 <> DESTROY(DBI::st=HASH(0x1a4f56c)) ignored for outer handle (inne +r DBI::st=HASH(0x2da2f4c) has ref cnt 1) <> DESTROY(DBI::db=HASH(0x2da2b5c)) ignored for outer handle (inne +r DBI::db=HASH(0x2daa28c) has ref cnt 3) -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x2da2f4c)~INNER) thr#2 +37014 dbd_st_finish(1a4f47c) ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]String data +, right truncation (SQL-01004)' (err#1) <- DESTROY= undef at wsoWinExtractor.pl line 222 via at wsoWinExt +ractor.pl line 222 -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x2daa28c)~INNER) thr#2 +37014 ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]String data +, right truncation (SQL-01004)' (err#0) <- DESTROY= undef at wsoWinExtractor.pl line 222 via at wsoWinExt +ractor.pl line 222 -- DBI::END ($@: , $!: ) !! ERROR: 1 CLEARED by call to disconnect_all method -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x2da9dfc)~0x2da +9e7c) thr#237014 <- disconnect_all= '' at DBI.pm line 731 via at wsoWinExtractor.p +l line 222 ! <> DESTROY(DBI::dr=HASH(0x2da9dfc)) ignored for outer handle (inne +r DBI::dr=HASH(0x2da9e7c) has ref cnt 1) ! -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x2da +9e7c)~INNER) thr#237014 ! <- DESTROY= undef during global destruction

      At first I did not recognise that logging but then I realised you are using DBD::ODBC 1.23. That version is 4.5 years old at least. You should look at the change log and you'll realise I've changed a massive amount since then and lots of fixes and enhancements have been made. You are retrieving an XML field which is relatively new.

      Plus your trace level at 3 is too low. It needs to be 15 to see the DBD::ODBC stuff properly.

      I strongly suggest you upgrade DBD::ODBC but if you cannot, run again with trace = 15 and post the last 200-300 lines (basically from the call to SQLPrepare to when the error is output).

        Thanks. Took time as i was trying for an upgrade and looks like there are other systems that would be affected if we do. So here are the logs with setting to 15 DBI 1.609-ithread default trace level set to 0x0/15 (pid 7976) at DBI.pm line 273 via

        wsoWinExtractor.pl line 31

        install_method DBI::db::get_info , flags 0x2a00,

        usage: min 2, max 2, '$info_type'

        install_method DBI::db::take_imp_data, flags 0x10000,

        usage: min 1, max 1, ''

        install_method DBI::db::disconnect , flags 0x10c00,

        usage: min 1, max 1, ''

        install_method DBI::db::selectrow_array, flags 0x2000,

        usage: min 2, max 0, '$statement [, \%attr , @bind_params ]'

        install_method DBI::db::tables , flags 0x2200,

        usage: min 1, max 6, '$catalog, $schema, $table, $type , \%attr '

        install_method DBI::db::quote_identifier, flags 0x0430,

        usage: min 2, max 6, '$name , ... , \%attr '

        install_method DBI::db::clone ,

        usage: min 1, max 2, '\%attr'

        install_method DBI::db::quote , flags 0x0430,

        usage: min 2, max 3, '$string , $data_type '

        install_method DBI::db::type_info , flags 0x2200,

        usage: min 1, max 2, '$data_type'

        install_method DBI::db::statistics_info, flags 0xaa00,

        usage: min 6, max 7, '$catalog, $schema, $table, $unique_only, $quick, , \%attr '

        install_method DBI::db::selectrow_arrayref, flags 0x2000,

        usage: min 2, max 0, '$statement [, \%attr , @bind_params ]'

        install_method DBI::db::begin_work , flags 0x0400,

        usage: min 1, max 2, ' \%attr '

        install_method DBI::db::last_insert_id, flags 0x2800,

        usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name , \%attr '

        install_method DBI::db::foreign_key_info, flags 0xaa00,

        usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table, $fk_catalog, $fk_schema,

        $fk_table , \%attr '

        install_method DBI::db::primary_key , flags 0x2200,

        usage: min 4, max 5, '$catalog, $schema, $table , \%attr '

        install_method DBI::db::commit , flags 0x0c80,

        usage: min 1, max 1, ''

        install_method DBI::db::ping , flags 0x0404,

        usage: min 1, max 1, ''

        install_method DBI::db::selectall_arrayref, flags 0x2000,

        usage: min 2, max 0, '$statement [, \%attr , @bind_params ]'

        install_method DBI::db::type_info_all, flags 0x2a00,

        usage: min 1, max 1, ''

        install_method DBI::db::do , flags 0x3200,

        usage: min 2, max 0, '$statement [, \%attr , @bind_params ]'

        install_method DBI::db::selectcol_arrayref, flags 0x2000,

        usage: min 2, max 0, '$statement [, \%attr , @bind_params ]'

        install_method DBI::db::prepare_cached, flags 0xa200,

        usage: min 2, max 4, '$statement [, \%attr , $if_active ]'

        install_method DBI::db::rows , flags 0x0004

        install_method DBI::db::rollback , flags 0x0c80,

        usage: min 1, max 1, ''

        install_method DBI::db::column_info , flags 0xaa00,

        usage: min 5, max 6, '$catalog, $schema, $table, $column , \%attr '

        install_method DBI::db::table_info , flags 0xaa00,

        usage: min 1, max 6, '$catalog, $schema, $table, $type , \%attr '

        install_method DBI::db::primary_key_info, flags 0xaa00,

        usage: min 4, max 5, '$catalog, $schema, $table , \%attr '

        install_method DBI::db::prepare , flags 0xa200,

        usage: min 2, max 3, '$statement , \%attr'

        install_method DBI::db::preparse

        install_method DBI::db::connected , flags 0x0004,

        usage: min 1, max 0, ''

        install_method DBI::db::data_sources, flags 0x0200,

        usage: min 1, max 2, '\%attr'

        install_method DBI::db::selectall_hashref, flags 0x2000,

        usage: min 3, max 0, '$statement, $keyfield [, \%attr , @bind_params ]'

        install_method DBI::db::selectrow_hashref, flags 0x2000,

        usage: min 2, max 0, '$statement [, \%attr , @bind_params ]'

        install_method DBI::dr::default_user,

        usage: min 3, max 4, '$user, $pass , \%attr'

        install_method DBI::dr::data_sources, flags 0x0800,

        usage: min 1, max 2, '\%attr'

        install_method DBI::dr::dbixs_revision, flags 0x0004

        install_method DBI::dr::disconnect_all, flags 0x0800,

        usage: min 1, max 1, ''

        install_method DBI::dr::connect_cached, flags 0x8000, H 3,

        usage: min 1, max 5, '[$db [,$user [,$passwd ,\%attr]]]'

        install_method DBI::dr::connect , flags 0x8000, H 3,

        usage: min 1, max 5, '[$db [,$user [,$passwd ,\%attr]]]'

        install_method DBI::st::more_results,

        usage: min 1, max 1, ''

        install_method DBI::st::blob_read ,

        usage: min 4, max 5, '$field, $offset, $len [, \$buf , $bufoffset]'

        install_method DBI::st::fetchall_hashref,

        usage: min 2, max 2, '$key_field'

        install_method DBI::st::bind_param_inout_array,

        usage: min 4, max 5, '$parameter, \@var, $maxlen, , \%attr'

        install_method DBI::st::finish ,

        usage: min 1, max 1, ''

        install_method DBI::st::rows , flags 0x0004

        install_method DBI::st::execute_for_fetch, flags 0x5040,

        usage: min 2, max 3, '$fetch_sub , $tuple_status'

        install_method DBI::st::fetchrow_hashref

        install_method DBI::st::_get_fbav

        install_method DBI::st::_set_fbav , T 6

        install_method DBI::st::fetchrow

        install_method DBI::st::fetch

        install_method DBI::st::execute_array, flags 0x5040,

        usage: min 2, max 0, '\%attribs , @args'

        install_method DBI::st::dump_results,

        usage: min 1, max 5, '$maxfieldlen, $linesep, $fieldsep, $filehandle'

        install_method DBI::st::bind_param_array,

        usage: min 3, max 4, '$parameter, $var , \%attr'

        install_method DBI::st::fetchrow_array

        install_method DBI::st::execute , flags 0x1040,

        usage: min 1, max 0, '@args'

        install_method DBI::st::bind_col ,

        usage: min 3, max 4, '$column, \$var , \%attr'

        install_method DBI::st::fetchall_arrayref,

        usage: min 1, max 3, '[ $slice , $max_rows]'

        install_method DBI::st::fetchrow_arrayref

        install_method DBI::st::bind_param_inout,

        usage: min 4, max 5, '$parameter, \$var, $maxlen, , \%attr'

        install_method DBI::st::bind_columns,

        usage: min 2, max 0, '\$var1 , \$var2, ...'

        install_method DBI::st::cancel , flags 0x0800,

        usage: min 1, max 1, ''

        install_method DBI::st::blob_copy_to_file,

        usage: min 3, max 3, '$field, $filename_or_handleref'

        install_method DBI::st::bind_param ,

        usage: min 3, max 4, '$parameter, $var , \%attr'

        install_method DBI::common::parse_trace_flag, flags 0x0404, T 8,

        usage: min 2, max 2, '$name'

        install_method DBI::common::errstr , flags 0x0004

        install_method DBI::common::trace_msg, flags 0x0004, T 8,

        usage: min 2, max 3, '$message_text , $min_level '

        install_method DBI::common::err , flags 0x0004

        install_method DBI::common::CLEAR , flags 0x0004

        install_method DBI::common::state , flags 0x0004

        install_method DBI::common::_not_impl

        install_method DBI::common::NEXTKEY , flags 0x0004

        install_method DBI::common::trace , flags 0x0004,

        usage: min 1, max 3, '[$trace_level, $filename]'

        install_method DBI::common::debug , flags 0x0004,

        usage: min 1, max 2, '$debug_level'

        install_method DBI::common::parse_trace_flags, flags 0x0404, T 8,

        usage: min 2, max 2, '$flags'

        install_method DBI::common::private_attribute_info

        install_method DBI::common::swap_inner_handle,

        usage: min 2, max 3, '$h , $allow_reparent '

        install_method DBI::common::EXISTS , flags 0x0004

        install_method DBI::common::visit_child_handles, flags 0x0404, T 4,

        usage: min 2, max 3, '$coderef , $info '

        install_method DBI::common::FETCH , flags 0x0404

        install_method DBI::common::FIRSTKEY, flags 0x0004

        install_method DBI::common::set_err , flags 0x0010,

        usage: min 3, max 6, '$err, $errmsg , $state, $method, $rv'

        install_method DBI::common::DESTROY , flags 0x10004

        install_method DBI::common::dump_handle, flags 0x0004,

        usage: min 1, max 3, '[$message , $level]'

        install_method DBI::common::FETCH_many, flags 0x0404

        install_method DBI::common::can , flags 0x0100

        install_method DBI::common::STORE , flags 0x041c

        install_method DBI::common::private_data, flags 0x0004,

        usage: min 1, max 1, ''

        install_method DBI::common::func , flags 0x0006

        -> DBI->connect(dbi:ODBC:Driver={SQL Server Native Client

        10.0};Provider=SQLNCLI10;Server=NT-CHCTTVC01\MDCTTEST1;Database=FCSData;Trusted_Connection

        =yes, cttest$user, ****, HASH(0x2d8952c))

        -> DBI->install_driver(ODBC) for MSWin32 perl=5.010001 pid=7976 ruid=0 euid=0

        install_driver: DBD::ODBC version 1.23 loaded from N:/Perl/5.10.1/lib/DBD/ODBC.pm

        New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef)

        dbih_setup_handle(DBI::dr=HASH(0x2dad724)=>DBI::dr=HASH(0x2dad784), DBD::ODBC::dr, 0,

        Null!)

        dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#237014

        dbih_setup_attrib(DBI::dr=HASH(0x2dad784), Err, Null!) SCALAR(0x2d8954c) (already

        defined)

        dbih_setup_attrib(DBI::dr=HASH(0x2dad784), State, Null!) SCALAR(0x182c154) (already

        defined)

        dbih_setup_attrib(DBI::dr=HASH(0x2dad784), Errstr, Null!) SCALAR(0x23abfc) (already

        defined)

        dbih_setup_attrib(DBI::dr=HASH(0x2dad784), TraceLevel, Null!) 0 (already defined)

        dbih_setup_attrib(DBI::dr=HASH(0x2dad784), FetchHashKeyName, Null!) 'NAME' (already

        defined)

        <- install_driver= DBI::dr=HASH(0x2dad724)

        >> connect DISPATCH (DBI::dr=HASH(0x2dad724) rc2/3 @5 g0 ima8001 pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 653 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        !! warn: 0 CLEARED by call to connect method

        -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x2dad724)~0x2dad784 'Driver={SQL Server

        Native Client

        10.0};Provider=SQLNCLI10;Server=NT-CHCTTVC01\MDCTTEST1;Database=FCSData;Trusted_Connection

        =yes' 'cttest$user' **** HASH(0x1a0cfbc)) thr#237014

        New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x2dad784), id=undef)

        dbih_setup_handle(DBI::db=HASH(0x2da6b04)=>DBI::db=HASH(0x2da6a54), DBD::ODBC::db,

        1a4f55c, Null!)

        dbih_make_com(DBI::dr=HASH(0x2dad784), 2d85b0c, DBD::ODBC::db, 508, 0) thr#237014

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), Err, DBI::dr=HASH(0x2dad784))

        SCALAR(0x1a4f76c) (already defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), State, DBI::dr=HASH(0x2dad784))

        SCALAR(0x1a4f7ec) (already defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), Errstr, DBI::dr=HASH(0x2dad784))

        SCALAR(0x1a4f7ac) (already defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), TraceLevel, DBI::dr=HASH(0x2dad784)) 0

        (already defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), FetchHashKeyName, DBI::dr=HASH(0x2dad784))

        'NAME' (already defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), HandleSetErr, DBI::dr=HASH(0x2dad784))

        undef (not defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), HandleError, DBI::dr=HASH(0x2dad784)) undef

        (not defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), ReadOnly, DBI::dr=HASH(0x2dad784)) undef

        (not defined)

        dbih_setup_attrib(DBI::db=HASH(0x2da6a54), Profile, DBI::dr=HASH(0x2dad784)) undef

        (not defined)

        !!dbd_error2(err_rc=1, what=db_login6sv/SQLConnectW, handles=(30212a0,3021348,0)

        !SQLError(30212a0,3021348,0) = (01000, 5701, MicrosoftSQL Server Native Client <p> <p>10.0SQL ServerChanged database context to 'FCSData'.)

        !SQLError(30212a0,3021348,0) = (01000, 5703, MicrosoftSQL Server Native Client <p> <p>10.0SQL ServerChanged language setting to us_english.)

        !SQLError(30212a0,3021348,0) = (01S00, 0, MicrosoftSQL Server Native Client <p> <p>10.0Invalid connection string attribute)

        <- connect= DBI::db=HASH(0x2da6b04) at N:/Perl/5.10.1/lib/DBI.pm line 653 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 705 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'RaiseError' 1) thr#237014

        !!DBD::ODBC unsupported attribute passed (RaiseError)

        STORE DBI::db=HASH(0x2da6a54) 'RaiseError' => 1

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <- STORE= 1 at N:/Perl/5.10.1/lib/DBI.pm line 705 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 705 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'PrintError' 1) thr#237014

        !!DBD::ODBC unsupported attribute passed (PrintError)

        STORE DBI::db=HASH(0x2da6a54) 'PrintError' => 1

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <- STORE= 1 at N:/Perl/5.10.1/lib/DBI.pm line 705 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 705 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'AutoCommit' 1) thr#237014

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <- STORE= 1 at N:/Perl/5.10.1/lib/DBI.pm line 705 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 708 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 196

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'Username' 'cttest$user')

        thr#237014

        !!DBD::ODBC unsupported attribute passed (Username)

        STORE DBI::db=HASH(0x2da6a54) 'Username' => 'cttest$user'

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <- STORE= 1 at N:/Perl/5.10.1/lib/DBI.pm line 708 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 196

        >> FETCH DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @2 g0 ima404 pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 708 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <> FETCH= 'cttest$user' ('Username' from cache) at N:/Perl/5.10.1/lib/DBI.pm line 708

        via at v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        >> connected DISPATCH (DBI::db=HASH(0x2da6b04) rc1/1 @5 g0 ima5 pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 714 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        -> connected in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x2da6b04)~0x2da6a54

        'dbi:ODBC:Driver={SQL Server Native Client

        10.0};Provider=SQLNCLI10;Server=NT-CHCTTVC01\MDCTTEST1;Database=FCSData;Trusted_Connection

        =yes' 'cttest$user' 'fcssucks

        ' HASH(0x2d8952c)) thr#237014

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <- connected= undef at N:/Perl/5.10.1/lib/DBI.pm line 714 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 195

        <- connect= DBI::db=HASH(0x2da6b04)

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 723 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 196

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'dbi_connect_closure'

        CODE(0x2dad644)) thr#237014

        !!DBD::ODBC unsupported attribute passed (dbi_connect_closure)

        STORE DBI::db=HASH(0x2da6a54) 'dbi_connect_closure' => CODE(0x2dad644)

        info: '' 'MicrosoftSQL Server Native Client 10.0SQL ServerChanged database

        context to 'FCSData'. (SQL-01000)

        MicrosoftSQL Server Native Client 10.0SQL ServerChanged language setting to

        us_english. (SQL-01000) state was 01000 now 01S00

        MicrosoftSQL Server Native Client 10.0Invalid connection string attribute (SQL-01S00)'

        (err#0)

        <- STORE= 1 at N:/Perl/5.10.1/lib/DBI.pm line 723 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 196

        >> prepare DISPATCH (DBI::db=HASH(0x2da6b04) rc1/3 @2 g0 imaa201 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 243 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        !! info: '' CLEARED by call to prepare method

        -> prepare for DBD::ODBC::db (DBI::db=HASH(0x2da6b04)~0x2da6a54 '

        SELECT MAX(m_lObjectId) ReportGroupID

        FROM FCSData..tblRequestGroup

        WHERE m_sGroupName = 'BankDebtCashProjectionExtract'

        ') thr#237014

        New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x2da6a54), id=undef)

        dbih_setup_handle(DBI::st=HASH(0x2da6c44)=>DBI::st=HASH(0x2da6bd4), DBD::ODBC::st,

        1a4f84c, Null!)

        dbih_make_com(DBI::db=HASH(0x2da6a54), 2d8ea64, DBD::ODBC::st, 220, 0) thr#237014

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), Err, DBI::db=HASH(0x2da6a54))

        SCALAR(0x1a4f76c) (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), State, DBI::db=HASH(0x2da6a54))

        SCALAR(0x1a4f7ec) (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), Errstr, DBI::db=HASH(0x2da6a54))

        SCALAR(0x1a4f7ac) (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), TraceLevel, DBI::db=HASH(0x2da6a54)) 0

        (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), FetchHashKeyName, DBI::db=HASH(0x2da6a54))

        'NAME' (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), HandleSetErr, DBI::db=HASH(0x2da6a54))

        undef (not defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), HandleError, DBI::db=HASH(0x2da6a54)) undef

        (not defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), ReadOnly, DBI::db=HASH(0x2da6a54)) undef

        (not defined)

        dbih_setup_attrib(DBI::st=HASH(0x2da6bd4), Profile, DBI::db=HASH(0x2da6a54)) undef

        (not defined)

        initializing sth query timeout to -1

        ignore named placeholders = 0

        SQLPrepare

        SELECT MAX(m_lObjectId) ReportGroupID

        FROM FCSData..tblRequestGroup

        WHERE m_sGroupName = 'BankDebtCashProjectionExtract'

        SQLPrepare = 0

        <- prepare= DBI::st=HASH(0x2da6c44) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 243 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        >> execute DISPATCH (DBI::st=HASH(0x2da6c44) rc1/1 @1 g0 ima1041 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 246 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 245

        -> execute for DBD::ODBC::st (DBI::st=HASH(0x2da6c44)~0x2da6bd4) thr#237014

        +dbd_st_execute(1a4f86c)

        dbd_st_finish(1a4f86c)

        outparams = 0

        SQLExecute/SQLExecDirect(30218e0)=0

        SQLRowCount=0 (rows=-1)

        dbd_describe done_desc=0

        dbd_describe SQLNumResultCols=0 (columns=1)

        DescribeCol column = 1, name = R, namelen = 13, type = INTEGER(4), precision/column

        size = 10, scale = 0, nullable = 1

        display size = 11

        column length = 4

        now using col 1: type = INTEGER (4), len = 5, display size = 12, prec = 10, scale = 0

        Bind 1: type = CHAR(1), buf=2db4cd4, buflen=12

        have 1 fields

        -dbd_st_execute(1a4f86c)=-1

        <- execute= -1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 246 via

        at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 245

        >> fetchrow_hashref DISPATCH (DBI::st=HASH(0x2da6c44) rc1/1 @1 g0 ima0 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        -> fetchrow_hashref in DBD::_::st for DBD::ODBC::st

        (DBI::st=HASH(0x2da6c44)~0x2da6bd4) thr#237014

        >> FETCH DISPATCH (DBI::st=HASH(0x2da6bd4) rc2/1 @2 g0 ima404 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        1 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x2da6bd4)~INNER 'NAME') thr#237014

        dbd_st_FETCH_attrib NAMES 1

        R

        Colname 0 => R

        1 <- FETCH= 'ReportGroupID' at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl

        line 254 via at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        >> fetch DISPATCH (DBI::st=HASH(0x2da6bd4) rc2/1 @1 g0 ima0 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        1 -> fetch for DBD::ODBC::st (DBI::st=HASH(0x2da6bd4)~INNER) thr#237014

        SQLFetch rc 0

        dbih_setup_fbav alloc for 1 fields

        dbih_setup_fbav now 1 fields

        fetch num_fields=1

        fetch col#1 R datalen=1 displ=12

        1 <- fetch= '8' row1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line

        254 via at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        <- fetchrow_hashref= HASH(0x2da6e44)1keys row1 at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        >> finish DISPATCH (DBI::st=HASH(0x2da6c44) rc1/1 @1 g0 ima1 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 259 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        -> finish for DBD::ODBC::st (DBI::st=HASH(0x2da6c44)~0x2da6bd4) thr#237014

        dbd_st_finish(1a4f86c)

        dbd_st_finish closed query:

        <- finish= 1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 259 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        >> DESTROY DISPATCH (DBI::st=HASH(0x2da6c44) rc1/1 @1 g0 ima10004 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        <> DESTROY(DBI::st=HASH(0x2da6c44)) ignored for outer handle (inner

        DBI::st=HASH(0x2da6bd4) has ref cnt 1)

        >> DESTROY DISPATCH (DBI::st=HASH(0x2da6bd4) rc1/1 @1 g0 ima10004 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x2da6bd4)~INNER) thr#237014

        SQLFreeStmt=0.

        <- DESTROY= undef at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        via at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 147

        DESTROY (dbih_clearcom) (sth 0x2da6bd4, com 0x2db53cc, imp DBD::ODBC::st):

        FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn

        PARENT DBI::db=HASH(0x2da6a54)

        KIDS 0 (0 Active)

        NUM_OF_FIELDS 1

        NUM_OF_PARAMS 0

        dbih_clearcom 0x2da6bd4 (com 0x2db53cc, type 3) done.

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 182 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 162

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'LongReadLen' 100000)

        thr#237014

        !!DBD::ODBC unsupported attribute passed (LongReadLen)

        STORE DBI::db=HASH(0x2da6a54) 'LongReadLen' => 100000

        <- STORE= 1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 182 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 162

        >> STORE DISPATCH (DBI::db=HASH(0x2da6a54) rc2/1 @3 g0 ima41c pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 183 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 162

        -> STORE for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER 'LongTruncOk' 1) thr#237014

        !!DBD::ODBC unsupported attribute passed (LongTruncOk)

        STORE DBI::db=HASH(0x2da6a54) 'LongTruncOk' => 1

        <- STORE= 1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 183 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 162

        >> prepare DISPATCH (DBI::db=HASH(0x2da6b04) rc1/4 @2 g0 imaa201 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 243 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        -> prepare for DBD::ODBC::db (DBI::db=HASH(0x2da6b04)~0x2da6a54 '

        SELECT m_sGroupName, m_oGroupDefinition as OrigReportXML

        FROM tblRequestGroup

        WHERE m_lObjectId = 8

        ') thr#237014

        New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x2da6a54), id=undef)

        dbih_setup_handle(DBI::st=HASH(0x2da6e94)=>DBI::st=HASH(0x1a4f86c), DBD::ODBC::st,

        2da6fd4, Null!)

        dbih_make_com(DBI::db=HASH(0x2da6a54), 2d8ea64, DBD::ODBC::st, 220, 0) thr#237014

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), Err, DBI::db=HASH(0x2da6a54))

        SCALAR(0x1a4f76c) (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), State, DBI::db=HASH(0x2da6a54))

        SCALAR(0x1a4f7ec) (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), Errstr, DBI::db=HASH(0x2da6a54))

        SCALAR(0x1a4f7ac) (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), TraceLevel, DBI::db=HASH(0x2da6a54)) 0

        (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), FetchHashKeyName, DBI::db=HASH(0x2da6a54))

        'NAME' (already defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), HandleSetErr, DBI::db=HASH(0x2da6a54))

        undef (not defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), HandleError, DBI::db=HASH(0x2da6a54)) undef

        (not defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), ReadOnly, DBI::db=HASH(0x2da6a54)) undef

        (not defined)

        dbih_setup_attrib(DBI::st=HASH(0x1a4f86c), Profile, DBI::db=HASH(0x2da6a54)) undef

        (not defined)

        initializing sth query timeout to -1

        ignore named placeholders = 0

        SQLPrepare

        SELECT m_sGroupName, m_oGroupDefinition as OrigReportXML

        FROM tblRequestGroup

        WHERE m_lObjectId = 8

        SQLPrepare = 0

        <- prepare= DBI::st=HASH(0x2da6e94) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 243 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        >> execute DISPATCH (DBI::st=HASH(0x2da6e94) rc1/1 @1 g0 ima1041 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 246 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 245

        -> execute for DBD::ODBC::st (DBI::st=HASH(0x2da6e94)~0x1a4f86c) thr#237014

        +dbd_st_execute(2da6fc4)

        dbd_st_finish(2da6fc4)

        outparams = 0

        SQLExecute/SQLExecDirect(30218e0)=0

        SQLRowCount=0 (rows=-1)

        dbd_describe done_desc=0

        dbd_describe SQLNumResultCols=0 (columns=2)

        DescribeCol column = 1, name = m, namelen = 12, type = VARCHAR(12), precision/column

        size = 256, scale = 0, nullable = 0

        display size = 256

        column length = 256

        now using col 1: type = VARCHAR (12), len = 257, display size = 257, prec = 256,

        scale = 0

        DescribeCol column = 2, name = O, namelen = 13, type = unknown(-152), precision/column

        size = 0, scale = 0, nullable = 0

        display size = 0

        column length = 0

        now using col 2: type = unknown (-152), len = 1, display size = 1, prec = 0, scale =

        0

        Bind 1: type = CHAR(1), buf=2d8c76c, buflen=257

        Bind 2: type = CHAR(1), buf=2d8c870, buflen=1

        have 2 fields

        -dbd_st_execute(2da6fc4)=-1

        <- execute= -1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 246 via

        at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 245

        >> fetchrow_hashref DISPATCH (DBI::st=HASH(0x2da6e94) rc1/1 @1 g0 ima0 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        -> fetchrow_hashref for DBD::ODBC::st (DBI::st=HASH(0x2da6e94)~0x1a4f86c) thr#237014

        >> FETCH DISPATCH (DBI::st=HASH(0x1a4f86c) rc2/1 @2 g0 ima404 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        1 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x1a4f86c)~INNER 'NAME') thr#237014

        dbd_st_FETCH_attrib NAMES 2

        m

        O

        Colname 1 => O

        Colname 0 => m

        1 <- FETCH= 'm_sGroupName' 'OrigReportXML' at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        >> fetch DISPATCH (DBI::st=HASH(0x1a4f86c) rc2/1 @1 g0 ima0 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        1 -> fetch for DBD::ODBC::st (DBI::st=HASH(0x1a4f86c)~INNER) thr#237014

        SQLFetch rc 1

        dbih_setup_fbav alloc for 2 fields

        dbih_setup_fbav now 2 fields

        fetch num_fields=2

        fetch col#1 m datalen=29 displ=257

        fetch col#2 O datalen=-4 displ=1

        1 <- fetch= 'BankDebtCashProjectionExtract' '.' row1 at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        <- fetchrow_hashref= HASH(0x2da6e04)2keys row1 at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 254 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        >> finish DISPATCH (DBI::st=HASH(0x2da6e94) rc1/1 @1 g0 ima1 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 259 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        -> finish for DBD::ODBC::st (DBI::st=HASH(0x2da6e94)~0x1a4f86c) thr#237014

        dbd_st_finish(2da6fc4)

        dbd_st_finish closed query:

        <- finish= 1 at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 259 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        >> DESTROY DISPATCH (DBI::st=HASH(0x2da6e94) rc1/1 @1 g0 ima10004 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        <> DESTROY(DBI::st=HASH(0x2da6e94)) ignored for outer handle (inner

        DBI::st=HASH(0x1a4f86c) has ref cnt 1)

        >> DESTROY DISPATCH (DBI::st=HASH(0x1a4f86c) rc1/1 @1 g0 ima10004 pid#7976) at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184 via at

        v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1a4f86c)~INNER) thr#237014

        SQLFreeStmt=0.

        <- DESTROY= undef at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        via at v:\wso\ssankara_wso\wso\winscripts\wsoWinExtractor.pl line 184

        DESTROY (dbih_clearcom) (sth 0x1a4f86c, com 0x2db53cc, imp DBD::ODBC::st):

        FLAGS 0x180591: COMSET Warn RaiseError PrintError PrintWarn LongTruncOk

        PARENT DBI::db=HASH(0x2da6a54)

        KIDS 0 (0 Active)

        LongReadLen 100000

        NUM_OF_FIELDS 2

        NUM_OF_PARAMS 0

        dbih_clearcom 0x1a4f86c (com 0x2db53cc, type 3) done.

        >> DESTROY DISPATCH (DBI::db=HASH(0x2da6b04) rc1/1 @1 g0 ima10004 pid#7976) at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236

        <> DESTROY(DBI::db=HASH(0x2da6b04)) ignored for outer handle (inner

        DBI::db=HASH(0x2da6a54) has ref cnt 1)

        >> DESTROY DISPATCH (DBI::db=HASH(0x2da6a54) rc1/1 @1 g0 ima10004 pid#7976) at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236

        -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x2da6a54)~INNER) thr#237014

        DBD::ODBC Disconnected!

        <- DESTROY= undef at v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236 via

        at v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236

        DESTROY (dbih_clearcom) (dbh 0x2da6a54, com 0x2d8ea64, imp DBD::ODBC::db):

        FLAGS 0x180791: COMSET Warn RaiseError PrintError PrintWarn AutoCommit LongTruncOk

        PARENT DBI::dr=HASH(0x2dad784)

        KIDS 0 (0 Active)

        LongReadLen 100000

        dbih_clearcom 0x2da6a54 (com 0x2d8ea64, type 2) done.

        -- DBI::END ($@: , $!: )

        >> disconnect_all DISPATCH (DBI::dr=HASH(0x2dad724) rc1/3 @1 g0 ima801 pid#7976) at

        N:/Perl/5.10.1/lib/DBI.pm line 731 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236

        !! info: '' CLEARED by call to disconnect_all method

        -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x2dad724)~0x2dad784) thr#237014

        <- disconnect_all= '' at N:/Perl/5.10.1/lib/DBI.pm line 731 via at

        v:/wso/ssankara_wso/wso/winscripts/../lib/WsoLib.pm line 236

        ! >> DESTROY DISPATCH (DBI::dr=HASH(0x2dad784) rc1/1 @1 g0 ima10004 pid#7976) during

        global destruction

        ! -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x2dad784)~INNER)

        thr#237014

        ! <- DESTROY= undef during global destruction

        DESTROY (dbih_clearcom) (drh 0x2dad724, com 0x2d85b0c, imp global destruction):

        FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit

        PARENT undef

        KIDS 0 (0 Active)

        dbih_clearcom 0x2dad724 (com 0x2d85b0c, type 1) done.

        ! >> DESTROY DISPATCH (DBI::dr=HASH(0x2dad724) rc1/1 @1 g0 ima10004 pid#7976) during

        global destruction

        ! <> DESTROY for DBI::dr=HASH(0x2dad724) ignored (inner handle gone)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1079665]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (9)
As of 2014-12-28 05:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (178 votes), past polls