Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Cannot Create DBMS Repository

  1. #1
    Join Date
    Apr 2007
    Posts
    6

    Default Cannot Create DBMS Repository

    I have installed the latest release of DI (Kettle) and have successfully created the necessary repository table objects (i.e. R_*) in Oracle XE and SQL Server 2005. However, when I try to log in all I get is an error message saying User [system] (for Oracle XE) or User [Admin] for SQL*Server 2005 could not be retrieved from the DBMS. However, just moments before trying to log in I was able to create the repository objects using these user accounts.

    Any suggestions?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Did you create the repository via the button on the startup screen?

    Also when you logon to the repository you should not be using the database users, try userid admin, password admin to originally log on to a repository.

    Regards,
    Sven

  3. #3
    Join Date
    Apr 2007
    Posts
    6

    Default

    first off, thanks for your reply. Just to clarify, I have installed Oracle XE on my laptop. Its all up and running with no issues. I then install DI3.0 on the same laptop without a hitch.

    Once installed, I run DI and as part of the first time running it I create a new Repository. I then create a new Connection using the following credentials:

    Database Name: XE
    Port: 1521
    User: Admin
    Password: *******

    I test the connection and all is ok. I then return to the create connection window which gives me the option to Create or Upgrade the repository. This step all works fine and I check the DBMS and can see that a whole lot of new tables (i.e. R_*) have been created in the Admin schema.

    All ssems fine until I try to log into the repository from the Welcome screen. Even though I use the same username and password from eariler I get the following error:


    org.pentaho.di.core.exception.KettleException:
    User [Admin] could not be loaded from repository: []
    The user [Admin] could not be found.

    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:96)
    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:105)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.ok(RepositoriesDialog.java:517)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.access$900(RepositoriesDialog.java:73)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$7.handleEvent(RepositoriesDialog.java:365)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:425)
    at org.pentaho.di.ui.spoon.Spoon.openRepositoryDialog(Spoon.java:5344)
    at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:5408)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5572)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5685)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    The user [Admin] could not be found.
    at org.pentaho.di.repository.UserInfo.<init>(UserInfo.java:90)
    ... 19 more

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    As in my original reply... there's a difference between the database ids/passwords and the ids/passwords of the repository.

    Use admin/admin to login in to the repository ("admin" as userid, "admin" as password... without quotes of course).

    Regards,
    Sven

  5. #5
    Join Date
    Apr 2007
    Posts
    6

    Default

    Wow, do I feel like a dork. I had tried this a couple of days ago but it kept dumping me out of the Welcome screen and back to Windows.

    However, I had been using ODBC and not JDBC.

    Thanks for your help.

  6. #6
    Join Date
    Apr 2007
    Posts
    6

    Default

    Actually, I spoke too soon. What had happened is that I thought it had logged in but it had not. For some silly reason it had loaded DI with a repository.

    when I try the "admin", "admin" I get the following error:
    org.pentaho.di.core.exception.KettleException:
    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection

    Error occured while trying to connect to the database
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection

    at org.pentaho.di.repository.Repository.connect(Repository.java:633)
    at org.pentaho.di.repository.Repository.connect(Repository.java:572)
    at org.pentaho.di.ui.spoon.Spoon.handleStartOptions(Spoon.java:5538)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5579)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5685)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection

    at org.pentaho.di.core.database.Database.normalConnect(Database.java:317)
    at org.pentaho.di.core.database.Database.connect(Database.java:266)
    at org.pentaho.di.core.database.Database.connect(Database.java:228)
    at org.pentaho.di.core.database.Database.connect(Database.java:218)
    at org.pentaho.di.repository.Repository.connect(Repository.java:590)
    ... 10 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Io exception: The Network Adapter could not establish the connection
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:434)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:301)
    ... 14 more
    Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:429)
    ... 15 more


    This is strange considering moments before I could Create or Update the repository using the "admin", "admin" credentials.

  7. #7
    Join Date
    May 2006
    Posts
    4,882

    Default

    Well... this is just a plain JDBC URL error probably... check the definition of the connection again.

    Regards,
    Sven

  8. #8
    Join Date
    Mar 2008
    Posts
    3

    Default

    HAs this issue ever been resolved? I've run into the same issues (local XE, able to create repository, but not able to log in ) and I think I'm doing everything right ...

    Thanks for looking into this issue again
    Thorsten

  9. #9
    Join Date
    May 2006
    Posts
    4,882

    Default

    It's never was an issue

    - If you get a TNS error message, it just means Oracle is not available
    - If you get password errors logging into the repository use user admin and password admin... there's a difference between the schema owner of the repository and the users used to log on to the repository.

    Regards,
    Sven

  10. #10
    Join Date
    Mar 2008
    Posts
    3

    Default

    Sven,

    thanks for getting back to me so fast. I'm not sure what is going on, but it is not quite as simple as you make it sound.

    I can test my connection to the Oracle XE successfully using the oracle user/password. However, directly after that, I cannot log on to the reporsaitory using the kettle admin/admin. I have it kind of working now: When I test the connection, then directly upgrade the repository (using admin/admin), then I can log on to the repository. I'm not exactly sure that this works all the time, but I managed to get connected to the repository, while directly logging on has never worked.

    Seems to me that something is not working 100% ...

    Thorsten

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.