cancel
Showing results for 
Search instead for 
Did you mean: 

Sender File with FCC coming with empty file

mf_haq
Active Participant
0 Kudos

Hi Experts,

Scenario: File(FCC) to Proxy

Error: CSV file picking up from source directory but its showing empty in sender CC (Actual file contains data in source directory) and find below attached Conversion parameters. Please let me know if any changes in the configuration.

Document Name: MT_Legacy

Document Name space: http://retails.com/pi/LEGACY/Purchasing/TECHNICAL_DATA

Recordset structure: Header,,Items,

Recordset sequence: Ascending

Keyfiled names: NumFacture,Constant

ignoreRecordsetName----


true

Header.fieldNames----


a,s,d,f,g,e

Header.keyFieldInStructure----


ignore

Header.keyFieldValue----


05

Header.endSeparator----


nl

Header.fieldSeparator----


;

Similar to Items also

Query: is this error related to source file (unexpected format) or Sender File CC configuration.

Regards,

FHM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Haq,

I see that there are two keyfield names in your content conversion. Are they for different nodes?

" Keyfiled names: NumFacture,Constant "

And also the you have provided key field value as 05 and what about the other key field?

Thanks,

mf_haq
Active Participant
0 Kudos

Hi HK,

I see that there are two keyfield names in your content conversion. Are they for different nodes?

" Keyfiled names: NumFacture,Constant "

Yes...those are coming from two different nodes like one from Header and another one from Items.

And also the you have provided key field value as 05 and what about the other key field?

Another key field value have given 43

one more thing Key filed value must be always constant right?

Thanks,

Former Member
0 Kudos

Yes, the keyfield value must always be a constant.

I think something wrong in your configuration. The recordset struture is not defined properly. Check it properly.

Thanks,

mf_haq
Active Participant
0 Kudos

Hi HK,

Recordset Structure has configure like this Header,,Items,

Anything needs to be change in this....please let me know

CC always showing Empty after doing all above suggested.

Thanks,

FHM

Former Member
0 Kudos

It depends on the occurance of the nodes. Do it accordingly.

mf_haq
Active Participant
0 Kudos

HK,

Am unable to get type problem with this.

Have phased similar issue earlier. its looking me a bit tricky...no error nothing...how can we fix this

Please share if any idea..

Regards,

FHM

RKothari
Contributor
0 Kudos

Hi,

Check the RecordSet Structure configuration.

I guess it follows the convention of NameA, nA,NameB, nB.....

where nA or nB....= 1, 2, ....,* i.e. the occurance of the field.

In you case it should be: Header,1,Item,*

-Rahul

mf_haq
Active Participant
0 Kudos

Hi Rahul,

I have done the same but no use.

Configure Recordset Structure: Header,1,Items,*----


but getting empty file only

I have tried processing mode with----


process empty files....then empty file coming in SXMB_MONI (No Vlues)

Please advice on this.

Regards,

FHM

former_member207622
Contributor
0 Kudos

Does your file directory and file has read write modify permissions

check your file chanel proper directory and file name is mentioned over there , remember its case sensitive

check with BASIS

regards

Ninad

mf_haq
Active Participant
0 Kudos

Hi,

I do have full authorizations for the folder.

basically we are testing from Exchange area. where i have check from folder properties and securities. it contains full control.

if anything else please let me know.

Regards,

FHM

RKothari
Contributor
0 Kudos

Hi,

What is the Key Field Type you have mentioned??

If its String than enter the below parameter for header and item as mentioned below:

Header.keyFieldValue----


"05"

Also, I hope the single quotes are used for parameter endSeparator value:

Header.endSeparator----


'nl'

Do you see any issue in Audit log entry of the sender CC?

-Rahul