 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Error Foc336 | Login/Join |
| <anubhasaini> |
Hello, while selecting master file for creating report in report painter i get an error Error parsing master file "File Name" ((Foc336) the sum of all field lengths exceeds maximum.(336)) Can anyone help.This message has been edited. Last edited by: Kerry, | ||
|
| Expert |
If you want a full explanation of any error code then open the Dev STudio command console and type ? errornum where errornum is the error you wish to see. In your case - ? 336 This gives - (FOC336) THE SUM OF ALL FIELD LENGTHS EXCEEDS MAXIMUM. The sum of the lengths of all fields in a structure exceeds the limit. The default limit is 32,768 bytes. Reduce the number and size of the fields in the file, or eliminate JOINs and cross-references if possible. In other words the size of the master that you are trying to access has fields that, when all the lengths are added together, exceeds a WebFOCUS limit. That being 32Kb! You need to reduce the size of your master file. | |||
|
| Expert |
Is this the (length of the fieldnames) or (the width/size of the data contained within those fields)? So, we can "PRINT *" more fields if the fieldnames/data sizes are smaller? I couldn't find the documentation on this. What's the "Limit" in 7.6.11, still 32kb?
| |||||
|
| Virtuoso |
77: (FOC336) THE SUM OF ALL FIELD LENGTHS EXCEEDS MAXIMUM. The sum of the lengths of all fields in a structure exceeds the limit. The limit is 262,144 bytes. Reduce the number and size of the fields in the file, or eliminate JOINs and cross-references if possible. It concerns the total size of the contents of all fields, not the fieldnames. GamP
| |||||||||
| ||||||||||
| Expert |
Thanks GamP, Do you think/know if that changed in 76x or 77? We may be going to 77 soon. But, in the meantime??? | |||
|
| Expert |
Doug, Issue ? 336 to get the message relevant to your release (should contain the limit if I remember correctly). T
| |||||||||
|
| Guru |
Doug, That limit has not changed in 77 or 8 as far as I know. David Glick Director WebFOCUS App Studio and WebFOCUS Developer Studio WebFOCUS Division Information Builders, Inc. Direct (917) 339-5560 Voice Mail (212) 736-6250 x3560 Fax (212) 947-5168 Email david_glick@ibi.com | |||
|
| Expert |
Thanks guys, I get the following: ? 336 (FOC336) THE SUM OF ALL FIELD LENGTHS EXCEEDS MAXIMUM. The sum of the lengths of all fields in a structure exceeds the limit. The default limit is 65,536 bytes. Reduce the number and size of the fields in the file, or eliminate JOINs and cross-references if possible. ? VERSION EDA7612 Release * Current Software: EDA7612 Release RELEASE = R727612B EDA7612 Release GEN_NUM = 421 EDA7612 Release SOURCE_DATE = 06/02/2010 16:02:45 EDA7612 Release BUILD_DATE = 06/03/2010 11:52:44 So, when did this change to "262,144 bytes"? Sometime between 7612 and 77? | |||
|
| Virtuoso |
IB probably increased this going from 76x to 77 GamP
| |||||||||
| ||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |