Problem

Trying to load an inspection defect file


ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE" line 475
ORA-29283: invalid file operation
ORA-06512: at "HIGHWAYS.NM3FILE" line 1545

Also later got (as a sub user loading data):

HIG-0126: You do not have privileges to perform this action: create job.

The user has MAI_USER role.

Solution

Navigate to exor, Directory Management, Directories (or fastpath HIG1895)
Check MAI_INSP_DIRECTORY setup to a directory on the database server as the database sees it.
Assign MAI_USER role save, then goto java role privs tab, against MAI_USER role select ALL ON and save.
Check on Roles tab that the applied check box is ticked.
Then check can upload and down load a file to the directory, again use Upload file to Oracle Directory, Download file to Oracle directory options accessible from exor, Directory Management.
If form doesn't appear when downloading or uploading, likely the Oracle DAD not setup or incorrectly setup on the Application Server. Or product options that relate to the DAD not set in the application. See DBA to resolve. Check NM3WEBHOST and NM3WEBCSS product options.
Amended DAD /exortest/nm3web setup to (Default portal from Reset Package state  - might not be necessary )  ,  Oracle Directory MAI_INSP_DIRECTORY reassigned correct directory on database server, E:\Exor\MAI_Inspections\ -reassigned MAI_USER roles, re-assigned java privs.

Once this done ORA messages dissappeared.

In order to read a maintenance manager inspection file ( usually inspection file from Map Capture )  automatically, ensure PROCESS TYPES (fast path hig2500, or navigate to exor, processes, process type Ensure Maintenance Inspection Loader process type setup correctly. Check all tabs at the bottom of the screen. Usually assigned MAI_ADMIN , MAI_USER in roles tab. Frequencies have once and 5 minutes/30 minutes etc. Area polled locations need to be setup if coming from an ftp server. Please check Process locations tab has File Type eg Inspection File, Input Data Store Oracle Directory, Input File Location  MAI_INSP_DIRECTORY. If want files to load automtically can add file extensions here eg  Amended ESI datatype ( suffix of the inspection file )

Ensure users or sub users processing inspections files in,  have PROCESS_USER role. This corrects HIG-0126: You do not have privileges to perform this action: create job message.  The main user may want PROCESS_ADMIN role too.

Erronoeous records can be edited in the error correction form, records can be deleted here too

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!