Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^3: DBI MSSQL LongReadLen issue

by mje (Deacon)
on Mar 27, 2014 at 16:25 UTC ( #1079959=note: print w/ replies, xml ) Need Help??


in reply to Re^2: DBI MSSQL LongReadLen issue
in thread DBI MSSQL LongReadLen issue

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).


Comment on Re^3: DBI MSSQL LongReadLen issue
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, 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)

      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

      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).

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2014-09-20 03:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (152 votes), past polls