(closed)ERROR MESSAGE TEXT MISSING: 0

September 11, 2012, 11:13 AM

Anybody know what this means? Can't find anything about it.
(FOC000) ERROR MESSAGE TEXT MISSING: 0

Here's the fex. No I can't duplicate with the CAR file. Yes the data is in HOLD_08 and is the correct format.

 TABLE FILE ZW_ZMEVENTS_DETAIL
PRINT
NOMINATION_KEY_ITEM_LEVEL_01
DTPASDF_NAME
STRASDF_NAME
IF  VNOMINATION_KEY_N IS (HOLD_08)
END

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

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

September 11, 2012, 12:16 PM

Tony A

Hi Prarie,

How many entries are there in HOLD_08 and what RDBMS is ZW_ZMEVENTS_DETAIL?

If there are over 1000 entries in the file and your RDBMS is Oracle or MS SQL then they have a limitation of only allowing 1000 entires within an "IN" statement (which is what WF produces - look at the SQL).

If not either of these them please elaborate.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

September 11, 2012, 01:50 PM

Prarie

Hi Tony.

I was thinking maybe a limit thing.
this has 700
It is actually a SAP BW query

September 11, 2012, 02:03 PM

j.gross

Suggestion -- See what happens if you use "WHERE ... IN FILE ..." syntax.

(Even if that also fails, it might tickle a differrent part of the error message generator.)

- Jack Gross
WF through 8.1.05

September 11, 2012, 03:31 PM

Prarie

Thanks Jack. You know I had tried that before and blew off the message I got. Dohhhh to me.

I was saving HOLD_8 and calling HOLD_08.

This was a step in 36 step program...so I missed the 0.

It's the little things sometimes...thanks for helping me point out the obvious...

September 11, 2012, 04:29 PM

Tony A

You're not on the Miller Lite already are you?

September 12, 2012, 09:50 AM

Prarie

I wasn't at the time...but they were there waiting for me after the day of banging my head on the desk..

September 13, 2012, 10:27 AM

George Patton

Don't feel bad... I spent an hour yesterday trying to figure out why a TABLE request got hung up on 'YEAR'. Turns out I had 'YESR' in my DEFINE. Grrrrr....

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

September 13, 2012, 10:38 AM

Prarie

Dang little things...