Data Migration issue

Dear All,

I got an error while migrating from csv file to t24. I am trying to upload data for opening account.
Data format for uploading csv file:

File . , Record 'SADV.csv' Insert 15:14:01
Command->
0001 28124041301000A,100514,NPR,3309
0002 28124041301010A,100524,NPR,3309
0003 28124020001032A,100447,NPR,3309
0004 28124020001007A,100422,NPR,3309

---

End Of Record

---

After starting DSC applicaiton and TSM agent I got a following error message:

jsh adbuat6 ~ -->tSA 2
tSA 2
<como>
<agent>2</agent>
<processid>7864554</processid>
<portno>1002</portno>
Agent 2 started 12 OCT 11 14-44-35
Agent's Process id 7864554
<servername>DRTEST</servername>
Running on server DRTEST PortNumber 1002
<service name = DM.SERVICE-STFADVAC.ADBL>
<process name = DM.SERVICE-STFADVAC.ADBL>
<job name = DM.SERVICE.PRE.PROCESS>
_DM.SERVICE-STFADVAC.ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Single Thread routine DM.SERVICE.PRE.PROCESS
_DM.SERVICE-STFADVAC.ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Starting job
_DM.SERVICE-STFADVAC.ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Allocating List File for DM.SERVICE-STFADVAC.ADBL-DM.0INPUTE.PRE.PROCESS-1
0 FD Base Account Opening_DM.SERVICE-ST0NPR 0ADBL_DM.SERVICE_2_12 OCT 2011_14:4** Error [ UTF8_CONVERSION_FAILED ] A UTF-8 codepage conversion error has occurred.4
Source IN2, Line 167DBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Using liPress Q to quitIST.4
An internal error - "UTF8_CONVERSION_FAILED" occured. OCT 2011_14:44:35_Control Trap from an error message, error message name = (UNKNOWN)
Line 168 , Source IN2ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_SELECT FjBASE debugger->


What kind of error is this?

Thank you in advance.

Suresh

Hi pokharel,

Please check the feed (Data) which you are trying to load. and also clear the temporary files before uploading the data and try.

SELECT F.DM.SERVICE.DATA.FILE
DELETE F.DM.SERVICE.DATA.FILE

SELECT F.JOB.LIST.2
DELETE F.JOB.LIST.2

SELECT F.JOB.LIST.3
DELETE F.JOB.LIST.3

Close the sessions and try in new sessions.


Regards
Madhu

pokharel wrote: wrote:

Dear All,

I got an error while migrating from csv file to t24. I am trying to upload data for opening account.
Data format for uploading csv file:

File . , Record 'SADV.csv' Insert 15:14:01
Command->
0001 28124041301000A,100514,NPR,3309
0002 28124041301010A,100524,NPR,3309
0003 28124020001032A,100447,NPR,3309
0004 28124020001007A,100422,NPR,3309

---

End Of Record

---

After starting DSC applicaiton and TSM agent I got a following error message:

jsh adbuat6 ~ -->tSA 2
tSA 2
<como>
<agent>2</agent>
<processid>7864554</processid>
<portno>1002</portno>
Agent 2 started 12 OCT 11 14-44-35
Agent's Process id 7864554
<servername>DRTEST</servername>
Running on server DRTEST PortNumber 1002
<service name = DM.SERVICE-STFADVAC.ADBL>
<process name = DM.SERVICE-STFADVAC.ADBL>
<job name = DM.SERVICE.PRE.PROCESS>
_DM.SERVICE-STFADVAC.ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Single Thread routine DM.SERVICE.PRE.PROCESS
_DM.SERVICE-STFADVAC.ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Starting job
_DM.SERVICE-STFADVAC.ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Allocating List File for DM.SERVICE-STFADVAC.ADBL-DM.0INPUTE.PRE.PROCESS-1
0 FD Base Account Opening_DM.SERVICE-ST0NPR 0ADBL_DM.SERVICE_2_12 OCT 2011_14:4** Error [ UTF8_CONVERSION_FAILED ] A UTF-8 codepage conversion error has occurred.4
Source IN2, Line 167DBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_Using liPress Q to quitIST.4
An internal error - "UTF8_CONVERSION_FAILED" occured. OCT 2011_14:44:35_Control Trap from an error message, error message name = (UNKNOWN)
Line 168 , Source IN2ADBL_DM.SERVICE.PRE.PROCESS_2_12 OCT 2011_14:44:35_SELECT FjBASE debugger->


What kind of error is this?

Thank you in advance.

Suresh

Thank you madhump :)