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 | 4 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 4 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 | 4 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

    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