Hi
I have problems to upgrade AX2012FP to AX2012R2, I follow Micosoft Upgrade Guide, deleted CUS model and USR models and started code upgrade (takes long time :( )
After Code upgrade i got this error messages
Cannot select a record in Worker (HcmWorker). Name: 0.
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PARTITION'.
SQL statement: SELECT TOP 1 T1.PERSON,T1.PERSONNELNUMBER,T1.MODIFIEDDATETIME,T1.MODIFIEDBY,T1.CREATEDDATETIME,T1.CREATEDBY,T1.RECVERSION,T1.PARTITION,T1.RECID FROM HCMWORKER T1 WHERE ((PARTITION=?) AND (PERSON=?))
Query extended range failure: Error occurred when executing the passed in function.
Cannot select a record in Current user's roles (MyRoles). Role identifier: 0.
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PARTITION'.
SQL statement: SELECT TOP 1 T1.RECID FROM tempdb."DBO".t100145_E7CB69AB966F4EFE88DC00FEB801E701 T1 WHERE (T1.PARTITION=?) AND EXISTS (SELECT TOP 1 'x' FROM DIRPARTYLOCATIONPRIVATEROLES T2 WHERE ((T2.PARTITION=?) AND (T1.ROLENAME=T2.SECURITYROLENAME)))
Query extended range failure: Error occurred when executing the passed in function.
Cannot select a record in Current user's roles (MyRoles). Role identifier: 0.
The SQL database has issued an error.
Is this common problem and is it ok to go forward to complete the checklist ?
