PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/07/2016 5:46 PM by  pbelsky
Missing data in modified CSV error report after promotion
 12 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Woozy
Private
Private
Veteran Member
(3478 points)
Veteran Member
Posts:704


Send Message:

--
12/28/2015 11:30 AM

    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
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    12/28/2015 12: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
    Private
    Private
    Senior Member
    (9596 points)
    Senior Member
    Posts:3216


    Send Message:

    --
    12/28/2015 3: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
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    12/28/2015 3: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
    Private
    Private
    Senior Member
    (9596 points)
    Senior Member
    Posts:3216


    Send Message:

    --
    12/28/2015 4:13 PM
    are you referring to 'create csv' from portal or LID?
    Thanks for using the LawsonGuru.com forums!
    John
    Woozy
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    12/28/2015 4: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
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    12/29/2015 9:24 AM
    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
    Private
    Private
    Veteran Member
    (471 points)
    Veteran Member
    Posts:163


    Send Message:

    --
    01/06/2016 1: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
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    01/06/2016 4: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
    Sr Analyst Project Manager
    Weyerhaeuser
    Veteran Member
    (215 points)
    Veteran Member
    Posts:75


    Send Message:

    --
    01/07/2016 4: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
    Sr Analyst Project Manager
    Weyerhaeuser
    Veteran Member
    (215 points)
    Veteran Member
    Posts:75


    Send Message:

    --
    01/07/2016 4: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
    Private
    Private
    Veteran Member
    (3478 points)
    Veteran Member
    Posts:704


    Send Message:

    --
    01/07/2016 4: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
    Sr Analyst Project Manager
    Weyerhaeuser
    Veteran Member
    (215 points)
    Veteran Member
    Posts:75


    Send Message:

    --
    01/07/2016 5: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).
    You are not authorized to post a reply.