Missing data in modified CSV error report after promotion -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Woozy

Veteran Member

Posts: 709

12/28/2015 4:30 PM

Hi Gurus - I'm stumped, and I need some ideas.

We have a custom batch program that includes an error report. I recently modified the program and the error report to add additional columns. With the new columns, the report is too wide for the printed report but works fine in the CSV export in DEV.

However, after promoting the changes to PROD, the report compiles and runs without errors in PROD, but some of the new columns are blank in the CSV including the error message column (from msgmnt).

I've already done the following:

I confirmed that the source files match between prodlines
I recompiled both prodlines with -D and confirmed that the .cbl files are identical (other than datestamps) between them
I confirmed that msgmnt matches between the two environments
I deleted my job setup and recreated a new job from scratch just to be sure that wasn't causing confusion

I'm at a loss. Where else can I look to see why this PROD version isn't working the same as DEV?

Thanks!

Kelly

Woozy

Veteran Member

Posts: 709

12/28/2015 5:33 PM

By the way, I should mention that the columns exist in the PROD CSV output, and the headers are correct,but the detail values are empty.

John Henley

Posts: 3353

12/28/2015 8:10 PM

Are you referring to 'create CSV' from Portal?
Try
/servlet/IOSCacheRefresh

The report properties files (which are used to create the CSV) are cached and might need to be updated since you updated to your new version.

If that doesn't work, try rptgen PROD XX YY123
Followed by IOSCacheRefresh.

Woozy

Veteran Member

Posts: 709

12/28/2015 8:27 PM

Hi John - I appreciate the ideas. Unfortunately, it still doesn't work. I tried just the IOSCacheRefresh, then I tried the rptgen followed by the IOSCacheRefresh and a new Job, but the problem remains. Bizarre.

John Henley

Posts: 3353

12/28/2015 9:13 PM

are you referring to 'create csv' from portal or LID?

Woozy

Veteran Member

Posts: 709

12/28/2015 9:48 PM

Create CSV from Portal - LSF 9.0.1.11. Sorry I forgot to confirm that before.

Woozy

Veteran Member

Posts: 709

12/29/2015 2:24 PM

I think I've identified the problem, but I can't explain why it's happening.

I modified the report output so it is only 130 chars wide and moved the other fields to the next line. This is working correctly now in PROD. I'm confused about why it would work OK in DEV and not in PROD. Is there a setting somewhere that sets the max report width? I was under the impression that batch reports could be up to 250 chars wide?

Anyone have any thoughts?

jaherb

Veteran Member

Posts: 164

1/6/2016 6:42 PM

Kelly.... I have gone very close to 250 characters and have never seen the issue as you described. I know you are not limited to the 133 characters of a print line.

Jim

Woozy

Veteran Member

Posts: 709

1/6/2016 9:23 PM

Thanks Jim. It's very odd. I can't think of anything that explains it.

pbelsky

Veteran Member

Posts: 80

1/7/2016 9:26 PM

Hello W, I apologize if this is so obvious that you did not mention it, but when you promoted the program, did you bring over a dump file and do a pgm load before you compiled? Happy New Year and good luck.

pbelsky

Veteran Member

Posts: 80

1/7/2016 9:33 PM

One more thing, I once ran into a strange problem with a batch job where, even after compiling or trying rptgen, I could not get a report I had modified to update. It turned out that for some reason, the .rmp file was not being created. I had to delete the .rmp file and then recompile/rptgen. The .rmp files are located in lawdir/prodline/rptmap/default.

Woozy

Veteran Member

Posts: 709

1/7/2016 9:58 PM

Thanks for the ideas pbelsky. Unfortunately, no luck. I did do a pgmdump/load, and I actually tried deleting all the compiled files I could find and then doing a full recompile/rptgen. I also compared the .cmp files between DEV and PROD and they were identical. It's very strange.

pbelsky

Veteran Member

Posts: 80

1/7/2016 10:46 PM

It's *super* strange. My understanding is that the Create CSV File button is using the bldxffiles utility against your report file. So even if certain columns are not displaying when you view the report - I'm assuming you are viewing in portal - they should all still exist in your actual report print file, right? If you have access and have not already, check and compare the error report print files between DEV and PROD and see if there is any difference. If the PROD report print file is complete, the next thing I would be wondering about is blxffiles. Can you confirm if the environment patch level is the same in your DEV and PROD environments? You might also try running bldxffiles from a command line in PROD to see if it creates a complete csv that way (check out KB article 1202695).