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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.
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.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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.