 |
|||||
|
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 |
| Error code 416 | Login/Join |
| Virtuoso |
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION I get this error message, but do'nt understand it, what do I have to do The report I want to build works fine however...
| ||||||
|
| Member |
If it's a comma delimited file you're file contains to many commas (fields). Example: FILENAME=TEST,SUFFIX=COM,$ SEGNAME=RECORD,$ FIELDNAME =FIELD1 , E01 ,ACTUAL=A4 ,USAGE=A4 ,$ FIELDNAME =FIELD2 , E02 ,ACTUAL=A4 ,USAGE=A4 ,$ Data: AAAA,BBBB,CCCC,$ VVVV,XXXX,XXXX,$ | |||
|
| Virtuoso |
The data comes from a SQL database, so it must be something else...
| |||||||
|
| Expert |
I'm sure the explanation won't be of any help, but: ? 416 0(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION Freeform data, in which commas delimit each value, contain too many commas. Or, a field is identified by its order number in the Master File Description which exceeds the number of fields in the file. 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 | |||
|
| Member |
If it's an SQL table then if could be that the occurs value is incorrect For example: FILENAME=TEST,SUFFIX=SQLDS,$ SEGNAME=RECORD,$ FIELDNAME =FIELD1 , ALIAS=E01 ,ACTUAL=A4 ,USAGE=A4 ,$ FIELDNAME =FIELD2 , ALIAS=E02 ,ACTUAL=A4 ,USAGE=A4 ,$ FIELDNAME =FIELD3 , ALIAS=E03 ,ACTUAL=A4 ,USAGE=A4 ,$ SEGNAME=OCC, PARENT=RECORD, POSITION=FIELD1, OCCURS=4,$ FIELDNAME =FIELD , ALIAS=E04 , ACTUAL=A4, USAGE=A4,$ FIELDNAME =ORDER , ALIAS=ORDER, ACTUAL=I4, USAGE=I4,$ The above master description is incorrect because the occurs value should be (3) and not (4). This will result in a FOCUS 416. Are you using an OCCURS in your MFD? | |||
|
| Virtuoso |
thanks for the help Albert was right it was a comma delimited file. I overlooked the part of my report that used that file. The error came right at the beginning where my program used that file at the end.... (Focus hocus pocus...)
| |||||||
|
| Expert |
Frank, The song was Hocus Pocus by Focus not the other way around  T
| |||||||||
|
| Expert |
T, you do know that Focus were Dutch? F | |||
|
| Expert |
Sure did Francis, they were from my era  T
| |||||||||
|
| 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 |