Saltar al contenido
Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
AWS re:Postre:Post
Acerca de re:Post

WHILE RUNNNING MONTHLY TRANSACTION REPORT GETTING EMPTY DATA

0

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

Temas
Migración y modernización
Etiquetas
AWS Blu Age
Idioma
English
preguntada hace 5 meses24 visualizaciones
1 Respuesta
0

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
Error while generating transaction report | AWS re:Post

respondido hace 5 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Contenido relevante