Filters on a Boolean Field don't work in Pages German (DEA)

Troubles_In_Paradise

Hi guys,

I've one terrible issue on a NAV 2009 R2 RTC Austrian db.
I explain...
Create one simple page (no matters type):

in this example a list: ('*' to indicate indentation)

Container	ContentArea	
*Group	Repeater	
**Field	"No."
**Field	Name
**Field	"Only Distributive"
("Only distributive" is a custom Boolean field)

than put the following code:

OnOpenPage
SETRANGE("Only Distributive",TRUE);

Now we can run the page. If RTC is in english filter is applied (as expected) but, if RTC is in German (DEA) filter isn't applied (see attachments).
:shock: What the hell???

Have you ever see something like this?
Build: 33137

thanks in advance.

Troubles_In_Paradise

Solved. There was something wrong in language folders installed on the NAV Server.

Mauddib

I am having an identical issue to this myself now.

It is not only when you use SETRANGE - but also happens if you set the filter when calling a Page from the Role Centre. Any boolean filters set simply disappear.

The "fix" above is a little vague. Does anyone know what the "something" that was wrong is and how to fix it?

Troubles_In_Paradise

Mauddib wrote:

I am having an identical issue to this myself now.

It is not only when you use SETRANGE - but also happens if you set the filter when calling a Page from the Role Centre. Any boolean filters set simply disappear.

The "fix" above is a little vague. Does anyone know what the "something" that was wrong is and how to fix it?

Probably some corrupted files in the language folders on NST.
We copied folders from the installation DVD, overwriting existing and it worked.

Mauddib

Exactly what I have done, with the difference being that it has not worked Damn

Troubles_In_Paradise

Have you already restared the service?

Mauddib

Yeah I have restarted the service too.

Downloaded the language pack from mibuso also and installed the folders that way too. Neither has helped.

It is a mystery at present.

Mauddib

Ok copying the folders did not work and a straight install of the language module did not work.

However if anyone else has this issue in the future... this DID work....

1) Stop your service.
2) Manually DELETE the DEU ENU and DE-de folders from your Database Middle Tier installation folder.
3) Then run the language module installation program.
4) Restart your service.

Having done this the problem resolved itself. Of course this does not explain what the problem was, or what fixed it, but at least it works.

Thanks for fast replies.