Hai all..

My report that is ran from a dashboard has few selection criteria. It works fine in DEV environment and so its moved to QA and then PROD.

Now, there is a problem with one selection criteria in QA and PROD which gives the error message "Unknown problem. Agent on EDASERVE may have crashed". But for the same selection criteria there is no problem in DEV. Is this because of any server settings or problem with code?

I found a point of code where the crash is occurring. But I don't understand why its fine in DEV and getting crashed in QA and PROD.
Please post your experiences regarding this.

Thanks all..

This message has been edited. Last edited by: Kerry,

Are all three servers at exactly the same version?

Please post the code that you think is crashing the server, particularly the selection criteria.

yes..they are all same version. this is the code

-SET &WHERE_GA = 'WHERE G_A EQ &ACC';

table file abc
print *
where x EQ y;
&WHERE_GA
end

Its getting crashed at the where condition just ablove the end statement. &ACC countains a built string. Due to some conditions it needs to be assigned there on the top using SET.

Let me know if you need more info..

Thanks..

What is the value of &ACC when it crashes?

Enigma,

I'd change:

-SET &WHERE_GA = 'WHERE G_A EQ &ACC';
...
where x EQ y;
&WHERE_GA

to:

-SET &WHERE_GA = 'WHERE G_A EQ ''' | &ACC | ''';
...
where x EQ y
&WHERE_GA ;

Don't know why it work in Dev and QA, perhaps testing wasn't through enough. Customers are good at breaking supposedly good code

Dave, it did not work actually. that code works in DEV but not in QA.

Francis, ACC keeps adding a string from list box. listbox has a space (value added by deault by composer) by default and it causes a problem when it's selected along with 4 strings from listbox.

my built string looks like 'a' OR 'b' OR 'c' OR 'd' OR 'e' OR ''

This is from DEV. But same returns crashed agent in QA. It works till 'a' OR 'b' OR 'c' OR 'd' OR '' . When 'e' gets added it crashes.
I have no clue why its fine in dev and crashing in QA.

Ok, my suggested -SET code is wrong for your 'built string', but you should get rid of the semi-colon between your two WHERE's.

quote:

you should get rid of the semi-colon between your two WHERE's

I wonder why...

This might be the culprit, though I cannot explain why it works in Dev and not in the other environments:

-SET &WHERE_GA = 'WHERE G_A EQ &ACC';

I don't think &ACC will successfully get replaced in that statement.

Try changing the -SET command:

-SET &WHERE_GA = 'WHERE G_A EQ ' | &ACC;

E.G.:

-SET &ACC = '''ENGLAND'' OR ''FRANCE'' OR ''ITALY'' OR ''CANADA'' OR ''JAPAN'' OR ''S KOREA''';
-SET &WHERE_GA = 'WHERE COUNTRY EQ ' | &ACC;

TABLE FILE CAR
SUM
SALES
BY COUNTRY
&WHERE_GA
END

If I code -SET &WHERE_GA = 'WHERE COUNTRY EQ &ACC;
the fex line looks like
WHERE COUNTRY EQ &ACC;
and I get an error:

ERROR AT OR NEAR LINE 11 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: &ACC

Would this also be safer to code this as an IN statement?

-SET &ACC = '''ENGLAND'',''FRANCE'',''ITALY'',''CANADA'',''JAPAN'',''S KOREA''';
-SET &WHERE_GA = 'WHERE COUNTRY IN (' | &ACC | ')';

Firstly thanks all for your suggestions..

Waz, some how I came up with same thing you showed. its working..