Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^4: DBI MSSQL LongReadLen issue

by simplelogic (Initiate)
on Apr 09, 2014 at 20:43 UTC ( [id://1081728]=note: print w/replies, xml ) Need Help??


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

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)

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1081728]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others cooling their heels in the Monastery: (3)
As of 2024-04-24 02:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found