Solved

How to set security in Windows for Oracle Directory in FndMig

  • 15 June 2023
  • 3 replies
  • 88 views
eqbstal
Rank
Userlevel 7
Badge +21

When reading the documentation about preparing a migration job that uses procedure Output File, the text shows:

Write data to a server file

When File Location = OnServer File Path must be a valid directory object. The column has a List-Of-Value with valid directory objects.

So logged in as IFSAPP in the database an Oracle directory MIGOUTFILES was created with C:\MigOutFiles as path on the server (I have created it on the database server).

Let's take the company as view to export. I select MIGOUTFILES as output path. File name is Companies.txt and File location is set to OnServer.

To make this as simple as possible, in the File Mapping only one field/row is created with field COMPANY.

All rules are inactive.

When starting this migration job online the system reports: Failed to open file Companies.txt on MIGOUTFILES.

The windows directory exist, so why do I get this message?

icon

Best answer by Charith Epitawatta 15 June 2023, 18:01

View original
Please like this response if it helped you

3 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @eqbstal,

Could you try to create the directory logged in as SYS and grant READ, WRITE  permissions to the directory as shown below?

CREATE OR REPLACE DIRECTORY MIGOUTFILES AS ‘C:\MigOutFiles’;

GRANT READ, WRITE ON DIRECTORY MIGOUTFILES TO <AppOwner>;

Hope this helps!

Charith - https://charith.xyz
eqbstal
Rank
Userlevel 7
Badge +21

Thanks @Charith Epitawatta for the idea. I'm currently trying to locate the person who knows the password of SYS. It took me already 10 cups of coffee 😄

Please like this response if it helped you
eqbstal
Rank
Userlevel 7
Badge +21

@Charith Epitawatta Yes, this was the solution. A real pity that this is not in the documentation of migration jobs.

Thanks for sharing your knowledge.

Please like this response if it helped you

Reply


Terms & ConditionsCookie settings