org.pentaho.platform.dataaccess.datasource.wizard.models.CsvTransformGeneratorException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE"

Pentaho BI Platform Tracking | Rob Fellows | 6 years ago
  1. 0

    Staging table is not being dropped before staging the data of an uploaded csv file when using PostgreSQL as the bi-server dbms. Repro: Configure postgresql as the dbms for biserver (for hibernate & quartz). Configure data-access plugin's dialect setting for postgresql. Start BI-SERVER Create a new CSV datasource. On the staging settings step, force a breaking data type selection (pick DATE for a column that defaulted to STRING or NUMBER). Click Finish. On summary screen, 0 rows loaded should show as expected. Expand the Error Log and click "Edit Field Settings" button On the stage settings step, put the bad column's data type back to the original value. Click Finish. Observe that an error dialog shows that a column could not be added due to a data type conflict. This should not happen because the table should have been dropped and recreated. *** note that the _KTL in the alter table statement looks out of place. regardless, the table should be dropped and never get here. but if the dialect is messed up, then that might explain the reason the drop of the table isn't happening. *** Error / Stack Trace ================================================ Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE" org.pentaho.platform.dataaccess.datasource.wizard.models.CsvTransformGeneratorException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE" at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.execSqlStatement(CsvTransformGenerator.java:591) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.executeSql(CsvTransformGenerator.java:524) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.createOrModifyTable(CsvTransformGenerator.java:127) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.CsvDatasourceServiceImpl.stageData(CsvDatasourceServiceImpl.java:87) 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 com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:562) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:544) at org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet.processCall(GwtRpcPluginProxyServlet.java:131) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:224) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:103) 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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE" at org.pentaho.di.core.database.Database.execStatement(Database.java:1623) at org.pentaho.di.core.database.Database.execStatement(Database.java:1569) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.execSqlStatement(CsvTransformGenerator.java:586) ... 74 more Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "DOUBLE" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) at org.pentaho.di.core.database.Database.execStatement(Database.java:1592) ... 76 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    org.pentaho.platform.dataaccess.datasource.wizard.models.CsvTransformGeneratorException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE"
  2. 0

    Staging table is not being dropped before staging the data of an uploaded csv file when using PostgreSQL as the bi-server dbms. Repro: Configure postgresql as the dbms for biserver (for hibernate & quartz). Configure data-access plugin's dialect setting for postgresql. Start BI-SERVER Create a new CSV datasource. On the staging settings step, force a breaking data type selection (pick DATE for a column that defaulted to STRING or NUMBER). Click Finish. On summary screen, 0 rows loaded should show as expected. Expand the Error Log and click "Edit Field Settings" button On the stage settings step, put the bad column's data type back to the original value. Click Finish. Observe that an error dialog shows that a column could not be added due to a data type conflict. This should not happen because the table should have been dropped and recreated. *** note that the _KTL in the alter table statement looks out of place. regardless, the table should be dropped and never get here. but if the dialect is messed up, then that might explain the reason the drop of the table isn't happening. *** Error / Stack Trace ================================================ Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE" org.pentaho.platform.dataaccess.datasource.wizard.models.CsvTransformGeneratorException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE" at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.execSqlStatement(CsvTransformGenerator.java:591) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.executeSql(CsvTransformGenerator.java:524) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.createOrModifyTable(CsvTransformGenerator.java:127) at org.pentaho.platform.dataaccess.datasource.wizard.service.impl.CsvDatasourceServiceImpl.stageData(CsvDatasourceServiceImpl.java:87) 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 com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:562) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:544) at org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet.processCall(GwtRpcPluginProxyServlet.java:131) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:224) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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:103) 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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE" at org.pentaho.di.core.database.Database.execStatement(Database.java:1623) at org.pentaho.di.core.database.Database.execStatement(Database.java:1569) at org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.execSqlStatement(CsvTransformGenerator.java:586) ... 74 more Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "DOUBLE" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261) at org.pentaho.di.core.database.Database.execStatement(Database.java:1592) ... 76 more

    Pentaho BI Platform Tracking | 6 years ago | Rob Fellows
    org.pentaho.platform.dataaccess.datasource.wizard.models.CsvTransformGeneratorException: Couldn't execute SQL: ALTER TABLE BADONES ADD COLUMN "from"_KTL DOUBLE PRECISION ERROR: syntax error at or near "DOUBLE"
  3. 0

    Issue with wso2 GREG 4.5.0 and postgresql as external DB

    Stack Overflow | 4 years ago | Jorge Infante Osorio
    org.wso2.carbon.humantask.core.engine.HumanTaskServerException: Error creating HumanTask database
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DSpace / Mailing Lists

    sourceforge.net | 1 year ago
    java.sql.SQLException: Flyway migration error occurred
  6. 0

    SQL deadlock detected

    Google Groups | 2 years ago | dave J
    org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 6085 waits for ShareLock on transaction 11439771; blocked by process 6088. Process 6088 waits for ShareLock on transaction 11439773; blocked by process 6085. Hint: See server log for query details. Where: SQL statement "UPDATE adir_MRExperiment_meta_data SET last_modified=NOW(), modified=1 WHERE meta_data_id=current_row.meta_data_id" PL/pgSQL function "update_ls_adir_mrexperiment" line 18 at SQL statement SQL statement "SELECT update_ls_adir_MRExperiment( $1, $2)" PL/pgSQL function "update_ls_xnat_imagesessiondata" line 15 at PERFORM SQL statement "SELECT update_ls_xnat_imageSessionData(current_row.image_session_id, $2)" PL/pgSQL function "update_ls_ext_xnat_imagescandata" line 14 at PERFORM SQL statement "SELECT update_ls_ext_xnat_imageScanData( $1, $2)" PL/pgSQL function "update_ls_ext_xnat_mrscandata" line 24 at PERFORM SQL statement "SELECT update_ls_ext_xnat_mrScanData( $1, $2)" PL/pgSQL function "update_ls_adir_mrscan" line 24 at PERFORM SQL statement "SELECT update_ls_adir_MRScan( $1, $2)" PL/pgSQL function "update_ls_xnat_mrscandata" line 15 at PERFORM

  1. silex 16 times, last 3 weeks ago
  2. silex 1 times, last 5 months ago
10 unregistered visitors
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.postgresql.util.PSQLException

    ERROR: syntax error at or near "DOUBLE"

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
    6 frames
  3. Commons DBCP
    DelegatingStatement.execute
    1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
    1 frame
  4. org.pentaho.di
    Database.execStatement
    1. org.pentaho.di.core.database.Database.execStatement(Database.java:1592)
    2. org.pentaho.di.core.database.Database.execStatement(Database.java:1569)
    2 frames
  5. org.pentaho.platform
    CsvDatasourceServiceImpl.stageData
    1. org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.execSqlStatement(CsvTransformGenerator.java:586)
    2. org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.executeSql(CsvTransformGenerator.java:524)
    3. org.pentaho.platform.dataaccess.datasource.wizard.service.agile.CsvTransformGenerator.createOrModifyTable(CsvTransformGenerator.java:127)
    4. org.pentaho.platform.dataaccess.datasource.wizard.service.impl.CsvDatasourceServiceImpl.stageData(CsvDatasourceServiceImpl.java:87)
    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. Jetty Contrib :: jetty-gwt RemoteServiceServlet
    RPC.invokeAndEncodeResponse
    1. com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:562)
    2. com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:544)
    2 frames
  8. org.pentaho.platform
    GwtRpcPluginProxyServlet.processCall
    1. org.pentaho.platform.web.servlet.GwtRpcPluginProxyServlet.processCall(GwtRpcPluginProxyServlet.java:131)
    1 frame
  9. Jetty Contrib :: jetty-gwt RemoteServiceServlet
    AbstractRemoteServiceServlet.doPost
    1. com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:224)
    2. com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
    2 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    2 frames
  11. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  12. org.pentaho.platform
    PentahoWebContextFilter.doFilter
    1. org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
    1 frame
  13. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  14. org.pentaho.platform
    PentahoRequestContextFilter.doFilter
    1. org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    1 frame
  15. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  16. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    1 frame
  17. org.springframework.security
    FilterSecurityInterceptor.doFilter
    1. org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    2. org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    2 frames
  18. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  19. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  20. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  21. org.pentaho.platform
    SecurityStartupFilter.doFilter
    1. org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    1 frame
  22. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  23. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  24. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  25. org.pentaho.platform
    RequestParameterAuthenticationFilter.doFilter
    1. org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    1 frame
  26. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  27. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  28. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  29. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  30. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  31. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  32. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  33. org.pentaho.platform
    HttpSessionReuseDetectionFilter.doFilter
    1. org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    1 frame
  34. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  35. Spring Security - Portlet support
    HttpSessionContextIntegrationFilter.doFilterHttp
    1. org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    1 frame
  36. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    1 frame
  37. spring-security-core
    FilterChainProxy$VirtualFilterChain.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    1 frame
  38. org.springframework.security
    SpringSecurityFilter.doFilter
    1. org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    2. org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    2 frames
  39. spring-security-core
    FilterToBeanProxy.doFilter
    1. org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    2. org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    3. org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    3 frames
  40. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  41. com.pentaho.ui
    SystemStatusFilter.doFilter
    1. com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43)
    1 frame
  42. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  43. org.pentaho.platform
    SetCharacterEncodingFilter.doFilter
    1. org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    1 frame
  44. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    9 frames
  45. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
    3 frames
  46. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame