problem with DBMirror.pl ...
От | Rajesh Kumar Mallah. |
---|---|
Тема | problem with DBMirror.pl ... |
Дата | |
Msg-id | 200211081751.00879.mallah@trade-india.com обсуждение исходный текст |
Список | pgsql-admin |
Hi Folks, DBMirror had been working very fine till recently. but is facing a problem currently. certain "Data" column in the "PendingData" Table which DBMirror.pl script uses has the stuff below: "company_id"='78111' "comp_name"='SUBAIDA JEWELLERY' "office_addr"='NEW.43, NSC BOSE ROAD, ' "phone_no"= '91-44-53508055/8056' "fax_no"= "email"='subaidajewellery@hotmail.com' "website"='http://www.subaidajewellery.c om' "key_exec"='MR. JAFAR|,|' "bran"= "estd"='0' "staff"='10' "prod_exp"= "prod_manu"='JEWELLERIES' "prod_imp"= "serv_prov"= "banker_name"='DENA BANK' "email_valid"= "currency_ann"= "old_company_id"='0' "currency_exp"= "ol d_formno"= "currency_imp"= "imp_exp_code"= "memb_affl"= "std_cert"= "trade_india_branch"='CHENNAI' "areacode"=' 0' "datasource"='1' "status"='p' "formno"='4714' "edition"='12' "area"= "sno"= "city"='CHENNAI' "pincode"='6000 79' "old_edition"= "has_new_form"= "annual_turn"='0.00' "exp_turn"='0.00' "imp_turn"='0.00' "generated"='2002-0 9-03 03:17:29.694147+05:30' "operator_code"='SURESH' "fts_index"= "eyp_group_id"= "old_branch"= "imported"='f' "collector"='G. BIJESJH' "______delete1"='f' "______delete2"='f' "eyp_exported"= "last_updated"='2002-11-08 17: 21:15.836594+05:30' "eyp_paid"= name DBMirror.pl dies in the else clause becoz data does not match if($dataField =~ m/(^= )/s) { Stuff here ... } elsif ($dataField =~ m/(^=\')/s) { Stuff here... } else { # for above case control reaches here :(( logErrorMessage "Error in PendingData Sequence Id " . $pendingResult->getvalue($currentTuple,0); die; } What shud i do ? where does "eyp_paid"= name come from? regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
В списке pgsql-admin по дате отправления: