PDI Repository with PostgreSQL

[Jaures Fouté]

Hi everyone,

I have this error when I try to run a transformation from my Postgresql repository.

2015/11/30 16:48:04 - Pan - Start of run.

2015/11/30 16:48:04 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml

ERROR: Pan can't continue because the transformation couldn't be loaded.

ERROR: No repository provided, can't load transformation.

Any Idea??????

That's my repositories.xml file:

<?xml version="1.0" encoding="UTF-8"?>

<repositories>

<connection>

    <name>server</name>

    <server>servert</server>

    <type>POSTGRESQL</type>

    <access>Native</access>

    <database>repository</database>

    <port>5432</port>

    <username>username</username>

    <password>Encrypted 2be98afc86aa7f285af1ca360d797bddf</password>

    <servername/>

    <data_tablespace/>

    <index_tablespace/>

    <attributes>

      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>

      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>

      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>

      <attribute><code>PORT_NUMBER</code><attribute>5432</attribute></attribute>

      <attribute><code>PRESERVE_RESERVED_WORD_CASE</code><attribute>N</attribute></attribute>

      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>

      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>Y</attribute></attribute>

      <attribute><code>SUPPORTS_TIMESTAMP_DATA_TYPE</code><attribute>Y</attribute></attribute>

      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>

    </attributes>

  </connection>

<repository>

<id>repository</id>

<name>REPOSITORY</name>

<description>REPOSITORY</description>

<connection>REPOSITORY</connection>

</repository>

</repositories>

Best Regards,

[Nelson Sousa]

what command line were you using?

Nelson Sousa

Business Intelligence Consultant

nso...@ubiquis.co.uk

+447554442766

--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/dba84b8f-c0e5-4f28-93af-cb463d907e5f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Juan Sierra Pons]

Hi,

Can you provide the full command your using?. I mean the pan.sh with
all the parameters

Best regards
--------------------------------------------------------------------------------------
Juan Sierra Pons ju...@elsotanillo.net
Linux User Registered: #257202
Web: http://www.elsotanillo.net Git: http://www.github.com/juasiepo
GPG key = 0xA110F4FE
Key Fingerprint = DF53 7415 0936 244E 9B00 6E66 E934 3406 A110 F4FE
--------------------------------------------------------------------------------------

[Jaures Fouté]

Thanks you for quick answer, The command line I use is: 

root@h2415123:/opt/pentaho/data-integration# sh pan.sh -rep=repository -user=admin -pass=admin -trans=Dummy

Result:

2015/11/30 18:03:45 - Pan - Start of run.

2015/11/30 18:03:45 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml

ERROR: Pan can't continue because the transformation couldn't be loaded.

ERROR: No repository provided, can't load transformation.

Best Regards

[Nelson Sousa]

Your repository name is server, as per repositories.xml, not repository.

--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/bf1c935f-c6f7-4d82-86cf-2154b136382f%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
Sent from Gmail Mobile

[Jaures Fouté]

Hello Nelson, 

I have the same Error With:::::   # sh pan.sh -rep=server -user=admin -pass=admin -trans=Dummy

Best regards

Le lundi 30 novembre 2015 17:06:04 UTC+1, Jaures Fouté a écrit :

[Nelson Sousa]

Sorry, my mistake, I misread your repositories.xml.

The repo name is REPOSITORY (all uppercase).

If that doesn't work, then you're missing something else. Try going through the docs for pan.sh.

Cheers,

Nelson

On Monday, 30 November 2015, Jaures Fouté <jaure...@gmail.com> wrote:

--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/db11a1a3-793e-4415-939c-603231806546%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Jaures Fouté]

Hi Nelson,

Just want to tell you that I check my database connection and all is good, but I always have the same error.
What may be the issue????

Best regards
Jaures

[Nelson Sousa]

The error message says it cannot find the repository. 

Either:

- You've set an incorrect repository on the command line;

- You have incorrect settings on the repositories.xml;

- Your repository is corrupt, missing, or sometghing else;

I can't see any other possible reason, so it has to be one of these three. How did you set up the repository in the first place? Check the documentation, re-trace your steps, at some point you did something incorrectly.

Regards,

Nelson Sousa

Business Intelligence Consultant

nso...@ubiquis.co.uk

+447554442766

--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To post to this group, send email to pentaho-...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/380b178c-8130-4525-b4f0-ca96ddf3a949%40googlegroups.com.