× 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
More
14 years 4 months ago #4451 by madhump
HELP for DM TOOL and DATA Migration was created by madhump
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




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

More
13 years 7 months ago #5764 by Barua.Barua
Replied by Barua.Barua on 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.

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

More
13 years 7 months ago #5785 by Pradeep_venkat
Replied by Pradeep_venkat on 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????

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

More
13 years 7 months ago #5791 by sri
Replied by sri on 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.

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

More
13 years 7 months ago #5796 by shanthi
Replied by shanthi on 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

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

More
13 years 5 months ago #6262 by AMMAR.FAIDI
Replied by AMMAR.FAIDI on 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

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

More
5 years 2 months ago #22104 by edzkyz19
Replied by edzkyz19 on topic Re: HELP for DM TOOL and DATA Migration
what is best tool to use is it data migration tool? or DFE tool.

Thanks

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

More
4 years 11 months ago #22156 by zaki_hyder
Replied by zaki_hyder on topic Re: HELP for DM TOOL and DATA Migration
DM tool

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

Time to create page: 0.080 seconds