12.2.3 Upgrade Error with Shared Directory File

Hi All,

In SAP jobs, we have set the shared folder to point to \Server\Folder to pick up the data file, but when the job runs, the jobs shows that the file path was showing //Server/Folder which was wrong and job failed. To prove this, we change the path to use local directory D:\Folder\ and it is able to correctly showing the path D:\Folder\ and able to pick up that file but then it gives another error when picking up the file as the jobs shows D:\Folder/File.ABAP instead. So we deduce that there could be a potential bug inside the BODI sap program.

Can anyone tell me how to resolve this? We encountered it during the upgrde to 12.2.3.2

regards,
Barry
BODI SAP Error.zip (267.0 KB)


barryn_99 (BOB member since 2009-06-15)

You said you are upgrading…

So are you using the same System account in old version and does the job runs fine?
I would say don’t bother about the slashes getting converted

I would personally wish not to give Share Directory path for DI stuffs. I feel it really tricky. Instead why don’t you try creating Map Network Drive and access that there?


ganeshxp :us: (BOB member since 2008-07-17)

Hi Ganesh,

Tks for replying.

Under the previous version of before the upgrade, the ids and folder path under shared directory is working fine with no issues.

What could have happen?

regards,
Barry


barryn_99 (BOB member since 2009-06-15)

Let’s ask the question again:

In start -> control panel -> administrative tools -> services -> BO DataServices -> Logon, what are the two installations show there? If it is local system account, that local user has no privileges on any network share.


Werner Daehn :de: (BOB member since 2004-12-17)

Hi Werner,

Tks for ur reply.

We are using a network account with access rights given to access the designated folder inside the SAP server. We had tested it before to open up the folder and able to see and access the files directly from our ETL server.

regards,
Barry


barryn_99 (BOB member since 2009-06-15)

Hi Werner,

Tks for ur reply.

We are using a network account with access rights given to access the designated folder inside the SAP server. We had tested it before to open up the folder and able to see and access the files directly from our ETL server.

regards,
Barry


barryn_99 (BOB member since 2009-06-15)

In the first issue it is saying that the jobserver cannot read the file, so I need proof it can.

In the second issue the SAP system cannot write to the D:… folder.

If there are / or \ it does not matter, DS converts it to the proper ones.


Werner Daehn :de: (BOB member since 2004-12-17)

Hi Werner,

Tks for ur replies.

Ok, I will try to get a screen for this.

For the second issue, I will investigate further since u mentioned / or \ does not matter.

Tks for the direction.

regards,
Barry


barryn_99 (BOB member since 2009-06-15)

Hi Werner,

We had verified that the account (used by the BODS service) is able to access the shared folder in the SAP application server and we are able to see the ABAP files there (using mapped network drive). So technically, we should not have any problem accessing the files.

Do u think we should uninstall and do a clean installation again?

regards,
Barry


barryn_99 (BOB member since 2009-06-15)

So now what error you get? By the way, is the Login Account on SAP Server having the access to access that same folder?


ganeshxp :us: (BOB member since 2008-07-17)

Hi Ganesh,

Tks for ur reply,

The error is as attached, error in opening file

Does it matter if the SAP server folder and my login account does not have the same rights? I am not sure (need to check as the server not with me at the moment) but I am suspecting the SAP application may have full rights while the login account should have read only.

regards,
Barry
1st issue.JPG
1st Issue - Data Transport still showing correct folder map.JPG


barryn_99 (BOB member since 2009-06-15)

I think you are trying to enter into the loop of confusion again.

As Werner says, take up the Service Account in your hand and prove that it has access to that folder.

You cannot assume that Service A/c has the supremo powers. After all it is another a/c for which someone has to provide the privilege. Of course manually only. So what if someone has not done it and you not have the privilege to check it.

I would say then it is not your job or it is just a Deadlock :roll_eyes:


ganeshxp :us: (BOB member since 2008-07-17)

Hi Ganesh,

Tks for ur reply. Sorry, my intention is defintely not to confuse all. If my explanation are not clear…do pardon me…

What type privilages are we talking about here…? Windows privileges?
Read, change or full control?

Assuming if the service a/c has read only, is that sufficient since we are only reading files?

Need to understand that I have some limitations in accessing devt and prod environment.

regards,
Barry


barryn_99 (BOB member since 2009-06-15)

Definitely a READ/WRITE/DELETE Windows privilege is required. If you are not able to access the service accounts then send up the required checklist task to the person who have one…


ganeshxp :us: (BOB member since 2008-07-17)

Hi Ganesh,

Thks for ur reply.

The acct has full control rights on the shared directory.


barryn_99 (BOB member since 2009-06-15)

I would like to see proof points. Screenshots. Show me the login-tab of the BO DataServices Service. The hostname of that server where you checked for the service. Proof you are actually using that job server.

And the trace log of above job execution as I am not 100% sure if the ABAP dataflow did complete and it is not related to the jobserver at all.


Werner Daehn :de: (BOB member since 2004-12-17)