ItextPdfGenerator Data rows skipped due to error: 1.

General discussion of the Co:Z Toolkit
Post Reply
Vikesh
Posts: 3
Joined: Fri Jul 22, 2016 7:15 am

ItextPdfGenerator Data rows skipped due to error: 1.

Post by Vikesh »

Good day,
I'm a bit stumped with this error and do not seem to be able to generate the pdf, all run on a z/OS 2.3 system.

The pdf template file ; mapping file ; filed data and common data all match, yet, I get this error :
2021-07-19 14:42:26,915 INFO ItextPdfGenerator - Generation completed. Data rows processed: 0. Data rows skipped due to error: 1.
Execution time: 589 ms.

The following is the jobs STDERR :
2021-07-19 14:42:24,540 INFO Configuration -
--common-data //DD:COMDATA (csv delimted by '|')
--common-map //DD:COMMAP (csv delimted by '|')
--field-data //DD:FLDDATA (csv delimted by '|')
--field-map //DD:FLDMAP (csv delimted by '|')
--field-data-limit generate pages for all data rows
--pdf-template //DD:TEMPLATE
--pdf-output //DD:PDFOUT
2021-07-19 14:42:24,732 INFO CommonFieldMap - Common form field names parsed: 4. Columns to be skipped: 0.
2021-07-19 14:42:24,732 INFO CommonFieldMap - Common file expected to have 4 columns.
2021-07-19 14:42:24,747 DEBUG CommonFieldMap - Common form fields:
column 0, field=Registration number value=4005845502
column 1, field=Tax period value=
column 2, field=Trading name value=VWXYZE INDUSTRIAL AND SECURITY SERVICES CC
column 3, field=SARS branch value=PRETORIA
2021-07-19 14:42:24,769 INFO DataFieldMap - Data form field names parsed: 66. Columns to be skipped: 0.
2021-07-19 14:42:24,770 INFO DataFieldMap - Data file expected to have 66 columns.
2021-07-19 14:42:24,772 DEBUG DataFieldMap - Data form fields:
column 0, field=Assessment date
column 1, field=Due date
column 2, field=Second date
column 3, field=Transaction number
column 4, field=Previous
column 5, field=Previous1
column 6, field=Previous2
column 7, field=Previous3
column 8, field=Previous4
column 9, field=%
column 10, field=cl
column 11, field=Previous5
column 12, field=Previous6
column 13, field=Previous7
column 14, field=Previous8
column 15, field=c/l
column 16, field=Previous9
column 17, field=Previous10
column 18, field=Previous11
column 19, field=Previous12
column 20, field=c/l1
column 21, field=Now
column 22, field=Now1
column 23, field=Now2
column 24, field=Now3
column 25, field=Now4
column 26, field=Now5
column 27, field=Now6
column 28, field=Now7
column 29, field=Now8
column 30, field=Now9
column 31, field=Now10
column 32, field=Now11
column 33, field=Now12
column 34, field=Diff
column 35, field=Diff1
column 36, field=Diff2
column 37, field=Diff3
column 38, field=Diff4
column 39, field=Diff5
column 40, field=Diff6
column 41, field=Diff7
column 42, field=Diff8
column 43, field=Diff9
column 44, field=Diff10
column 45, field=Diff11
column 46, field=Diff12
column 47, field=Diff13
column 48, field=Diff14
column 49, field=Diff15
column 50, field=Diff16
column 51, field=Payment
column 52, field=Period
column 53, field=Remittance date
column 54, field=Cheque
column 55, field=Cash
column 56, field=Address
column 57, field=Address1
column 58, field=Address2
column 59, field=Address3
column 60, field=Address4
column 61, field=Postal Code
column 62, field=Enquiries
column 63, field=Tel number
column 64, field=Fax number
column 65, field=Date
2021-07-19 14:42:26,201 DEBUG ItextPdfGenerator - Field data mapping found for: Diff11
2021-07-19 14:42:26,203 DEBUG ItextPdfGenerator - Field data mapping found for: Address
2021-07-19 14:42:26,205 DEBUG ItextPdfGenerator - Field data mapping found for: Diff
2021-07-19 14:42:26,227 DEBUG ItextPdfGenerator - Field data mapping found for: Diff10
2021-07-19 14:42:26,227 DEBUG ItextPdfGenerator - Field data mapping found for: Second date
2021-07-19 14:42:26,227 DEBUG ItextPdfGenerator - Field data mapping found for: Diff13
2021-07-19 14:42:26,233 DEBUG ItextPdfGenerator - Field data mapping found for: Diff12
2021-07-19 14:42:26,236 DEBUG ItextPdfGenerator - Field data mapping found for: Diff15
2021-07-19 14:42:26,243 DEBUG ItextPdfGenerator - Field data mapping found for: Diff14
2021-07-19 14:42:26,247 DEBUG ItextPdfGenerator - Field data mapping found for: Diff16
2021-07-19 14:42:26,253 DEBUG ItextPdfGenerator - Field data mapping found for: Remittance date
2021-07-19 14:42:26,253 DEBUG ItextPdfGenerator - Field data mapping found for: Previous10
2021-07-19 14:42:26,255 DEBUG ItextPdfGenerator - Field data mapping found for: Previous11
2021-07-19 14:42:26,256 DEBUG ItextPdfGenerator - Field data mapping found for: Now3
2021-07-19 14:42:26,257 DEBUG ItextPdfGenerator - Field data mapping found for: Now2
2021-07-19 14:42:26,259 DEBUG ItextPdfGenerator - Field data mapping found for: Previous12
2021-07-19 14:42:26,260 DEBUG ItextPdfGenerator - Field data mapping found for: Now5
2021-07-19 14:42:26,261 DEBUG ItextPdfGenerator - Field data mapping found for: Now4
2021-07-19 14:42:26,261 DEBUG ItextPdfGenerator - Field data mapping found for: Now1
2021-07-19 14:42:26,265 DEBUG ItextPdfGenerator - Field data mapping found for: Postal Code
2021-07-19 14:42:26,268 DEBUG ItextPdfGenerator - Common data mapping found for: Registration number
2021-07-19 14:42:26,269 DEBUG ItextPdfGenerator - Field data mapping found for: %
2021-07-19 14:42:26,270 DEBUG ItextPdfGenerator - Field data mapping found for: Previous4
2021-07-19 14:42:26,271 DEBUG ItextPdfGenerator - Field data mapping found for: Now12
2021-07-19 14:42:26,271 DEBUG ItextPdfGenerator - Field data mapping found for: Previous3
2021-07-19 14:42:26,275 DEBUG ItextPdfGenerator - Field data mapping found for: Now11
2021-07-19 14:42:26,294 DEBUG ItextPdfGenerator - Field data mapping found for: Period
2021-07-19 14:42:26,296 DEBUG ItextPdfGenerator - Field data mapping found for: Previous6
2021-07-19 14:42:26,297 DEBUG ItextPdfGenerator - Field data mapping found for: Now10
2021-07-19 14:42:26,298 DEBUG ItextPdfGenerator - Field data mapping found for: Previous5
2021-07-19 14:42:26,298 DEBUG ItextPdfGenerator - Field data mapping found for: Due date
2021-07-19 14:42:26,299 DEBUG ItextPdfGenerator - Field data mapping found for: Previous2
2021-07-19 14:42:26,299 DEBUG ItextPdfGenerator - Field data mapping found for: Previous1
2021-07-19 14:42:26,301 DEBUG ItextPdfGenerator - Field data mapping found for: Payment
2021-07-19 14:42:26,302 DEBUG ItextPdfGenerator - Field data mapping found for: Tel number
2021-07-19 14:42:26,303 DEBUG ItextPdfGenerator - Field data mapping found for: Now
2021-07-19 14:42:26,303 DEBUG ItextPdfGenerator - Field data mapping found for: Transaction number
2021-07-19 14:42:26,303 DEBUG ItextPdfGenerator - Field data mapping found for: Diff4
2021-07-19 14:42:26,304 DEBUG ItextPdfGenerator - Field data mapping found for: c/l
2021-07-19 14:42:26,307 DEBUG ItextPdfGenerator - Field data mapping found for: Diff3
2021-07-19 14:42:26,308 DEBUG ItextPdfGenerator - Field data mapping found for: Diff2
2021-07-19 14:42:26,309 DEBUG ItextPdfGenerator - Field data mapping found for: Diff1
2021-07-19 14:42:26,311 DEBUG ItextPdfGenerator - Common data mapping found for: Tax period
2021-07-19 14:42:26,312 DEBUG ItextPdfGenerator - Field data mapping found for: Cash
2021-07-19 14:42:26,312 DEBUG ItextPdfGenerator - Field data mapping found for: Previous8
2021-07-19 14:42:26,312 DEBUG ItextPdfGenerator - Field data mapping found for: Previous7
2021-07-19 14:42:26,313 DEBUG ItextPdfGenerator - Field data mapping found for: Address4
2021-07-19 14:42:26,313 DEBUG ItextPdfGenerator - Field data mapping found for: Previous9
2021-07-19 14:42:26,314 DEBUG ItextPdfGenerator - Field data mapping found for: Diff9
2021-07-19 14:42:26,314 DEBUG ItextPdfGenerator - Field data mapping found for: c/l1
2021-07-19 14:42:26,315 DEBUG ItextPdfGenerator - Field data mapping found for: Diff8
2021-07-19 14:42:26,315 DEBUG ItextPdfGenerator - Field data mapping found for: Diff7
2021-07-19 14:42:26,316 DEBUG ItextPdfGenerator - Field data mapping found for: Diff6
2021-07-19 14:42:26,316 DEBUG ItextPdfGenerator - Field data mapping found for: Diff5
2021-07-19 14:42:26,317 DEBUG ItextPdfGenerator - Field data mapping found for: Assessment date
2021-07-19 14:42:26,317 DEBUG ItextPdfGenerator - Field data mapping found for: Now7
2021-07-19 14:42:26,318 DEBUG ItextPdfGenerator - Field data mapping found for: Now6
2021-07-19 14:42:26,318 DEBUG ItextPdfGenerator - Field data mapping found for: Now9
2021-07-19 14:42:26,319 DEBUG ItextPdfGenerator - Field data mapping found for: Now8
2021-07-19 14:42:26,319 DEBUG ItextPdfGenerator - Field data mapping found for: Address2
2021-07-19 14:42:26,320 DEBUG ItextPdfGenerator - Field data mapping found for: cl
2021-07-19 14:42:26,320 DEBUG ItextPdfGenerator - Field data mapping found for: Address3
2021-07-19 14:42:26,321 DEBUG ItextPdfGenerator - Field data mapping found for: Address1
2021-07-19 14:42:26,322 DEBUG ItextPdfGenerator - Field data mapping found for: Date
2021-07-19 14:42:26,322 DEBUG ItextPdfGenerator - Field data mapping found for: Enquiries
2021-07-19 14:42:26,323 DEBUG ItextPdfGenerator - Common data mapping found for: Trading name
2021-07-19 14:42:26,323 DEBUG ItextPdfGenerator - Field data mapping found for: Previous
2021-07-19 14:42:26,324 DEBUG ItextPdfGenerator - Common data mapping found for: SARS branch
2021-07-19 14:42:26,325 DEBUG ItextPdfGenerator - Field data mapping found for: Cheque
2021-07-19 14:42:26,326 DEBUG ItextPdfGenerator - Field data mapping found for: Fax number
2021-07-19 14:42:26,326 INFO ItextPdfGenerator - Form fields with data or common field mappings: 66
2021-07-19 14:42:26,326 DEBUG ItextPdfGenerator - Starting generation with PdfSmartCopy...
2021-07-19 14:42:26,850 DEBUG ItextPdfGenerator - Data row 1 failed validation: 02/05/2021|01/06/2021|30/06/2021|1FEXYZ06|0|0.00|0|0
.00|0.00|15|0|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0|0.00|0.00|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00
|0.00|48785.87|0.00|-48785.87|0.00|0.00|0.00|0.00|10/20|-|-|-|VWXYZE INDUSTRIAL AND SECURITY|218 ABCDEFG TOWERS|202 ADDRESS NAME S
TREET|SUNNYSIDE|PRETORIA|0002|080 123 4567|(011) 334 2548|-|2021/05/02|080 123 4567|(012) 334 2548|-|2021/05/02
2021-07-19 14:42:26,915 INFO ItextPdfGenerator - Generation completed. Data rows processed: 0. Data rows skipped due to error: 1.
Execution time: 589 ms.


I'm not sure where my error is in the above output.

Your kind assistance and guidance is appreciated.
dovetail
Site Admin
Posts: 2022
Joined: Thu Jul 29, 2004 12:12 pm

Re: ItextPdfGenerator Data rows skipped due to error: 1.

Post by dovetail »

Itext is an open source Java pdf generator, it is not part of Co:Z.
If you are having problems using it to parse a CSV, you should seek support assistance from itextpdf.com
Post Reply