CX_SY_FILE_OPEN_MODE Error while loading from AL11

[Former Member]

Hi Friends,

I am facing with a strange issue. I am running a process chain which loads two CSV files(two info packages) into the same DSO. Data is getting loaded for one info package while the other one is failing and i get this error message "An exception with the type CX_SY_FILE_OPEN_MODE occurred, but was neither handled locally, nor declared in a RAISING clause".

Both the files were in the same folder in AL11, Initially thought that the error could be due to both Info packages trying to access the same folder hence second Info package is not able to read the CSV file. Now, I have changed the folder structure( Created two folders) one for each file. Tried running the process chain but still the same issue.

Upon investigation I came across a scenario, the file which is throwing error, i did a bit of digging I can see the content of the file directly in AL11 transaction. However, when i try to link the file in the info package  under extraction tab that takes me to AL11 and the file path and then the file.

When double click on t.CSV file I get two options 1. Disp.Cont 2.Copy file name. I can copy the file name no issue, but when i click on the display content i get the folowing message "Unable to display the contents of this file" (Remember i can see the contents of this file if i use AL11 transaction directly).

To test what i have done is I have copied the above file on to the local work station and ran the Info package and guess what it sucessfully loads. The issue is only while loading from the application server and where the contents cant be dispalyed via the Info Package (I have double checked with some other files and the result is consistent) i.e where we cannot display content the error message is same.

Can someone please suggest how to handle this?.

Your help is appreciated.

Regards

BN

[Former Member · Accepted solution]

Hi Friends,

My issue is resolved. Its a simple but strange issue though.

In AL11 file path, the floder structure is like the following

"\\dunv-bw7-p2\sapmnt\BIP\DATA\Folder Name" and the file name.

In the infopakage  under extraction tab when we select the filename, it is copied as below

"\\dunv-bw7-p2\sapmnt\BIP\DATA\Foldername\file.csv." Here when the file name is copied from AL11 spaces are removedfrom the folder name(If any).

Solution is simple just make sure that the folder name in the extract tab is same as that of AL11 folder Name. (I know its strange as we just copy the file location from AL11).

Thanks to all for your quick replies and help.

Regards

BN

[Former Member]

Hi

It might be possible that you have multiple instance (SM51) and the file server mounting is done only from the central instance and not from secondary instances.

You can goto SM51, select the secondary instance and from the same screen goto Al11. Try to display the file. If this is giving error, some config by basis team will be required.

Thanks.

[Former Member]

Hi Jugal,

Thanks for the reply.

I checked SM51 there are two hosts. now the confusion is how do I check on which of these hosts is server mounting is done?.

I tried going to AL11 using transaction  \nAL11 and i can go to the directory and see the content of the file. My issue is cant viewing the content of the file when i try to give the file location in the extract tab from Info Package.

Regards

BN.

[Former Member]

Hi,

Please consult with your basis team. they should be able to resolve the mounting issue.

Also please check if you have sufficient authorization and authorization for the file (File attribute in Al11) ?

Thanks

[Former Member]

Hi Jugal,

This file which i am not able to load, has the same permissions as the other file which i am able to load. So, I am not sure if it is anything to do with file permissions. I will check with my Basis team as suggested.

Regards

BN

[former_member257204]

Thanks Jugal, in my case this was the problem.