Hi
I have a controller workspace with some DB paramaters. In it ther is one specific FMESJS amongs the others FMESJS. There are user parameters in the controller for DB user, service and password.
The controller passes these to the FMESJS.
The tnsnames.ora on the fme server has the proper entries for this service.
When I run the controller on the server all FMESJS run OK with the supplied DB params, but this specific one. I got the error
ORA-01005: null password given; logon deniedin one of the FeatureReaders in the targer workspace (one invoked by the FMESJS).
The log is below
1
INFORM
0.0
0.0
2016-05-19 14:17:05
FME 2015.1.0.3 (20150623 - Build 15485 - linux-x64)
2
INFORM
0.0
0.0
2016-05-19 14:17:05
FME_HOME is '/apps/fmeserver/Server/FMEEngineUpgrade.2015.1/'
3
INFORM
0.0
0.0
2016-05-19 14:17:05
FME Engine (floating)
4
INFORM
0.0
0.0
2016-05-19 14:17:05
Permanent License.
5
INFORM
0.0
0.0
2016-05-19 14:17:05
Machine host name is: servername
6
INFORM
0.0
0.0
2016-05-19 14:17:05
START - ProcessID: 8139, peak process memory usage: 0 kB, current process memory usage: 103644 kB
7
INFORM
0.0
0.0
2016-05-19 14:17:05
FME Configuration: Command line arguments are `fme' `Region Processing Runners/delta_region_updatechangeevent_runner/delta_region_updatechangeevent_runner.fmw' `--FME_SHAREDRESOURCE_BACKUP' `/apps/fmeserver/Backup/' `--ORCL_GISSTAGE_PASS' `***' `--LND_DATA_PASS' `***' `--FME_SERVER_HOST' `servername' `--ORCL_CHANGE_EVENT_SERV' `DBSERVICE' `--CHANGE_DATE' `20151001102100' `--FME_SHAREDRESOURCE_TEMP' `/apps/fmeserver/Temp/' `--FME_ENGINE' `servername_Engine1' `-LOG_FILENAME' `/apps/fmeserver/Logs/engine/current/jobs/304000/job_304552.log' `--FME_SERVER_ROOT' `/apps/fmeserver' `--FME_SHAREDRESOURCE_LOG' `/apps/fmeserver/Logs/' `--ORCL_CHANGE_EVENT_PASS' `***' `--FME_JOB_ID' `304552' `--FME_DATA_REPOSITORY' `/apps/fmeserver/Server/Upload/' `--ORCL_GISSTAGE_USR' `D7_GIS_STAGE' `--EFFECTIVE_DATE_PARAM' `' `--LND_DATA_SRV' `DBSERVICE' `--USE_DATE' `No' `--ORCL_GISSTAGE_SRV' `DBSERVICE' `--FME_SECURITY_ROLES' `fmeadmin fmesuperuser' `--FME_MF_NAME' `delta_region_updatechangeevent_runner.fmw' `--FME_SHAREDRESOURCE_DATA' `/apps/fmeserver/Data/' `--LND_DATA_USR' `FME' `--FME_SECURITY_USER' `admin' `--FME_SERVER_WEB_URL' `http://servername:8080' `--ORCL_CHANGE_EVENT_USER' `FME' `-FME_ENGINE_MEMORY_REDLINE' `0.5' `--FME_SERVER_PORT' `7071'
.
.
.
.
.
.
.
.
37
INFORM
0.0
0.1
2016-05-19 14:17:05
Creating writer for format:
38
INFORM
0.0
0.1
2016-05-19 14:17:05
Creating reader for format:
39
INFORM
0.0
0.1
2016-05-19 14:17:05
MULTI_READER(MULTI_READER): Will fail with first member reader failure
40
INFORM
0.0
0.1
2016-05-19 14:17:05
MULTI_READER(MULTI_READER): Adding ORACLE_NONSPATIAL Reader with keyword ORACLE_NONSPATIAL_1
41
INFORM
0.0
0.1
2016-05-19 14:17:05
MULTI_READER(MULTI_READER): Adding ORACLE_NONSPATIAL Reader with keyword ORACLE_NONSPATIAL_2
42
INFORM
0.0
0.1
2016-05-19 14:17:05
Using Multi Reader $Revision$ ( $Date$ ) with keyword `MULTI_READER' to read multiple datasets
43
INFORM
0.0
0.1
2016-05-19 14:17:05
Creating reader for format: Oracle Non-spatial
44
INFORM
0.0
0.1
2016-05-19 14:17:05
ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `DBSERVICE', user name `FME', password `***'
45
INFORM
0.0
0.1
2016-05-19 14:17:05
ORACLE Reader: Using Rich geometry.
46
INFORM
0.0
0.1
2016-05-19 14:17:05
Connected to ORACLE database `DBSERVICE'
47
INFORM
0.0
0.1
2016-05-19 14:17:05
Using MultiWriter $Revision$ ( $Date$ ) with keyword `MULTI_WRITER' to output data (ID_ATTRIBUTE is `multi_writer_id')
48
INFORM
0.0
0.1
2016-05-19 14:17:05
Writer output will be ordered by value of multi_writer_id
.
.
.
.
.
55
INFORM
0.0
0.1
2016-05-19 14:17:06
ORACLE Reader: Executing SQL Statement `SELECT "DATA_CHANGE_EVENT"."DATA_CHANGE_EVENT_ID", "DATA_CHANGE_EVENT"."EVENT_DATE", "DATA_CHANGE_EVENT"."EVENT_TYPE", "DATA_CHANGE_EVENT"."EFFECTIVE_DATE", "DATA_CHANGE_EVENT"."JPA_VERSION_NUMBER", "DATA_CHANGE_EVENT"."LAST_UPDATED_DATE", "DATA_CHANGE_EVENT"."LAST_UPDATED_BY", "DATA_CHANGE_EVENT"."LOCATION_ID", "DATA_CHANGE_EVENT"."OBJECT_ID", "DATA_CHANGE_EVENT"."CONTRACT_ID", "DATA_CHANGE_EVENT"."LPIS_LND_PRCL_ID", "DATA_CHANGE_EVENT"."PDU_IS_PROCESSED_DATE", "DATA_CHANGE_EVENT"."BRN", "DATA_CHANGE_EVENT"."SOURCE", "DATA_CHANGE_EVENT"."DM_BATCH_REF", "DATA_CHANGE_EVENT"."PRCL_ID", "DATA_CHANGE_EVENT"."FME_CLASS_PROCESSED_DATE", "DATA_CHANGE_EVENT"."FME_REGION_PROCESSED_DATE" FROM "DATA_CHANGE_EVENT" WHERE EVENT_TYPE IN (1,2,3,12) AND FME_REGION_PROCESSED_DATE IS NULL' to obtain features for feature type `DATA_CHANGE_EVENT'
56
INFORM
0.0
0.2
2016-05-19 14:17:06
Creating reader for format: Oracle Non-spatial
57
INFORM
0.0
0.2
2016-05-19 14:17:06
FeatureReader_3(QueryFactory): Performing query against ORACLE_NONSPATIAL dataset `DBSERVICE'
58
INFORM
0.0
0.2
2016-05-19 14:17:06
ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `DBSERVICE', user name `FME', password `***'
59
INFORM
0.0
0.2
2016-05-19 14:17:06
ORACLE Reader: Using Rich geometry.
60
INFORM
0.0
0.2
2016-05-19 14:17:06
Environment variable ORACLE_HOME has value `/apps/oracleInstantClient/instantclient_12_1'
61
INFORM
0.0
0.2
2016-05-19 14:17:06
Connecting to ORACLE database `DBSERVICE' with user name of `FME' and password of `***'
62
ERROR
0.0
0.2
2016-05-19 14:17:06
Error connecting to Oracle database: message was `ORA-01005: null password given; logon denied'. (serverType=`ORACLE8i', serverName=`DBSERVICE', userName=`FME', password=`***', dbname=`')
Strangelly it connects to DB at line 46 in the log but this is not in a feature reader, but is a normal reader.
All reader are using the fame user/pass for the DB.
What might the problem be?