File is getting truncated in when writing to the application server

[parameshwari_palle]

Hi All,

When we write the File into AL11, some column fields are not getting displayed. Using transfer statement file data getting truncated in AL11.

Even though we download CG3Y, not able to view the complete data. Also observed that if the file length is divisible by 512 we are getting this issue.

Due to missing of some columns data, PI system does not able to read data and interface is getting failed.

Could you please suggest is there any file size limitation in AL11.

Eg: If my file is having 3 columns and 3 Rows, The Last row columns are getting truncated.

Regards

Parameshwari

Message was edited by: Matthew Billingham - fixed the wrong terminology.

[michael_kozlowski]

Standard length is 512 bytes in AL11. Creator of the file must provide LENGTH when GT 512 bytes.

For example: TRANSFER datarec TO fname LENGTH g_length.

[matt]

Michael Kozlowski wrote:

Standard length is 512 bytes in AL11.

This is nonsense. AL11 is a transaction for viewing files on the appserver file system. Nothing more. It has no standard length - any more than windows explorer has a standard length in Windows, or ls does in unix.

[matt]

Michael has given the answer (notwithstanding the terminology), yet the OP continues to agitate for answers. Therefore I have marked Michael's answer as correct and locked the thread.

[matt]

It is really important to use the correct terminology. Surely you understand that AL11 is merely a transaction for looking at the contents of the application server file system? The concept of "writing a file into AL11" is utter nonsense.

Your problem is truncation when you are using OPEN DATASET and TRANSFER when creating files on the application server.

[Former Member]

Matthew Billingham wrote:

This is nonsense ... utter nonsense.

As HAL said:

"I can see you're really upset about this. I honestly think you ought to sit down calmly, take a stress pill..."

Rob

Happy holidays!

[matt]

I can't do that, Dave.

[parameshwari_palle]

This message was moderated.

[parameshwari_palle]

This message was moderated.

[Former Member]

Even if you are not able to see the complete data from file within AL11,  you can view the full set of data by selecting the 'Download File as Text button on AL11 home screen.

Try this & download your file to your desktop and check the data.

[michael_kozlowski]

Did you tried it with LENGTH addition?

For example: TRANSFER datarec TO fname LENGTH g_length.

Also check whether dataset finally proper be closed.

[Former Member]

Hello Parameshwari,

Please check with BASIS and your OS team whether you have required read/write access to the particular folders while running the program.

Ask your respective team to give you full access for a limited period of time and then check. Hope this will definitely resolve your issue.

Happy Holidays!

Cheers,

Varun