Quick Jump Menu
Advanced Search Search the Knowledgebase
Cursor Not in Valid State
Author: Bruno Reference Number: AA-08135 Views: 431 Created: 2018-04-26 10:52 Last Updated: 2018-04-26 10:52 0 Rating/ Voters


Core

If encountered when clicking “Personal Details”.

This message will be prompt as per below :


Solution:

With help from Developer, there are duplicate records at Core à Personnel Details à Email with contact location "ePortal" for 1 employee.

NOTE: Possible reason will be duplicate records at Personnel details, this requires developer to zoom-in to check which employee is having such problem.


Income Tax

During processing of Income tax, encounter the following message:

Failed to process IR8A - Error message: - Key Violation [SYBASE][ODBC DRIVER] [ADAPTIVE SERVER ANYWHERE] General Error : SELECT returns more than one row

Reason:

The error indicates that one or more employees have the same 1 hire date. To know which staff is having problem do the following. Usually this is a problem for rehire staff where in user key in the same hire date of the person from the first record. 


Solution:

Steps1: Go to EPE Income Tax module and process income tax record by batches (E.g.. to select 10 employees at a time). This is procedure is for you to identify which employee is having the problem. However if you know the staff that might have this problem go to step 2.


Steps2: Go to EPE Core module à Personnel Details à  under Employment Status à  check the hire and cessation of the employee. Make necessary amendment, an employee record should not have the same hire date. 

Example:

Employee (1st record)

Hired on 10/1/1997 --- Terminated on 20/5/2008

Employee (2nd record)

Hired on 10/1/1997, no termination 

*After the adjustments go to EPE Income Tax module and process Income Tax record for those employees that failed.


Payroll

For the error 'Cursor not in a valid state. Select returns more than one row'. 

Reason:

One of pay elements with method: Formula which DOES NOT end with ; (semi-colon) and this pay element was already inserted into the pay records.

Solutions:

1. To check if this is a Formula Pay Element Id

Ø  Check the Formula, if it is setup correctly. Please note that the formula should end with a semi colon. Rectify & save. Retry again to mark the specific Pay Element Id as 'History'. 2. To check if all Formula Pay element id ended with; (semi-colon)

Ø  Go to Payroll module / pay element setup / click on 'Preview' / select formula

Ø  Check through on the formula setup to ensure that all end with ;

Ø  Also, check if user have inserted any pay element with the method "formula" for pay records

 

 


Attachments
Cursor Not in Valid state.pdf 0.3 Mb Download File
Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: