WHILE RUNNNING MONTHLY TRANSACTION REPORT GETTING EMPTY DATA

Question

WHILE RUNNNIG MONTHLY TRANSACTIO REPRT GETTINNG EMPTY AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00 AND  AWS.M2.CARDDEMO.TRANREPT.G0015V00. BUT SCRPTS ENEDED WITHOUT ANY ERRORS AND FILES ALSO CRETED AT WORKING DIRECTORY.

Start date: [2025-06-01]
End   date: [2025-06-30]
2025-06-06_01-02-04-119 | [JOB] TRANREPT-TRANREPT - Started
2025-06-06_01-02-04-197 | [STEP] STEP01R - Started
2025-06-06_01-02-04-328 | [EXEC GROOVY FILE] D:\PhotonUser\AppData\Local\Temp\2\blu_age_rt_temp_dir\TRANREPT-TRANREPT_STEP01R_REPROC_2025-06-06_01-02-04-289.groovy - Started
2025-06-06_01-02-04-590 | [PROC] REPROC - Started
2025-06-06_01-02-04-606 | [STEP] PRC001 - Started
2025-06-05T23:02:04.633Z  INFO 4560 --- [      Thread-24] c.n.b.g.i.s.FileConfigurationUtils       : PRC001.FILEIN : BluesamFileConfiguration [bluesamId=, dataset=AWS.M2.CARDDEMO.TRANSACT.VSAM.KSDS, cacheCompression=false, warmUp=true, isAnsiCarriageControl=false, disposition=SHR, normal termination=KEEP, abnormal termination=KEEP]
2025-06-05T23:02:04.634Z  INFO 4560 --- [      Thread-24] c.n.b.g.i.s.FileConfigurationUtils       : PRC001.FILEOUT : GDGSupportConfiguration [relativeGeneration=1, name=AWS.M2.CARDDEMO.TRANSACT.BKUP, ownerPath=., cacheCompression=false, warmUp=true, storageProvider=filesystem, recordSize=350, jobContext=com.netfective.bluage.gapwalk.rt.job.support.DefaultJobContext@25bab541, rdw=false, bdw=false, isFixed=false, isLF=false, isCRLF=false, isMicroFocusCompatible=false, order=LIFO]
2025-06-05T23:02:04.636Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.c.i.ExecutionControllerImpl    : Executing program: IDCAMS
2025-06-05T23:02:04.636Z  INFO 4560 --- [      Thread-24] c.n.b.g.rt.db.stats.DatabaseStatistics   : DATABASE STATISTIC DISABLED
2025-06-05T23:02:04.684Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Using path =[.\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00] for FileSystem GDG named AWS.M2.CARDDEMO.TRANSACT.BKUP generation 79
2025-06-05T23:02:04.684Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Stored [.\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00] for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:04.686Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.io.support.FileFactory     : Created new file [D:\PhotonUser\Workshop\working-directory\.\.\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00]
2025-06-05T23:02:04.881Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.idcams.IdcamsPgm   : IDCAMS REPRO : REPRO INFILE(FILEIN) OUTFILE(FILEOUT)
2025-06-05T23:02:05.090Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.sort.service.AdaptableSort     : External sort threshold is 2071420268 bytes
2025-06-05T23:02:05.102Z  INFO 4560 --- [      Thread-24] org.ehcache.core.EhcacheManager          : Cache 'AWS_M2_CARDDEMO_TRANSACT_VSAM_KSDS' created in EhcacheManager.
2025-06-05T23:02:05.126Z  INFO 4560 --- [      Thread-24] .b.c.s.r.AbstractRdbmsPersistenceSupport : Loaded 314 records from AWS_M2_CARDDEMO_TRANSACT_VSAM_KSDS in 24 ms
2025-06-05T23:02:05.141Z  INFO 4560 --- [      Thread-24] c.n.b.g.u.s.s.e.io.DataSetRecordReader   : Open dataSet AWS.M2.CARDDEMO.TRANSACT.VSAM.KSDS status = OK
2025-06-05T23:02:05.180Z  INFO 4560 --- [      Thread-24] c.n.b.g.u.s.s.e.ExternalSortTasklet      : fcOut:GDGSupportConfiguration [relativeGeneration=1, name=AWS.M2.CARDDEMO.TRANSACT.BKUP, ownerPath=., cacheCompression=false, warmUp=true, storageProvider=filesystem, recordSize=350, jobContext=com.netfective.bluage.gapwalk.rt.job.support.DefaultJobContext@25bab541, rdw=false, bdw=false, isFixed=false, isLF=false, isCRLF=false, isMicroFocusCompatible=false, order=LIFO]
2025-06-05T23:02:05.189Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.189Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.190Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.common.FileUtils   : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00 - Existing file! - no file creation.
2025-06-05T23:02:05.198Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.198Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.198Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.common.FileUtils   : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00 - Existing file! - no file creation.
2025-06-05T23:02:05.198Z  INFO 4560 --- [      Thread-24] c.n.b.g.u.s.s.e.ExternalSortTasklet      : Sort output file length = 109900 bytes 
2025-06-05T23:02:05.199Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.idcams.IdcamsPgm   : IDCAMS REPRO : Number of records processed: 314
2025-06-05T23:02:05.206Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.206Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.206Z  INFO 4560 --- [      Thread-24] c.n.b.g.i.c.i.AbstractDatasetCatalogImpl : Register Dataset - GDG computed absolute generation 79
2025-06-05T23:02:05.209Z  INFO 4560 --- [      Thread-24] c.n.b.g.i.c.i.AbstractDatasetCatalogImpl : Registering a new dataset file AWS.M2.CARDDEMO.TRANSACT.BKUP
2025-06-05T23:02:05.212Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.212Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.223Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.224Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.234Z  INFO 4560 --- [      Thread-24] b.g.r.i.s.i.DefaultGDGEventsQueueHandler : [396502365] - Stacked GDG Event :GDGEvent [provider=filesystem, fsPath=./.\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00, gdgName=AWS.M2.CARDDEMO.TRANSACT.BKUP, type=NEW_GENERATION, relativeGeneration=1, absoluteGeneration=79, ] for [Thread-24]
2025-06-05T23:02:05.234Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.io.support.FileFactory     : FileUtils : stack new generation event
2025-06-06_01-02-05-249 | Program return code is 0
2025-06-06_01-02-05-251 | [STEP] PRC001 - Ended
2025-06-06_01-02-05-267 | [PROC] REPROC - Ended
2025-06-06_01-02-05-270 | [EXEC GROOVY FILE] D:\PhotonUser\AppData\Local\Temp\2\blu_age_rt_temp_dir\TRANREPT-TRANREPT_STEP01R_REPROC_2025-06-06_01-02-04-289.groovy - Ended
2025-06-06_01-02-05-271 | [STEP] STEP01R - Ended
2025-06-06_01-02-05-289 | [STEP] STEP05R - Started
2025-06-05T23:02:05.293Z  WARN 4560 --- [      Thread-24] c.n.b.g.i.s.c.b.FileConfigurationBuilder : Update of GDGSUpportConfiguration from catalog is not implemented.
2025-06-05T23:02:05.389Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.c.i.ExecutionControllerImpl    : Executing program: SORT
2025-06-05T23:02:05.390Z  INFO 4560 --- [      Thread-24] c.n.b.g.rt.db.stats.DatabaseStatistics   : DATABASE STATISTIC DISABLED
2025-06-05T23:02:05.397Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Using path =[.\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00] for FileSystem GDG named AWS.M2.CARDDEMO.TRANSACT.DALY generation 31
2025-06-05T23:02:05.397Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Stored [.\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00] for key (AWS.M2.CARDDEMO.TRANSACT.DALY,1)
2025-06-05T23:02:05.398Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.io.support.FileFactory     : Created new file [D:\PhotonUser\Workshop\working-directory\.\.\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00]
2025-06-05T23:02:05.401Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.401Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.867Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.sort.service.AdaptableSort     : External sort threshold is 2070363904 bytes
2025-06-05T23:02:05.869Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.869Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.870Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.io.utils.CommonDDUtils     : Record length read from the catalog for GDG dataset AWS.M2.CARDDEMO.TRANSACT.BKUP Generation 79 : 350
2025-06-05T23:02:05.872Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.BKUP,1)
2025-06-05T23:02:05.872Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00
2025-06-05T23:02:05.872Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.common.FileUtils   : .\AWS.M2.CARDDEMO.TRANSACT.BKUP.G0079V00 - Existing file! - no file creation.
2025-06-05T23:02:06.404Z  INFO 4560 --- [      Thread-24] c.n.b.g.u.s.s.e.ExternalSortTasklet      : fcOut:GDGSupportConfiguration [relativeGeneration=1, name=AWS.M2.CARDDEMO.TRANSACT.DALY, ownerPath=., cacheCompression=false, warmUp=true, storageProvider=filesystem, recordSize=350, jobContext=com.netfective.bluage.gapwalk.rt.job.support.DefaultJobContext@25bab541, rdw=false, bdw=false, isFixed=false, isLF=false, isCRLF=false, isMicroFocusCompatible=false, order=LIFO]
2025-06-05T23:02:06.405Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.DALY,1)
2025-06-05T23:02:06.406Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00
2025-06-05T23:02:06.406Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.common.FileUtils   : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00 - Existing file! - no file creation.
2025-06-05T23:02:06.412Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.DALY,1)
2025-06-05T23:02:06.412Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00
2025-06-05T23:02:06.412Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.utility.common.FileUtils   : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00 - Existing file! - no file creation.
2025-06-05T23:02:06.412Z  INFO 4560 --- [      Thread-24] c.n.b.g.u.s.s.e.ExternalSortTasklet      : Sort output file length = 0 bytes 
2025-06-05T23:02:06.414Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.DALY,1)
2025-06-05T23:02:06.415Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00
2025-06-05T23:02:06.415Z  INFO 4560 --- [      Thread-24] c.n.b.g.i.c.i.AbstractDatasetCatalogImpl : Register Dataset - GDG computed absolute generation 31
2025-06-05T23:02:06.415Z  INFO 4560 --- [      Thread-24] c.n.b.g.i.c.i.AbstractDatasetCatalogImpl : Registering a new dataset file AWS.M2.CARDDEMO.TRANSACT.DALY
2025-06-05T23:02:06.418Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.DALY,1)
2025-06-05T23:02:06.418Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00
2025-06-05T23:02:06.420Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored dataset path from job context for key (AWS.M2.CARDDEMO.TRANSACT.DALY,1)
2025-06-05T23:02:06.420Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Retrieved path from jobContext : .\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00
2025-06-05T23:02:06.420Z  INFO 4560 --- [      Thread-24] b.g.r.i.s.i.DefaultGDGEventsQueueHandler : [396502365] - Stacked GDG Event :GDGEvent [provider=filesystem, fsPath=./.\AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00, gdgName=AWS.M2.CARDDEMO.TRANSACT.DALY, type=NEW_GENERATION, relativeGeneration=1, absoluteGeneration=31, ] for [Thread-24]
2025-06-05T23:02:06.420Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.io.support.FileFactory     : FileUtils : stack new generation event
2025-06-06_01-02-06-425 | Program return code is 0
2025-06-06_01-02-06-426 | [STEP] STEP05R - Ended
2025-06-06_01-02-06-436 | [STEP] STEP10R - Started
2025-06-05T23:02:06.441Z  WARN 4560 --- [      Thread-24] c.n.b.g.i.s.c.b.FileConfigurationBuilder : Update of GDGSUpportConfiguration from catalog is not implemented.
2025-06-05T23:02:06.451Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.c.i.ExecutionControllerImpl    : Executing program: CBTRN03C
2025-06-05T23:02:06.452Z  INFO 4560 --- [      Thread-24] c.n.b.g.rt.db.stats.DatabaseStatistics   : DATABASE STATISTIC DISABLED
2025-06-05T23:02:06.477Z  INFO 4560 --- [      Thread-24] c.n.b.g.io.support.basic.BuilderHelper   : Using path =[.\AWS.M2.CARDDEMO.TRANREPT.G0015V00] for FileSystem GDG named AWS.M2.CARDDEMO.TRANREPT generation 15
2025-06-05T23:02:06.478Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Stored [.\AWS.M2.CARDDEMO.TRANREPT.G0015V00] for key (AWS.M2.CARDDEMO.TRANREPT,1)
2025-06-05T23:02:06.479Z  INFO 4560 --- [      Thread-24] c.n.b.gapwalk.io.support.FileFactory     : Created new file [D:\PhotonUser\Workshop\working-directory\.\.\AWS.M2.CARDDEMO.TRANREPT.G0015V00]
2025-06-05T23:02:06.479Z  INFO 4560 --- [      Thread-24] a.b.l.w.c.s.impl.Cbtrn03cProcessImpl     : START OF EXECUTION OF PROGRAM CBTRN03C
2025-06-05T23:02:06.492Z  INFO 4560 --- [      Thread-24] c.n.b.g.r.job.support.DefaultJobContext  : Returning stored data

re:Post Agent · Answer

The issue you're experiencing with empty transaction report files (AWS.M2.CARDDEMO.TRANSACT.DALY.G0031V00 and AWS.M2.CARDDEMO.TRANREPT.G0015V00) is likely related to the INCLUDE COND functionality in the TRANREPT job.

Looking at your logs, I can see that the sort operation completed successfully but produced an empty output file (note the line "Sort output file length = 0 bytes"). This suggests that the date filtering condition is not finding any matching records in your data.

This is a known issue with the INCLUDE COND functionality in the TRANREPT job. The problem occurs because the date filtering condition is not properly identifying or comparing the characters in your transaction data. Even though your script is running without errors and creating the output files, they remain empty because no records match your date criteria.

To resolve this issue:

1. Try modifying your TRANREPT script to comment out the INCLUDE COND and keep only the SORT FIELDS parameter. This approach has worked for others experiencing the same issue.

2. Make sure you're using CH (character) format instead of ZD (zoned decimal) for date comparisons, as you mentioned in your logs.

3. Double-check that your date format in the input file matches exactly with how you're specifying it in the INCLUDE COND.

4. Verify that the start position for the date field is correct in your condition.

The most effective solution based on similar cases is to comment out the INCLUDE COND entirely and rely only on the SORT functionality. This should allow your transaction report to generate with data rather than empty files.  
**Sources**  
[L3-Workshop-Execution-Test-Online-User features-Transaction report(INCLUDE COND not working) | AWS re:Post](https://repost.aws/questions/QULyPEhSqXSpCAPbuBJR6a-g/l3-workshop-execution-test-online-user-features-transaction-report-include-cond-not-working)  
[Error while generating transaction report | AWS re:Post](https://repost.aws/questions/QUR-BIrxUYQ1mpqfMlJkphwg/error-while-generating-transaction-report)

WHILE RUNNNING MONTHLY TRANSACTION REPORT GETTING EMPTY DATA

添加回答

相关内容