Hi All,
we're currently evaluating FME for data export/production and ran into
a problem when exporting data from an Oracle 10G database (version
10.1.0.4.0).
When FME accesses the database I get the error below:
.\ocidb.cpp:608 Postcondition columns.entries() == 2 failed
The database characterset is AL32UTF8 and the NLS_LENGHT_SEMANTICS is
set to CHAR.
Other 9i or 10G R2 databases work without problems.
I suspect the NLS_LENGHT_SEMANTICS causing this problem. Any solution
to this except changing the database parameter?
Alex
The complete log is below:
Commandline to run this workspace:
fme.exe oracle8i2shape.fmw
--SourceDataset_ORACLE8I skynet
--DestDataset_SHAPE D:\Temp\fme_export\hal\shape
--DestDataset_MITAB D:\Temp\fme_export\hal\tab
--DestDataset_MIF D:\Temp\fme_export\hal\mif
--_ORACLE8I_UserName_ORACLE8I ntc_dca13_prod_q106
--_ORACLE8I_Password_ORACLE8I brain
--DestDataset_DBF D:\Temp\fme_export\hal\shape
Starting Translation ...
Feature Manipulation Engine 2006 GB (O) (20060620 - Build 2651)
EVAL_ALL (node locked-crc)
Warning: The software you are using is for demo purposes only.
This is not freeware and cannot be used to process any data for any
purposes other than evaluation and demonstration.
To purchase, contact [EMAIL PROTECTED] or call 604-501-9985
Evaluation License: 14 days left.
Machine host name is: wxp-nb-abarth
FME Configuration: Reader Keyword is `ORACLE8I_1'
FME Configuration: Writer Keyword is `MULTI_WRITER'
FME Configuration: Writer Group Definition Keyword is `MULTI_WRITER_DEF'
FME Configuration: Reader type is `ORACLE8I'
FME Configuration: Writer type is `MULTI_WRITER'
FME Configuration: No destination coordinate system set
FME Configuration: Current working directory is `D:\My Documents\My
FME Workspaces'
FME Configuration: Temporary directory is
`C:\DOCUME~1\abarth\LOCALS~1\Temp'
FME Configuration: FME_HOME is `C:\Program Files\FME\'
FME Configuration: FME_BASE is 'no'
FME Configuration: FME_MF_DIR is 'D:\My Documents\My FME Workspaces/'
FME Configuration: FME_MF_NAME is 'wb-xlate-a01428'
FME Configuration: FME_PRODUCT_NAME is 'FME 2006 GB'
System Status: 3080MB of disk space available in the FME temporary
directory (C:\DOCUME~1\abarth\LOCALS~1\Temp\)
System Status: 1963MB of virtual memory available
Operating System: Microsoft Windows XP Professional Service Pack 2
(Build 2600)
ORACLE Reader: Using Oracle 8 SC Reader Version 1.2 (Jul. 04, 2000) to
read tables from database `', server type `ORACLE8i', server name
`skynet', user name `ntc_dca13_prod_q106', password `***'
Environment variable ORACLE_HOME is not set.
Connecting to ORACLE database `skynet' with user name of
`ntc_dca13_prod_q106' and password of `***'.
Connected to ORACLE database `skynet'.
.\ocidb.cpp:608 Postcondition columns.entries() == 2 failed
.\ocidb.cpp:608 Postcondition columns.entries() == 2 failed
--
Alexander Barthel
NAVTEQ - Technical Center Europe
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
