web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / error, when opening ta...
Microsoft Dynamics NAV (Archived)

error, when opening table 'Page Data Personalization'

(0) ShareShare
ReportReport
Posted on by keoma 32,729

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

I have the same question (0)
  • Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: error, when opening table 'Page Data Personalization'

    What version?

  • keoma Profile Picture
    keoma 32,729 on at
    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.

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,967 Super User 2025 Season 2 on at
    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)))

  • Community Member Profile Picture
    Community Member on at
    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))).

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,967 Super User 2025 Season 2 on at
    RE: error, when opening table 'Page Data Personalization'

    hi, if your question is answered, please verify. thx.

  • keoma Profile Picture
    keoma 32,729 on at
    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.

  • keoma Profile Picture
    keoma 32,729 on at
    RE: error, when opening table 'Page Data Personalization'

    also thanks sandeep.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans