Enable Download of Log Files - Intergraph Smart Reference Data - Version 10.2 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.2

Downloading log files is only available in Smart Reference Data.

To enable the function to download log files from the database server to the client in a zipped format, launch a SQL*Plus session, connect as SYS, and execute the following statements:

Statement 1 (to create an Oracle directory object)

SELECT ' CREATE OR REPLACE DIRECTORY log_file_dest AS '''|| dsv.value_vch ||''''

FROM m_dba_settings ds, m_dba_setting_values dsv

WHERE ds.name = 'LOG_FILE_DEST'

AND ds.ds_id = dsv.ds_id

AND dsv.active_ind = 'Y'

AND NOT EXISTS (SELECT 1 FROM DBA_DIRECTORIES WHERE directory_name = 'LOG_FILE_DEST');

Statement 2 (to grant Java privileges to the log file destination directory)

SELECT ' begin dbms_java.grant_permission(''M_SYS'',''java.io.FilePermission'',''' ||dsv.value_vch|| '\*' ||''',''read,write,delete'');end;'

FROM m_dba_settings ds, m_dba_setting_values dsv

WHERE ds.name = 'LOG_FILE_DEST'

AND ds.ds_id = dsv.ds_id

AND dsv.active_ind = 'Y';