Add HR Module after upgrading GP from GP 2010 to GP 2013 SP2

(0) Share

Report

Posted on by Mohamedaldakak

115

When I add HR module after Upgrading GP from GP 2010 to GP 2013 SP2 and run utility i get this error in stor proseduer

The following SQL statement produced an error:
CREATE PROCEDURE hrGetMaxCompTrxNum @outNEXTRECNUM NUMERIC(14,5) OUTPUT, @O_iErrorState INT OUTPUT AS SET @outNEXTRECNUM = (SELECT ISNULL(MAX(CMRECNUM)+ 1, 1) FROM TATX1030 WITH (INDEX(AK8TATX1030)) WHERE ATTTRXSTATUS IN (3,4)) return(@@ERROR)

ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'ATTTRXSTATUS'.

any one can help me

*This post is locked for comments