Prev
Next
Forums S3 Systems Administration

GLTRANSREL Question

Sort:
You are not authorized to post a reply.
Author
Messages
Ward Mitchell
Veteran Member
Posts: 81
Veteran Member
9/15/2010 8:10 PM
    Wondering if when we run the importdb command to dump data into GLTRANSREL from a command line what it does to GLTRANSREL?

    We had a error pop up in our production environment where it stated that we had x amount of new records to be added, but then 1 that already existed and would be updated and our system burped at us but still came out balanced and the whole 9.

    I know this is kind of a vague question, but we realy want to nail down the purpose and activity of GLTRANSREL in Lawson out side of this link: https://www.lawsonguru.co.../programs/GL165.html

    Thanks in advance friends!
    Joe O'Toole
    Veteran Member
    Posts: 314
    Veteran Member
    9/15/2010 8:24 PM
      Are you sure you do not have one record more than once in the file you are uploading? I have seen that cause this message.
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      9/15/2010 9:01 PM
        Also look for blank lines at the end of the file or perhaps extra CR/LF during file upload if moving between platforms. =
        Thanks for using the LawsonGuru.com forums!
        John
        Mark Ivankovich
        Basic Member
        Posts: 16
        Basic Member
        9/17/2010 1:04 PM
          Think of GLTRANSREL as a staging table to load gl transactions from a non lawson application (i.e manual entries from a spreadsheet, external file from a different system like Meditech AR, etc.).

          Once you import to gltransrel you can review and edit the records in GL65.

          Then when you run GL165 in update mode it moves the records into gltrans and removes the records from gltransrel.

          Hope this helps...

          Ward Mitchell
          Veteran Member
          Posts: 81
          Veteran Member
          9/17/2010 1:36 PM
            @Joe - our feed files always have 144 new records in the file that we upload. For some reason, we had 143 records to add but then had 1 that was updated, BUT, the GL165 pushed 144 new records up. So we are trying to figure out how can 1 be updated when 144 were added

            @John - we triple chekced this and we do not have any blank lines or cr/lf

            @Mark - thanks. We know that aspects but just not why it is acting as odd as it does (see my explanation to Joe). This has us baffled! What is funny though is that everything balances out and is good in the system! Very odd!
            Joe O'Toole
            Veteran Member
            Posts: 314
            Veteran Member
            9/17/2010 3:13 PM
              I would make sure your GLTRANSREL table was empty before you run importdb (delete * from GLTRANSREL, used with caution of course). Perhaps there is a record that is never removed when you run GL165. I guess it's possible, but I have not found the updated records count to be erroneous.
              Mark Ivankovich
              Basic Member
              Posts: 16
              Basic Member
              9/17/2010 5:40 PM
                I echo Joe, make sure you don't have a record hanging out in gltransrel from the last upload.

                If so, check the RunGroup, Company, Seq_number fields to see if it matches one in your importdb file upload.

                If it matches then this would be the reason why you have "1 Modified" on your importdb log.

                Also, check your options for the importdb command, are you using -u (update) if so, it will update existing records not overwrite them if you intend to actually overwrite them.

                We do the bldora10ddl -URIT productline GL GLTRANSREL lawson utility to remove the records in a table. It's much cleaner and rebuilds the associated indexes as well.

                Hope this helps...
                You are not authorized to post a reply.