Error Messages and Meanings

InterBase Deadlock

SYMPTON: Users get this error first thing in the morning. If you examine the ccasib6.log file, you see the exception "EIBInterBaseError: deadlock".

CAUSE: The cause of this is usually related to an overnight backup or virus scan. If the ccasib6 process is running when an overnight backup or virus scan occurs (this will always occur if the CCDeviceAggregator process is running, but can occur even without the aggregator), and the overnight process accesses the KEYSTONE *.ib files, this will cause the deadlock condition when the users sign on in the morning.

SOLUTION: Modify the overnight backup or virus scan to exclude the *.ib files.

Multiple Rows in Singleton Select

During Calculate Payroll or in Timecard Maintenance

NOTE: As of version 1.8.42, this error is replaced with the more descriptive message 'CCPPERIOD_DATERANGE: Multiple periods found for specified date.'

This usually indicates that the check date falls within more than one of the defined payroll periods. A diagnostic query that you can run is as follows (substitute the check date where you see the date:)

SELECT * FROM CCPPERIOD_DATERANGE('Y', 'M', '3/15/07', 5)

If you receive the 'multiple rows in singleton select' error, this means there is more than one matching period for the date.

Exception EDBClientError: Key Violation

When adding an employee in Payroll Employee Maintenance

This indicates that for one of the category links not all of the associated company definitions have the same value for ACTIVE_FLAG.

Run this query and look at the LINK_ID column and see if any LINK_ID appears more than once:

SELECT DISTINCT
 LK.LINK_ID, LK.DESCRIPTION, LK.LINK_TYPE,
 LK.SUBTOTAL, LK.LINE_NO, LK.AUTO_ADD,
 CD.ACTIVE_FLAG COMP_ACTIVE
FROM PRTLINKS LK
INNER JOIN PRTCOMPDEF CD ON (CD.LINK_ID = LK.LINK_ID)

Then run this query to see the company definitions associated with that link:

SELECT * FROM PRTCOMPDEF WHERE (LINK_ID = :LINK_ID)

You should see differing values for the ACTIVE_FLAG field. Determine the correct value for this field and set all the definitions associated with the link to this value.

Unable to write to C:\ProgramData\GivenHansco\Keystone\Settings\ccwappsv.ini

During Keystone system activation or re-activation, if you see this message it indicates that the currently logged in user does not have ADMINISTRATOR rights (which are necessary only during activation/re-activation.)

You can either logout and log back in to Windows as ADMINISTRATOR, or right-click the Keystone icon and select "Run As Adminstrator."

After activation/re-activation, be sure to close Keystone and log back in to Windows as the correct user.