Finance | Project Operations, Human Resources, ...

Issue removing employee from Projects WBS

(0) Share

Report

Posted on by Liam Tran

When trying to remove an employee from Project WBS, received the error

"SQL statement: SELECT SUM(T1.WORK),SUM(T1.REMAININGWORK),SUM(T1.ACTUALWORK),SUM(T1.DURATION),SUM(T1.DELAY),SUM(T1.OVERLOAD),SUM(T1.PERCENTWORKCOMPLETE),COUNT(T1.RECID) FROM ARPTASKS T1 WHERE (((PARTITION=?) AND (DATAAREAID=?)) AND ((((PLANMODELID=?) AND (PROJID=?)) AND (PARENTUID=?)) AND (WORK<>?)))"

The employee was terminated from the Human Resources module before removing from projects. We added the employee back into the Human Resources module as an employee and user but still receive the same error.

All responses (3)

Answers (0)

Satya Teki on at

Like (0)

Report

RE: Issue removing employee from Projects WBS

Hi Liam,

Please log a support incident and we go ahead with fixing it.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Issue removing employee from Projects WBS

Hi Liam,

I would recommend opening a support case with MS on that issue.

Best regards,

Ludwig
Liam Tran 5 on at

Like (0)

Report

RE: Issue removing employee from Projects WBS

The error that instigated this error is

"SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int."