×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
T24 ARCHIVING
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20305
by ahmarabrar
T24 ARCHIVING was created by ahmarabrar
I am trying to use ARCHIVE application, for FUNDS.TRANSFER$HIS. where my selection field is processing date and setup is done as per temenos documents. my purge date is 20140401 and i have data in $his which is older than this.
but none of my record moved to $arc.
As per below screen system has selected the records from $his. further i have checked the como as well but couldn't found any error.
jsh R14MB ~ -->LIST-ITEM F.ARC.RECORDS.SEL
FUNDS.TRANSFER-4314-GB0010001
001 656
002 0
but none of my record moved to $arc.
As per below screen system has selected the records from $his. further i have checked the como as well but couldn't found any error.
jsh R14MB ~ -->LIST-ITEM F.ARC.RECORDS.SEL
FUNDS.TRANSFER-4314-GB0010001
001 656
002 0
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago #20306
by jpb
Replied by jpb on topic T24 ARCHIVING
Can you post your F.ARCHIVE record and corresponding Fxxx.ARC.RECORDS.SELECT ?
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20308
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
Thanks for your reply.
ARCHIVE.ID........ FUNDS.TRANSFER
1. 1. 1 GB DESCRIPTN Archives the FUDNS.TRANSFER$HIS
1. 2. 1 GB DESCRIPTN file. Only contracts which are no
1. 3. 1 GB DESCRIPTN longer on the live file are
1. 4. 1 GB DESCRIPTN archived.
3 RETENTION.PERIOD.. 02M
4 ARCHIVE.DATA...... Y
6. 1 ARC.FILENAME... FUNDS.TRANSFER$ARC
9 STOP.INDICATOR.... NO
10 CHECK.NO.OF.RECS.. 1000
11 ROUTINE........... ARC.GENERIC
12. 1 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 1 TIME.STARTED... 30 SEP 16 12:59
14. 1 USER.ID........ 31966_INPUTTER
15. 1 DATE.SELECTED.. 01 JUN 2015
17. 1 RECS.DELETED... 0
18. 1 RECS.PROCESSED. 2366
20. 1 TIME.ENDED..... 30 SEP 16 12:59
12. 2 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 2 TIME.STARTED... 30 SEP 16 12:59
14. 2 USER.ID........ 31406_INPUTTER
15. 2 DATE.SELECTED.. 01 JUN 2015
17. 2 RECS.DELETED... 0
18. 2 RECS.PROCESSED. 1183
20. 2 TIME.ENDED..... 30 SEP 16 12:59
12. 3 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 3 TIME.STARTED... 28 SEP 16 11:32
14. 3 USER.ID........ 1439_INPUTTER
15. 3 DATE.SELECTED.. 01 MAY 2015
17. 3 RECS.DELETED... 0
18. 3 RECS.PROCESSED. 1090
20. 3 TIME.ENDED..... 28 SEP 16 11:32
12. 4 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 4 TIME.STARTED... 28 SEP 16 11:16
14. 4 USER.ID........ 27750_INPUTTER
15. 4 DATE.SELECTED.. 01 MAY 2015
17. 4 RECS.DELETED... 0
18. 4 RECS.PROCESSED. 1090
20. 4 TIME.ENDED..... 28 SEP 16 11:16
12. 5 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 5 TIME.STARTED... 28 SEP 16 11:08
14. 5 USER.ID........ 30728_INPUTTER
15. 5 DATE.SELECTED.. 01 MAY 2015
17. 5 RECS.DELETED... 0
18. 5 RECS.PROCESSED. 1090
20. 5 TIME.ENDED..... 28 SEP 16 11:08
21 FIELD.TO.CHECK.... PROCESSING.DATE
23 GENERIC.METHOD.... Y
24. 1 MAIN.FILE...... FUNDS.TRANSFER$HIS
33 CURR.NO........... 7
34. 1 INPUTTER....... 102_SEAT.USER
35. 1 DATE.TIME...... 30 SEP 16 12:57
36 AUTHORISER........ 5813_INPUTTER
37 CO.CODE........... US-001-0001
LIST FBNK.ARC.RECORDS.SELECT PAGE 1 14:56:09 30 SEP 2016
@ID.......
No Records Listed
jsh R15MB ~ -->
ARCHIVE.ID........ FUNDS.TRANSFER
1. 1. 1 GB DESCRIPTN Archives the FUDNS.TRANSFER$HIS
1. 2. 1 GB DESCRIPTN file. Only contracts which are no
1. 3. 1 GB DESCRIPTN longer on the live file are
1. 4. 1 GB DESCRIPTN archived.
3 RETENTION.PERIOD.. 02M
4 ARCHIVE.DATA...... Y
6. 1 ARC.FILENAME... FUNDS.TRANSFER$ARC
9 STOP.INDICATOR.... NO
10 CHECK.NO.OF.RECS.. 1000
11 ROUTINE........... ARC.GENERIC
12. 1 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 1 TIME.STARTED... 30 SEP 16 12:59
14. 1 USER.ID........ 31966_INPUTTER
15. 1 DATE.SELECTED.. 01 JUN 2015
17. 1 RECS.DELETED... 0
18. 1 RECS.PROCESSED. 2366
20. 1 TIME.ENDED..... 30 SEP 16 12:59
12. 2 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 2 TIME.STARTED... 30 SEP 16 12:59
14. 2 USER.ID........ 31406_INPUTTER
15. 2 DATE.SELECTED.. 01 JUN 2015
17. 2 RECS.DELETED... 0
18. 2 RECS.PROCESSED. 1183
20. 2 TIME.ENDED..... 30 SEP 16 12:59
12. 3 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 3 TIME.STARTED... 28 SEP 16 11:32
14. 3 USER.ID........ 1439_INPUTTER
15. 3 DATE.SELECTED.. 01 MAY 2015
17. 3 RECS.DELETED... 0
18. 3 RECS.PROCESSED. 1090
20. 3 TIME.ENDED..... 28 SEP 16 11:32
12. 4 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 4 TIME.STARTED... 28 SEP 16 11:16
14. 4 USER.ID........ 27750_INPUTTER
15. 4 DATE.SELECTED.. 01 MAY 2015
17. 4 RECS.DELETED... 0
18. 4 RECS.PROCESSED. 1090
20. 4 TIME.ENDED..... 28 SEP 16 11:16
12. 5 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 5 TIME.STARTED... 28 SEP 16 11:08
14. 5 USER.ID........ 30728_INPUTTER
15. 5 DATE.SELECTED.. 01 MAY 2015
17. 5 RECS.DELETED... 0
18. 5 RECS.PROCESSED. 1090
20. 5 TIME.ENDED..... 28 SEP 16 11:08
21 FIELD.TO.CHECK.... PROCESSING.DATE
23 GENERIC.METHOD.... Y
24. 1 MAIN.FILE...... FUNDS.TRANSFER$HIS
33 CURR.NO........... 7
34. 1 INPUTTER....... 102_SEAT.USER
35. 1 DATE.TIME...... 30 SEP 16 12:57
36 AUTHORISER........ 5813_INPUTTER
37 CO.CODE........... US-001-0001
LIST FBNK.ARC.RECORDS.SELECT PAGE 1 14:56:09 30 SEP 2016
@ID.......
No Records Listed
jsh R15MB ~ -->
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago #20311
by jpb
Replied by jpb on topic T24 ARCHIVING
The only obvious thing is that the routine ARCHIVE.FT.FILTER is not attached as FILTER.RTN (this will compare PROCESSING.DATE and DEBIT.VALUE.DATE and CREDIT.VALUE.DATE against the DATE.SELECTED).
As you have so few records being selected (max. 2366) - are you sure there are records to be archived ?
Meaning PROCESS.DATE before the DATE.SELECTED and not in LIVE file ?
Have you tried with setting explicit PURGE.DATE ?
As you have so few records being selected (max. 2366) - are you sure there are records to be archived ?
Meaning PROCESS.DATE before the DATE.SELECTED and not in LIVE file ?
Have you tried with setting explicit PURGE.DATE ?
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20315
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
I tried with that routine too, but result was same. actually i am doing this over a model banking environment as test so same can be done at client side as well. i will share the result with you after including the said routine.
for ft and tt and for account i have already developed multi-thread routines which are working properly. but still i am interested to use core module as i need to archive stmt and categ also.
for ft and tt and for account i have already developed multi-thread routines which are working properly. but still i am interested to use core module as i need to archive stmt and categ also.
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20316
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
I have also tested purge date but result is same
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago #20317
by jpb
Replied by jpb on topic T24 ARCHIVING
But for stmt and categ its not FUNDS.TRANSFER to be used, its STATEMENTS if I remember correct (currently no access to system . . .)
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20318
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
Yes I know there are different records for STMT and Categ, For just now I am trying FT, my records in history are more than 7 months but still not going through, any idea.?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago #20323
by jpb
Replied by jpb on topic T24 ARCHIVING
The selection is first based on the $HIS record with CURR.NO = 1, if there is no record with ;1 in the FUNDS.TRANSFER$HIS it will never be archived.
Second check is if there is a record with the same @ID in the live file, if it exists the records are not archived.
Third check is of the PROCESSING.DATE of the last history record (with highest CURR.NO) against the PURGE.DATE (either direct input or calculated from period).
I don't think you have DL installed (writing to $ARC in a different database), have you?
Second check is if there is a record with the same @ID in the live file, if it exists the records are not archived.
Third check is of the PROCESSING.DATE of the last history record (with highest CURR.NO) against the PURGE.DATE (either direct input or calculated from period).
I don't think you have DL installed (writing to $ARC in a different database), have you?
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20338
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
dear Jpb kindly find below records from como, archive and history records of como
let me know if i am doing anything wrong
LIST F.DATES TODAY PAGE 1 18:02:07 03 OCT 2016
@ID............ TODAY......
GB0010005 20150930
&COMO&
===========
jsh R15MB ~ -->tSA 10
tSA 10
<como>
<agent>10</agent>
<processid>20512</processid>
<portno>48</portno>
Agent 10 started 03 OCT 16 17-55-55
Agent's Process id 20512
<servername>NDCTECH-112</servername>
Running on server NDCTECH-112 PortNumber 48
<service name = BNK/ARC.GENERIC>
<process name = BNK/ARC.GENERIC>
<job name = ARC.GENERIC>
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:496_Standard multi-thread job
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:496_Calling load routine
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:625_Obtained the Locking with BNK/ARC.GENERIC-ARC.GENERIC-1 and F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:628_Using list file F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:628_Control list STATEMENT**16656_INPUTTER**ARCHIVE.FREQ1-STATEMENT
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:655_Fatal error in OPF error MISSING FILE - FBNK.ACCT.STMT.PRINT$RO , MNEMONIC = BNK , IN.PARAMETER = F.ACCT.STMT.PRINT$RO , COMPANY = GB0010001 , CALL.ROUTINE = OPF,I_IO.ROUTINES,F.READ contract:USD1430600050001
</job>
</process>
</service>
</como>
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:664_SELECT F.RECORD.LOCK WITH K.USER EQ "" Selected=0 time=0secs
SOME SAMPLE HISTORY RECORDS.
==================================
LIST FBNK.FUNDS.TRANSFER$HIS PROCESSING.DATE CURR.NO SAMPLE 10 PAGE 1 17:58:44 03 OCT 2016
@ID...................... PROCESSING.DATE CURR.NO
FT150838302S;1 20150324 1
FT15093FD0P2;1 20150403 1
FT15104QXHTD;1 20150414 1
FT15112LF732;1 20150422 1
FT15089GRGKH;1 20150330 1
FT15231Q16BV;1 20150819 1
FT15093BML3J;1 20150403 1
FT15201903BK;1 20150720 1
FT15231PPSRT;1 20150819 1
FT15083M5SSN;1 20150324 1
10 Records Listed
jsh R15MB ~ -->
archive record for funds.transfer FILTER routine is included.
Model Bank R15-AMR Archiving SEE
ARCHIVE.ID........ FUNDS.TRANSFER
1. 1. 1 GB DESCRIPTN Archives the FUDNS.TRANSFER$HIS
1. 2. 1 GB DESCRIPTN file. Only contracts which are no
1. 3. 1 GB DESCRIPTN longer on the live file are
1. 4. 1 GB DESCRIPTN archived.
3 RETENTION.PERIOD.. 02M
4 ARCHIVE.DATA...... Y
6. 1 ARC.FILENAME... FUNDS.TRANSFER$ARC
9 STOP.INDICATOR.... NO
10 CHECK.NO.OF.RECS.. 1000
11 ROUTINE........... ARC.GENERIC
12. 1 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 1 TIME.STARTED... 30 SEP 16 12:59
14. 1 USER.ID........ 31966_INPUTTER
15. 1 DATE.SELECTED.. 01 JUN 2015
17. 1 RECS.DELETED... 0
18. 1 RECS.PROCESSED. 2366
20. 1 TIME.ENDED..... 30 SEP 16 12:59
12. 2 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 2 TIME.STARTED... 30 SEP 16 12:59
14. 2 USER.ID........ 31406_INPUTTER
15. 2 DATE.SELECTED.. 01 JUN 2015
17. 2 RECS.DELETED... 0
18. 2 RECS.PROCESSED. 1183
20. 2 TIME.ENDED..... 30 SEP 16 12:59
12. 3 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 3 TIME.STARTED... 28 SEP 16 11:32
14. 3 USER.ID........ 1439_INPUTTER
15. 3 DATE.SELECTED.. 01 MAY 2015
17. 3 RECS.DELETED... 0
18. 3 RECS.PROCESSED. 1090
20. 3 TIME.ENDED..... 28 SEP 16 11:32
12. 4 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 4 TIME.STARTED... 28 SEP 16 11:16
14. 4 USER.ID........ 27750_INPUTTER
15. 4 DATE.SELECTED.. 01 MAY 2015
17. 4 RECS.DELETED... 0
18. 4 RECS.PROCESSED. 1090
20. 4 TIME.ENDED..... 28 SEP 16 11:16
12. 5 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 5 TIME.STARTED... 28 SEP 16 11:08
14. 5 USER.ID........ 30728_INPUTTER
15. 5 DATE.SELECTED.. 01 MAY 2015
17. 5 RECS.DELETED... 0
18. 5 RECS.PROCESSED. 1090
20. 5 TIME.ENDED..... 28 SEP 16 11:08
21 FIELD.TO.CHECK.... PROCESSING.DATE
23 GENERIC.METHOD.... Y
24. 1 MAIN.FILE...... FUNDS.TRANSFER$HIS
25 FILTER.RTN........ ARCHIVE.FT.FILTER
33 CURR.NO........... 7
34. 1 INPUTTER....... 102_SEAT.USER
35. 1 DATE.TIME...... 03 OCT 16 17:55
36 AUTHORISER........ 16508_INPUTTER
37 CO.CODE........... US-001-0001
let me know if i am doing anything wrong
LIST F.DATES TODAY PAGE 1 18:02:07 03 OCT 2016
@ID............ TODAY......
GB0010005 20150930
&COMO&
===========
jsh R15MB ~ -->tSA 10
tSA 10
<como>
<agent>10</agent>
<processid>20512</processid>
<portno>48</portno>
Agent 10 started 03 OCT 16 17-55-55
Agent's Process id 20512
<servername>NDCTECH-112</servername>
Running on server NDCTECH-112 PortNumber 48
<service name = BNK/ARC.GENERIC>
<process name = BNK/ARC.GENERIC>
<job name = ARC.GENERIC>
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:496_Standard multi-thread job
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:496_Calling load routine
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:625_Obtained the Locking with BNK/ARC.GENERIC-ARC.GENERIC-1 and F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:628_Using list file F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:628_Control list STATEMENT**16656_INPUTTER**ARCHIVE.FREQ1-STATEMENT
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:655_Fatal error in OPF error MISSING FILE - FBNK.ACCT.STMT.PRINT$RO , MNEMONIC = BNK , IN.PARAMETER = F.ACCT.STMT.PRINT$RO , COMPANY = GB0010001 , CALL.ROUTINE = OPF,I_IO.ROUTINES,F.READ contract:USD1430600050001
</job>
</process>
</service>
</como>
_BNK/ARC.GENERIC_ARC.GENERIC_10_03 OCT 2016_17:55:55:664_SELECT F.RECORD.LOCK WITH K.USER EQ "" Selected=0 time=0secs
SOME SAMPLE HISTORY RECORDS.
==================================
LIST FBNK.FUNDS.TRANSFER$HIS PROCESSING.DATE CURR.NO SAMPLE 10 PAGE 1 17:58:44 03 OCT 2016
@ID...................... PROCESSING.DATE CURR.NO
FT150838302S;1 20150324 1
FT15093FD0P2;1 20150403 1
FT15104QXHTD;1 20150414 1
FT15112LF732;1 20150422 1
FT15089GRGKH;1 20150330 1
FT15231Q16BV;1 20150819 1
FT15093BML3J;1 20150403 1
FT15201903BK;1 20150720 1
FT15231PPSRT;1 20150819 1
FT15083M5SSN;1 20150324 1
10 Records Listed
jsh R15MB ~ -->
archive record for funds.transfer FILTER routine is included.
Model Bank R15-AMR Archiving SEE
ARCHIVE.ID........ FUNDS.TRANSFER
1. 1. 1 GB DESCRIPTN Archives the FUDNS.TRANSFER$HIS
1. 2. 1 GB DESCRIPTN file. Only contracts which are no
1. 3. 1 GB DESCRIPTN longer on the live file are
1. 4. 1 GB DESCRIPTN archived.
3 RETENTION.PERIOD.. 02M
4 ARCHIVE.DATA...... Y
6. 1 ARC.FILENAME... FUNDS.TRANSFER$ARC
9 STOP.INDICATOR.... NO
10 CHECK.NO.OF.RECS.. 1000
11 ROUTINE........... ARC.GENERIC
12. 1 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 1 TIME.STARTED... 30 SEP 16 12:59
14. 1 USER.ID........ 31966_INPUTTER
15. 1 DATE.SELECTED.. 01 JUN 2015
17. 1 RECS.DELETED... 0
18. 1 RECS.PROCESSED. 2366
20. 1 TIME.ENDED..... 30 SEP 16 12:59
12. 2 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 2 TIME.STARTED... 30 SEP 16 12:59
14. 2 USER.ID........ 31406_INPUTTER
15. 2 DATE.SELECTED.. 01 JUN 2015
17. 2 RECS.DELETED... 0
18. 2 RECS.PROCESSED. 1183
20. 2 TIME.ENDED..... 30 SEP 16 12:59
12. 3 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 3 TIME.STARTED... 28 SEP 16 11:32
14. 3 USER.ID........ 1439_INPUTTER
15. 3 DATE.SELECTED.. 01 MAY 2015
17. 3 RECS.DELETED... 0
18. 3 RECS.PROCESSED. 1090
20. 3 TIME.ENDED..... 28 SEP 16 11:32
12. 4 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 4 TIME.STARTED... 28 SEP 16 11:16
14. 4 USER.ID........ 27750_INPUTTER
15. 4 DATE.SELECTED.. 01 MAY 2015
17. 4 RECS.DELETED... 0
18. 4 RECS.PROCESSED. 1090
20. 4 TIME.ENDED..... 28 SEP 16 11:16
12. 5 COMPANY.RUN.IN. GB-001-0001 Model Bank R15-AMR
13. 5 TIME.STARTED... 28 SEP 16 11:08
14. 5 USER.ID........ 30728_INPUTTER
15. 5 DATE.SELECTED.. 01 MAY 2015
17. 5 RECS.DELETED... 0
18. 5 RECS.PROCESSED. 1090
20. 5 TIME.ENDED..... 28 SEP 16 11:08
21 FIELD.TO.CHECK.... PROCESSING.DATE
23 GENERIC.METHOD.... Y
24. 1 MAIN.FILE...... FUNDS.TRANSFER$HIS
25 FILTER.RTN........ ARCHIVE.FT.FILTER
33 CURR.NO........... 7
34. 1 INPUTTER....... 102_SEAT.USER
35. 1 DATE.TIME...... 03 OCT 16 17:55
36 AUTHORISER........ 16508_INPUTTER
37 CO.CODE........... US-001-0001
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago #20340
by jpb
Replied by jpb on topic T24 ARCHIVING
The COMO is from a run on STATEMENT, not from FUNDS.TRANSFER (what is defined in ARC.GENERIC.REQUEST to be run?).
The fatal error is from FBNK.ACCT.STMT.PRINT$RO what seem to point to DL /RO (as mentioned above) being installed - and I have no experience with that. I know that afer archiving there are other routines to be run . . .
The fatal error is from FBNK.ACCT.STMT.PRINT$RO what seem to point to DL /RO (as mentioned above) being installed - and I have no experience with that. I know that afer archiving there are other routines to be run . . .
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20354
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
Sorry that environment was crashed
i did same on other environment kindly find below information and will appreciate if you can suggest me what exactly wrong
COMO
tSA 15
<como>
<agent>15</agent>
<processid>7180</processid>
<portno>38</portno>
Agent 15 started 04 OCT 16 13-55-53
Agent's Process id 7180
<servername>NDCTECH-112</servername>
Running on server NDCTECH-112 PortNumber 38
<service name = BNK/ARC.GENERIC>
<process name = BNK/ARC.GENERIC>
<job name = ARC.GENERIC>
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:129_Standard multi-thread job
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:129_Calling load routine
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:354_Allocating List File for BNK/ARC.GENERIC-ARC.GENERIC-1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:373_Updating the Locking with BNK/ARC.GENERIC-ARC.GENERIC-1 and F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:472_Calling..ARC.GENERIC.SELECT
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:608_List starting from 0 keys processed so far 0
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:608_Building from driving file
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:864_Control list.. FUNDS.TRANSFER**4970_INPUTTER**FUNDS.TRANSFER$HIS
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:076_Using list file F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:076_Control list FUNDS.TRANSFER**4970_INPUTTER**FUNDS.TRANSFER$HIS
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:255_SELECT F.DW.EXPORT WITH TAKEOVER IN "INCREMENTAL" "ONLINE" Selected=0 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:260_SELECT F.DW.EXPORT.PARAM WITH @ID NE "SYSTEM" Selected=1 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:215_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=138 time=2secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:293_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=122 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:426_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=108 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:577_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=95 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:690_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=84 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:740_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=74 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:907_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=65 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:950_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=57 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:098_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=49 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:124_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=39 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:143_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=31 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:167_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=24 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:190_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=18 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:197_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=13 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:259_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=0 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:273_Calling..ARC.GENERIC.SELECT
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:274_List starting from 0 keys processed so far 0
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:274_Building from list passed
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:274_Control list.. FUNDS.TRANSFER**4970_INPUTTER**UPDATE.ARCHIVE
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:275_Using list file F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:275_Control list FUNDS.TRANSFER**4970_INPUTTER**UPDATE.ARCHIVE proc
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:356_SELECT F.ARC.RECORDS.SEL WITH @ID LIKE "...'GB0010001'" Selected=1 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:365_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=0 time=0secs
</job>
</process>
</service>
Agent stopped
</como>
___15_04 OCT 2016_13:55:58:424_SELECT F.RECORD.LOCK WITH K.USER EQ "" Selected=0 time=0secs
jsh R14MB ~ -->tSA 16
tSA 16
<como>
<agent>16</agent>
<processid>7180</processid>
<portno>38</portno>
Agent 16 started 04 OCT 16 13-56-09
Agent's Process id 7180
<servername>NDCTECH-112</servername>
Running on server NDCTECH-112 PortNumber 38
Agent stopped
</como>
LIST FBNK.FUNDS.TRANSFER$HIS PROCESSING.DATE CURR.NO SAMPLE 15 PAGE 1 13:58:02 04 OCT 2016
@ID...................... PROCESSING.DATE CURR.NO
FT14083709GF;1 20140324 1
FT14083TD35X;1 20140324 1
FT140831X0Y5;1 20140324 1
FT14083WQXRK;1 20140324 1
FT1408373PMD;1 20140324 1
FT1408333SPC;1 20140324 1
FT14087BH060;1 20140328 1
FT140838CW6N;1 20140324 1
FT14083432J9;1 20140324 1
FT14083HZVYJ;1 20140324 1
FT14083F2PBZ;1 20140324 1
FT140992F761;1 20140409 1
FT14083SZL6X;1 20140324 1
FT14083MQKWB;1 20140324 1
FT14112T3XY0;1 20140422 1
15 Records Listed
jsh R14MB ~ -->COUNT FBNK.FUNDS.TRANSFER$ARC
No Records counted
ARCHIVE.ID........ FUNDS.TRANSFER
1. 1. 1 GB DESCRIPTN Archives the FUDNS.TRANSFER$HIS
1. 2. 1 GB DESCRIPTN file. Only contracts which are no
1. 3. 1 GB DESCRIPTN longer on the live file are
1. 4. 1 GB DESCRIPTN archived.
2 PURGE.DATE........ 01 APR 2014
4 ARCHIVE.DATA...... Y
6. 1 ARC.FILENAME... FUNDS.TRANSFER$ARC
9 STOP.INDICATOR.... NO
10 CHECK.NO.OF.RECS.. 1000
11 ROUTINE........... ARC.GENERIC
12. 1 COMPANY.RUN.IN. GB-001-0001 Model Bank R14-AMR
13. 1 TIME.STARTED... 04 OCT 16 13:55
14. 1 USER.ID........ 4970_INPUTTER
15. 1 DATE.SELECTED.. 01 APR 2014
17. 1 RECS.DELETED... 0
18. 1 RECS.PROCESSED. 656
20. 1 TIME.ENDED..... 04 OCT 16 13:55
12. 2 COMPANY.RUN.IN. GB-001-0001 Model Bank R14-AMR
13. 2 TIME.STARTED... 30 SEP 16 10:41
14. 2 USER.ID........ 28222_INPUTTER
15. 2 DATE.SELECTED.. 01 APR 2014
17. 2 RECS.DELETED... 0
18. 2 RECS.PROCESSED. 656
20. 2 TIME.ENDED..... 30 SEP 16 10:41
21 FIELD.TO.CHECK.... PROCESSING.DATE
23 GENERIC.METHOD.... Y
24. 1 MAIN.FILE...... FUNDS.TRANSFER$HIS
25 FILTER.RTN........ ARCHIVE.FT.FILTER
33 CURR.NO........... 4
34. 1 INPUTTER....... 102_SEAT.USER
35. 1 DATE.TIME...... 04 OCT 16 13:50
36 AUTHORISER........ 29827_INPUTTER
37 CO.CODE........... US-001-0001
REF.NO............ SYSTEM
1. 1 ARCHIVE.ID..... FUNDS.TRANSFER ARC.GENERIC
5. 1 DATE.TIME...... 30 SEP 16 10:37
6 AUTHORISER........ 28222_INPUTTER
7 CO.CODE........... GB-001-0001 Model Bank R14-AMR
@ID............ TODAY......
GB0010005 20140424
GB0010003 20140424
SG0010001 20140424
GB0010001-COB 20140424
EU0010001 20140424
GB0010003-COB 20140424
GB0010001 20140424
GB0010005-COB 20140424
EU0010001-COB 20140424
GB0010002 20140424
GB0010002-COB 20140424
GB0010004 20140424
GB0010004-COB 20140424
SG0010001-COB 20140424
i did same on other environment kindly find below information and will appreciate if you can suggest me what exactly wrong
COMO
tSA 15
<como>
<agent>15</agent>
<processid>7180</processid>
<portno>38</portno>
Agent 15 started 04 OCT 16 13-55-53
Agent's Process id 7180
<servername>NDCTECH-112</servername>
Running on server NDCTECH-112 PortNumber 38
<service name = BNK/ARC.GENERIC>
<process name = BNK/ARC.GENERIC>
<job name = ARC.GENERIC>
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:129_Standard multi-thread job
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:129_Calling load routine
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:354_Allocating List File for BNK/ARC.GENERIC-ARC.GENERIC-1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:373_Updating the Locking with BNK/ARC.GENERIC-ARC.GENERIC-1 and F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:472_Calling..ARC.GENERIC.SELECT
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:608_List starting from 0 keys processed so far 0
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:608_Building from driving file
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:54:864_Control list.. FUNDS.TRANSFER**4970_INPUTTER**FUNDS.TRANSFER$HIS
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:076_Using list file F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:076_Control list FUNDS.TRANSFER**4970_INPUTTER**FUNDS.TRANSFER$HIS
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:255_SELECT F.DW.EXPORT WITH TAKEOVER IN "INCREMENTAL" "ONLINE" Selected=0 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:55:260_SELECT F.DW.EXPORT.PARAM WITH @ID NE "SYSTEM" Selected=1 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:215_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=138 time=2secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:293_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=122 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:426_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=108 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:577_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=95 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:690_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=84 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:740_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=74 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:907_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=65 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:57:950_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=57 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:098_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=49 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:124_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=39 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:143_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=31 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:167_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=24 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:190_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=18 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:197_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=13 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:259_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=0 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:273_Calling..ARC.GENERIC.SELECT
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:274_List starting from 0 keys processed so far 0
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:274_Building from list passed
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:274_Control list.. FUNDS.TRANSFER**4970_INPUTTER**UPDATE.ARCHIVE
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:275_Using list file F.JOB.LIST.1
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:275_Control list FUNDS.TRANSFER**4970_INPUTTER**UPDATE.ARCHIVE proc
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:356_SELECT F.ARC.RECORDS.SEL WITH @ID LIKE "...'GB0010001'" Selected=1 time=0secs
_BNK/ARC.GENERIC_ARC.GENERIC_15_04 OCT 2016_13:55:58:365_SELECT F.JOB.LIST.1 SAMPLE 100000 Selected=0 time=0secs
</job>
</process>
</service>
Agent stopped
</como>
___15_04 OCT 2016_13:55:58:424_SELECT F.RECORD.LOCK WITH K.USER EQ "" Selected=0 time=0secs
jsh R14MB ~ -->tSA 16
tSA 16
<como>
<agent>16</agent>
<processid>7180</processid>
<portno>38</portno>
Agent 16 started 04 OCT 16 13-56-09
Agent's Process id 7180
<servername>NDCTECH-112</servername>
Running on server NDCTECH-112 PortNumber 38
Agent stopped
</como>
LIST FBNK.FUNDS.TRANSFER$HIS PROCESSING.DATE CURR.NO SAMPLE 15 PAGE 1 13:58:02 04 OCT 2016
@ID...................... PROCESSING.DATE CURR.NO
FT14083709GF;1 20140324 1
FT14083TD35X;1 20140324 1
FT140831X0Y5;1 20140324 1
FT14083WQXRK;1 20140324 1
FT1408373PMD;1 20140324 1
FT1408333SPC;1 20140324 1
FT14087BH060;1 20140328 1
FT140838CW6N;1 20140324 1
FT14083432J9;1 20140324 1
FT14083HZVYJ;1 20140324 1
FT14083F2PBZ;1 20140324 1
FT140992F761;1 20140409 1
FT14083SZL6X;1 20140324 1
FT14083MQKWB;1 20140324 1
FT14112T3XY0;1 20140422 1
15 Records Listed
jsh R14MB ~ -->COUNT FBNK.FUNDS.TRANSFER$ARC
No Records counted
ARCHIVE.ID........ FUNDS.TRANSFER
1. 1. 1 GB DESCRIPTN Archives the FUDNS.TRANSFER$HIS
1. 2. 1 GB DESCRIPTN file. Only contracts which are no
1. 3. 1 GB DESCRIPTN longer on the live file are
1. 4. 1 GB DESCRIPTN archived.
2 PURGE.DATE........ 01 APR 2014
4 ARCHIVE.DATA...... Y
6. 1 ARC.FILENAME... FUNDS.TRANSFER$ARC
9 STOP.INDICATOR.... NO
10 CHECK.NO.OF.RECS.. 1000
11 ROUTINE........... ARC.GENERIC
12. 1 COMPANY.RUN.IN. GB-001-0001 Model Bank R14-AMR
13. 1 TIME.STARTED... 04 OCT 16 13:55
14. 1 USER.ID........ 4970_INPUTTER
15. 1 DATE.SELECTED.. 01 APR 2014
17. 1 RECS.DELETED... 0
18. 1 RECS.PROCESSED. 656
20. 1 TIME.ENDED..... 04 OCT 16 13:55
12. 2 COMPANY.RUN.IN. GB-001-0001 Model Bank R14-AMR
13. 2 TIME.STARTED... 30 SEP 16 10:41
14. 2 USER.ID........ 28222_INPUTTER
15. 2 DATE.SELECTED.. 01 APR 2014
17. 2 RECS.DELETED... 0
18. 2 RECS.PROCESSED. 656
20. 2 TIME.ENDED..... 30 SEP 16 10:41
21 FIELD.TO.CHECK.... PROCESSING.DATE
23 GENERIC.METHOD.... Y
24. 1 MAIN.FILE...... FUNDS.TRANSFER$HIS
25 FILTER.RTN........ ARCHIVE.FT.FILTER
33 CURR.NO........... 4
34. 1 INPUTTER....... 102_SEAT.USER
35. 1 DATE.TIME...... 04 OCT 16 13:50
36 AUTHORISER........ 29827_INPUTTER
37 CO.CODE........... US-001-0001
REF.NO............ SYSTEM
1. 1 ARCHIVE.ID..... FUNDS.TRANSFER ARC.GENERIC
5. 1 DATE.TIME...... 30 SEP 16 10:37
6 AUTHORISER........ 28222_INPUTTER
7 CO.CODE........... GB-001-0001 Model Bank R14-AMR
@ID............ TODAY......
GB0010005 20140424
GB0010003 20140424
SG0010001 20140424
GB0010001-COB 20140424
EU0010001 20140424
GB0010003-COB 20140424
GB0010001 20140424
GB0010005-COB 20140424
EU0010001-COB 20140424
GB0010002 20140424
GB0010002-COB 20140424
GB0010004 20140424
GB0010004-COB 20140424
SG0010001-COB 20140424
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago #20357
by jpb
Replied by jpb on topic T24 ARCHIVING
I have no idea, especially the selection on DW.EXPORT is irritating.
As I don't know DW I can't say if there are special checks related to this module.
As I don't know DW I can't say if there are special checks related to this module.
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20360
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
Dear,
Do you have any alternate way for STMT, Categ and Re consol entries, I have solution for FT TT and Accounts.
If possible for you to share any alternate way, kindly send it to me at This email address is being protected from spambots. You need JavaScript enabled to view it., This email address is being protected from spambots. You need JavaScript enabled to view it.
Best Regards,
Do you have any alternate way for STMT, Categ and Re consol entries, I have solution for FT TT and Accounts.
If possible for you to share any alternate way, kindly send it to me at This email address is being protected from spambots. You need JavaScript enabled to view it., This email address is being protected from spambots. You need JavaScript enabled to view it.
Best Regards,
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
8 years 9 months ago - 8 years 9 months ago #20361
by jpb
Replied by jpb on topic T24 ARCHIVING
I tried archiving in R14MB in the meantime and I'm not able to get it run, there is a Fatal Error on ARC.GENERIC.LOADthat I can't overcome - suppose it's related to DL (activated in R14MB and we don't use it) but I can't spent more time investigating.
But as DW is used in R14MB and in your test the SELECT F.DW.EXPORT.PARAM WITH @ID NE "SYSTEM" returns one record (normally there is only "SYSTEM") it's maybe worth looking into this and also make sure no DW services are running.
For an alternate solution than using generic (or core ARC... service) you have to write your own archive service that will take care of all files (related files, concats etc.) for the area you want to work on.
For STATEMENT, CATEG and SPECIAL there are core routines that work OK in our live environment, what's the problem on R14MB I can't guess.
<job name = ARC.GENERIC>
_BNK/ARC.GENERIC_ARC.GENERIC_5_05 OCT 2016_07:16:54:357_Standard multi-thread job
_BNK/ARC.GENERIC_ARC.GENERIC_5_05 OCT 2016_07:16:54:357_Calling load routine
_BNK/ARC.GENERIC_ARC.GENERIC_5_05 OCT 2016_07:16:54:378_Fatal error in ARC.GENERIC.LOAD error 1
</job>But as DW is used in R14MB and in your test the SELECT F.DW.EXPORT.PARAM WITH @ID NE "SYSTEM" returns one record (normally there is only "SYSTEM") it's maybe worth looking into this and also make sure no DW services are running.
For an alternate solution than using generic (or core ARC... service) you have to write your own archive service that will take care of all files (related files, concats etc.) for the area you want to work on.
For STATEMENT, CATEG and SPECIAL there are core routines that work OK in our live environment, what's the problem on R14MB I can't guess.
Last edit: 8 years 9 months ago by jpb.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1209
- Thank you received: 158
8 years 9 months ago #20363
by VK
Cheers
VK
Replied by VK on topic T24 ARCHIVING
Hi colleagues,
Model Bank usually contains "GA" release without further patches etc. I remember not being able even to run COB on some earlier MB...
As for archival, the main problem with it is that you need to create new ENQUIRY's to see the data in $ARC files; I really prefer the files distribution when files grow large. To improve SELECTs performance you always can SELECT a part file rather than the stub (if you distribute time-wise). Part files that reflect historic data can be stored outside bnk.data to save backup time as well.
Of course if we have jBASE hashed files not RDBMS :)
Model Bank usually contains "GA" release without further patches etc. I remember not being able even to run COB on some earlier MB...
As for archival, the main problem with it is that you need to create new ENQUIRY's to see the data in $ARC files; I really prefer the files distribution when files grow large. To improve SELECTs performance you always can SELECT a part file rather than the stub (if you distribute time-wise). Part files that reflect historic data can be stored outside bnk.data to save backup time as well.
Of course if we have jBASE hashed files not RDBMS :)
Cheers
VK
Please Log in or Create an account to join the conversation.
- ahmarabrar
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 11
- Thank you received: 0
8 years 9 months ago #20367
by ahmarabrar
Replied by ahmarabrar on topic T24 ARCHIVING
Thank VK for your valuable input, yes you are correct as the same i tried over other environment, it is working perfectly.
Thanks JPB for sharing your experience.
Regards,
Thanks JPB for sharing your experience.
Regards,
Please Log in or Create an account to join the conversation.
- AHAMED
- Visitor
-
7 years 5 months ago #21586
by AHAMED
Replied by AHAMED on topic T24 ARCHIVING
HI Friends,
I am unable to run the ARC.GENERIC service. I am getting the below error.
como>
agent>3</agent>
processid>19192</processid>
portno>468</portno>
gent 3 started 19 JAN 18 12-06-12
gent's Process id 19192
servername>sinaloaPOC3</servername>
unning on server sinaloaPOC3 PortNumber 468
ext Service Current Service
service name = BNK/ARC.GENERIC>
process name = BNK/ARC.GENERIC>
job name = ARC.GENERIC>
BNK/ARC.GENERIC_ARC.GENERIC_3_19 JAN 2018_12:06:12:408_Standard multi-thread job
BNK/ARC.GENERIC_ARC.GENERIC_3_19 JAN 2018_12:06:12:408_Calling load routine
** Error [ SUBROUTINE_CALL_FAIL ] **
nable to perform CALL to subroutine .LOAD , Line 167 , Source ARC.GENERIC.LOAD
ress C to continue or Q to quit
rap from an error message, error message name = SUBROUTINE_CALL_FAIL
ine 167 , Source ARC.GENERIC.LOAD
BASE debugger->end
BASE debugger , END
BNK/ARC.GENERIC_ARC.GENERIC_3_19 JAN 2018_12:09:26:454_SELECT F.RECORD.LOCK WITH K.USER EQ "" Selected=0 time=0secs
sh T24-Migra ~ -->
Could you guys help me to overcome this ?
Thanks in advance,
Ahamed
I am unable to run the ARC.GENERIC service. I am getting the below error.
como>
agent>3</agent>
processid>19192</processid>
portno>468</portno>
gent 3 started 19 JAN 18 12-06-12
gent's Process id 19192
servername>sinaloaPOC3</servername>
unning on server sinaloaPOC3 PortNumber 468
ext Service Current Service
service name = BNK/ARC.GENERIC>
process name = BNK/ARC.GENERIC>
job name = ARC.GENERIC>
BNK/ARC.GENERIC_ARC.GENERIC_3_19 JAN 2018_12:06:12:408_Standard multi-thread job
BNK/ARC.GENERIC_ARC.GENERIC_3_19 JAN 2018_12:06:12:408_Calling load routine
** Error [ SUBROUTINE_CALL_FAIL ] **
nable to perform CALL to subroutine .LOAD , Line 167 , Source ARC.GENERIC.LOAD
ress C to continue or Q to quit
rap from an error message, error message name = SUBROUTINE_CALL_FAIL
ine 167 , Source ARC.GENERIC.LOAD
BASE debugger->end
BASE debugger , END
BNK/ARC.GENERIC_ARC.GENERIC_3_19 JAN 2018_12:09:26:454_SELECT F.RECORD.LOCK WITH K.USER EQ "" Selected=0 time=0secs
sh T24-Migra ~ -->
Could you guys help me to overcome this ?
Thanks in advance,
Ahamed
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1209
- Thank you received: 158
- nugirasjid
- Offline
- New Member
-
Less
More
- Posts: 1
- Thank you received: 0
4 years 10 months ago #22943
by nugirasjid
Replied by nugirasjid on topic T24 ARCHIVING
Hi, i am new to T24, i have a question about archiving, my client is using R8, is archiving available in R8 or is it available only in version R10 or above. Thanks before hand.
Please Log in or Create an account to join the conversation.
Time to create page: 0.074 seconds