Skip to main content
  • EN

Hi,

I got a FME work space (version 2017) published into Server and scheduled to run every half an hour.

I have got an oracle connection parameters published into FME server

Within the work space i've got several transformer for example

SQL Creator,SQL Executer,DBJoiner and DatabaseUpdater - all of them are using the same oracle DB connection.

But some of them are Persistent connection and some are not ( Actually i thought it won't make any difference in the process)

But i am seeing the below warning messages in my FME Job log

*****************************************************************************************************************

WARN |Existing connection changed to 'persistent' mode (is connection closed after all clients release it) setting. The following connection is being requested in an inconsistent manner (serverType='ORACLE8i', serverName='***', userName='***', password='***', dbname='')

0.0|WARN |Existing connection changed to 'non-persistent' mode (is connection closed after all clients release it) setting. The following connection is being requested in an inconsistent manner (serverType='ORACLE8i', serverName='***', userName='***', password='***', dbname='')

*****************************************************************************************************************

How could i avoid these warnings in my log?

Any help would be much appreciated.

Thanks in advance,

Mari...

Hello Mari,

I also found same warning in one of my FME job.

Were you able to find root cause?

Thanks in advance.

Vikas

Hello Mari,

I also found same warning in one of my FME job.

Were you able to find root cause?

Thanks in advance.

Vikas

Hi Vikas,

No not yet.I am still waiting for a clue :(

Regards,

Mari...

Hi @reachmj,

 

As you noted this this warning is caused by the fact you have persistent and non-persistent connections in the same workspace. While normally this is not a concern as an open non-persistent connection will be shared between transformers. For instance if one transformer has not fully closed the connection before the next one begins.

 

The warning is a concern under the following circumstances, and assumes that you do not want to open a new connection.

 

Within a workspace:

A reader or transformer is set to a non-persistent connection and it finishes reading and closing the connection. The following transformer will use a new connection.

 

On FME Server:

Since persistent connections exist on fmeServer until an engine restart. If the last connection to use the connection is a non-persistent connection the following workspace will create a new connection.

 

So to avoid the errors I would try setting the connections to be the same. (Persistent / Non-Persistent).

 

Richard

 

Reply


Community Stats

30,159
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.