Hi,
I've run into a problem writing to tables in several different Oracle schemas using FME Server. In my workspace I have 5 different Oracle Spatial Object writers that I will write to depeding what data comes through. The Oracle schemas (users) are created with a .bat and several .sql files.
The problem is that I only seems to be able to write data in 2 of the 5 schemas (the only differences between the schemas are password, srid and extent. All those have been verified). For example, writer 1 and 2 works but not number 3.
If I delete all schemas and only create a schema for number 3 FME Server can write to tables in that schema. If I create all schemas (1-5), only number 1 and 2 will work.
There are no differences between the Oracle schemas and FME will write data to all if I execute from Workbench. Unfortunately, I can't get it to work on FME Server. I have checked and rechecked the Oracle, FME Server and log files and I can't find any suspicious (connection ok, parameters ok, data ok...).
Funny thing is that FME logs files say that features have been written to Oracle, but the tables are empty...
Anyone have any ideas ? I've running out of where to look...
