T24 - DM TOOL . ERROR -

731 views
Skip to first unread message

madhu

unread,
Feb 2, 2010, 8:52:07 AM2/2/10
to jBASE
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



------------------------------------------------------------------------------

Lakshmi

unread,
Mar 26, 2010, 2:00:17 AM3/26/10
to jBASE
Are u logging in the errors in an log file?
May be the file format wouldn't have been as per the mapping
definition.

On Feb 2, 6:52 pm, madhu <madhumuru...@gmail.com> wrote:
> 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
>

> ---------------------------------------------------------------------------­---

> ===========================================================================­==============


>
> 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 ..

> ===========================================================================­=============

> ===========================================================================­=============


> 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
>

> ---------------------------------------------------------------------------­---

Subrata Saha

unread,
Mar 26, 2010, 11:05:33 AM3/26/10
to jb...@googlegroups.com
Hi,

Check your OFS error log  file TEST#LOG.3 in DATA.BP. You can paste the file here also.

thanks,

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

To unsubscribe from this group, send email to jbase+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.

hareendra seneviratne

unread,
Mar 30, 2010, 2:36:27 AM3/30/10
to jb...@googlegroups.com
First u should check the TEST#LOG.3 as Subrata Saha suggests.
 
Then try this
 
In order to the contracts to be uploaded as authorized, the field NO.OF.AUTH of your version FUNDS.TRANSFER,TEST2 sholud be set as 0. ie : The version should be in zero level authorization. Otherwise the contracts will be uploaded in INAU status.
Reply all
Reply to author
Forward
0 new messages