Skip to main content
Question

Oracle connection warning in FME Job log

  • October 10, 2018
  • 3 replies
  • 31 views
R

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...

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

V
Forum|alt.badge.img
  • vikastawde
  • 2 replies
  • October 31, 2018

Hello Mari,

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

Were you able to find root cause?

Thanks in advance.

Vikas

R
  • reachmj
  • Author
  • 6 replies
  • November 16, 2018

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...

richardatsafe
Safer
Forum|alt.badge.img+10
  • richardatsafeSafer
  • Safer
  • 217 replies
  • November 19, 2018

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

 

Community Stats

32,061
Posts
121,725
Replies
39,688
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.