Re: HELP for DM TOOL and DATA Migration

Hello,
All,

I 'm trying to upload the Data from .csv file into a FT,TEST named Application .. for this i'm using DM TOOL application
and in DM.MAPPING.DEFINITION .. i have defined the Fields like this


DM.RECORD.ID...... TEST

---

1. 1 GB DESCRIPTION. TEST
2 APPLICATION.NAME.. FUNDS.TRANSFER FUNDS.TRANSFER
3 LOAD.TYPE......... OFS.LOAD Upload data via OFS
4 OFS.ACTION........ PROCESS
5 OFS.FUNCTION...... I
7 OFS.VERSION....... FUNDS.TRANSFER,TEST2
8 IN.DATA.DEF....... DELIM
9 FM.DELIM.......... ,
10 VM.DELIM.......... ;;
11 SM.DELIM.......... ##
14 ID.TYPE........... AUTO
18. 1 APPL.FIELD.NAME TRANSACTION.TYPE
19. 1 FIELD.POSITION. 1
18. 2 APPL.FIELD.NAME DEBIT.ACCT.NO
19. 2 FIELD.POSITION. 2
18. 3 APPL.FIELD.NAME DEBIT.CURRENCY
19. 3 FIELD.POSITION. 3
18. 4 APPL.FIELD.NAME DEBIT.AMOUNT
19. 4 FIELD.POSITION. 4
18. 5 APPL.FIELD.NAME DEBIT.THEIR.REF
19. 5 FIELD.POSITION. 5
18. 6 APPL.FIELD.NAME CREDIT.THEIR.REF
19. 6 FIELD.POSITION. 6
18. 7 APPL.FIELD.NAME PAYMENT.DETAILS
19. 7 FIELD.POSITION. 7
18. 8 APPL.FIELD.NAME CREDIT.ACCT.NO
19. 8 FIELD.POSITION. 8
18. 9 APPL.FIELD.NAME CREDIT.CURRENCY
19. 9 FIELD.POSITION. 9
18.10 APPL.FIELD.NAME ORDERING.BANK
19.10 FIELD.POSITION. 10
24 OFS.SOURCE........ DM.OFS.SRC
=========================================================================================

AND for DM.SERVICE.CONTROL as follows

Table............. TEST TEST

---

1 UPLOAD.COMPANY.... GB0010001 R8 MODEL BANK
2 FLAT.FI DATA.BP
3 FLAT.FI FT.csv
6 NO.OF.SESSIONS.... 1
9 RUN.STATUS........ START
12. 1 CONTROL.LOG.... Marking START the TSA.SERVICE DM.SERVICE-TEST At 15:36:35 02 FEB 2010
18. 1 DATE.TIME...... 02 FEB 10 15:35
19 AUTHORISER........ 2_MADHU2
20 CO.CODE........... GB-001-0001 R8 MODEL BANK
===========================================================================================



so when i try run a tSA service i'm getting following message ..
========================================================================================
Running on server compaq PortNumber 2
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:17_Standard multi-thread job
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:17_Calling load routine
Opening Sequential file TEST#LOG.3
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:17_Updating the Locking with DM.SERVICE-TEST-DM.SERVICE-2 and F.JOB.LIST.4
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:17_Session not doing SELECT PROCESS processing 1 1
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:17_Processing...1 Offset...0 Number of sessions...4
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:17_Job nearing completion .... Trying to run another job
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:19_Standard multi-thread job
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:19_Calling load routine
Opening Sequential file TEST#LOG.3
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:19_Updating the Locking with DM.SERVICE-TEST-DM.SERVICE-2 and F.JOB.LIST.4
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:19_Session not doing SELECT PROCESS processing 1 1
_DM.SERVICE-TEST_DM.SERVICE_3_02 FEB 2010_18:57:19_Processing...1 Offset...0 Number of sessions...4

========================================================================================
and also no data is writing for FT,TEST application and also in OFS.REQUEST.DETAIL also..
Please any one help me out in this Issue


Thanks in Advance
MADHU

---

Is the MAINT.MSG.DETS in the OFS.SOURCE > DM.OFS.SRC set to Y.This turns on the OFS logging in ORD.

@madhu

how many records are there in ur flat file for uploading it to the FT record????

Dear Madhu,

y dont u go for TakeOver Mapping concept and EBS.AUTO.FUNCTION.

Regards,

Srinivas Yadav.

Madhu,

I think you are having challenges because the Pre Process has not run.

Please check.

Shanthi

in the same folder of the input file you'll find a file of the errors you can check it
B.R

what is best tool to use is it data migration tool? or DFE tool.

Thanks

DM tool