org.pentaho.di.ui.repository.repositoryexplorer.ControllerInitializationException: java.lang.RuntimeException: java.lang.RuntimeException: org.pentaho.di.core.exception.KettleException: Unable to get list of repository objects An error occurred executing SQL: SELECT NAME, MODIFIED_USER, MODIFIED_DATE, DESCRIPTION, ID_JOB FROM R_JOB WHERE ID_DIRECTORY = ? Error determining value metadata from SQL resultset metadata For input string: "4294967295"

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,

You try to parse a String that contains non-numeric characters to an int. The string must contain decimal characters only, optionally beginning with a + or - sign.

,

Java does not handle IPv6 nameservers before 1.8.0_60. Upgrade to the latest JVM.

Solutions on the web

via ukettle.org by Unknown author, 1 year ago
java.lang.RuntimeException: java.lang.RuntimeException: org.pentaho.di.core.exception.KettleException: Unable to get list of repository objects An error occurred executing SQL: SELECT NAME, MODIFIED_USER, MODIFIED_DATE, DESCRIPTION, ID_JOB FROM R_JOB WHERE ID_DIRECTORY = ? Error determining value metadata from SQL resultset metadata For input string: "4294967295"
via Pentaho BI Platform Tracking by Golda David, 1 year ago
org.pentaho.di.core.exception.KettleException: An error occured loading the directory tree from the repository ERROR executing query ERROR: current transaction is aborted, commands ignored until end of transaction block
org.pentaho.di.ui.repository.repositoryexplorer.ControllerInitializationException: java.lang.RuntimeException: java.lang.RuntimeException: org.pentaho.di.core.exception.KettleException: Unable to get list of repository objects An error occurred executing SQL: SELECT NAME, MODIFIED_USER, MODIFIED_DATE, DESCRIPTION, ID_JOB FROM R_JOB WHERE ID_DIRECTORY = ? Error determining value metadata from SQL resultset metadata For input string: "4294967295"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:495)
at java.lang.Integer.parseInt(Integer.java:527)
at oracle.jdbc.driver.OracleResultSetMetaData.getPrecision(OracleResultSetMetaData.java:331)
at org.pentaho.di.core.row.value.ValueMetaBase.getOriginalColumnMetadata(ValueMetaBase.java:4608)
at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromSQLType(ValueMetaBase.java:4561)
at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2260)
at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2222)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1707)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1639)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1634)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getRepositoryObjects(KettleDatabaseRepositoryConnectionDelegate.java:1537)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getRepositoryObjects(KettleDatabaseRepository.java:848)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getJobObjects(KettleDatabaseRepository.java:824)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getJobAndTransformationObjects(KettleDatabaseRepository.java:1904)
at org.pentaho.di.ui.repository.repositoryexplorer.model.UIRepositoryDirectory.getRepositoryObjects(UIRepositoryDirectory.java:123)
at org.pentaho.di.ui.repository.repositoryexplorer.controllers.BrowseController.setRepositoryDirectories(BrowseController.java:840)
at org.pentaho.di.ui.repository.repositoryexplorer.controllers.BrowseController.setSelectedFolderItems(BrowseController.java:759)
at org.pentaho.di.ui.repository.repositoryexplorer.controllers.BrowseController.createBindings(BrowseController.java:250)
at org.pentaho.di.ui.repository.repositoryexplorer.controllers.BrowseController.init(BrowseController.java:170)
at org.pentaho.di.ui.repository.repositoryexplorer.uisupport.AbstractRepositoryExplorerUISupport.initControllers(AbstractRepositoryExplorerUISupport.java:79)
at org.pentaho.di.ui.repository.repositoryexplorer.RepositoryExplorer.(RepositoryExplorer.java:110)
at org.pentaho.di.ui.spoon.Spoon$25$1.run(Spoon.java:3982)
at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1339)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9214)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:653)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week ago
18 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
264 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.