Product(s):	Exor Network Manager
	Version(s):	04.05.00.00
	Environment:	N\A
	Area:	NET
	Subarea:	Admin Units

Issue:

When a user runs Network Extract process on HIG2520 form no CSV file is being created in Database server. The process outcome is ‘Success’ and no errors are shown in Process Execution Logs of that process.

Solution:

There is Network Data Extract process in Exor and running it a NETWORK_EXTRACT_xxxxxxx.csv file should be created in Database server (NETWORL EXTRACT oracle directory).

There are two cases when the CSV file can’t be created:

1. Need to do change NETWORK_DATA_EXTRACT package source code.

            Go to NETWORK_DATA_EXTRACT.Create_File procedure and do changes in the source code :

             Original code is                file_handle:=utl_file.fopen(loc_in,file_in,FWrite,32767);

             Should be changed to     file_handle:=utl_file.fopen('NETWORK_EXTRACT',file_in,FWrite,32767);

             Save. Compile the package.

      2.    The network extract csv file is not being created if there is sections whose description contains more than 80 symbols.

            The code below lists sections which are included into network extract

                 select road_id ,road_name ,road_number,network_type,maintenance_category,carriageway_type

                                , environment, class, no_of_lanes, from_node, to_node, section_length

                                , to_easting ,to_northing , from_easting , from_northing

                 from im_network

                   where

                   class in ('Classified A Roads','Classified B Roads','Classified C Roads')

                     or rtrim(road_number)='D328' ;

                amend the description for these sections whose the description length is over 80 symbols and save.