org.postgresql.util.PSQLException: ERROR: syntax error at or near "RUNSCRIPT" Position: 1


Samebug tips

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


7 months ago
Expert tip

Solutions on the web

Solution icon of stackoverflow
ERROR: syntax error at or near "RUNSCRIPT" Position: 1

Solution icon of pentaho
via Pentaho BI Platform Tracking by Kleyson Rios, 1 year ago
ERROR: syntax error at or near "RUNSCRIPT" Position : 1

Solution icon of pentaho
via Pentaho BI Platform Tracking by Florent, 1 year ago
ERROR: syntax error at or near "RUNSCRIPT" Position : 1

Solution icon of pentaho
via Pentaho BI Platform Tracking by Florent, 10 months ago
ERROR: syntax error at or near "RUNSCRIPT" Position : 1

Solution icon of web
via pentaho.com by Unknown author, 1 year ago
ERROR: syntax error at or near "RUNSCRIPT" Position: 1

Solution icon of pentaho
via Pentaho BI Platform Tracking by Kleyson Rios, 1 year ago
ERROR: syntax error at or near "RUNSCRIPT" Position : 1

Solution icon of web
ERROR: syntax error at or near "RUNSCRIPT" Position: 1

Solution icon of web
ERROR: syntax error at or near "RUNSCRIPT" Position: 1

Stack trace

org.postgresql.util.PSQLException: ERROR: syntax error at or near "RUNSCRIPT"
  Position: 1
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:333)
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
	at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.verifyQuartzIsConfigured(EmbeddedQuartzSystemListener.java:176)
	at org.pentaho.platform.scheduler2.quartz.EmbeddedQuartzSystemListener.startup(EmbeddedQuartzSystemListener.java:100)
	at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:436)
	at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:427)
	at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406)
	at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:427)
	at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:82)
	at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:358)
	at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:355)
	at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:406)
	at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:355)
	at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:326)
	at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:222)
	at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:154)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1101)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1786)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 2 months ago
2 times, 4 months ago
25 times, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
99 more bugmates