[SHARING] LAST Function gives EDASERVE crash error

In Webfocus 7.7.04, I can't use the LAST function on a field greater than A254V in the TABLE FILE section. It gives that dreaded EDASERVE error that gives you absolutely no clue as to what the problem is.

I tried looking it up in the manual to see if I missed a limitation or something, but I can't find one (not to say that it is not out there). So, I'm making this public service announcement in case somebody can't find it either.

For example:

This will crash the agent:

DEFINE FILE CAR
CAR2/A255V=CAR;
END
TABLE FILE CAR
PRINT COMPUTE CARLAST/A255V=LAST CAR2;
BY COUNTRY
BY CAR2
ON TABLE PCHOLD FORMAT HTML
END

But change it to this and it runs happily along:

DEFINE FILE CAR
CAR2/A254V=CAR;
END
TABLE FILE CAR
PRINT COMPUTE CARLAST/A254V=LAST CAR2;
BY COUNTRY
BY CAR2
ON TABLE PCHOLD FORMAT HTML
END

And using LAST in the DEFINE is just fine too:

DEFINE FILE CAR
CAR2/A255V=CAR;
CAR3/A255V=LAST CAR2;
END
TABLE FILE CAR
PRINT CAR3
BY COUNTRY
BY CAR2
ON TABLE PCHOLD FORMAT HTML
END

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

WF 8.1.05 Windows

Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006

Francis Mariani

Expert

posted

Hide Post

Uh oh!

A11000V works fine in v7.7.03...

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Anatess

Guru

posted

Hide Post

quote:
A11000V

That's sooo interesting! It works in 7.7.04 too!

A256V does not crash but it returns empty! I'm going psychotic...

So, here are the stunning results:
A257V only returns the first character.
A258V returns 2 characters.
A259V returns 3 characters.
... and so on and so forth...

Francis, can you try A255V and A256V and A257V and see what happens?

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

WF 8.1.05 Windows

Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006

Ignored post by Anatess posted

Show Post

Francis Mariani

Expert

posted

Hide Post

These all work fine in v7.7.03, and in our v7.7.04 sandbox environment.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Anatess

Guru

posted

Hide Post

Now, THAT's really really interesting! What patch number do you have on 7.7.04?

WF 8.1.05 Windows

Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006

Ignored post by Anatess posted

Show Post