Re^3: DBI MSSQL LongReadLen issue

Replies are listed 'Best First'.
Re^4: DBI MSSQL LongReadLen issue by simplelogic (Initiate) on Apr 09, 2014 at 20:43 UTC
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, Microsoft SQL Server Native Client <p> <p>10.0 SQL ServerChanged database context to 'FCSData'.) !SQLError(30212a0,3021348,0) = (01000, 5703, Microsoft SQL Server Native Client <p> <p>10.0 SQL ServerChanged language setting to us_english.) !SQLError(30212a0,3021348,0) = (01S00, 0, Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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: '' 'Microsoft SQL Server Native Client 10.0 SQL ServerChanged database context to 'FCSData'. (SQL-01000) Microsoft SQL Server Native Client 10.0 SQL ServerChanged language setting to us_english. (SQL-01000) state was 01000 now 01S00 Microsoft SQL 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)	[reply]
Re^5: DBI MSSQL LongReadLen issue by mje (Curate) on Apr 10, 2014 at 08:52 UTC
The problem is: `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, pre +c = 0, scale = 0` [download] Column type -152 is unknown to your DBD::ODBC and in any case a call to SQLDescribeCol reports it as size=0 and SQLColAttributes reports display size=1 and column length = 0. For now you'll either have to upgrade to the latest DBD::ODBC which I believe supports MS_SQLS_XML_TYPE or you'll have to cast your m_oGroupDefinition to something else (a varchar).	[reply] [d/l]


Do you know where your variables are?
	PerlMonks