on 04-02-2007 10:47 AM
HI All,
I am gettng
"Consistency error: field(s) missing - specify 'lastFieldsOptional' parameter to allow this"
What this error means?
Hi Ankur,
can u give ur input file and structure of output file required?
check this blog if it could help ur requirement :
/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30
Thanks,
Maheshwari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ankur,
use fieldFixedLengths if lenght of field is fix,
u will obiviously get error when lenght og filed is different than that of configured length.
Go through this weblog so u will get an idea of fieldFixedLengths
/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file
Thanks,
Maheshwari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The problem...
'
Field Max Length
X 3
Y 4
ideal structure of file.. should be
XXX YYYY
or
(ii) XX YYYY
But in my situation it is coming like...
(ii) XXYYYY if the X field is of two value instead of 3 .
so if use my logic adapter will pickup XXY in one field and YYY as second...
If field lenght is smaller the maximum then file should have spaces to file upto max lenth ..
but this is not the case with my situation..
i guess we cannot read such kind of file where we are not sure of the file structure..
Hi,
check in Data type definition , there in detail column , double click , check the min length, maxlength..if it is there, change accordingly.
but this will not give any erro , it will truncate the input length of data to specified .
Also check the content conversion processing parameters , try to add the following
eg.
Recordstructure.fixedLengthTooShortHandling = Cut
Regards
Chilla
Hi Ankur ,
This parameter specifies whether the last fields can be omitted (YES) or not (NO) in a CSV structure. If you do not make a specification, the default value is NO.
Can u tell ur requirement?
Thanks,
Maheshwari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Maheshwari,
As per the requirement XI is supposed to read legacy system generated text file having a particular format...
this error is coming when the total length of sourc value is not as per the total lenght of the data type defined in IR..
because when i am increasing the length of data by inserting some value making its total length equal to total lenght of data field i am able to read the data...
i have used 'totaldigit' for specifying the possible maximum lenght of the integer field.
is it correct...
Hi,
probably in your source data file the ending field/s is/are missing
Regards,
Jakub
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try:
lastFieldsOptional=YES
as per:
http://help.sap.com/saphelp_nw04s/helpdata/en/0d/00453c91f37151e10000000a11402f/content.htm
the default is NO
Regards,
michal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.