Pentaho

 View Only

 Won't create database repository

Marc Stroo's profile image
Marc Stroo posted 09-25-2023 07:30

With my current client I try to create a database repository for PDI, on SQL Server 2016. I have added the repository info and created a connection. Then nothing happens and when I try to connect it says I can't. The log gives this message:

No repository exists on the specified connection.
 
To create a repository, select the Edit' button followed by the 'Create or upgrade' button.
I would gladly do that, just... There is no 'Create or upgrade' button. It seems I can't create the repository, even though I have filled in all information. Any idea what the issue is here? I would really like to have this repository  to convince my client that PDI is a good, useful and easy ETL tool.

Petr Prochazka's profile image
Petr Prochazka posted 09-25-2023 08:42

Hi Marc,

which version of PID are you used? I checked latest release and repository dialog is changed. So button is not available.

You can try my trans which can upgrade or create repository directly and generated SQL statements are stored to output file.

Attachment  View in library
kdr_upgrade.ktr 17 KB
Marc Stroo's profile image
Marc Stroo posted 09-27-2023 09:05

I am using version 9.4, which is the latest version at the time of my download, about a month ago. Thank you for your reply. Does this mean that your transformation is the only way to create repositories from version 9.4 on?

Marc Stroo's profile image
Marc Stroo posted 09-27-2023 09:13

When I run your transformation, I get this error:

2023/09/27 15:12:17 - Upgrade.groovy.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error
2023/09/27 15:12:17 - Upgrade.groovy.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 
2023/09/27 15:12:17 - Upgrade.groovy.0 - Couldn't compile javascript: 
2023/09/27 15:12:17 - Upgrade.groovy.0 - <eval>:1:0 Expected an operand but found import
2023/09/27 15:12:17 - Upgrade.groovy.0 - import org.pentaho.di.core.exception.KettleAuthException
2023/09/27 15:12:17 - Upgrade.groovy.0 - ^ in <eval> at line number 1 at column number 0
2023/09/27 15:12:17 - Upgrade.groovy.0 - 
2023/09/27 15:12:17 - Upgrade.groovy.0 - at org.pentaho.di.trans.steps.script.Script.addValues(Script.java:286)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at org.pentaho.di.trans.steps.script.Script.processRow(Script.java:459)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at java.lang.Thread.run(Thread.java:748)
2023/09/27 15:12:17 - Upgrade.groovy.0 - Caused by: javax.script.ScriptException: <eval>:1:0 Expected an operand but found import
2023/09/27 15:12:17 - Upgrade.groovy.0 - import org.pentaho.di.core.exception.KettleAuthException
2023/09/27 15:12:17 - Upgrade.groovy.0 - ^ in <eval> at line number 1 at column number 0
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.api.scripting.NashornScriptEngine.throwAsScriptException(NashornScriptEngine.java:470)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.api.scripting.NashornScriptEngine.asCompiledScript(NashornScriptEngine.java:496)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.api.scripting.NashornScriptEngine.compile(NashornScriptEngine.java:182)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at org.pentaho.di.trans.steps.script.Script.addValues(Script.java:284)
2023/09/27 15:12:17 - Upgrade.groovy.0 - ... 3 more
2023/09/27 15:12:17 - Upgrade.groovy.0 - Caused by: jdk.nashorn.internal.runtime.ParserException: <eval>:1:0 Expected an operand but found import
2023/09/27 15:12:17 - Upgrade.groovy.0 - import org.pentaho.di.core.exception.KettleAuthException
2023/09/27 15:12:17 - Upgrade.groovy.0 - ^
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.AbstractParser.error(AbstractParser.java:294)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.AbstractParser.error(AbstractParser.java:279)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.unaryExpression(Parser.java:3182)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.expression(Parser.java:3282)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.expressionStatement(Parser.java:1150)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.statement(Parser.java:967)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.sourceElements(Parser.java:773)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.program(Parser.java:709)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.parse(Parser.java:283)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.parser.Parser.parse(Parser.java:249)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.runtime.Context.compile(Context.java:1284)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.internal.runtime.Context.compileScript(Context.java:651)
2023/09/27 15:12:17 - Upgrade.groovy.0 - at jdk.nashorn.api.scripting.NashornScriptEngine.asCompiledScript(NashornScriptEngine.java:493)
2023/09/27 15:12:17 - Upgrade.groovy.0 - ... 5 more

Any idea what I do wrong?

Petr Prochazka's profile image
Petr Prochazka posted 09-27-2023 11:21

Hi Marc,

yes. in PDI is not way how to create DB repository.

At second post:

It's my fault, script is written in Groovy. Pls copy groovy.jar and groovy-jsr223.jar to lib directory. You can download for ex. from Maven repository: groovy.jar,  groovy-jsr223.jar. I tested on Groovy 4.x.

Marc Stroo's profile image
Marc Stroo posted 10-31-2023 08:37

An alternative is to install version 9.3. I am unaware of the differences between 9.3 and 9.4, but for most work the 9.3 version is just fine. This is my last day at the client, so no need to check it anymore here. I will test it on my home development machine later.

Related Content