DBI 1.609-ithread default trace level set to 0x6000000/15 (pid 3352) at email.pl line 5 -> DBI->connect(dbi:ODBC:SFSDB, , ****) -> DBI->install_driver(ODBC) for MSWin32 perl=5.010001 pid=3352 ruid=0 euid=0 install_driver: DBD::ODBC version 1.23 loaded from C:/Perl64/site/lib/DBD/ODBC.pm New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x3af4bc8)=>DBI::dr=HASH(0x3af4c58), DBD::ODBC::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::ODBC::dr, 168, 0) thr#25d9a8 dbih_setup_attrib(DBI::dr=HASH(0x3af4c58), Err, Null!) SCALAR(0x2d3afa8) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3af4c58), State, Null!) SCALAR(0x2d3af18) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3af4c58), Errstr, Null!) SCALAR(0x2d3af60) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3af4c58), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3af4c58), FetchHashKeyName, Null!) 'NAME' (already defined) <- install_driver= DBI::dr=HASH(0x3af4bc8) >> default_user DISPATCH (DBI::dr=HASH(0x3af4bc8) rc1/3 @4 g1 ima1 pid#3352) at C:/Perl64/site/lib/DBI.pm line 641 via at D:\WebPortal\email.pl line 37 !! warn: 0 CLEARED by call to default_user method -> default_user in DBD::_::dr for DBD::ODBC::dr (DBI::dr=HASH(0x3af4bc8)~0x3af4c58 undef undef HASH(0x2d3cbc0)) thr#25d9a8 <- default_user= ( undef undef ) [2 items] at C:/Perl64/site/lib/DBI.pm line 641 via at D:\WebPortal\email.pl line 37 >> connect DISPATCH (DBI::dr=HASH(0x3af4bc8) rc2/3 @5 g0 ima8001 pid#3352) at C:/Perl64/site/lib/DBI.pm line 653 via at D:\WebPortal\email.pl line 18 -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x3af4bc8)~0x3af4c58 'SFSDB' undef **** HASH(0x2d3cbc0)) thr#25d9a8 New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x3af4c58), id=undef) dbih_setup_handle(DBI::db=HASH(0x3af6438)=>DBI::db=HASH(0x3af6330), DBD::ODBC::db, 2d45c98, Null!) dbih_make_com(DBI::dr=HASH(0x3af4c58), 296488, DBD::ODBC::db, 608, 0) thr#25d9a8 dbih_setup_attrib(DBI::db=HASH(0x3af6330), Err, DBI::dr=HASH(0x3af4c58)) SCALAR(0x2d45fb0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), State, DBI::dr=HASH(0x3af4c58)) SCALAR(0x2d46070) (already defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), Errstr, DBI::dr=HASH(0x3af4c58)) SCALAR(0x2d46010) (already defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), TraceLevel, DBI::dr=HASH(0x3af4c58)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), FetchHashKeyName, DBI::dr=HASH(0x3af4c58)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), HandleSetErr, DBI::dr=HASH(0x3af4c58)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), HandleError, DBI::dr=HASH(0x3af4c58)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), ReadOnly, DBI::dr=HASH(0x3af4c58)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x3af6330), Profile, DBI::dr=HASH(0x3af4c58)) undef (not defined) Unicode login6 dbname=SFSDB, uid=undef, pwd=xxxxx SQLDriverConnect 'SFSDB', 'undef', 'xxxx' SQLDriverConnectW failed: SQLConnect ''SFSDB'', 'undef' !!dbd_error2(err_rc=1, what=db_login6sv/SQLConnectW, handles=(3242940,3242a80,0) !SQLError(3242940,3242a80,0) = (01000, 5701, [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'SFSDB'.) !SQLError(3242940,3242a80,0) = (01000, 5703, [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english.) Turning autocommit on DRIVER_ODBC_VER = 03.52 DRIVER_NAME = sqlncli10.dll DRIVER_VERSION = 10.00.1600 MAX_COLUMN_NAME_LEN = 128 DBD::ODBC is unicode built : YES Deferring Binding SQL_DBMS_NAME = Microsoft SQL Server SQLMoreResults supported: 1 SQLDescribeParam supported: 1 SQLDescribeParam supported: 1 <- connect= DBI::db=HASH(0x3af6438) at C:/Perl64/site/lib/DBI.pm line 653 via at D:\WebPortal\email.pl line 18 >> STORE DISPATCH (DBI::db=HASH(0x3af6330) rc2/1 @3 g0 ima41c pid#3352) at C:/Perl64/site/lib/DBI.pm line 705 via at D:\WebPortal\email.pl line 18 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3af6330)~INNER 'PrintError' 1) thr#25d9a8 !!DBD::ODBC unsupported attribute passed (PrintError) ............ ............ ............ ............ >> fetch DISPATCH (DBI::st=HASH(0x3af6558) rc2/1 @1 g0 ima0 pid#3352) at D:\WebPortal\email.pl line 87 via at D:\WebPortal\email.pl line 19 1 -> fetch for DBD::ODBC::st (DBI::st=HASH(0x3af6558)~INNER) thr#25d9a8 SQLFetch rc 0 fetch num_fields=12 fetch col#1 e datalen=42 displ=302 fetch col#2 c datalen=5 displ=12 fetch col#3 c datalen=10 displ=602 fetch col#4 c datalen=6 displ=51 fetch col#5 c datalen=6 displ=12 fetch col#6 d datalen=10 displ=11 fetch col#7 a datalen=8 displ=22 fetch col#8 b datalen=11 displ=22 fetch col#9 c datalen=3 displ=12 fetch col#10 M datalen=54 displ=202 fetch col#11 m datalen=4 displ=12 fetch col#12 c datalen=24 displ=1022 1 <- fetch= [ 'xxxx@xxxxxxxx.com' '14954' 'xxxxx' 'xxxxx' '290815' '2009-12-09' '589.6100' '101520.9100' '967' 'XXXXXXXXXXXXX' '2138' 'Cash Advance' ] row44 at D:\WebPortal\email.pl line 87 via at D:\WebPortal\email.pl line 19 <- fetchrow_hashref= HASH(0x3b7b988)12keys row44 at D:\WebPortal\email.pl line 87 via at D:\WebPortal\email.pl line 19 >> prepare DISPATCH (DBI::db=HASH(0x3af6438) rc5/1 @2 g0 imaa201 pid#3352) at D:\WebPortal\email.pl line 191 via at D:\WebPortal\email.pl line 68 -> prepare for DBD::ODBC::db (DBI::db=HASH(0x3af6438)~0x3af6330 'insert into emailHistory (tableName, recordId, toAddress, sentDate, typeOfEmail) values (?, ?, ?, ?, ?)') thr#25d9a8 New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x3af6330), id=undef) dbih_setup_handle(DBI::st=HASH(0x3b7bfa8)=>DBI::st=HASH(0x3b7b5f8), DBD::ODBC::st, 3af6ac8, Null!) dbih_make_com(DBI::db=HASH(0x3af6330), 3788768, DBD::ODBC::st, 384, 0) thr#25d9a8 dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), Err, DBI::db=HASH(0x3af6330)) SCALAR(0x2d45fb0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), State, DBI::db=HASH(0x3af6330)) SCALAR(0x2d46070) (already defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), Errstr, DBI::db=HASH(0x3af6330)) SCALAR(0x2d46010) (already defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), TraceLevel, DBI::db=HASH(0x3af6330)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), FetchHashKeyName, DBI::db=HASH(0x3af6330)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), HandleSetErr, DBI::db=HASH(0x3af6330)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), HandleError, DBI::db=HASH(0x3af6330)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), ReadOnly, DBI::db=HASH(0x3af6330)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x3b7b5f8), Profile, DBI::db=HASH(0x3af6330)) undef (not defined) initializing sth query timeout to -1 ignore named placeholders = 0 creating new parameter key 1 creating new parameter key 2 creating new parameter key 3 creating new parameter key 4 creating new parameter key 5 dbd_preparse scanned 5 distinct placeholders SQLPrepare insert into emailHistory (tableName, recordId, toAddress, sentDate, typeOfEmail) values (?, ?, ?, ?, ?) Processing non-utf8 sql in unicode mode SQLPrepare = 0 <- prepare= DBI::st=HASH(0x3b7bfa8) at D:\WebPortal\email.pl line 191 via at D:\WebPortal\email.pl line 68 >> execute DISPATCH (DBI::st=HASH(0x3b7bfa8) rc1/1 @6 g0 ima1041 pid#3352) at D:\WebPortal\email.pl line 195 via at D:\WebPortal\email.pl line 68 -> execute for DBD::ODBC::st (DBI::st=HASH(0x3b7bfa8)~0x3b7b5f8 'contractPaymentHistory' '292587' 'xxxx@xxxxxxxxxx.com' '2009-12-10 21:11:34' 1) thr#25d9a8 +dbd_bind_ph(3af6ab0, name=1, value='contractPaymentHistory', attribs=, sql_type=0(unknown), is_inout=0, maxlen=0 +get_param_type(3af6ab0,1) SQLDescribeParam failed reverting to default SQL bind type -9 HY000 [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command get_param_type: modified value type to SQL_C_WCHAR -get_param_type -dbd_bind_ph=1 +dbd_bind_ph(3af6ab0, name=2, value='292587', attribs=, sql_type=0(unknown), is_inout=0, maxlen=0 +get_param_type(3af6ab0,2) SQLDescribeParam failed reverting to default SQL bind type -9 HY000 [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command get_param_type: modified value type to SQL_C_WCHAR -get_param_type -dbd_bind_ph=1 +dbd_bind_ph(3af6ab0, name=3, value='xxxx@xxxxxxx.com', attribs=, sql_type=0(unknown), is_inout=0, maxlen=0 +get_param_type(3af6ab0,3) SQLDescribeParam failed reverting to default SQL bind type -9 HY000 [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command get_param_type: modified value type to SQL_C_WCHAR -get_param_type -dbd_bind_ph=1 +dbd_bind_ph(3af6ab0, name=4, value='2009-12-10 21:11:34', attribs=, sql_type=0(unknown), is_inout=0, maxlen=0 +get_param_type(3af6ab0,4) SQLDescribeParam failed reverting to default SQL bind type -9 HY000 [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command get_param_type: modified value type to SQL_C_WCHAR -get_param_type -dbd_bind_ph=1 +dbd_bind_ph(3af6ab0, name=5, value='1', attribs=, sql_type=0(unknown), is_inout=0, maxlen=0 +get_param_type(3af6ab0,5) SQLDescribeParam failed reverting to default SQL bind type -9 HY000 [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command get_param_type: modified value type to SQL_C_WCHAR -get_param_type -dbd_bind_ph=1 +dbd_st_execute(3af6ab0) dbd_st_finish(3af6ab0) outparams = 0 +rebind_param 4 ''2009-12-10 21:11:34'' (size svCUR=19/SvLEN=24/max=0) svtype 5, value type:-8 sql type:-9 +get_param_type(3af6ab0,4) SQLDescribeParam already run and returned rc=-1 get_param_type: modified value type to SQL_C_WCHAR -get_param_type Need to modify phs->sv in place: old length = 19 Need to modify phs->sv in place: new length = 38 bind 4 '2' value_len=38 maxlen=38 null=0) bind 4 value_type:-8 UNICODE VARCHAR cs=38 dd=0 bl=38 SQLBindParameter: idx=4: param_type=1, name=4, value_type=-8, SQL_Type=-9, column_size=0, d_digits=0, value_ptr=3abd778, buffer_length=38, cbValue=38, param_size=0 -rebind_param +rebind_param 1 ''contractPaymentHistory'' (size svCUR=22/SvLEN=24/max=0) svtype 5, value type:-8 sql type:-9 +get_param_type(3af6ab0,1) SQLDescribeParam already run and returned rc=-1 get_param_type: modified value type to SQL_C_WCHAR -get_param_type Need to modify phs->sv in place: old length = 22 Need to modify phs->sv in place: new length = 44 bind 1 'c' value_len=44 maxlen=46 null=0) bind 1 value_type:-8 UNICODE VARCHAR cs=44 dd=0 bl=44 SQLBindParameter: idx=1: param_type=1, name=1, value_type=-8, SQL_Type=-9, column_size=0, d_digits=0, value_ptr=3abd8b8, buffer_length=44, cbValue=44, param_size=0 -rebind_param +rebind_param 3 ''xxx@xxxxxx.com'' (size svCUR=21/SvLEN=24/max=0) svtype 5, value type:-8 sql type:-9 +get_param_type(3af6ab0,3) SQLDescribeParam already run and returned rc=-1 get_param_type: modified value type to SQL_C_WCHAR -get_param_type Need to modify phs->sv in place: old length = 21 Need to modify phs->sv in place: new length = 42 bind 3 'm' value_len=42 maxlen=46 null=0) bind 3 value_type:-8 UNICODE VARCHAR cs=42 dd=0 bl=42 SQLBindParameter: idx=3: param_type=1, name=3, value_type=-8, SQL_Type=-9, column_size=0, d_digits=0, value_ptr=3abdc78, buffer_length=42, cbValue=42, param_size=0 -rebind_param +rebind_param 2 ''292587'' (size svCUR=6/SvLEN=8/max=0) svtype 5, value type:-8 sql type:-9 +get_param_type(3af6ab0,2) SQLDescribeParam already run and returned rc=-1 get_param_type: modified value type to SQL_C_WCHAR -get_param_type Need to modify phs->sv in place: old length = 6 Need to modify phs->sv in place: new length = 12 bind 2 '2' value_len=12 maxlen=14 null=0) bind 2 value_type:-8 UNICODE VARCHAR cs=12 dd=0 bl=12 SQLBindParameter: idx=2: param_type=1, name=2, value_type=-8, SQL_Type=-9, column_size=0, d_digits=0, value_ptr=66f14f8, buffer_length=12, cbValue=12, param_size=0 -rebind_param +rebind_param 5 '1' (size svCUR=1/SvLEN=8/max=0) svtype 6, value type:-8 sql type:-9 +get_param_type(3af6ab0,5) SQLDescribeParam already run and returned rc=-1 get_param_type: modified value type to SQL_C_WCHAR -get_param_type Need to modify phs->sv in place: old length = 1 Need to modify phs->sv in place: new length = 2 bind 5 '1' value_len=2 maxlen=6 null=0) bind 5 value_type:-8 UNICODE VARCHAR cs=2 dd=0 bl=2 SQLBindParameter: idx=5: param_type=1, name=5, value_type=-8, SQL_Type=-9, column_size=0, d_digits=0, value_ptr=66f14c8, buffer_length=2, cbValue=2, param_size=0 -rebind_param SQLExecute/SQLExecDirect(32446c0)=-1 !!dbd_error2(err_rc=-1, what=st_execute/SQLExecute, handles=(3242940,3242a80,32446c0) !SQLError(3242940,3242a80,32446c0) = (HY000, 0, [Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command) -dbd_st_execute(3af6ab0)=-2 !! ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' (err#1) <- execute= undef at D:\WebPortal\email.pl line 195 via at D:\WebPortal\email.pl line 68 -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::ODBC::st::errstr <- $DBI::errstr= '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' >> DESTROY DISPATCH (DBI::st=HASH(0x3b7bfa8) rc1/1 @1 g0 ima10004 pid#3352) at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 <> DESTROY(DBI::st=HASH(0x3b7bfa8)) ignored for outer handle (inner DBI::st=HASH(0x3b7b5f8) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x3b7b5f8) rc1/1 @1 g0 ima10004 pid#3352) at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3b7b5f8)~INNER) thr#25d9a8 SQLFreeStmt=0. ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' (err#1) <- DESTROY= undef at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 DESTROY (dbih_clearcom) (sth 0x3b7b5f8, com 0x2ff0848, imp DBD::ODBC::st): FLAGS 0x180111: COMSET Warn PrintError PrintWarn ERR 1 ERRSTR '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' PARENT DBI::db=HASH(0x3af6330) KIDS 0 (0 Active) NUM_OF_FIELDS -1 NUM_OF_PARAMS 5 dbih_clearcom 0x3b7b5f8 (com 0x2ff0848, type 3) done. >> DESTROY DISPATCH (DBI::st=HASH(0x3af65a0) rc1/1 @1 g0 ima10004 pid#3352) at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 <> DESTROY(DBI::st=HASH(0x3af65a0)) ignored for outer handle (inner DBI::st=HASH(0x3af6558) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x3af6558) rc1/1 @1 g0 ima10004 pid#3352) at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x3af6558)~INNER) thr#25d9a8 dbd_st_finish(3af6618) dbd_st_finish closed query: SQLFreeStmt=0. ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' (err#0) <- DESTROY= undef at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 DESTROY (dbih_clearcom) (sth 0x3af6558, com 0x2ff0338, imp DBD::ODBC::st): FLAGS 0x180111: COMSET Warn PrintError PrintWarn ERR 1 ERRSTR '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' PARENT DBI::db=HASH(0x3af6330) KIDS 0 (0 Active) NUM_OF_FIELDS 12 NUM_OF_PARAMS 0 dbih_clearcom 0x3af6558 (com 0x2ff0338, type 3) done. -> $DBI::err (*) FETCH from lasth=HASH <- $DBI::err= 1 -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::ODBC::db::errstr <- $DBI::errstr= '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' -- DBI::END ($@: , $!: ) >> disconnect_all DISPATCH (DBI::dr=HASH(0x3af4bc8) rc1/4 @1 g0 ima801 pid#3352) at C:/Perl64/site/lib/DBI.pm line 731 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 !! info: '' CLEARED by call to disconnect_all method -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x3af4bc8)~0x3af4c58) thr#25d9a8 <- disconnect_all= '' at C:/Perl64/site/lib/DBI.pm line 731 via at C:/Perl64/site/lib/Log/Log4perl/Logger.pm line 852 ! >> DESTROY DISPATCH (DBI::db=HASH(0x3af6438) rc1/1 @1 g0 ima10004 pid#3352) during global destruction ! <> DESTROY(DBI::db=HASH(0x3af6438)) ignored for outer handle (inner DBI::db=HASH(0x3af6330) has ref cnt 1) ! >> DESTROY DISPATCH (DBI::db=HASH(0x3af6330) rc1/1 @1 g0 ima10004 pid#3352) during global destruction ! -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x3af6330)~INNER) thr#25d9a8 SQLDisconnect=0 DBD::ODBC Disconnected! ERROR: 1 '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' (err#0) ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (dbh 0x3af6330, com 0x3788768, imp global destruction): FLAGS 0x180311: COMSET Warn PrintError PrintWarn AutoCommit ERR 1 ERRSTR '[Microsoft][SQL Server Native Client 10.0]Connection is busy with results for another command (SQL-HY000)' PARENT DBI::dr=HASH(0x3af4c58) KIDS 0 (0 Active) dbih_clearcom 0x3af6330 (com 0x3788768, type 2) done. ! >> DESTROY DISPATCH (DBI::dr=HASH(0x3af4c58) rc1/1 @1 g0 ima10004 pid#3352) during global destruction ! -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x3af4c58)~INNER) thr#25d9a8 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (drh 0x3af4bc8, com 0x296488, imp global destruction): FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 1 (1 Active) dbih_clearcom 0x3af4bc8 (com 0x296488, type 1) done. ! >> DESTROY DISPATCH (DBI::dr=HASH(0x3af4bc8) rc1/1 @1 g0 ima10004 pid#3352) during global destruction ! <> DESTROY for DBI::dr=HASH(0x3af4bc8) ignored (inner handle gone)