FME Users
I am trying to convert a MapInfo TAB file (24 613 records) into an Oracle Spatial table. When I run the process in FME I get the message:
"fme.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created."
The only option available then is to click Cancel and this resultantly closes down Workbench.
I have tried packing my MapInfo TAB file but this hasn't helped either.
Has anybody else had this problem? Is there a workaround and is there anything I should be looking out for?
Below please find attached the log file generated:
2006-07-26 08:35:32| 1.2| 1.2|INFORM|Feature Manipulation Engine 2006 GB (O) (20060620 - Build 2651)
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Oracle Edition (floating)
2006-07-26 08:35:32| 1.2| 0.0|INFORM|Permanent License.
2006-07-26 08:35:32| 1.2| 0.0|INFORM|Machine host name is: LCC35330
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Reader Keyword is `MAPINFO_1'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Writer Keyword is `ORACLE8I_1'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Writer Group Definition Keyword is `ORACLE8I_1_DEF'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Reader type is `MAPINFO'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Writer type is `ORACLE8I'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: No destination coordinate system set
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Current working directory is `K:\PRI Fileplan\Data Management\FME Workbench Workspaces\Planning Control\Flood Plains'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: Temporary directory is `C:\DOCUME~1\vgovind\LOCALS~1\Temp'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: FME_HOME is `C:\Program Files\FME\'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: FME_BASE is 'no'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: FME_MF_DIR is 'K:\PRI Fileplan\Data Management\FME Workbench Workspaces\Planning Control\Flood Plains/'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: FME_MF_NAME is 'wb-xlate-a01000'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|FME Configuration: FME_PRODUCT_NAME is 'FME 2006 GB'
2006-07-26 08:35:32| 1.2| 0.0|INFORM|System Status: 2682MB of disk space available in the FME temporary directory (C:\DOCUME~1\vgovind\LOCALS~1\Temp\)
2006-07-26 08:35:32| 1.2| 0.0|INFORM|System Status: 1962MB of virtual memory available
2006-07-26 08:35:32| 1.2| 0.0|INFORM|Operating System: Microsoft Windows 2000 Professional Service Pack 4 (Build 2195)
2006-07-26 08:35:33| 1.7| 0.5|INFORM|Using MapInfo (MFAL) Native Reader $Revision: 17.0 $ ( $Date: 2005/10/28 21:04:59 $ ) to read MapInfo data from directory `P:\Data\GeoMap\Planning Control\Cnstrnt\Flood_Plain\'
2006-07-26 08:35:36| 1.7| 0.0|INFORM|Opened native MapInfo file `P:\Data\GeoMap\Planning Control\Cnstrnt\Flood_Plain\Floodzone2.tab'
2006-07-26 08:35:39| 3.5| 1.8|INFORM|Opened native MapInfo file `P:\Data\GeoMap\Planning Control\Cnstrnt\Flood_Plain\Floodzone2.tab'
2006-07-26 08:35:39| 3.5| 0.0|INFORM|Module `LogCount_func' API version matches current core version (3.1 20031010).
2006-07-26 08:35:39| 3.5| 0.1|INFORM|FME Configuration: Source coordinate system for reader MAPINFO_1[MAPINFO] set to `BritishNatGrid' as read from input data
2006-07-26 08:35:39| 3.5| 0.0|INFORM|Coordinate System `BritishNatGrid' parameters: CS_NAME=`BritishNatGrid' DESC_NM=`British National Grid (ORD SURV GB) (EPSG #27700)' DT_NAME=`OSGB-7P' GROUP=`EUROPE' MAP_SCL=`1.0' ORG_LAT=`49.0' PARM1=`-2.0' PROJ=`TM' SCL_RED=`0.9996012717' UNIT=`METER' X_OFF=`400000.0' Y_OFF=`-100000.0'
2006-07-26 08:35:39| 3.5| 0.0|INFORM|Coordinate System `BritishNatGrid' as OGC Well Known Text: PROJCS["British National Grid (ORD SURV GB) (EPSG #27700)",GEOGCS["OSGB_1936",DATUM["OSGB_1936",SPHEROID["Airy - 1830",6377563.396,299.3249612664953],AUTHORITY["EPSG","6277"]],PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",49],PARAMETER["central_meridian",-2],PARAMETER["scale_factor",0.9996012717],PARAMETER["false_easting",400000],PARAMETER["false_northing",-100000],UNIT["METER",1]]
2006-07-26 08:35:40| 3.8| 0.3|INFORM|FME Configuration: Destination coordinate system set to input coordinate system `BritishNatGrid'
2006-07-26 08:35:40| 3.8| 0.0|INFORM|Using Oracle 8 SC Writer Version 1.0 (Nov. 05, 1998) to write tables to database `', server type `ORACLE8I', server name `lgis', user name `localdata', password `***'
2006-07-26 08:35:40| 3.8| 0.0|INFORM|Oracle 8 Spatial Writer: Starting at transaction 0 with a transaction interval of 2000
2006-07-26 08:35:43| 3.8| 0.0|WARN |Environment variable ORACLE_HOME is not set.
2006-07-26 08:35:43| 3.8| 0.0|INFORM|Connecting to ORACLE database `lgis' with user name of `localdata' and password of `***'.
2006-07-26 08:35:44| 3.9| 0.1|INFORM|Connected to ORACLE database `lgis'.
2006-07-26 08:35:44| 3.9| 0.0|INFORM|Creating table `FLOODZONE2' with a geometry column named `GEOM'.
2006-07-26 08:35:44| 3.9| 0.0|INFORM|Creating Oracle8i table `FLOODZONE2' using query: CREATE TABLE FLOODZONE2 (UNIQUE_ID FLOAT,HEIGHT FLOAT,ROTATION FLOAT,TEXTSTRING VARCHAR2(254),MI_PRINX INTEGER,MI_STYLE CHAR(80),CREATOR CHAR(150),CREATED_DATE DATE,SUBJECT CHAR(150),TITLE CHAR(120),ACCESSIBILITY CHAR(50),DISPOSAL CHAR(50),LOCATION CHAR(150),FORMAT CHAR(50),PUBLISHER CHAR(50),GEOM MDSYS.SDO_GEOMETRY)
2006-07-26 08:35:44| 3.9| 0.0|INFORM|Creating geometry metadata for Oracle8i table `FLOODZONE2' using query: INSERT INTO USER_SDO_GEOM_METADATA ( TABLE_NAME, COLUMN_Name, DimInfo, SRID ) VALUES( 'FLOODZONE2', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',0,2000000,0.0000000005),MDSYS.SDO_DIM_ELEMENT('Y',0,2000000,0.0000000005) ), 81989 )
2006-07-26 08:36:15| 23.7| 19.8|INFORM|Reading source feature # 2500
2006-07-26 08:40:10| 61.2| 37.5|INFORM|Reading source feature # 5000
2006-07-26 08:40:47| 80.6| 19.4|INFORM|Reading source feature # 7500
2006-07-26 08:40:51| 83.7| 3.1|INFORM|Reading source feature # 10000
2006-07-26 08:40:54| 86.5| 2.8|INFORM|Reading source feature # 12500
2006-07-26 08:40:57| 89.0| 2.5|INFORM|Reading source feature # 15000
2006-07-26 08:41:01| 91.7| 2.6|INFORM|Reading source feature # 17500
2006-07-26 08:41:03| 94.1| 2.5|INFORM|Reading source feature # 20000
2006-07-26 08:41:14| 102.5| 8.3|INFORM|Reading source feature # 22500
Any help appreciated.
Thanks.
Vinny
_______________________________________________________________________
Leicestershire County Council - rated a 'four-star' council by the Audit Commission
_______________________________________________________________________
This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000.
The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council.
Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment.
__._,_.___
Join us at the FME Worldwide User Conference Sept. 21-22, 2006 Vancouver BC Canada. For more information, visit www.safe.com/2006uc.
YAHOO! GROUPS LINKS
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
__,_._,___
