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
Rank
Userlevel 2
Badge +17
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
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

 

G
Badge +3
maybe @Value($(test)) ?

 

 

is Takashi not using FME2014?
takashi
Rank
Userlevel 2
Badge +17
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
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
Badge

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


Community Stats

28,707
Posts
109,480
Replies
36,553
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.