java.lang.reflect.InvocationTargetException: Error creating or upgrading repository: Unable to create or modify table R_REPOSITORY_LOG Couldn't execute SQL: CREATE TABLE R_REPOSITORY_LOG ( ID_REPOSITORY_LOG BIGSERIAL , REP_VERSION VARCHAR(255) , LOG_DATE TIMESTAMP , LOG_USER VARCHAR(255) , OPERATION_DESC VARCHAR(2000000) ) ERROR: no schema has been selected to create in

Pentaho BI Platform Tracking | Golda David | 3 years ago
  1. 0

    1. Create a database in postgres. 2. Start spoon. 3. In the repo login dialog, create a new db repository. 4. create a database connection enter all the credentials in the general UI. test the connection and save it. 5. Enter an id and name for the db repository and click on the create/upgrade button. 6. click ok to run the scripts. 7. an error dialog appears. java.lang.reflect.InvocationTargetException: Error creating or upgrading repository: Unable to create or modify table R_REPOSITORY_LOG Couldn't execute SQL: CREATE TABLE R_REPOSITORY_LOG ( ID_REPOSITORY_LOG BIGSERIAL , REP_VERSION VARCHAR(255) , LOG_DATE TIMESTAMP , LOG_USER VARCHAR(255) , OPERATION_DESC VARCHAR(2000000) ) ERROR: no schema has been selected to create in at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:117) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:125) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.create(KettleDatabaseRepositoryDialog.java:505) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.access$500(KettleDatabaseRepositoryDialog.java:75) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog$5.handleEvent(KettleDatabaseRepositoryDialog.java:283) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)

    Pentaho BI Platform Tracking | 3 years ago | Golda David
    java.lang.reflect.InvocationTargetException: Error creating or upgrading repository: Unable to create or modify table R_REPOSITORY_LOG Couldn't execute SQL: CREATE TABLE R_REPOSITORY_LOG ( ID_REPOSITORY_LOG BIGSERIAL , REP_VERSION VARCHAR(255) , LOG_DATE TIMESTAMP , LOG_USER VARCHAR(255) , OPERATION_DESC VARCHAR(2000000) ) ERROR: no schema has been selected to create in
  2. 0

    1. Create a database in postgres. 2. Start spoon. 3. In the repo login dialog, create a new db repository. 4. create a database connection enter all the credentials in the general UI. test the connection and save it. 5. Enter an id and name for the db repository and click on the create/upgrade button. 6. click ok to run the scripts. 7. an error dialog appears. java.lang.reflect.InvocationTargetException: Error creating or upgrading repository: Unable to create or modify table R_REPOSITORY_LOG Couldn't execute SQL: CREATE TABLE R_REPOSITORY_LOG ( ID_REPOSITORY_LOG BIGSERIAL , REP_VERSION VARCHAR(255) , LOG_DATE TIMESTAMP , LOG_USER VARCHAR(255) , OPERATION_DESC VARCHAR(2000000) ) ERROR: no schema has been selected to create in at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:117) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:125) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.create(KettleDatabaseRepositoryDialog.java:505) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.access$500(KettleDatabaseRepositoryDialog.java:75) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog$5.handleEvent(KettleDatabaseRepositoryDialog.java:283) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)

    Pentaho BI Platform Tracking | 3 years ago | Golda David
    java.lang.reflect.InvocationTargetException: Error creating or upgrading repository: Unable to create or modify table R_REPOSITORY_LOG Couldn't execute SQL: CREATE TABLE R_REPOSITORY_LOG ( ID_REPOSITORY_LOG BIGSERIAL , REP_VERSION VARCHAR(255) , LOG_DATE TIMESTAMP , LOG_USER VARCHAR(255) , OPERATION_DESC VARCHAR(2000000) ) ERROR: no schema has been selected to create in
  3. 0

    weblogic.utils.AssertionError: ***** ASSERTION FAILED

    Oracle Community | 2 decades ago | 3004
    java.lang.reflect.InvocationTargetException: weblogic.utils.AssertionError: ***** ASSERTION FAILED *****[ Failed to create initial context ]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problems creating a JFrame instance on Windows 2000

    Oracle Community | 2 decades ago | 843807
    java.lang.reflect.InvocationTargetException: java.lang.ExceptionInInitializerError: java.lang.Runtim eException: Unable to create a suitable default GraphicsConfiguration. Try changing your Display Settings.
  6. 0

    WL6.1 SP3: How to Properly configure the JMS Messaging Bridge

    Google Groups | 1 decade ago | Anil Arora
    java.lang.reflect.InvocationTargetException: javax.resource.Reso urceException: Error creating asynchronous consumer or setting message lisenter

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.reflect.InvocationTargetException

      Error creating or upgrading repository: Unable to create or modify table R_REPOSITORY_LOG Couldn't execute SQL: CREATE TABLE R_REPOSITORY_LOG ( ID_REPOSITORY_LOG BIGSERIAL , REP_VERSION VARCHAR(255) , LOG_DATE TIMESTAMP , LOG_USER VARCHAR(255) , OPERATION_DESC VARCHAR(2000000) ) ERROR: no schema has been selected to create in

      at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run()
    2. org.pentaho.di
      UpgradeRepositoryProgressDialog$1.run
      1. org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:117)
      1 frame
    3. JFace
      ProgressMonitorDialog.run
      1. org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
      2. org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
      3. org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495)
      3 frames
    4. org.pentaho.di
      KettleDatabaseRepositoryDialog$5.handleEvent
      1. org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:125)
      2. org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.create(KettleDatabaseRepositoryDialog.java:505)
      3. org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.access$500(KettleDatabaseRepositoryDialog.java:75)
      4. org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog$5.handleEvent(KettleDatabaseRepositoryDialog.java:283)
      4 frames
    5. RWT
      EventTable.sendEvent
      1. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      1 frame