nasty eda crash with format /AnV in sqlserver db

here's a mess that cost me a whole day..
when a field in an sql db is variable format,
FIELD/AnV,
and you don't perhaps know this in advance.
and you
TABLE FILE ..
PRINT FIELD ..
ON TABLE HOLD...
END
then later
TABLE FILE HOLD
PRINT FIELD ..
eda crashes and not just the agent...the whole eda dies an ugly death.
Repeated this , oh, 50 times yesterday.
Till i figured it out, and edited all the /AnV to /An before reading the sql.
Head stopped hurting now, but brickwall has major dent

Should I have known something in advance that I didn't ?

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Francis Mariani

Expert

posted

Hide Post

Susannah,

Wasn't there some kind of restriction that the AnV field had to be the last one in a TABLE FILE, and that you can have only one? I can't find the documentation on this though.

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

hammo1j

Master

posted

Hide Post

S.

Obviously you are a bit annoyed and may have this as the last thing in the world that you want to do, but could you post the precise code that killed eda since I have done what you describe many times without this behaviour.

When you say it killed EDA do you mean you had to reboot the entire server to get it working again?

Regards

John

Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo

Posts: 888 | Location: Airstrip One | Registered: October 06, 2006

Ignored post by hammo1j posted

Show Post

GinnyJakes

Expert

posted

Hide Post

Starting somewhere in release 7, when you generated the masters for relational engines, the alpha formats were changed to variable. I think that is because the real relational column is defined as a VARCHAR.

That cause quite a bit of havoc at our site as well. Our resolution was to put the following in the edasprof.prf where the connections are placed (and we have lots as you can see below):

ENGINE engine SET VARCHAR OFF

Then regen the master.

I don't know if you should have known that in advance. We just stumbled across it as well though we didn't have server crashes. We had failed joins.

I hope your head feels better.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Show Post

susannah

Expert

posted

Hide Post

Brilliant, Ginny. thanks.
Yes John, had to reboot the whole puppy.
Frankie, that sounds reasonable...

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

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted