Variable behaves differently on Server

[#1]

Hi.

I am baffled. I've got a variable that works fine on my desktop and on a staging server, but once on the production access point, the variable comes up null (using the same data and filters.

The variable's name is vQBRFYstartMonthDate, as is defined as:

=Addmonths(IF($(vQBRFYstartMonth)=1,

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)+11)),

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)-1))),-11)

This returns a date.

On the server, the variable fails, but the funtion works find. Yet on my local file and on a staging server, the variable works fine.

What give? I hope I am not overloking something silly...

[#2]

Yes, I am engaging with them today. Thank for your help nonetheless.

Here is a new piece of information:

I just created a second variable with the exact same definition as the failing one. This one works!!!

So, to recap:

Failing variable:

vQBRFYstartMonthDate =Addmonths(IF($(vQBRFYstartMonth)=1,

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)+11)),

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)-1))),-11)

Working variable:

vQBRFYstartMonthDateB =Addmonths(IF($(vQBRFYstartMonth)=1,

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)+11)),

NUM(makedate($(vQBRDYselectedYear),$(vQBRFYstartMonth)-1))),-11)

Both expressions are identical.

Thoroughly baffled.

[Clever_Anjos]

Thoroughly baffled too...

[#4]

This is happenning again, with another variable.

Please help

[Clever_Anjos]

Maybe because is Halloween today

It seems very very weird to me.

[#6]

Hi all.

Just closing the loop on this issue. We resolved it by deleting Server objects which had been accumulating over time. Then all broken vairables started working agains.

Has this limitation been documented? or is it a bug?

I also noticed that when you manually delete a sever object from the dashboard surface (by right+clikc + remove), a copy of the object is still listed in the Server object management widget. So no wonder I had a lot of objects accumulating.

Thanks all for your help