× Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…

Re: HELP for DM TOOL and DATA Migration

  • madhump
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 49
  • Thank you received: 4

madhump created the topic: 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




#4451

Please Log in or Create an account to join the conversation.

  • Posts: 42
  • Thank you received: 3

Barua.Barua replied the topic: Re: HELP for DM TOOL and DATA Migration

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

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0

Pradeep_venkat replied the topic: Re: HELP for DM TOOL and DATA Migration

@madhu

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

Please Log in or Create an account to join the conversation.

  • Posts: 14
  • Thank you received: 3

sri replied the topic: Re: HELP for DM TOOL and DATA Migration

Dear Madhu,

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

Regards,

Srinivas Yadav.
#5791

Please Log in or Create an account to join the conversation.

  • Posts: 128
  • Karma: 3
  • Thank you received: 10

shanthi replied the topic: Re: HELP for DM TOOL and DATA Migration

Madhu,

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

Please check.

Shanthi
#5796

Please Log in or Create an account to join the conversation.

  • Posts: 266
  • Karma: -5
  • Thank you received: 12

AMMAR.FAIDI replied the topic: Re: HELP for DM TOOL and DATA Migration

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

Please Log in or Create an account to join the conversation.

  • Posts: 7
  • Thank you received: 0

edzkyz19 replied the topic: Re: HELP for DM TOOL and DATA Migration

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

Thanks
#22104

Please Log in or Create an account to join the conversation.

Time to create page: 0.242 seconds