DBI 1.58-ithread default trace level set to 0x0/15 (pid 8616) at DBI.pm line 271 via COIS_DBCONNECT.pm line 10 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::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::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};server=DBserverNameHere;Address=DBserverNameHere,49301;Network=DBMSSOCN;database=DBNameHere;AutoTranslate=no, UserNameHere, ****) -> DBI->install_driver(ODBC) for MSWin32 perl=5.008008 pid=8616 ruid=0 euid=0 install_driver: DBD::ODBC version 1.13 loaded from C:/automation/bin/perl/lib/DBD/ODBC.pm New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x3e726bc)=>DBI::dr=HASH(0x3e72710), DBD::ODBC::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#2b4ee4 dbih_setup_attrib(DBI::dr=HASH(0x3e72710), Err, Null!) SCALAR(0x303f50) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3e72710), State, Null!) SCALAR(0x303f98) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3e72710), Errstr, Null!) SCALAR(0x303f74) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3e72710), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x3e72710), FetchHashKeyName, Null!) 'NAME' (already defined) <- install_driver= DBI::dr=HASH(0x3e726bc) >> connect DISPATCH (DBI::dr=HASH(0x3e726bc) rc2/3 @5 g0 ima8001 pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 633 via at bug.pl line 100 !! warn: 0 CLEARED by call to connect method -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x3e726bc)~0x3e72710 'driver={SQL Server};server=DBserverNameHere;Address=DBserverNameHere,49301;Network=DBMSSOCN;database=DBNameHere;AutoTranslate=no' 'UserNameHere' **** HASH(0x3ba6f10)) thr#2b4ee4 New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x3e72710), id=undef) dbih_setup_handle(DBI::db=HASH(0x3e72ac4)=>DBI::db=HASH(0x3e72a4c), DBD::ODBC::db, 3bec1f4, Null!) dbih_make_com(DBI::dr=HASH(0x3e72710), 3e962fc, DBD::ODBC::db, 224, 0) thr#2b4ee4 dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), Err, DBI::dr=HASH(0x3e72710)) SCALAR(0x3bec380) (already defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), State, DBI::dr=HASH(0x3e72710)) SCALAR(0x3bec3e0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), Errstr, DBI::dr=HASH(0x3e72710)) SCALAR(0x3bec3b0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), TraceLevel, DBI::dr=HASH(0x3e72710)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), FetchHashKeyName, DBI::dr=HASH(0x3e72710)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), HandleSetErr, DBI::dr=HASH(0x3e72710)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), HandleError, DBI::dr=HASH(0x3e72710)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), ReadOnly, DBI::dr=HASH(0x3e72710)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x3e72a4c), Profile, DBI::dr=HASH(0x3e72710)) undef (not defined) Driver connect 'driver={SQL Server};server=DBserverNameHere;Address=DBserverNameHere,49301;Network=DBMSSOCN;database=DBNameHere;AutoTranslate=no;UID=UserNameHere;PWD=UserNameHere;', 'UserNameHere', 'xxxx' 01000 [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'DBNameHere'. 01000 [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. Connected to: Microsoft SQL Server SQLGetFunctions - SQL_MoreResults supported: 1 <- connect= DBI::db=HASH(0x3e72ac4) at C:/automation/bin/perl/lib/DBI.pm line 633 via at bug.pl line 100 >> STORE DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @3 g0 ima41c pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 685 via at bug.pl line 100 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'PrintError' 1) thr#2b4ee4 DBD::ODBC unsupported attribute passed (PrintError) STORE DBI::db=HASH(0x3e72a4c) 'PrintError' => 1 <- STORE= 1 at C:/automation/bin/perl/lib/DBI.pm line 685 via at bug.pl line 100 >> STORE DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @3 g0 ima41c pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 685 via at bug.pl line 100 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'AutoCommit' 1) thr#2b4ee4 <- STORE= 1 at C:/automation/bin/perl/lib/DBI.pm line 685 via at bug.pl line 100 >> STORE DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @3 g0 ima41c pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 688 via at C:/automation/scripts/lib/COIS_DBCONNECT.pm line 137 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'Username' 'UserNameHere') thr#2b4ee4 DBD::ODBC unsupported attribute passed (Username) STORE DBI::db=HASH(0x3e72a4c) 'Username' => 'UserNameHere' <- STORE= 1 at C:/automation/bin/perl/lib/DBI.pm line 688 via at C:/automation/scripts/lib/COIS_DBCONNECT.pm line 137 >> FETCH DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @2 g0 ima404 pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 688 via at bug.pl line 100 <> FETCH= 'UserNameHere' ('Username' from cache) at C:/automation/bin/perl/lib/DBI.pm line 688 via at bug.pl line 100 >> connected DISPATCH (DBI::db=HASH(0x3e72ac4) rc1/1 @4 g0 ima5 pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 694 via at bug.pl line 100 -> connected in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x3e72ac4)~0x3e72a4c 'dbi:ODBC:driver={SQL Server};server=DBserverNameHere;Address=DBserverNameHere,49301;Network=DBMSSOCN;database=DBNameHere;AutoTranslate=no' 'UserNameHere' 'UserNameHere') thr#2b4ee4 <- connected= undef at C:/automation/bin/perl/lib/DBI.pm line 694 via at bug.pl line 100 <- connect= DBI::db=HASH(0x3e72ac4) >> STORE DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @3 g0 ima41c pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 703 via at C:/automation/scripts/lib/COIS_DBCONNECT.pm line 137 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'dbi_connect_closure' CODE(0x3e72620)) thr#2b4ee4 DBD::ODBC unsupported attribute passed (dbi_connect_closure) STORE DBI::db=HASH(0x3e72a4c) 'dbi_connect_closure' => CODE(0x3e72620) <- STORE= 1 at C:/automation/bin/perl/lib/DBI.pm line 703 via at C:/automation/scripts/lib/COIS_DBCONNECT.pm line 137 >> STORE DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @3 g0 ima41c pid#8616) at bug.pl line 107 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'FetchHashKeyName' 'NAME_lc') thr#2b4ee4 DBD::ODBC unsupported attribute passed (FetchHashKeyName) STORE DBI::db=HASH(0x3e72a4c) 'FetchHashKeyName' => 'NAME_lc' <- STORE= 1 at bug.pl line 107 >> STORE DISPATCH (DBI::db=HASH(0x3e72a4c) rc2/1 @3 g0 ima41c pid#8616) at bug.pl line 108 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'AutoCommit' 0) thr#2b4ee4 <- STORE= 1 at bug.pl line 108 >> prepare_cached DISPATCH (DBI::db=HASH(0x3e72ac4) rc1/4 @2 g0 imaa201 pid#8616) at bug.pl line 56 via at bug.pl line 73 -> prepare_cached in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x3e72ac4)~0x3e72a4c 'INSERT INTO T_Alarm_Maintenances (Created_Date_Time, Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_Time, Comment, Source, Component, Media, Media_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ;SELECT SCOPE_IDENTITY()') thr#2b4ee4 >> prepare DISPATCH (DBI::db=HASH(0x3e72a4c) rc1/2 @3 g0 imaa201 pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 1648 via at bug.pl line 56 1 -> prepare for DBD::ODBC::db (DBI::db=HASH(0x3e72a4c)~INNER 'INSERT INTO T_Alarm_Maintenances (Created_Date_Time, Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_Time, Comment, Source, Component, Media, Media_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ;SELECT SCOPE_IDENTITY()' undef) thr#2b4ee4 New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x3e72a4c), id=undef) dbih_setup_handle(DBI::st=HASH(0x3e72ad0)=>DBI::st=HASH(0x3e72bfc), DBD::ODBC::st, 3bec434, Null!) dbih_make_com(DBI::db=HASH(0x3e72a4c), 3cefbdc, DBD::ODBC::st, 212, 0) thr#2b4ee4 dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), Err, DBI::db=HASH(0x3e72a4c)) SCALAR(0x3bec380) (already defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), State, DBI::db=HASH(0x3e72a4c)) SCALAR(0x3bec3e0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), Errstr, DBI::db=HASH(0x3e72a4c)) SCALAR(0x3bec3b0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), TraceLevel, DBI::db=HASH(0x3e72a4c)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), FetchHashKeyName, DBI::db=HASH(0x3e72a4c)) 'NAME_lc' (already defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), HandleSetErr, DBI::db=HASH(0x3e72a4c)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), HandleError, DBI::db=HASH(0x3e72a4c)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), ReadOnly, DBI::db=HASH(0x3e72a4c)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x3e72bfc), Profile, DBI::db=HASH(0x3e72a4c)) undef (not defined) initializing sth query timeout to 0 ignore named placeholders = 0 dbd_preparse scanned 9 distinct placeholders SQLPrepare returned 0 dbd_st_prepare'd sql f87306824, ExecDirect=0 INSERT INTO T_Alarm_Maintenances (Created_Date_Time, Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_Time, Comment, Source, Component, Media, Media_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ;SELECT SCOPE_IDENTITY() 1 <- prepare= DBI::st=HASH(0x3e72ad0) at C:/automation/bin/perl/lib/DBI.pm line 1648 via at bug.pl line 56 <- prepare_cached= DBI::st=HASH(0x3e72ad0) at bug.pl line 56 via at bug.pl line 73 >> execute DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @10 g0 ima1041 pid#8616) at bug.pl line 57 via at bug.pl line 73 -> execute for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc '2010-01-01 00:00:00' 'datkins' '2010-01-01 00:00:00' '2010-01-01 00:10:00' 'A Comment1' 'maintenance' 'blackout' 'Script :' 'myselftest') thr#2b4ee4 bind 1 <== '2010-01-01 00:00:00' (attribs: ), type 0 SQLDescribeParam idx = 1. SQLDescribeParam 1: SqlType=TIMESTAMP, ColDef=23 bind 2 <== 'datkins' (attribs: ), type 0 SQLDescribeParam idx = 2. SQLDescribeParam 2: SqlType=VARCHAR, ColDef=50 bind 3 <== '2010-01-01 00:00:00' (attribs: ), type 0 SQLDescribeParam idx = 3. SQLDescribeParam 3: SqlType=TIMESTAMP, ColDef=23 bind 4 <== '2010-01-01 00:10:00' (attribs: ), type 0 SQLDescribeParam idx = 4. SQLDescribeParam 4: SqlType=TIMESTAMP, ColDef=23 bind 5 <== 'A Comment1' (attribs: ), type 0 SQLDescribeParam idx = 5. SQLDescribeParam 5: SqlType=VARCHAR, ColDef=600 bind 6 <== 'maintenance' (attribs: ), type 0 SQLDescribeParam idx = 6. SQLDescribeParam 6: SqlType=VARCHAR, ColDef=50 bind 7 <== 'blackout' (attribs: ), type 0 SQLDescribeParam idx = 7. SQLDescribeParam 7: SqlType=VARCHAR, ColDef=50 bind 8 <== 'Script :' (attribs: ), type 0 SQLDescribeParam idx = 8. SQLDescribeParam 8: SqlType=VARCHAR, ColDef=50 bind 9 <== 'myselftest' (attribs: ), type 0 SQLDescribeParam idx = 9. SQLDescribeParam 9: SqlType=VARCHAR, ColDef=50 dbd_st_execute (outparams = 0)... bind 6 <== 'maintenance' (size 11/12/0, ptype 4, otype 1, sqltype 12) bind 6 <== 'maintenance' (len 11/11, null 0) bind 6: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=11. SQLBindParameter: idx = 6: fParamType=1, name=6, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a414, cbValueMax=11, cbValue = 11 Param value = maintenance rebind check char Param 6 (maintenance) bind 3 <== '2010-01-01 00:00:00' (size 19/20/0, ptype 4, otype 1, sqltype 93) bind 3 <== '2010-01-01 00:00:00' (len 19/19, null 0) bind 3: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 3: fParamType=1, name=3, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a134, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:00:00 rebind check char Param 3 (2010-01-01 00:00:00) bind 7 <== 'blackout' (size 8/12/0, ptype 4, otype 1, sqltype 12) bind 7 <== 'blackout' (len 8/11, null 0) bind 7: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=8. SQLBindParameter: idx = 7: fParamType=1, name=7, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a474, cbValueMax=8, cbValue = 8 Param value = blackout rebind check char Param 7 (blackout) bind 9 <== 'myselftest' (size 10/12/0, ptype 4, otype 1, sqltype 12) bind 9 <== 'myselftest' (len 10/11, null 0) bind 9: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=10. SQLBindParameter: idx = 9: fParamType=1, name=9, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a53c, cbValueMax=10, cbValue = 10 Param value = myselftest rebind check char Param 9 (myselftest) bind 2 <== 'datkins' (size 7/8/0, ptype 4, otype 1, sqltype 12) bind 2 <== 'datkins' (len 7/7, null 0) bind 2: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=7. SQLBindParameter: idx = 2: fParamType=1, name=2, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a344, cbValueMax=7, cbValue = 7 Param value = datkins rebind check char Param 2 (datkins) bind 8 <== 'Script :' (size 8/12/0, ptype 4, otype 1, sqltype 12) bind 8 <== 'Script :' (len 8/11, null 0) bind 8: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=8. SQLBindParameter: idx = 8: fParamType=1, name=8, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a4d4, cbValueMax=8, cbValue = 8 Param value = Script : rebind check char Param 8 (Script :) bind 1 <== '2010-01-01 00:00:00' (size 19/20/0, ptype 4, otype 1, sqltype 93) bind 1 <== '2010-01-01 00:00:00' (len 19/19, null 0) bind 1: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 1: fParamType=1, name=1, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a2dc, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:00:00 rebind check char Param 1 (2010-01-01 00:00:00) bind 4 <== '2010-01-01 00:10:00' (size 19/20/0, ptype 4, otype 1, sqltype 93) bind 4 <== '2010-01-01 00:10:00' (len 19/19, null 0) bind 4: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 4: fParamType=1, name=4, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a10c, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:10:00 rebind check char Param 4 (2010-01-01 00:10:00) bind 5 <== 'A Comment1' (size 10/12/0, ptype 4, otype 1, sqltype 12) bind 5 <== 'A Comment1' (len 10/11, null 0) bind 5: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=10. SQLBindParameter: idx = 5: fParamType=1, name=5, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a3ac, cbValueMax=10, cbValue = 10 Param value = A Comment1 rebind check char Param 5 (A Comment1) dbd_st_execute (for hstmt 87306824 before)... dbd_st_execute (for hstmt 87306824 after, rc = 0)... dbd_error: err_rc=0 rc=0 s/d/e: 87306824/87300640/87300472 dbd_error: err_rc=0 rc=0 s/d/e: 0/87300640/87300472 dbd_error: err_rc=0 rc=0 s/d/e: 0/0/87300472 dbd_st_execute getting row count dbd_st_execute got row count 1 dbd_describe 87306824 getting num fields Numfields == 0, SQLMoreResults == 0 Numfields == 0, SQLNumResultCols == 0 dbd_describe sql 87306824: num_fields=1 colname 1 = len = 0 (1) col 1: NUMERIC (2) len= 40 disp= 41, prec= 38 scale=0 colname buffer size = 2 pre SQLDescribeCol 0: fbh[0]=3e9acb4 fbh=3e9acb4, cbuf_ptr=3e9b194 post SQLDescribeCol col 0: '' (3e9b194) colname 1 = , len = 0 (sp = 0) pre SQLBindCol col 0: '', 3e9b194, 3e9a4f4, 3e9b194 post SQLBindCol col 0: '', 3e9b194, 3e9a4f4, 3e9b194 col 1: '' sqltype=NUMERIC, ctype=SQL_C_CHAR, maxlen=41, (dp = 0, cp = 0) DEBUG col 0: '' dbd_describe failed, dbd_st_execute #2...! <- execute= 1 at bug.pl line 57 via at bug.pl line 73 >> fetchrow_arrayref DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @1 g0 ima0 pid#8616) at bug.pl line 58 via at bug.pl line 73 -> fetchrow_arrayref for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc) thr#2b4ee4 SQLFetch rc 0 dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields fetch num_fields=1 fetch col#0 datalen=5 displ=41 <- fetchrow_arrayref= [ '25576' ] row1 at bug.pl line 58 via at bug.pl line 73 >> finish DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @1 g0 ima1 pid#8616) at bug.pl line 66 via at bug.pl line 73 -> finish for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc) thr#2b4ee4 dbd_st_finish closed query: <- finish= 1 at bug.pl line 66 via at bug.pl line 73 >> prepare_cached DISPATCH (DBI::db=HASH(0x3e72ac4) rc1/4 @2 g0 imaa201 pid#8616) at bug.pl line 56 via at bug.pl line 73 -> prepare_cached for DBD::ODBC::db (DBI::db=HASH(0x3e72ac4)~0x3e72a4c 'INSERT INTO T_Alarm_Maintenances (Created_Date_Time, Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_Time, Comment, Source, Component, Media, Media_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ;SELECT SCOPE_IDENTITY()') thr#2b4ee4 >> FETCH DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @2 g0 ima404 pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 1642 via at bug.pl line 56 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc 'Active') thr#2b4ee4 .. FETCH DBI::st=HASH(0x3e72bfc) 'Active' = '' <- FETCH= '' at C:/automation/bin/perl/lib/DBI.pm line 1642 via at bug.pl line 56 <- prepare_cached= DBI::st=HASH(0x3e72ad0) at bug.pl line 56 via at bug.pl line 73 >> execute DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @10 g0 ima1041 pid#8616) at bug.pl line 57 via at bug.pl line 73 -> execute for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc '2010-01-01 00:00:00' 'datkins' undef '2010-01-01 00:10:00' 'A Comment2' 'maintenance' 'blackout' 'Script :' 'myselftest') thr#2b4ee4 bind 1 <== '2010-01-01 00:00:00' (attribs: ), type 0 bind 2 <== 'datkins' (attribs: ), type 0 bind 3 <== '' (attribs: ), type 0 bind 4 <== '2010-01-01 00:10:00' (attribs: ), type 0 bind 5 <== 'A Comment2' (attribs: ), type 0 bind 6 <== 'maintenance' (attribs: ), type 0 bind 7 <== 'blackout' (attribs: ), type 0 bind 8 <== 'Script :' (attribs: ), type 0 bind 9 <== 'myselftest' (attribs: ), type 0 dbd_st_execute (outparams = 0)... bind 6 <== 'maintenance' (size 11/12/11, ptype 4, otype 1, sqltype 12) bind 6 <== 'maintenance' (len 11/11, null 0) bind 6: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=11. SQLBindParameter: idx = 6: fParamType=1, name=6, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a414, cbValueMax=11, cbValue = 11 Param value = maintenance rebind check char Param 6 (maintenance) bind 3 <== undef (size -1/-1/19, ptype 4, otype 1, sqltype 93) bind 3 <== '(null)' (len 0/19, null 1) bind 3: CTy=1, STy=TIMESTAMP, CD=1, Sc=0, VM=0. SQLBindParameter: idx = 3: fParamType=1, name=3, fCtype=1, SQL_Type = 93, cbColDef=1, scale=0, rgbValue = 0, cbValueMax=0, cbValue = -1 Param value = (null) rebind check char Param 3 (2010-01-01 00:00:00) bind 7 <== 'blackout' (size 8/12/11, ptype 4, otype 1, sqltype 12) bind 7 <== 'blackout' (len 8/11, null 0) bind 7: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=8. SQLBindParameter: idx = 7: fParamType=1, name=7, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a474, cbValueMax=8, cbValue = 8 Param value = blackout rebind check char Param 7 (blackout) bind 9 <== 'myselftest' (size 10/12/11, ptype 4, otype 1, sqltype 12) bind 9 <== 'myselftest' (len 10/11, null 0) bind 9: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=10. SQLBindParameter: idx = 9: fParamType=1, name=9, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a53c, cbValueMax=10, cbValue = 10 Param value = myselftest rebind check char Param 9 (myselftest) bind 2 <== 'datkins' (size 7/8/7, ptype 4, otype 1, sqltype 12) bind 2 <== 'datkins' (len 7/7, null 0) bind 2: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=7. SQLBindParameter: idx = 2: fParamType=1, name=2, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a344, cbValueMax=7, cbValue = 7 Param value = datkins rebind check char Param 2 (datkins) bind 8 <== 'Script :' (size 8/12/11, ptype 4, otype 1, sqltype 12) bind 8 <== 'Script :' (len 8/11, null 0) bind 8: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=8. SQLBindParameter: idx = 8: fParamType=1, name=8, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a4d4, cbValueMax=8, cbValue = 8 Param value = Script : rebind check char Param 8 (Script :) bind 1 <== '2010-01-01 00:00:00' (size 19/20/19, ptype 4, otype 1, sqltype 93) bind 1 <== '2010-01-01 00:00:00' (len 19/19, null 0) bind 1: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 1: fParamType=1, name=1, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a2dc, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:00:00 rebind check char Param 1 (2010-01-01 00:00:00) bind 4 <== '2010-01-01 00:10:00' (size 19/20/19, ptype 4, otype 1, sqltype 93) bind 4 <== '2010-01-01 00:10:00' (len 19/19, null 0) bind 4: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 4: fParamType=1, name=4, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a10c, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:10:00 rebind check char Param 4 (2010-01-01 00:10:00) bind 5 <== 'A Comment2' (size 10/12/11, ptype 4, otype 1, sqltype 12) bind 5 <== 'A Comment2' (len 10/11, null 0) bind 5: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=10. SQLBindParameter: idx = 5: fParamType=1, name=5, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a3ac, cbValueMax=10, cbValue = 10 Param value = A Comment2 rebind check char Param 5 (A Comment2) dbd_st_execute (for hstmt 87306824 before)... dbd_st_execute (for hstmt 87306824 after, rc = -1)... dbd_error: err_rc=-1 rc=0 s/d/e: 87306824/87300640/87300472 dbd_error: SQL-23000 (native 515): [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Scheduled_Start_Date_Time', table 'DBNameHere.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) dbd_error: SQL-01000 (native 3621): [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Scheduled_Start_Date_Time', table 'DBNameHere.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000) dbd_error: err_rc=-1 rc=0 s/d/e: 0/87300640/87300472 dbd_error: err_rc=-1 rc=0 s/d/e: 0/0/87300472 st_execute/SQLExecute error -1 recorded: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Scheduled_Start_Date_Time', table 'DBNameHere.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1) !! ERROR: -1 '[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Scheduled_Start_Date_Time', table 'DBNameHere.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)' (err#0) <- execute= undef at bug.pl line 57 via at bug.pl line 73 -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::ODBC::st::errstr <- $DBI::errstr= '[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Scheduled_Start_Date_Time', table 'DBNameHere.dbo.T_Alarm_Maintenances'; column does not allow nulls. INSERT fails. (SQL-23000) [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)' >> finish DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @1 g0 ima1 pid#8616) at bug.pl line 66 via at bug.pl line 73 !! ERROR: -1 CLEARED by call to finish method -> finish for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc) thr#2b4ee4 <- finish= 1 at bug.pl line 66 via at bug.pl line 73 >> prepare_cached DISPATCH (DBI::db=HASH(0x3e72ac4) rc1/4 @2 g0 imaa201 pid#8616) at bug.pl line 56 via at bug.pl line 73 -> prepare_cached for DBD::ODBC::db (DBI::db=HASH(0x3e72ac4)~0x3e72a4c 'INSERT INTO T_Alarm_Maintenances (Created_Date_Time, Created_By, Scheduled_Start_Date_Time, Scheduled_End_Date_Time, Comment, Source, Component, Media, Media_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ;SELECT SCOPE_IDENTITY()') thr#2b4ee4 >> FETCH DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @2 g0 ima404 pid#8616) at C:/automation/bin/perl/lib/DBI.pm line 1642 via at bug.pl line 56 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc 'Active') thr#2b4ee4 .. FETCH DBI::st=HASH(0x3e72bfc) 'Active' = '' <- FETCH= '' at C:/automation/bin/perl/lib/DBI.pm line 1642 via at bug.pl line 56 <- prepare_cached= DBI::st=HASH(0x3e72ad0) at bug.pl line 56 via at bug.pl line 73 >> execute DISPATCH (DBI::st=HASH(0x3e72ad0) rc1/2 @10 g0 ima1041 pid#8616) at bug.pl line 57 via at bug.pl line 73 -> execute for DBD::ODBC::st (DBI::st=HASH(0x3e72ad0)~0x3e72bfc '2010-01-01 00:00:00' 'datkins' '2010-01-01 00:00:00' '2010-01-01 00:10:00' 'A Comment3' 'maintenance' 'blackout' 'Script :' 'myselftest') thr#2b4ee4 bind 1 <== '2010-01-01 00:00:00' (attribs: ), type 0 bind 2 <== 'datkins' (attribs: ), type 0 bind 3 <== '2010-01-01 00:00:00' (attribs: ), type 0 bind 4 <== '2010-01-01 00:10:00' (attribs: ), type 0 bind 5 <== 'A Comment3' (attribs: ), type 0 bind 6 <== 'maintenance' (attribs: ), type 0 bind 7 <== 'blackout' (attribs: ), type 0 bind 8 <== 'Script :' (attribs: ), type 0 bind 9 <== 'myselftest' (attribs: ), type 0 dbd_st_execute (outparams = 0)... bind 6 <== 'maintenance' (size 11/12/11, ptype 4, otype 1, sqltype 12) bind 6 <== 'maintenance' (len 11/11, null 0) bind 6: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=11. SQLBindParameter: idx = 6: fParamType=1, name=6, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a414, cbValueMax=11, cbValue = 11 Param value = maintenance rebind check char Param 6 (maintenance) bind 3 <== '2010-01-01 00:00:00' (size 19/20/19, ptype 4, otype 1, sqltype 93) bind 3 <== '2010-01-01 00:00:00' (len 19/19, null 0) bind 3: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 3: fParamType=1, name=3, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a134, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:00:00 rebind check char Param 3 (2010-01-01 00:00:00) bind 7 <== 'blackout' (size 8/12/11, ptype 4, otype 1, sqltype 12) bind 7 <== 'blackout' (len 8/11, null 0) bind 7: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=8. SQLBindParameter: idx = 7: fParamType=1, name=7, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a474, cbValueMax=8, cbValue = 8 Param value = blackout rebind check char Param 7 (blackout) bind 9 <== 'myselftest' (size 10/12/11, ptype 4, otype 1, sqltype 12) bind 9 <== 'myselftest' (len 10/11, null 0) bind 9: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=10. SQLBindParameter: idx = 9: fParamType=1, name=9, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a53c, cbValueMax=10, cbValue = 10 Param value = myselftest rebind check char Param 9 (myselftest) bind 2 <== 'datkins' (size 7/8/7, ptype 4, otype 1, sqltype 12) bind 2 <== 'datkins' (len 7/7, null 0) bind 2: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=7. SQLBindParameter: idx = 2: fParamType=1, name=2, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a344, cbValueMax=7, cbValue = 7 Param value = datkins rebind check char Param 2 (datkins) bind 8 <== 'Script :' (size 8/12/11, ptype 4, otype 1, sqltype 12) bind 8 <== 'Script :' (len 8/11, null 0) bind 8: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=8. SQLBindParameter: idx = 8: fParamType=1, name=8, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a4d4, cbValueMax=8, cbValue = 8 Param value = Script : rebind check char Param 8 (Script :) bind 1 <== '2010-01-01 00:00:00' (size 19/20/19, ptype 4, otype 1, sqltype 93) bind 1 <== '2010-01-01 00:00:00' (len 19/19, null 0) bind 1: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 1: fParamType=1, name=1, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a2dc, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:00:00 rebind check char Param 1 (2010-01-01 00:00:00) bind 4 <== '2010-01-01 00:10:00' (size 19/20/19, ptype 4, otype 1, sqltype 93) bind 4 <== '2010-01-01 00:10:00' (len 19/19, null 0) bind 4: CTy=1, STy=TIMESTAMP, CD=19, Sc=0, VM=19. SQLBindParameter: idx = 4: fParamType=1, name=4, fCtype=1, SQL_Type = 93, cbColDef=19, scale=0, rgbValue = 3e9a10c, cbValueMax=19, cbValue = 19 Param value = 2010-01-01 00:10:00 rebind check char Param 4 (2010-01-01 00:10:00) bind 5 <== 'A Comment3' (size 10/12/11, ptype 4, otype 1, sqltype 12) bind 5 <== 'A Comment3' (len 10/11, null 0) bind 5: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=10. SQLBindParameter: idx = 5: fParamType=1, name=5, fCtype=1, SQL_Type = 12, cbColDef=80, scale=0, rgbValue = 3e9a3ac, cbValueMax=10, cbValue = 10 Param value = A Comment3 rebind check char Param 5 (A Comment3) dbd_st_execute (for hstmt 87306824 before)...