org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement

Pentaho BI Platform Tracking | Sean Flatley | 4 years ago
  1. 0

    To reproduce - create an instaview. Example of how to create: - Open Spoon - Create a new instaview - Choose the "Local File" / "CSV" template - Use the customer-100.txt sample data file as inpu.t. Change the delimiter to a a semicolon - Click close on the "document scan dialog" - Click ok on the step dialog - Click "Close" in the Instaview perspective. - Click "Don't save" - From the Instaview start page quickly create a new instaview clicking through the wizard quickly to get to the step dialog. It appears that MonetDB is not completely shut down when the restart happens. This appears in the Spoon console: RROR 04-10 15:49:58,632 - directory is already initialised: /home/sflatley/.kettle/instaview/dbfarm another monetdbd is already running monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p ERROR 04-10 14:37:06,701 - InstaService.ERROR_COUL - Could not start MonetDB. java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB could not start. at org.pentaho.agilebi.insta.MonetDbUtil.start(MonetDbUtil.java:203) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpen(InstaService.java:2399) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpenJson(InstaService.java:2390) at org.pentaho.agilebi.insta.InstaContentGenerator.beforeProjectOpen(InstaContentGenerator.java:152) at org.pentaho.agilebi.insta.InstaContentGenerator.createContent(InstaContentGenerator.java:134) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) This exception appeared when I was in the "CSV" step dialog. I was able to use the dialog, i.e., I was not informed through the UI that there was an exceotion. When I clicked "OK" in the dialog an error dialog was displayed with " Could not adjust schema for table: instaview_20121004024804211". Spoon's console had: INFO 04-10 14:48:04,564 - Output - Exit Value of psql: 2 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121004024804211 rowCount=-1 ERROR 04-10 14:48:04,575 - Output - An error occurred: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Unable to connect (localhost:50000): Connection refused ERROR 04-10 14:48:04,583 - Output - Output from mclient: ERROR 04-10 14:48:04,584 - Output - Could not adjust schema for table: instaview_20121004024804211 ERROR 04-10 14:48:04,585 - Output - org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:628) at org.pentaho.di.trans.steps.monetdbagilemart.MonetDBAgileMart.adjustSchema(MonetDBAgileMart.java:160) at org.pentaho.agilebi.insta.PdiRunnerBase.updateSchema(PdiRunnerBase.java:688) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:44) 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.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8298) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Caused by: org.pentaho.di.core.exception.KettleException: An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:595) ... 16 more ERROR 04-10 14:48:04,587 - PdiRunner.SCHEMA_UPDATE_FAILED - Could not adjust schema for table: /home/sflatley/pdi-ee-4.4.0-GA-oct-4/pdi-ee/data-integration/projects/Untitled 3/Untitled 3.ktr ERROR 04-10 14:48:04,590 - operation failed: MODE_UPDATE_SCHEMA

    Pentaho BI Platform Tracking | 4 years ago | Sean Flatley
    org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement
  2. 0

    To reproduce - create an instaview. Example of how to create: - Open Spoon - Create a new instaview - Choose the "Local File" / "CSV" template - Use the customer-100.txt sample data file as inpu.t. Change the delimiter to a a semicolon - Click close on the "document scan dialog" - Click ok on the step dialog - Click "Close" in the Instaview perspective. - Click "Don't save" - From the Instaview start page quickly create a new instaview clicking through the wizard quickly to get to the step dialog. It appears that MonetDB is not completely shut down when the restart happens. This appears in the Spoon console: RROR 04-10 15:49:58,632 - directory is already initialised: /home/sflatley/.kettle/instaview/dbfarm another monetdbd is already running monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p monetdb: cannot find a control socket, use -h and/or -p ERROR 04-10 14:37:06,701 - InstaService.ERROR_COUL - Could not start MonetDB. java.lang.IllegalStateException: MonetDB.ERROR_COUL - MonetDB could not start. at org.pentaho.agilebi.insta.MonetDbUtil.start(MonetDbUtil.java:203) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpen(InstaService.java:2399) at org.pentaho.agilebi.insta.InstaService.beforeProjectOpenJson(InstaService.java:2390) at org.pentaho.agilebi.insta.InstaContentGenerator.beforeProjectOpen(InstaContentGenerator.java:152) at org.pentaho.agilebi.insta.InstaContentGenerator.createContent(InstaContentGenerator.java:134) at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66) at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261) at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:108) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:322) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:536) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:930) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:405) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) This exception appeared when I was in the "CSV" step dialog. I was able to use the dialog, i.e., I was not informed through the UI that there was an exceotion. When I clicked "OK" in the dialog an error dialog was displayed with " Could not adjust schema for table: instaview_20121004024804211". Spoon's console had: INFO 04-10 14:48:04,564 - Output - Exit Value of psql: 2 Util.updateMetadata writing AgileBI~$NULL$~instaview_20121004024804211 rowCount=-1 ERROR 04-10 14:48:04,575 - Output - An error occurred: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Unable to connect (localhost:50000): Connection refused ERROR 04-10 14:48:04,583 - Output - Output from mclient: ERROR 04-10 14:48:04,584 - Output - Could not adjust schema for table: instaview_20121004024804211 ERROR 04-10 14:48:04,585 - Output - org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:628) at org.pentaho.di.trans.steps.monetdbagilemart.MonetDBAgileMart.adjustSchema(MonetDBAgileMart.java:160) at org.pentaho.agilebi.insta.PdiRunnerBase.updateSchema(PdiRunnerBase.java:688) at org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:44) 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.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8298) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134) Caused by: org.pentaho.di.core.exception.KettleException: An error occurred creating SQL statement at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:595) ... 16 more ERROR 04-10 14:48:04,587 - PdiRunner.SCHEMA_UPDATE_FAILED - Could not adjust schema for table: /home/sflatley/pdi-ee-4.4.0-GA-oct-4/pdi-ee/data-integration/projects/Untitled 3/Untitled 3.ktr ERROR 04-10 14:48:04,590 - operation failed: MODE_UPDATE_SCHEMA

    Pentaho BI Platform Tracking | 4 years ago | Sean Flatley
    org.pentaho.di.core.exception.KettleException: An error occurred writing data to the mclient process An error occurred creating SQL statement
  3. 0

    I have created a transformation that injects metadata to a row denormalizer step using PDI 5.4 The transformation works perfectly when I am saving the files as .ktr, but if I create and save exactly the same in a database repository I obtain an error when running. If I close the transformation in the database repository I obtain as well an error and it's not possible to open it. Both error logs contain: ArrayIndexOutOfBoundsException I am attaching the ktr files for your review. EDIT: Sorry, I'm not being able to upload the file. Tried with .zip .ktr in Chrome and Mozilla and the file doesn't attach. Is it another bug or just me, nothing working today? Maybe something related to this bug came back: PDI-9152 Error Log when running: org.pentaho.di.core.exception.KettleException: Transformation was unable to open [MetaInject 1] An error occured reading a transformation from the repository at org.pentaho.di.trans.Trans.<init>(Trans.java:592) at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3639) at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:880) at org.pentaho.di.ui.spoon.Spoon$31$1.run(Spoon.java:8464) 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.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) 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:92) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278) at org.pentaho.di.trans.Trans.<init>(Trans.java:568) ... 16 more Caused by: java.lang.ArrayIndexOutOfBoundsException Error log when opening: java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:97) 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.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:105) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4237) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4159) 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.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141) at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton.access$100(SwtToolbarbutton.java:48) at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton$1.widgetSelected(SwtToolbarbutton.java:96) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) 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.spoon.Spoon.readAndDispatch(Spoon.java:1319) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) 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:92) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:92) ... 29 more Caused by: java.lang.ArrayIndexOutOfBoundsException

    Pentaho BI Platform Tracking | 1 year ago | Azucena Coronel
    org.pentaho.di.core.exception.KettleException: Transformation was unable to open [MetaInject 1] An error occured reading a transformation from the repository
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    tested in trunk: java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:81) 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.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89) at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5679) at org.pentaho.di.ui.spoon.Spoon.loadLastUsedFile(Spoon.java:5651) at org.pentaho.di.ui.spoon.Spoon.lastFileSelect(Spoon.java:1278) 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.xul.EventHandler.handleMenuEvent(EventHandler.java:44) at org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52) at org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117) at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77) at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73) 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.spoon.Spoon.readAndDispatch(Spoon.java:945) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository Unable to set partition schema for name [PartitionSchema], method: Mod partitioner This is the list of available partition schema: at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2609) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2442) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77) ... 23 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to set partition schema for name [PartitionSchema], method: Mod partitioner This is the list of available partition schema:

    Pentaho BI Platform Tracking | 8 years ago | Jens Bleuel
    java.lang.reflect.InvocationTargetException: Error loading transformation
  6. 0

    When passing JSon Input step a Null value, the following Null Pointer Exception is thrown: {noformat} 2015/08/20 16:29:01 - Json Input.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected Error : org.pentaho.di.core.exception.KettleException: 2015/08/20 16:29:01 - Json Input.0 - Error parsing string [java.lang.NullPointerException]! 2015/08/20 16:29:01 - Json Input.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2015/08/20 16:29:01 - Json Input.0 - Error parsing string [java.lang.NullPointerException]! 2015/08/20 16:29:01 - Json Input.0 - 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonReader.readString(JsonReader.java:147) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.parseJson(JsonInput.java:272) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.readFileOrString(JsonInput.java:258) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.ReadNextString(JsonInput.java:165) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.getOneRow(JsonInput.java:396) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.steps.jsoninput.JsonInput.processRow(JsonInput.java:344) 2015/08/20 16:29:01 - Json Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/08/20 16:29:01 - Json Input.0 - at java.lang.Thread.run(Thread.java:745) {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Meelan Laxman
    org.pentaho.di.core.exception.KettleException: Error parsing string [java.lang.NullPointerException]!

    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. org.pentaho.di.core.exception.KettleException

      An error occurred creating SQL statement

      at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema()
    2. org.pentaho.di
      MonetDBAgileMart.adjustSchema
      1. org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoader.autoAdjustSchema(MonetDBBulkLoader.java:595)
      2. org.pentaho.di.trans.steps.monetdbagilemart.MonetDBAgileMart.adjustSchema(MonetDBAgileMart.java:160)
      2 frames
    3. org.pentaho.agilebi
      PdiRunner.run
      1. org.pentaho.agilebi.insta.PdiRunnerBase.updateSchema(PdiRunnerBase.java:688)
      2. org.pentaho.agilebi.insta.PdiRunner.run(PdiRunner.java:44)
      2 frames
    4. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
      2. org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
      3. org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
      4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      4 frames
    5. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221)
      2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8298)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
      4 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
      1 frame