RDBMS conversion Data Errors

hi Any one having idea how to solve Rdbms Conversion Data Errors.

1) F.ENQUIRY.SELECT :
A10006 record data error, record contains invalid characters
bad record IMAGE.VIEW_MM0010120_KHINEMONKYAW_1472017362892_, char 09 at offset 20
bad record CB.STMT.ENT.BOOK_MM0010010_AYENYEINTHU_1472119755466_, char 09 at offset 28
bad record IMAGE.VIEW_MM0010076_CHOZINTHAW_1472022617697_, char 09 at offset 8
bad record CB.ACCOUNT.AMEND_MM0012017_MIKYALLAR_Enquiry311075637304_, char 09 at offset 24

F.ENQUIRY.SELECT(Sample Records):
*************************
jsh cbuat ~ -->CT F.ENQUIRY.SELECT IMAGE.VIEW_MM0010120_KHINEMONKYAW_1472017362892_

IMAGE.VIEW_MM0010120_KHINEMONKYAW_1472017362892_
001 IMAGE.REFERENCE]EQ].005360010001865]

jsh cbuat ~ -->CT F.ENQUIRY.SELECT CB.STMT.ENT.BOOK_MM0010010_AYENYEINTHU_1472119755466_
CB.STMT.ENT.BOOK_MM0010010_AYENYEINTHU_1472119755466_
001 ACCOUNT]EQ]MMK1404600010010.]
002 BOOKING.DATE]EQ]20160825]

jsh cbuat ~ -->CT F.ENQUIRY.SELECT CB.ACCOUNT.AMEND_MM0012017_MIKYALLAR_Enquiry311075637304_
CB.ACCOUNT.AMEND_MM0012017_MIKYALLAR_Enquiry311075637304_
001 @ID]EQ]2017600500022818.]
**************************************************************************************************************************************************************
2)F.DE.I.HISTORY:
**********************
A10007 record data error, record contains invalid characters
bad record R20150526262995355601, char 0D at offset 84
jsh cbuat ~ -->
R20150526262995355601
001 {1:F01CPOBMMMYAXXX1029049756}{2:O1031033150526COBADEFFBXXX4011968866150526
1503N}{4:..:20:FAAN514604062000..:23B:CRED..:32A:150526EUR6207,51..:33B:EU
R6207,51..:50K:/FR7630588620190148483010751..AGENCE SPATIALE EUROPEENNE..8
RUE MARIO NIKIS..75015 PARIS..:52A:BARCFRPP..:59:/0010101200339091..AUNG
KYI AYE..NO. 508, MYA KHWAR NYO CONDO..THARKAYTA TOWNSHIP, THARKAYTA..YANG
ON..:70:PENSION MAY 2015 EUROPEAN SPACE AGE..NCY..:71A:OUR..:72:/ACC/CO-OP
ERATIVE BANK LTD..//HO BRANCH..//LATHA TOWNSHIP..//YANGON..-}{5:{CHK:B8C22
0609C91}}{S:{SAC:}{COP:S}.
************************************************************************************************************************************************************
3)F.DE.I.MSG
A10012 record data error, record contains invalid characters
bad record R20131007265004700803, char 0D at offset 21

jsh cbuat ~ -->CT F.DE.I.MSG R20131007265004700803
R20131007265004700803
001 :20:ST20131005000039..:25:3800021054240..:28C:00279/00001..:60F:C131005USD
48817,98..:62F:C131005USD48817,98..:64:C131005USD48817,98..-}{5:{CHK:DD3F7
18F39BD}{DLM:}}{S:{COP:S}.

Any one having idea about above Errors how to solve...kindly reply.

Thanks in Advance.

Regards,
Rajasekar
This email address is being protected from spambots. You need JavaScript enabled to view it..

Hi

bad record IMAGE.VIEW_MM0010120_KHINEMONKYAW_1472017362892_, char 09 at offset 20
...
IMAGE.VIEW_MM0010120_KHINEMONKYAW_1472017362892_
001 IMAGE.REFERENCE]EQ].005360010001865]

I suppose there's a Tab character (ASCII 9) after "]EQ]" which is represented by a dot in the output.
Open this record in JED, then issue HEX command to see if this is the fact. You can then correct these records manually (if there's not much) or via a program.

Actually, you probably don't need the contents of this file - users selection on enquiries is recorded there, including many trash records.

As for F.DE.I.HISTORY and F.DE.I.MSG, 0D is part of end-of-line sequence for Windows (0D0A); which system are you under?

Hi
You mean that all agents go to sleep after some time but conversion isn't over?

Hi VK,

after starting the RDBMS conversion all the agents are going to sleep, but conversion is not completed, still many files to be convert example around 64 bigfiles like STMT,FT,TELLER,ACCOUNT, STMT.PRINTED,ARC files yet to be convert.

Please share u have any Runbook or documents related to RDBMS conversion. it my helpful.

Thanks & Regards
Rajasekar
This email address is being protected from spambots. You need JavaScript enabled to view it.

Hi
No I don't have any documents; the only guess is that "multi-threading" conversion either doesn't work (or requires some initiation step that we're not aware of...)

Is a single-threaded conversion an option for you?