JDBC to FILE Scenario

[former_member185881]

Hi All

Scenario is SQL to FILE

XI is correctly fetching data from SQL

problem is when file adapter is creating file in ftp then i am getting bank file

but when i am checking my communication channel in rwb there i can see correct payload getting generated over there.

Why I am getting blank file only in file i can see Message Type of receiver.

Regards

Dheeraj Kumar

[former_member200962 · Accepted solution]

you using any FCC? If yes confirm that the FCC is accurate.

What about space on your file server?

[former_member185881 · Accepted solution]

Hi Abhishek

No i am not using FCC over here as i want to create xml file.

space is also ok there.

Regards

Dheeraj Kumar

[former_member200962 · Accepted solution]

Why I am getting blank file only in file i can see Message Type of receiver.

you mean to say that once you open the file you are able to see only </MT_ReceiverStructure>? Is any other program assigned to read data from the file?

if possible try changing the FTP location (may be set-up a FTP in your desktop) and then re-generate the file.

[former_member185881 · Accepted solution]

Hi Abhishek / spantaleoni

Yes abhishek you are correct i can see only receiver message type nothing else

I tried same location from diff scenario its working fine.

I have tested my message mapping its correct thats you I am getting payload in my Receiver CC.

Any other input please

Regards

Dheeraj Kumar

[former_member200962 · Accepted solution]

I tried same location from diff scenario its working fine.

can you re-create file channel and receiver agreement?

[former_member185881 · Accepted solution]

Hi Abhishek

Ok I will try and let you know the result.

Regards

Dheeraj Kumar

[baskar_gopalakrishnan2 · Accepted solution]

I think more than one program or file adapter reads that file. I would suggest you to change the file name and location and try again. Also do some simple change in file cc, activate and restart the server.

[Former Member]

Have you tested your message mapping?