error, when opening table 'Page Data Personalization'

(0) Share

Report

Posted on by keoma

32,675

hi,

when i open table 'Page Data Personalization' (in RTC client) i get this error.

Microsoft Dynamics NAV
---------------------------

The supplied field name '1' cannot be found in the 'Page Data Personalization' table.

Page Edit - Page Data Personalization must close.
---------------------------
OK
---------------------------

there is no customization.

any ideas?

*This post is locked for comments

All responses (7)

Answers (1)

keoma 32,675 on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

also thanks sandeep.
keoma 32,675 on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

i found the solution. it was a bug in the with that version delivered cronus database. the field "User ID" is a flowfield, the calcformula was wrong. now it works.
Mohana Yadav 60,159 Super User 2025 Season 1 on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

hi, if your question is answered, please verify. thx.
Community Member Microsoft Employee on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

The problem comes from a flowfield calcformula.

The field User ID has the following calcformula: Lookup(User."User Name" WHERE (Full Name=FIELD(Field1))).

Change the formula into Lookup(User."User Name" WHERE (User Security ID=FIELD(User SID))).
Verified answer

Mohana Yadav 60,159 Super User 2025 Season 1 on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

the problem is with the CalcFormula of FlowFiled User ID.

Change it to Lookup(User."User Name" WHERE (User Security ID=FIELD(User SID)))
keoma 32,675 on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

nav 2013, build no. 7.0.38052, cronus database, no changes on that table, not converted from an older version.
Aleksandar Totovic 16,765 on at

Like (0)

Report

RE: error, when opening table 'Page Data Personalization'

What version?