Focal Point
Anyone hit a limit on FEX size [CLOSED]

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3717093376

November 03, 2014, 10:09 PM
Waz
Anyone hit a limit on FEX size [CLOSED]
Has anyone hit a limit on a focexec number of lines ?

We have one over 13K, but I'm about to generate one significantly larger.

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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 04, 2014, 12:24 AM
Ram Prasad E
I have one for 95K. Most of the time when I work in developer studio, file gets corrupted and becomes 0k. So to edit this fex, I used to work directly in webconsole.

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
November 04, 2014, 03:29 AM
Rifaz
In my past experience, didn't notice the fex size, but I'm sure, might have a bigger one than 13K. Because of exceeding the line limitation, server crash happened. So, have to set MESSAGE parameter to OFF.


-Rifaz

WebFOCUS 7.7.x and 8.x
November 04, 2014, 07:17 AM
Pravin.Singh
I never came across such situations and didn't notice as well. But good to have in knowledge.

Thanks to All,
Pravin


WebFOCUS 7703
Windows, All Outputs
pravinsinghwebfocus.blogspot.com
November 04, 2014, 07:43 AM
Waz
Well this is going to be interesting.

My fex generates a second fex to do a load of work.

The second fex has 2.8 million lines, and it is still running, about half way though.

Sweating


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 04, 2014, 08:44 AM
George Patton
I have a couple that are very long with a lot of MODIFYs, MATCH FILES etc. But I don't like working on very long files (short attention span!) so I have them broken into manageable sections and pull them together in one very short FEX with -INCLUDE statements.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
November 04, 2014, 01:42 PM
EricH
Our largest is 165K - not counting -INCLUDEs. We've had no issues up to now - but 2M rows is certainly pushing things.

Let us know how this turns out.

EricH
November 04, 2014, 03:00 PM
Waz
The real issue here is a slow degradation of performance.

I had fixed this years ago, but with many update and changes to the program, its crept back in.

My gut feeling was that it has something to do with -REPEAT loops, but that may not be it.

This was an attampt to produce a single fex that ran end to end with no loops, but the issue is still there.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 04, 2014, 05:36 PM
susannah
MAXCOMMANDS an issue??




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
November 04, 2014, 05:58 PM
Waz
MAXCOMMANDS, not heard of it before.

Can't find any details on it.

What does it do ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 05, 2014, 11:23 AM
susannah
and of course i can't find it this morning either. and i can't seem to recreate it...
Still looking....
but in the meantime, what i can find is IBIF_max_messages
M:\srv76\home\etc\cgivars.wfs(58): IBIF_max_messages
M:\srv76\home\etc\cgivars.wfs(59): IBIF_max_messages=20000
M:\srv76\home\etc\enib00e.html(2360): Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted.
M:\srv76\wfs\etc\cgivars.wfs(58): IBIF_max_messages
M:\srv76\wfs\etc\cgivars.wfs(59): IBIF_max_messages=20000
..
https://techsupport.informatio...om/sps/90982011.html
that little bugger you can set to 0 for unlimited




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
November 05, 2014, 02:31 PM
Waz
Yes, I have had to manage the output returned with ECHO, etc


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 12, 2014, 03:51 PM
Waz
I'm closing this thread.

The 2.8 million lines failed, but not due to the size.

I guess the limit is only limited by resources.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!