DBI 1.616-ithread default trace level set to 0x0/15 (pid 20983 pi 146fb010) at odbc.pl line 6 dbi:ODBC:Driver=libdbodbc11.so;ServerName=CLTRERPIR02;links=tcpip{host=cltmbslpdb02;port=55020} -> DBI->connect(dbi:ODBC:Driver=libdbodbc11.so;ServerName=CLTRERPIR02;links=tcpip{host=cltmbslpdb02;port=55020}, scratchpad, ****, HASH(0x146fed80)) -> DBI->install_driver(ODBC) for linux perl=5.012002 pid=20983 ruid=36010 euid=36010 install_driver: DBD::ODBC version 1.39 loaded from /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBD/ODBC.pm New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x147273d0)=>DBI::dr=HASH(0x14727460), DBD::ODBC::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::ODBC::dr, 168, 0) thr#146fb010 dbih_setup_attrib(DBI::dr=HASH(0x14727460), Err, Null!) SCALAR(0x14923ff8) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x14727460), State, Null!) SCALAR(0x14923f80) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x14727460), Errstr, Null!) SCALAR(0x14923fc8) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x14727460), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x14727460), FetchHashKeyName, Null!) 'NAME' (already defined) install_method DBI::st::odbc_lob_read install_method DBI::st::odbc_getdiagrec, flags 0x0004 install_method DBI::db::odbc_getdiagrec, flags 0x0004 install_method DBI::db::odbc_getdiagfield, flags 0x0004 install_method DBI::st::odbc_getdiagfield, flags 0x0004 <- install_driver= DBI::dr=HASH(0x147273d0) >> connect DISPATCH (DBI::dr=HASH(0x147273d0) rc2/3 @5 g2 ima8001 pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 665 !! warn: 0 CLEARED by call to connect method -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x147273d0)~0x14727460 'Driver=libdbodbc11.so;ServerName=CLTRERPIR02;links=tcpip{host=cltmbslpdb02;port=55020}' 'scratchpad' **** HASH(0x1493b500)) thr#146fb010 New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x14727460), id=undef) dbih_setup_handle(DBI::db=HASH(0x14a70ed0)=>DBI::db=HASH(0x14727ee0), DBD::ODBC::db, 149a2430, Null!) dbih_make_com(DBI::dr=HASH(0x14727460), 14928ac0, DBD::ODBC::db, 592, 0) thr#146fb010 dbih_setup_attrib(DBI::db=HASH(0x14727ee0), Err, DBI::dr=HASH(0x14727460)) SCALAR(0x149a2748) (already defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), State, DBI::dr=HASH(0x14727460)) SCALAR(0x149a2808) (already defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), Errstr, DBI::dr=HASH(0x14727460)) SCALAR(0x149a27a8) (already defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), TraceLevel, DBI::dr=HASH(0x14727460)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), FetchHashKeyName, DBI::dr=HASH(0x14727460)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), HandleSetErr, DBI::dr=HASH(0x14727460)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), HandleError, DBI::dr=HASH(0x14727460)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), ReadOnly, DBI::dr=HASH(0x14727460)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x14727ee0), Profile, DBI::dr=HASH(0x14727460)) undef (not defined) <- connect= ( DBI::db=HASH(0x14a70ed0) ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 665 >> STORE DISPATCH (DBI::db=HASH(0x14727ee0) rc2/1 @3 g2 ima41c pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 717 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x14727ee0)~INNER 'RaiseError' 1) thr#146fb010 !!DBD::ODBC unsupported attribute passed (RaiseError) STORE DBI::db=HASH(0x14727ee0) 'RaiseError' => 1 <- STORE= ( 1 ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 717 >> STORE DISPATCH (DBI::db=HASH(0x14727ee0) rc2/1 @3 g2 ima41c pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 717 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x14727ee0)~INNER 'PrintError' 1) thr#146fb010 !!DBD::ODBC unsupported attribute passed (PrintError) STORE DBI::db=HASH(0x14727ee0) 'PrintError' => 1 <- STORE= ( 1 ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 717 >> STORE DISPATCH (DBI::db=HASH(0x14727ee0) rc2/1 @3 g2 ima41c pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 717 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x14727ee0)~INNER 'AutoCommit' 1) thr#146fb010 setting AutoCommit <- STORE= ( 1 ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 717 >> STORE DISPATCH (DBI::db=HASH(0x14727ee0) rc2/1 @3 g2 ima41c pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 720 via at odbc.pl line 15 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x14727ee0)~INNER 'Username' 'scratchpad') thr#146fb010 !!DBD::ODBC unsupported attribute passed (Username) STORE DBI::db=HASH(0x14727ee0) 'Username' => 'scratchpad' <- STORE= ( 1 ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 720 via at odbc.pl line 15 >> connected DISPATCH (DBI::db=HASH(0x14a70ed0) rc1/1 @5 g2 ima5 pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 727 -> connected in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x14a70ed0)~0x14727ee0 'dbi:ODBC:Driver=libdbodbc11.so;ServerName=CLTRERPIR02;links=tcpip{host=cltmbslpdb02;port=55020}' 'scratchpad' 'scratchpad' HASH(0x146fed80)) thr#146fb010 <- connected= ( undef ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 727 <- connect= DBI::db=HASH(0x14a70ed0) >> STORE DISPATCH (DBI::db=HASH(0x14727ee0) rc2/1 @3 g2 ima41c pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 736 via at odbc.pl line 15 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x14727ee0)~INNER 'dbi_connect_closure' CODE(0x147276b8)) thr#146fb010 !!DBD::ODBC unsupported attribute passed (dbi_connect_closure) STORE DBI::db=HASH(0x14727ee0) 'dbi_connect_closure' => CODE(0x147276b8) <- STORE= ( 1 ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 736 via at odbc.pl line 15 >> prepare DISPATCH (DBI::db=HASH(0x14a70ed0) rc1/1 @2 g2 imaa201 pid#20983) at odbc.pl line 21 -> prepare for DBD::ODBC::db (DBI::db=HASH(0x14a70ed0)~0x14727ee0 'select flt=convert(float, 123.456), dbl=convert(double, 123.456), num=convert(numeric(36,30), 123.456)') thr#146fb010 New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x14727ee0), id=undef) dbih_setup_handle(DBI::st=HASH(0x14a71050)=>DBI::st=HASH(0x14a70f78), DBD::ODBC::st, 149a2898, Null!) dbih_make_com(DBI::db=HASH(0x14727ee0), 14a72300, DBD::ODBC::st, 432, 0) thr#146fb010 dbih_setup_attrib(DBI::st=HASH(0x14a70f78), Err, DBI::db=HASH(0x14727ee0)) SCALAR(0x149a2748) (already defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), State, DBI::db=HASH(0x14727ee0)) SCALAR(0x149a2808) (already defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), Errstr, DBI::db=HASH(0x14727ee0)) SCALAR(0x149a27a8) (already defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), TraceLevel, DBI::db=HASH(0x14727ee0)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), FetchHashKeyName, DBI::db=HASH(0x14727ee0)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), HandleSetErr, DBI::db=HASH(0x14727ee0)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), HandleError, DBI::db=HASH(0x14727ee0)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), ReadOnly, DBI::db=HASH(0x14727ee0)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x14a70f78), Profile, DBI::db=HASH(0x14727ee0)) undef (not defined) initializing sth query timeout to -1 ignore named placeholders = 0 SQLPrepare select flt=convert(float, 123.456), dbl=convert(double, 123.456), num=convert(numeric(36,30), 123.456) SQLPrepare = 0 <- prepare= ( DBI::st=HASH(0x14a71050) ) [1 items] at odbc.pl line 21 >> execute DISPATCH (DBI::st=HASH(0x14a71050) rc1/1 @1 g2 ima1041 pid#20983) at odbc.pl line 22 -> execute for DBD::ODBC::st (DBI::st=HASH(0x14a71050)~0x14a70f78) thr#146fb010 +dbd_st_execute(149a28c8) dbd_st_finish(149a28c8) outparams = 0 SQLExecute/SQLExecDirect(14adc820)=0 SQLRowCount=0 (rows=1) SQLNumResultCols=0 (flds=3) dbd_describe done_desc=0 dbd_describe SQLNumResultCols=0 (columns=3) DescribeCol column = 1, name = flt, namelen = 3, type = REAL(7), precision/column size = 7, scale = 0, nullable = 0 SQL_COLUMN_DISPLAY_SIZE = 13 SQL_COLUMN_LENGTH = 7 now using col 1: type = REAL (7), len = 7, display size = 14, prec = 7, scale = 0 DescribeCol column = 2, name = dbl, namelen = 3, type = DOUBLE(8), precision/column size = 15, scale = 0, nullable = 0 SQL_COLUMN_DISPLAY_SIZE = 22 SQL_COLUMN_LENGTH = 15 now using col 2: type = DOUBLE (8), len = 15, display size = 23, prec = 15, scale = 0 DescribeCol column = 3, name = num, namelen = 3, type = NUMERIC(2), precision/column size = 36, scale = 30, nullable = 0 SQL_COLUMN_DISPLAY_SIZE = 38 SQL_COLUMN_LENGTH = 38 now using col 3: type = NUMERIC (2), len = 38, display size = 39, prec = 36, scale = 30 -dbd_describe done_bind=0 have 3 fields -dbd_st_execute(149a28c8)=1 <- execute= ( 1 ) [1 items] at odbc.pl line 22 >> FETCH DISPATCH (DBI::st=HASH(0x14a70f78) rc2/1 @2 g2 ima404 pid#20983) at odbc.pl line 24 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x14a70f78)~INNER 'NAME') thr#146fb010 dbd_st_FETCH_attrib NAMES 3 flt dbl num Colname 2 => num Colname 1 => dbl Colname 0 => flt <- FETCH= ( [ 'flt' 'dbl' 'num' ] ) [1 items] at odbc.pl line 24 >> FETCH DISPATCH (DBI::st=HASH(0x14a70f78) rc2/1 @2 g2 ima404 pid#20983) at odbc.pl line 25 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x14a70f78)~INNER 'TYPE') thr#146fb010 <- FETCH= ( [ 7 8 2 ] ) [1 items] at odbc.pl line 25 >> fetchall_arrayref DISPATCH (DBI::st=HASH(0x14a71050) rc1/1 @3 g2 ima1 pid#20983) at odbc.pl line 27 -> fetchall_arrayref for DBD::ODBC::st (DBI::st=HASH(0x14a71050)~0x14a70f78 undef 1000) thr#146fb010 bind_columns fbh=14adf6c0 fields=3 Bind 1: type = CHAR(1), buf=14adfc60, buflen=14 Bind 2: type = CHAR(1), buf=14adfc70, buflen=23 Bind 3: type = CHAR(1), buf=14adfc88, buflen=39 bind_columns=0 SQLFetch=1 dbih_setup_fbav alloc for 3 fields dbih_setup_fbav now 3 fields fetch num_fields=3 fetch col#1 flt datalen=19 displ=14 !!dbd_error2(err_rc=-999, what=st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small), handles=(14a73240,14a73830,14adc820) !SQLError(14a73240,14a73830,14adc820) = (HY000, 1, st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small)) !SQLError(14a73240,14a73830,14adc820) = (01004, 0, [Sybase][ODBC Driver]Data truncated) !! ERROR: 1 'st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004)' (err#2) <- fetchall_arrayref= ( [ ] ) [1 items] row1 at odbc.pl line 27 DBD::ODBC::st fetchall_arrayref failed: st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004) at odbc.pl line 27. DBD::ODBC::st fetchall_arrayref failed: st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004) at odbc.pl line 27. >> DESTROY DISPATCH (DBI::st=HASH(0x14a71050) rc1/1 @1 g2 ima10004 pid#20983) at odbc.pl line 27 via at odbc.pl line 27 <> DESTROY(DBI::st=HASH(0x14a71050)) ignored for outer handle (inner DBI::st=HASH(0x14a70f78) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x14a70f78) rc1/1 @1 g2 ima10004 pid#20983) at odbc.pl line 27 via at odbc.pl line 27 -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x14a70f78)~INNER) thr#146fb010 dbd_st_finish(14a71398) dbd_st_finish closed query: SQLFreeHandle(stmt)=0 ERROR: 1 'st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004)' (err#2) <- DESTROY= ( undef ) [1 items] at odbc.pl line 27 via at odbc.pl line 27 DESTROY (dbih_clearcom) (sth 0x14a70f78, com 0x14adc380, imp DBD::ODBC::st): FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn ERR 1 ERRSTR 'st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004)' PARENT DBI::db=HASH(0x14727ee0) KIDS 0 (0 Active) NUM_OF_FIELDS 3 NUM_OF_PARAMS 0 dbih_clearcom 0x14a70f78 (com 0x14adc380, type 3) done. >> DESTROY DISPATCH (DBI::db=HASH(0x14a70ed0) rc1/1 @1 g2 ima10004 pid#20983) at odbc.pl line 27 via at odbc.pl line 27 <> DESTROY(DBI::db=HASH(0x14a70ed0)) ignored for outer handle (inner DBI::db=HASH(0x14727ee0) has ref cnt 1) >> DESTROY DISPATCH (DBI::db=HASH(0x14727ee0) rc1/1 @1 g2 ima10004 pid#20983) at odbc.pl line 27 via at odbc.pl line 27 -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x14727ee0)~INNER) thr#146fb010 DBD::ODBC Disconnected! ERROR: 1 'st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004)' (err#0) <- DESTROY= ( undef ) [1 items] at odbc.pl line 27 via at odbc.pl line 27 DESTROY (dbih_clearcom) (dbh 0x14727ee0, com 0x14a72300, imp DBD::ODBC::db): FLAGS 0x180391: COMSET Warn RaiseError PrintError PrintWarn AutoCommit ERR 1 ERRSTR 'st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) (SQL-HY000) [state was HY000 now 01004] [Sybase][ODBC Driver]Data truncated (SQL-01004)' PARENT DBI::dr=HASH(0x14727460) KIDS 0 (0 Active) dbih_clearcom 0x14727ee0 (com 0x14a72300, type 2) done. -- DBI::END ($@: , $!: ) >> disconnect_all DISPATCH (DBI::dr=HASH(0x147273d0) rc1/3 @1 g2 ima801 pid#20983) at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 744 via at odbc.pl line 27 !! ERROR: 1 CLEARED by call to disconnect_all method -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x147273d0)~0x14727460) thr#146fb010 <- disconnect_all= ( '' ) [1 items] at /opt/local/vndr/ActivePerl-5.12.2-64/site/lib/DBI.pm line 744 via at odbc.pl line 27 flt,dbl,num SQL_LONGVARBINARY,SQL_VARBINARY,SQL_WVARCHAR ! >> DESTROY DISPATCH (DBI::dr=HASH(0x14727460) rc1/1 @1 g2 ima10004 pid#20983) during global destruction ! -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x14727460)~INNER) thr#146fb010 ! <- DESTROY= ( undef ) [1 items] during global destruction DESTROY (dbih_clearcom) (drh 0x147273d0, com 0x14928ac0, imp global destruction): FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 0 (0 Active) dbih_clearcom 0x147273d0 (com 0x14928ac0, type 1) done. ! >> DESTROY DISPATCH (DBI::dr=HASH(0x147273d0) rc1/1 @1 g2 ima10004 pid#20983) during global destruction ! <> DESTROY for DBI::dr=HASH(0x147273d0) ignored (inner handle gone)