Timeout error after validating variable

building reports webintelligence
1

I created such a variable:

=NoFilter(Max(([Amount of All Transactions]/[Agreement Balance ( D )]) In([Servicing Account Nbr];[ProductGroup])))

Checked syntax, was correct so I validated it and then received a timeout error. At first I figured it was a local issue and I didn’t relate the timeout with what I was really doing so I tried a couple of more times. Apparently it dropped the webi processing server for a couple of minutes each time.

I didn’t know it was even possible to get such an outcome with a report-level variable. The conflicting functions seem to be the NoFilter() and In() or Max() and In(). They run separately, but combined are one heck of a recipe for destruction…

Has anyone ever encountered anything like this, dropping the whole damn server with just a report-level variable, did I create an infinite loop or what?

Hafsolace :estonia: (BOB member since 2010-08-27)

2

So, can you get the logic to work if you break it up with named variables?
It may have nopthing to do with it, but I would advise that you shiould avoid special characters in object / variable names.

[Agreement Balance ( D )]

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thanks for the prompt reply.

Perhaps I could get it to work as separate variables, but a workaround isn’t exactly what I’m looking for. What I meant was that those two functions work separately but I haven’t tried putting them both into the table at the same time, I’m guessing it will give the same result, the timeout. I’m just curious as to why it happened and I don’t want for it to happen again so I’m not touching it until someone internally investigates the issue.

Regarding the second comment, a valid suggestion but it is a universe-level object and ergo out of my domain as I’m just a reporting analyst. I also doubt it has anything to do with it because it has been successfully used countless times.

Hafsolace :estonia: (BOB member since 2010-08-27)

4

Fair enough, they should have a look in the server logs and try to ascertain what the cause is.

Possibly correct, however, when working with software, I have seen a number of such things have certain effects, at certain times, in the past.

Mak 1 :uk: (BOB member since 2005-01-06)

5

Hafsolace

Did you find a resolution/workaround to your problem. I have users who are experiencing similar timeout problems, and using reports with complex report variables (as you seemed to be). I’d be very interested in your outcomes.

rodlangham :uk: (BOB member since 2004-04-13)

6

I messed around enough with the syntax of the formula, keeping the same logic but with a different build and it worked.
A couple of months later I ran into the same thing in slightly different context.
By now, I’ve just filed these under “one of those things…”. I shiver every time I validate a context variable.

Hafsolace :estonia: (BOB member since 2010-08-27)

7

You could also look ar amending your Java run time variables on your Java client.

https://bobj-board.org/t/150661

Mak 1 :uk: (BOB member since 2005-01-06)