During the upgrade of The Lake Companies ShopTrak 2012 Service Pack 1 product to version 2013 of ShopTrak following the Infor SyteLine upgrade from 8.03.11 to 8.03.20, you receive error messages concerning function dbo.IsMaterialTiedToProject. It appears that this function was upgraded from SyteLine 8.03.11 to 8.03.20 and now pulls back another field called “@CheckJobStatus” which is causing errors in the lc_lt_JobIssueQtyRequired and lc_lt_JobPickSp procedures.
Run below query in SQL Management Studio to disable replication in Infor SyteLine.
After you copy (or restore) a Infor SyteLine multisite environment and try to log in you receive the error message:
“The license document installed on this system is invalid”.
From the Syteline client, open up the Sites/Entities form, and click on the Filter In Place icon.
Below I’ll describe how to create a copy of a multisite environment in Infor Syteline 8.03.XX. You can use this procedure to duplicate an existing environment that you are using or to create a new environment out of your “seed” environment. Seed environment would be your fully configured environment that does not contain any transactional data. You can create copies of this “template” (clean environment) with different names to create test and/or production environments.
Assuming you have backups going for your existing multisite environment, first thing you’ll want to do is to create a copy of each of your databases by restoring them from the source backup and then renaming them so that they have the target’s naming convention.
When creating a user account in Syteline 8.03.11 you receive the error message:
Error Message does not exist. Object: Profiles_UX, Type:17
You start the SL client and navigate to the Users form. You can create a new user account and populate the appropriate account information, however when you click on the Save button you receive the error message shown below.