Skip to main content
Question

Postgres SCHEMA name as Published Parameter

I
Hi,

 

 

I am trying to pass a schema name (database_username) for a postgis table as Publishes Parameter:

 

TYPE: Text

 

NAME: test

 

PROMT: Schemaname

 

 

After starting the workbench from a batch file with --test verden_test as parameter, I can see in the logfile that the parameter gets passed to FME:

 

 

2014-05-09 08:51:32|  19.5|  0.0|STATS |AttributeRenamer_3_OUTPUT -> verden_test.verkehr Correlator(TeeFactory)

 

 

But when FME tries to write into the database the logfileoutput is:

 

 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

                       Features With No Schema defined

 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

$(test).verkehr                                                       5

 

 

and the Database is empty.

 

 

I am using FME2013 SP2.

 

 

Any idea why the schema name is not used when writing to the database?

 

 

Thank,

 

Iris

6 replies

takashi
Influencer
  • takashiInfluencer
  • May 9, 2014
Hi Iris,

 

 

In my quick test, I was success. In this image, is there any difference from your workspace?

 

 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

                           Features Written Summary

 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

verden_test.verkehr                                                          5

 

=============================================================

 

Total Features Written                                                       5

 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

 

Takashi
I
  • iris
  • Author
  • May 12, 2014
Hi Takashi,

 

 

thanks for your answer.  The workbench looks the same, but the log file says something different:

 

 

 

 

 

AttributeRenamer_4_OUTPUT -> verden_test.verkehr Correlator(TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)

 

.

 

.

 

.

 

|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

|                       Features With No Schema defined

 

|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

|$(test).verkehr                                                                          3

 

|==============================================================

 

|Total Features NOT Written                                                   3

 

|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

.

 

.

 

.

 

|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

|                           Features Written Summary

 

|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

|$(test).verkehr                                                                     3

 

|==============================================================

 

|Total Features Written                                                       3

 

|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

 

Iris

 

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • May 12, 2014
maybe @Value($(test)) ?

 

 

is Takashi not using FME2014?
takashi
Influencer
  • takashiInfluencer
  • May 12, 2014
Yes, I was using FME 2014. But I was not able to reproduce the same error also with both FME2012 SP4 and FME 2013 SP4. Strange...

 

I
  • iris
  • Author
  • May 12, 2014
Hi,

 

 

my FME Version seems to be the problem.  I am usually using FME2013 SP2.

 

 

I tried the same workbench with FME2012 SP2 and with FME2013 SP2.  It works fine in FME2012 SP2, but does not work in FME2013 SP2. So I guess I will just have to update my FME Version.

 

 

Thanks for getting me on the right track.

 

 

Iris
B
Forum|alt.badge.img
  • bajbouja
  • May 27, 2016

Hi,

I have the same problem with 2015 Version... :/

I try to make Schéma_Postgis's name as published parametre and no results...

there is no error in log file..

Thanks for helping me.

Reply


Helpful Members This Week

Community Stats

31,310
Posts
118,734
Replies
38,899
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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