90 Minds Community

I'm working on a Premium to Premium upgrade. I am not reinstalling system files (I did this last weekend) and I'm wondering if anyone has a great way of moving/copying  the MAS_SYSTEM: PL​_JournalPDFLog, PL_PeriodEndPDFLog  and PL_ReportPDFLog files missing entries to the new system files?

In last years MOTM SQL pre-session, Carmen had a script but I did not save it or get it. Does anyone else have that or have a method? 

Thank you 

------------------------------
Tina Meacham
RKL eSolutions, LLC
------------------------------

If you can backup/restore a copy of the source MAS_SYSTEM database onto the new server, you can use the attached scripts. They'll delete the contents of those three tables in new MAS_SYSTEM and then copy them from MAS_ZZZ (what I called the source MAS_SYSTEM that I restored),  I used Sage 100 2023 for the list of fields to pull, so if you get an error about a field not existing (like MapService), you can just put two hyphens in beginning of that line (--,MapService) to comment them out and try again.

If you can't backup/restore, then you'll need to create a Linked Server entry from the new SQL server to the old, then you'd update the last FROM in each query to LINKED_SERVER_NAME.MAS_ZZZ.dbo.PLPeriodEndLog.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

Thank you Both!! 

------------------------------
Tina Meacham
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 09-15-2024 10:02
From: Steve Iwanowski
Subject: Premium to Premium Paperless Office files

If you can backup/restore a copy of the source MAS_SYSTEM database onto the new server, you can use the attached scripts. They'll delete the contents of those three tables in new MAS_SYSTEM and then copy them from MAS_ZZZ (what I called the source MAS_SYSTEM that I restored),  I used Sage 100 2023 for the list of fields to pull, so if you get an error about a field not existing (like MapService), you can just put two hyphens in beginning of that line (--,MapService) to comment them out and try again.

If you can't backup/restore, then you'll need to create a Linked Server entry from the new SQL server to the old, then you'd update the last FROM in each query to LINKED_SERVER_NAME.MAS_ZZZ.dbo.PLPeriodEndLog.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

I had a Premium to Premium ( v2021 to v2024 ) where I did re-migrate the system files. I found that the paperles office log files did not appear to re-migrate. I'm fairly certain that I answered yes to re-migrate the system files. I tried to verify this in the various migration logs but they're difficult to interpret. 

Does anyone know if this could be some type of bug or maybe it was user error on my end. Luckily there was only a one week testing period and the PDF files still exist ( just no record of them in the viewer ).

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
CT
------------------------------

I'm not aware of such a bug, so you may have just missed it.  If you can still get to the 2021 SQL, you can use the scripts above to pull that week's activities.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

Original Message:
Sent: 02-28-2025 14:08
From: Wayne Schulz
Subject: Premium to Premium Paperless Office files

I had a Premium to Premium ( v2021 to v2024 ) where I did re-migrate the system files. I found that the paperles office log files did not appear to re-migrate. I'm fairly certain that I answered yes to re-migrate the system files. I tried to verify this in the various migration logs but they're difficult to interpret. 

Does anyone know if this could be some type of bug or maybe it was user error on my end. Luckily there was only a one week testing period and the PDF files still exist ( just no record of them in the viewer ).

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
CT
------------------------------