• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization S3 Customization/Development

Missing data in modified CSV error report after promotion

 12 Replies
 2 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
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

Kelly Meade
J. R. Simplot Company
Boise, ID
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
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.
Kelly Meade
J. R. Simplot Company
Boise, ID
John Henley
Send Private Message
Posts: 3351
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.

Thanks for using the LawsonGuru.com forums!
John
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
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.
Kelly Meade
J. R. Simplot Company
Boise, ID
John Henley
Send Private Message
Posts: 3351
12/28/2015 9:13 PM
are you referring to 'create csv' from portal or LID?
Thanks for using the LawsonGuru.com forums!
John
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
12/28/2015 9:48 PM
Create CSV from Portal - LSF 9.0.1.11. Sorry I forgot to confirm that before.
Kelly Meade
J. R. Simplot Company
Boise, ID
Woozy
Veteran Member Send Private Message
Posts: 709
Veteran Member
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?
Kelly Meade
J. R. Simplot Company
Boise, ID
jaherb
Veteran Member Send Private Message
Posts: 164
Veteran Member
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 Send Private Message
Posts: 709
Veteran Member
1/6/2016 9:23 PM
Thanks Jim. It's very odd. I can't think of anything that explains it.
Kelly Meade
J. R. Simplot Company
Boise, ID
pbelsky
Veteran Member Send Private Message
Posts: 80
Veteran Member
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 Send Private Message
Posts: 80
Veteran Member
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 Send Private Message
Posts: 709
Veteran Member
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.
Kelly Meade
J. R. Simplot Company
Boise, ID
pbelsky
Veteran Member Send Private Message
Posts: 80
Veteran Member
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).