PRTAXLEVY

 7 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Margie Gyurisin
Veteran Member
Posts: 538
Veteran Member

    Our IT dept loaded CTP for PRTAXLEVY updates but I do not see it on PR10 or in the table.  I seem to remember there is another step so it updates the system but don't remember what that is.

     

    Can you help, please?

    Thanks.

    Jimmy Chiu
    Veteran Member
    Posts: 641
    Veteran Member
      lawappinstall preview/update/activate?
      Margie Gyurisin
      Veteran Member
      Posts: 538
      Veteran Member
        I am sure that is what was done since that is standard. It seems to me as if something else needs to occur with this particular CTP update to load the file.
        Kwane McNeal
        Veteran Member
        Posts: 479
        Veteran Member
          You need to load the CSV file located in Admin. Use either ldappcsv command or importdb -af (if I recall correctly)

          Kwane
          John Henley
          Posts: 3353
            This should have been done automatically when the CTP is installed via lawappinstall activate.
            You used to have to run separate updates (PR710 or PR910 or something like that), but that was a long long time ago.

            Do you have command line/LID access, or access to the LAWDIR/prod/Admin/ folder on the server?

            You should check:
            1. what is the rowcount in PRTAXLEVY data table, e.g. count PROD PRTAXLEVY
            2. what is the rowcount in the delivered csv file, e.g. cat LAWDIR/prod/Admin/prtaxlevy.csv | wc -l
            (should be one higher than the rowcount in the table due to csv header)
            3. look at LAWDIR/prod/Admin/apploadcsv.log for any errors related to loading of prtaxlevy, and verify that date in the log file matches when CTP was installed.
            4. tmcontrol -rp PROD PR10
            (this will clear any caching of data in PR10-- quite a longshot, but you'd be surprised)
            Thanks for using the LawsonGuru.com forums!
            John
            JimY
            Veteran Member
            Posts: 510
            Veteran Member
              I ran the CTP yesterday and it ran fine and updated the table when I activated it.
              Margie Gyurisin
              Veteran Member
              Posts: 538
              Veteran Member
                Thanks to everyone who responded.

                It is resolved.
                John Henley
                Posts: 3353
                  what was the resolution?
                  Thanks for using the LawsonGuru.com forums!
                  John