Database exception: SQLException doing query (42P01)

[Vance Karimi]

After logging into Datafari's admin console and going to the ManifoldCF admin console, I created a new repository connection to the local file system (as per the tutorial video).

When clicking on the New Job button, I get the following error in the browser and can't proceed:

Database exception: SQLException doing query (42P01): ERREUR: la relation « transformationconnections » n'existe pas Position: 63

The tomcat logs contains the following stack trace:

org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (42P01): ERREUR: la relation ½ transformationconnections ╗ n'existe pas  Position: 63

        at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.finishUp(Database.java:702)

        at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:728)

        at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:790)

        at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1444)

        at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146)

        at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:191)

        at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performQuery(DBInterfacePostgreSQL.java:832)

        at org.apache.manifoldcf.core.database.BaseTable.performQuery(BaseTable.java:221)

        at org.apache.manifoldcf.agents.transformationconnection.TransformationConnectionManager.getAllConnections(TransformationConnectionManager.java:201)

        at org.apache.jsp.editjob_jsp._jspService(editjob_jsp.java:198)

        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)

        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

        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:744)Caused by: org.postgresql.util.PSQLException: ERREUR: la relation ½ transformationconnections ╗ n'existe pas  Position: 63

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)

        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)

        at org.apache.manifoldcf.core.database.Database.execute(Database.java:863)

        at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)

[Aurélien MAZOYER]

Hi Vance,

 

Sorry about these issues. They all relate to windows server, and we haven’t tested the executables for this environment. After a quick look, we can solve them rather quickly, but for now we are working on other feature improvements. This is for now due to the fact that all our current customers are using linux rather than windows, hence the low priority of these issues. We do provide executables for Windows 7 and 8, but this is currently recommended for test purposes rather than for productive use.

Note that if enough people are interested in the windows server version, we’ll elevate the priority of this issue and we’ll quickly solve it with pleasure J

 

Regards,

Aurélien

--
You received this message because you are subscribed to the Google Groups "Datafari" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datafari+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[cedric...@francelabs.com]

Hi Vance,

just to let you know that Aurélien closed the issue related to that problem, and that things should be working smoothly on Windows now. Note that the patch has been integrated directly in version 1.0 (yes, it was not clean, we should have done a version 1.01, we'll do that for next patches, but at least now it works :)  ).

You may want to give it a try (go to www.datafari.com/en to download it) and let us know if everything's going smoothly.

Regards,

Cedric

To unsubscribe from this group and stop receiving emails from it, send an email to datafari+unsubscribe@googlegroups.com.