Missing data in modified CSV error report after promotion

Sort:
You are not authorized to post a reply.
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member

    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
    Posts: 709
    Veteran Member
      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
      Senior Member
      Posts: 3348
      Senior Member
        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
        Posts: 709
        Veteran Member
          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
          Senior Member
          Posts: 3348
          Senior Member
            are you referring to 'create csv' from portal or LID?
            Thanks for using the LawsonGuru.com forums!
            John
            Woozy
            Veteran Member
            Posts: 709
            Veteran Member
              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
              Posts: 709
              Veteran Member
                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
                Posts: 164
                Veteran Member
                  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
                  Veteran Member
                    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
                    Posts: 80
                    Veteran Member

                      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
                      Veteran Member

                        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
                        Veteran Member
                          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
                          Posts: 80
                          Veteran Member
                            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.