mibuso.com
Home› NAV Three Tier

Unable to compare operands of type NavInteger with NavCode on one user

BalwanBalwan Member Posts: 12
in NAV Three Tier
I get error "Unable to compare operands of type NavInteger with NavCode. Page must close" only on one user, on custom page/table I created. Interesting is that I can start page on server, with user's credentials. On other workstations I get same error.
Other users can access same page without problems.
I tried to recompile table/page, restart service but no effect. Table has 2 code fields and several flowfields with lookup. There is no mismatch in data types in connected tables.

Answers

  • SanderDkSanderDk Member Posts: 502
    What version are you running?
    If you are running Classic NAV: - Try to delete zup file.
    If you are running RTC: - Try to remove all user personalization from that user
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • BalwanBalwan Member Posts: 12
    I'm on NAV 2015. On server side I have app server&sql server. Clients are installed on workstations.
    Please clarify where to look for personalization.
    Thank you!
  • BalwanBalwan Member Posts: 12
    Found it...
    I deleted PersonalizationStore.xml and no effect. Also, I checked table 2000000075, User Metadata and there is no records for my page.
  • SanderDkSanderDk Member Posts: 502
    on the client computer there is a file
    "%temp%\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\PersonalizationStore.xml"
    Have you delete that on too? together with emptying the table?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • BalwanBalwan Member Posts: 12
    Yes, still no effect, same error just for that user.
    Interesting thing is that page is working when I start NAV using "/runas my_user" command on server.
  • SanderDkSanderDk Member Posts: 502
    That is kinda the problem, it shows that the error your are faceing is only for that computer.
    That is why I suggested that you delete the locals files.
    Quick question after you delete the client file, did you go into NAV on a differet computer and press delete user personalization, and after that restarted the client computer?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • BalwanBalwan Member Posts: 12
    I didn't restart client computer. Specific user profile gives me error on 2 different computers (one of those is mine). I am able to start app as this user, on my computer, using /runas credentials. Page is not working on my computer while it is working when I try with my account. Also, page is working on other computer with different credentials. On server everything works fine, with any user :(
  • BalwanBalwan Member Posts: 12
    Finaly solved it...deleted record for specific user in table 2000000075, User metadata and file PersonalizationStore.xml in %temp%\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\. I had difficulties to find metadata for specific user since I had to find out SID. Anyway, problem solved. Thanks for helping me.
  • SanderDkSanderDk Member Posts: 502
    The ssid is in the user table for future information.
    But great you succeeded
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • krikikriki Member, Moderator Posts: 9,116
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.