IEA Software, Inc.

IEA Software Knowledge Base - ID:56056

IEA Knowledge base

Emerald (KB ID: 56056)

Jan 5 2006

When converting an Emerald 2.5 database to Emerald 4.5 I get the following error during the conversion process: [Microsoft][ODBC SQL Server Driver][SQL Server]There are PayPeriods missing from the Emerald 2.5 PayPeriods table. How can this problem be fixed?

Jan 5 2006

This problem is caused when an MBR references a Pay Period which is not defined under Pay Periods in the Emerald admin. You can use the following query to find and correct these mismatches in the 2.5 database. After running the query - rerun the Emerald 2.5 to 4.5 conversion process.

INSERT PayPeriods(PayPeriod, Period, Percentage, SetupCharge, GroupID, SortOrder)
SELECT DISTINCT PayPeriod,1,100,0,NULL,1
FROM MasterAccounts WHERE PayPeriod NOT IN (SELECT PayPeriod FROM PayPeriods)