PRTAXLEVY

 7 Replies
 0 Subscribed to this topic
 69 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
New Poster
New Poster
Congrats on posting!
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: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
what was the resolution?
Thanks for using the LawsonGuru.com forums!
John