Table Information Cannot Access In NAV2013R2

QuickWE

Hi All Expert

I tried to created a simple page by using Table Information(Virtual Table 2000000082) as Sourcetable but unfortunately it was show SQL error.

Can you tell me for solved this problems.

Thank in advance for every replies. :P

postsaurav

Hey,

What is the error message.

Below is the article where it seems that the table is accessible.

http://saurav-nav.blogspot.in/2015/01/nav-2013-r2-later-table-information.html

Let me know the error message.

QuickWE

postsaurav wrote:

Hey,

What is the error message.

Below is the article where it seems that the table is accessible.

http://saurav-nav.blogspot.in/2015/01/nav-2013-r2-later-table-information.html

Let me know the error message.

Here's the error message
"The following SQL error was unexpected.
The nvarchar data type cannot be selected as DISTINCT because it is not comparable.
Statement(s) could not be prepared."

I tried to do following your blogs, But unfortunately it 's still doesn't work.

Thanks in advance for your suggestion.

postsaurav

Hi,

What is the EXE Build that you are using?

QuickWE

postsaurav wrote:

Hi,

What is the EXE Build that you are using?

I'm using Build NAV2013R2 (7.10.37563)

GreatScott000

Has anyone found a solution to this problem? I have converted my DB to build 42610 and still have the problem. I can't delete the table objects and reimport them because this is client data upgrade.