Hi,
i have an problem with the Oracle Non-Spatial (and Spatial) Reader / Writer.
FME seems to have an issue when the password contains a section sign (§).
Other special characters don't seem to cause any problems - at least dollar signs ($) and slashes (/) work.
As soon as a § is included, the login fails.
Version: FME Form 2024.2.1.0 (Build 24801)
I tried with Named-Connection and with Embedded Connection Parameters.
Maybe it is a similar problem as this post:
Error Message:
Creating reader for format: Oracle Non-Spatial
Creating reader for format: Oracle Non-Spatial
Environment variable ORACLE_HOME is not set.
Connecting to ORACLE database `ABC' with user name of `CARLO_TEST' and password of `***'
Error connecting to Oracle database: message was `ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt'. (serverType=`ORACLE8i', serverName=`ABC', userName=`CARLO_TEST', password=`***', dbname=`')
Failed to obtain any schemas from reader 'ORACLE_NONSPATIAL' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information
UniversalReader -- readSchema resulted in 0 schema features being returned
Reader Parameter(0) = >ABC<
Reader Parameter(1) = >SERVER_TYPE<
Reader Parameter(1) = >ORACLE8i<
Reader Parameter(3) = >REMOVE_SCHEMA_QUALIFIER<
Reader Parameter(3) = >NO<
Reader Parameter(5) = >PERSISTENT_CONNECTION<
Reader Parameter(5) = >YES<
Reader Parameter(7) = >SHOW_SYSTEM_TABLES<
Reader Parameter(7) = >NO<
Reader Parameter(9) = >WORKSPACE<
Reader Parameter(9) = ><
Reader Parameter(11) = >CONNECTION_MODE<
Reader Parameter(11) = >SERVICE_NAME<
Reader Parameter(13) = >USER_NAME<
Reader Parameter(13) = >CARLO_TEST<
Reader Parameter(15) = >PASSWORD<
Reader Parameter(15) = >********<
Reader Parameter(17) = >WALLET_PATH<
Reader Parameter(17) = ><
Reader Parameter(19) = >SELECTED_SERVICE<
Reader Parameter(19) = ><
Reader Parameter(21) = >RETRIEVE_ALL_TABLE_NAMES<
Reader Parameter(21) = >YES<
Reader Parameter(23) = >_MERGE_SCHEMAS<
Reader Parameter(23) = >YES<
Reader Parameter(25) = >ARCGIS_COMPATIBILITY<
Reader Parameter(25) = >ARCGIS_AUTO<
Reader Directive(0) = >RUNTIME_MACROS<
Reader Directive(1) = >SERVER_TYPE,ORACLE8i,REMOVE_SCHEMA_QUALIFIER,NO,PERSISTENT_CONNECTION,YES,SHOW_SYSTEM_TABLES,NO,WORKSPACE,,CONNECTION_MODE,SERVICE_NAME,USER_NAME,CARLO_TEST,PASSWORD,********,WALLET_PATH,,SELECTED_SERVICE,,RETRIEVE_ALL_TABLE_NAMES,YES,_MERGE_SCHEMAS,YES<
UniversalReader -- readSchema resulted in 0 schema features being returned
Any ideas or workarounds?
