Question Vaccum in process

Hello,
It is not possible in SqlOperation to add 'VACUUM VERBOSE ANALYZE TABLE ' When prcess was running.

How can i execute Vaccum for table in my procss

Thank you,

Zineddine

Hi,

Can you confirm that you are talking about Postgresql's VACUUM order ?

Why do you say that it is not possible ? Can you share what you tried and what was the unexpected result ? Was there an error ?

Thank you for your answer,

Yes I confirm I want to do a Vaccum on a very large PostgreSQL table that my process uses alot .

I want to incorporate Vaccum between mapping to clean the dead lines, using SQLOPERATION ' VACUUM VERBOSE ANALYZE table_name ' .

But I have a compilation error , I think SqlOperation DDL_DML performed only the operation ( select, update .... ect)

And does not support maintenance Opération like Vaccum.

What is the compilation error ?
Can you post a screenshot of the process and SqlOperation's parameters ?

[xslt] \connection.xsl:146: Fatal Error! Error in call to extension function {public static java.util.List com.indy.xsl.global.Functions.xpath(net.sf.saxon.expr.XPathContext,net.sf.saxon.om.ValueRepresentation,java.lang.String) throws javax.xml.xpath.XPathExpressionException,net.sf.saxon.trans.XPathException,javax.xml.transform.TransformerException,com.indy.xsl.global.XSLException,java.net.URISyntaxException}: Error in call to extension function {public static java.util.List com.indy.xsl.global.Functions.getMdRef(net.sf.saxon.om.NodeInfo) throws javax.xml.xpath.XPathExpressionException,javax.xml.transform.TransformerException,java.net.URISyntaxException}: Cannot convert value class net.sf.saxon.value.EmptySequence of type empty-sequence() to class net.sf.saxon.om.NodeInfo

Hi, I cannot see any metadata on the SqlOperation. So I think it does not know which database to use.
Try to drag an drop the table's metadata on the SqlOperation, and let me know if this is better.

It's great thank you Thomas it work