GitHub user anilaladag edited a comment on the discussion: Remote Workflow
Execution
```
<workflow_configuration>
<workflow>
<name>onlyPip</name>
<name_sync_with_filename>N</name_sync_with_filename>
<description/>
<extended_description/>
<workflow_version/>
<created_user>-</created_user>
<created_date>2025/03/13 12:04:36.837</created_date>
<modified_user>-</modified_user>
<modified_date>2025/03/13 12:04:36.837</modified_date>
<parameters>
</parameters>
<actions>
<action>
<name>Start</name>
<description/>
<type>SPECIAL</type>
<attributes/>
<DayOfMonth>1</DayOfMonth>
<hour>12</hour>
<intervalMinutes>60</intervalMinutes>
<intervalSeconds>0</intervalSeconds>
<minutes>0</minutes>
<repeat>N</repeat>
<schedulerType>0</schedulerType>
<weekDay>1</weekDay>
<parallel>N</parallel>
<xloc>50</xloc>
<yloc>50</yloc>
<attributes_hac/>
</action>
<action>
<name>Success</name>
<description/>
<type>SUCCESS</type>
<attributes/>
<parallel>N</parallel>
<xloc>864</xloc>
<yloc>64</yloc>
<attributes_hac/>
</action>
<action>
<name>PostgreDBdataRetrieve.hpl</name>
<description/>
<type>PIPELINE</type>
<attributes/>
<add_date>N</add_date>
<add_time>N</add_time>
<clear_files>N</clear_files>
<clear_rows>N</clear_rows>
<create_parent_folder>N</create_parent_folder>
<exec_per_row>N</exec_per_row>
<filename>${Internal.Entry.Current.Folder}/PostgreDBdataRetrieve.hpl</filename>
<loglevel>Basic</loglevel>
<parameters>
<pass_all_parameters>Y</pass_all_parameters>
</parameters>
<params_from_previous>N</params_from_previous>
<run_configuration>local</run_configuration>
<set_append_logfile>N</set_append_logfile>
<set_logfile>N</set_logfile>
<wait_until_finished>Y</wait_until_finished>
<parallel>N</parallel>
<xloc>544</xloc>
<yloc>64</yloc>
<attributes_hac/>
</action>
</actions>
<hops>
<hop>
<from>Start</from>
<to>PostgreDBdataRetrieve.hpl</to>
<enabled>Y</enabled>
<evaluation>Y</evaluation>
<unconditional>Y</unconditional>
</hop>
<hop>
<from>PostgreDBdataRetrieve.hpl</from>
<to>Success</to>
<enabled>Y</enabled>
<evaluation>Y</evaluation>
<unconditional>N</unconditional>
</hop>
</hops>
<notepads>
</notepads>
<attributes/>
</workflow>
<workflow_execution_configuration>
<parameters>
</parameters>
<variables>
<variable><name>Author</name><value>Anıl Aladağ</value></variable>
<variable><name>HOP_AES_ENCODER_KEY</name><value/></variable>
<variable><name>HOP_AGGREGATION_ALL_NULLS_ARE_ZERO</name><value>N</value></variable>
<variable><name>HOP_AGGREGATION_MIN_NULL_IS_VALUED</name><value>N</value></variable>
<variable><name>HOP_ALLOW_EMPTY_FIELD_NAMES_AND_TYPES</name><value>N</value></variable>
<variable><name>HOP_BATCHING_ROWSET</name><value>N</value></variable>
<variable><name>HOP_CONTEXT_DIALOG_STRICT_SEARCH</name><value>N</value></variable>
<variable><name>HOP_DATASETS_FOLDER</name><value>/usr/local/tomcat/webapps/ROOT/config/projects/ftpAndDbPoC/datasets</value></variable>
<variable><name>HOP_DEFAULT_BIGNUMBER_FORMAT</name><value/></variable>
<variable><name>HOP_DEFAULT_BUFFER_POLLING_WAITTIME</name><value>20</value></variable>
<variable><name>HOP_DEFAULT_DATE_FORMAT</name><value/></variable>
<variable><name>HOP_DEFAULT_INTEGER_FORMAT</name><value/></variable>
<variable><name>HOP_DEFAULT_NUMBER_FORMAT</name><value/></variable>
<variable><name>HOP_DEFAULT_SERVLET_ENCODING</name><value/></variable>
<variable><name>HOP_DEFAULT_TIMESTAMP_FORMAT</name><value/></variable>
<variable><name>HOP_DISABLE_CONSOLE_LOGGING</name><value>N</value></variable>
<variable><name>HOP_EMPTY_STRING_DIFFERS_FROM_NULL</name><value>N</value></variable>
<variable><name>HOP_ENVIRONMENT_NAME</name><value>Dev</value></variable>
<variable><name>HOP_FILE_OUTPUT_MAX_STREAM_COUNT</name><value>1024</value></variable>
<variable><name>HOP_FILE_OUTPUT_MAX_STREAM_LIFE</name><value>0</value></variable>
<variable><name>HOP_GLOBAL_LOG_VARIABLES_CLEAR_ON_EXPORT</name><value>N</value></variable>
<variable><name>HOP_GUI_ZOOM_FACTOR</name><value>1.0</value></variable>
<variable><name>HOP_JSON_INPUT_INCLUDE_NULLS</name><value>Y</value></variable>
<variable><name>HOP_LENIENT_STRING_TO_NUMBER_CONVERSION</name><value>N</value></variable>
<variable><name>HOP_LICENSE_HEADER_FILE</name><value/></variable>
<variable><name>HOP_LOG_LEVEL</name><value>Basic</value></variable>
<variable><name>HOP_LOG_MARK_MAPPINGS</name><value>N</value></variable>
<variable><name>HOP_LOG_SIZE_LIMIT</name><value>0</value></variable>
<variable><name>HOP_MAX_ACTIONS_LOGGED</name><value>5000</value></variable>
<variable><name>HOP_MAX_LOGGING_REGISTRY_SIZE</name><value>10000</value></variable>
<variable><name>HOP_MAX_TAB_LENGTH</name><value/></variable>
<variable><name>HOP_MAX_WORKFLOW_TRACKER_SIZE</name><value>5000</value></variable>
<variable><name>HOP_PASSWORD_ENCODER_PLUGIN</name><value>Hop</value></variable>
<variable><name>HOP_PIPELINE_ROWSET_SIZE</name><value/></variable>
<variable><name>HOP_PLUGIN_CLASSES</name><value/></variable>
<variable><name>HOP_PROJECT_NAME</name><value>FtpAndDBPoC</value></variable>
<variable><name>HOP_ROWSET_GET_TIMEOUT</name><value>50</value></variable>
<variable><name>HOP_ROWSET_PUT_TIMEOUT</name><value>50</value></variable>
<variable><name>HOP_S3_VFS_PART_SIZE</name><value/></variable>
<variable><name>HOP_SERVER_DETECTION_TIMER</name><value/></variable>
<variable><name>HOP_SERVER_JETTY_ACCEPTORS</name><value/></variable>
<variable><name>HOP_SERVER_JETTY_ACCEPT_QUEUE_SIZE</name><value/></variable>
<variable><name>HOP_SERVER_JETTY_RES_MAX_IDLE_TIME</name><value/></variable>
<variable><name>HOP_SERVER_OBJECT_TIMEOUT_MINUTES</name><value>1440</value></variable>
<variable><name>HOP_SERVER_REFRESH_STATUS</name><value/></variable>
<variable><name>HOP_SPLIT_FIELDS_REMOVE_ENCLOSURE</name><value>N</value></variable>
<variable><name>HOP_SYSTEM_HOSTNAME</name><value/></variable>
<variable><name>HOP_TRANSFORM_PERFORMANCE_SNAPSHOT_LIMIT</name><value>0</value></variable>
<variable><name>HOP_UNIT_TESTS_FOLDER</name><value>/usr/local/tomcat/webapps/ROOT/config/projects/ftpAndDbPoC</value></variable>
<variable><name>HOP_WEB_THEME</name><value>light</value></variable>
<variable><name>HOP_ZIP_MAX_ENTRY_SIZE</name><value/></variable>
<variable><name>HOP_ZIP_MAX_ENTRY_SIZE_DEFAULT_STRING</name><value/></variable>
<variable><name>HOP_ZIP_MAX_TEXT_SIZE</name><value/></variable>
<variable><name>HOP_ZIP_MAX_TEXT_SIZE_DEFAULT_STRING</name><value/></variable>
<variable><name>HOP_ZIP_MIN_INFLATE_RATIO</name><value/></variable>
<variable><name>HOP_ZIP_MIN_INFLATE_RATIO_DEFAULT_STRING</name><value/></variable>
<variable><name>NEO4J_LOGGING_CONNECTION</name><value/></variable>
<variable><name>PROJECT_HOME</name><value>/usr/local/tomcat/webapps/ROOT/config/projects/ftpAndDbPoC</value></variable>
<variable><name>XML_ALLOW_DOCTYPE_DECL</name><value>N</value></variable>
<variable><name>catalina.base</name><value>/usr/local/tomcat</value></variable>
<variable><name>catalina.home</name><value>/usr/local/tomcat</value></variable>
<variable><name>catalina.useNaming</name><value>true</value></variable>
<variable><name>common.loader</name><value>"${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar"</value></variable>
<variable><name>ignore.endorsed.dirs</name><value/></variable>
<variable><name>jdk.debug</name><value>release</value></variable>
<variable><name>jdk.tls.ephemeralDHKeySize</name><value>2048</value></variable>
<variable><name>native.encoding</name><value>UTF-8</value></variable>
<variable><name>org.apache.catalina.security.SecurityListener.UMASK</name><value>0027</value></variable>
<variable><name>package.access</name><value>sun.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.tomcat.</value></variable>
<variable><name>package.definition</name><value>sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.naming.,org.apache.tomcat.</value></variable>
<variable><name>server.loader</name><value/></variable>
<variable><name>shared.loader</name><value/></variable>
<variable><name>tomcat.util.buf.StringCache.byte.enabled</name><value>true</value></variable>
<variable><name>tomcat.util.scan.StandardJarScanFilter.jarsToScan</name><value>log4j-taglib*.jar,log4j-web*.jar,log4javascript*.jar,slf4j-taglib*.jar</value></variable>
<variable><name>tomcat.util.scan.StandardJarScanFilter.jarsToSkip</name><value>annotations-api.jar,ant-junit*.jar,ant-launcher.jar,ant.jar,asm-*.jar,aspectj*.jar,bootstrap.jar,catalina-ant.jar,catalina-ha.jar,catalina-ssi.jar,catalina-storeconfig.jar,catalina-tribes.jar,catalina.jar,cglib-*.jar,cobertura-*.jar,commons-beanutils*.jar,commons-codec*.jar,commons-collections*.jar,commons-daemon.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,derby-*.jar,dom4j-*.jar,easymock-*.jar,ecj-*.jar,el-api.jar,geronimo-spec-jaxrpc*.jar,h2*.jar,ha-api-*.jar,hamcrest-*.jar,hibernate*.jar,httpclient*.jar,icu4j-*.jar,jasper-el.jar,jasper.jar,jaspic-api.jar,jaxb-*.jar,jaxen-*.jar,jaxws-rt-*.jar,jdom-*.jar,jetty-*.jar,jmx-tools.jar,jmx.jar,jsp-api.jar,jstl.jar,jta*.jar,junit-*.jar,junit.jar,log4j*.jar,mail*.jar,objenesis-*.jar,oraclepki.jar,oro-*.jar,servlet-api-*.ja
r,servlet-api.jar,slf4j*.jar,taglibs-standard-spec-*.jar,tagsoup-*.jar,tomcat-api.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-i18n-*.jar,tomcat-jdbc.jar,tomcat-jni.jar,tomcat-juli-adapters.jar,tomcat-juli.jar,tomcat-util-scan.jar,tomcat-util.jar,tomcat-websocket.jar,tools.jar,websocket-api.jar,wsdl4j*.jar,xercesImpl.jar,xml-apis.jar,xmlParserAPIs-*.jar,xmlParserAPIs.jar,xom-*.jar</value></variable>
</variables>
<log_level>Detailed</log_level>
<clear_log>Y</clear_log>
<start_copy_name/>
<gather_metrics>Y</gather_metrics>
<expand_remote_workflow>N</expand_remote_workflow>
<run_configuration>local</run_configuration>
</workflow_execution_configuration>
<metastore_json>H4sIAAAAAAAAA9UayXLbOPZXWMwcrXiJ01luikWP1aUtopxUqp1iQSRIISYBDgDaVlz+lj7OuS/zA93zX/OwkCIlem078eRgkQ/A2/E25tIVmJ9h7r7/7dIVi0JG7JxOGJfue1qk6ZZ7jufdPB+hDLvvXXfLFSI9YDQmSbkBAEMWwWqMUoG33Jyzi6XBoPYvmJDUnF6wPDDU9mCBMjpRW49ggzB7GSxxEmHvgghJaALrOeaSYLHCjoQ4ZzyCAx4N+TKXOHL25vjdWxSHb39B6E28h/fD+Zt3IX6zG6F3Mfol2gfcZ4TLAqUTJBeGWF4hHyIhMTciGplyw/7bnbfqqGVfvTk9Fp6CtqyYRyvhAFSAcPYNRRmh7tXWD9Tp/41Kd1cqPRpPHF9zf0/FfoV9JMcpobgDB+aw9BvACkpkR2IhzSuP5pnQnr3Bql26dCdjf/bPqed/HKi3CEk0RwJb2+TARsJBV0AuLRJC+0pLtSNbLqERvpiheYpFjsJKXIVoE4rCEAsxW+YA2WnYsU7pofYwLFrWJwahYdIq//X+K3XzjL/QmnGQlJzMC4m1SvzjyWQ8nfnBrD/0/Fl3OAl63Vk3mH2ZeIDlC6D4eDyeeUF3MAgO+96g5wN4BODq5IfxeOB1RxvnDsfTAy/o97zRrA8np0BjHAzGn73pQdf3LJYJ6NabfvIC+9sLPo+nvcDuUGhAquBgPBp5BzNjzla8wMw63kNvOgV8/sGRN+wGo+5QrcE9dTNEwT+OeXqdx11VTms1W3qs8sXu94JjuMIUh5Iw2sMxAU+EJ+OH+AKHhXrtEBqzTspCZBfXPNNYo9reh92DavOlqw6mnZilkQrYl02DH5IUOxXqhsM2zoHvMyYPLRL3H5dwCYPuca8/Cw7Hg543vTrZrjgQJ9tadOXOA5YAwqSHU7SEg3s7Ozurm2xIoCIiEoARFiEnueFb6bN2vk8hMpwhpejXCoXSH7j7a
Zyyc1BN0n5fU3N4gjimUoxpuqzil+WgByScKZbOZ4vMAYLuCveMDTRykHgyHf8KrhMcjYceSKt2pDE7B2EVn4CDE3yGXy7OY/eruuGG4T71cchopCKrktwqCZjCnLCIgAJqXJXhSZnFcrhB2ApVkS05t5p6ucjTOp2u9CiYU/IC8ANSiC6r19UmXyJ12zUfSrkiXOAMdaK6U7ZoGNMwZQL82Lxanofg5I5WrQ+q9TWqNgPHBKfRyu9N1I1wSDKU+stszuzFIvEIfPwTSgtc5rLcxENXOUZiUwAcFBr3jnLXgkYgmd22QGkcgHmUj4NqE8X/7k7FMIkAHhYc/CRcVpSPKflXgZ1+BN5DYmIuiUOLbI75iSIZsiyDNSsM4xmSkMNO4f0FABLgIQcW6pKAk2Q2kqs8fz9ZfThNk6aond07yfp6Jav+aZPWRq9bJHu+goEbXiebX/ws0f6Gf76qJENJq1Td5DaJnsQNR/oCNCXau++NEyhFfNlqK71ym2BbL168eKlzyXPyxt2dlYQhka3y/QQnhFCMHyhPJc4cQv/CIrqvTEv41xkOO1H0FNJ9YCzFiD5MwNUdgyLs7CHCfTnZHj0zN6wFxQjnkNg160/ii6pUUCSQZFxXxQAIoRdBNOKoE1bVralpKWb73zoJR/mik0GvmhowtLYd1V8Q1fRACSA5okJxYqvUX/3xyGGFzAvZ1kHqMsJu/SZ0HRvfUEBBEVtkha2T5ixaQg0uQQGfECeqPLK1o2l9oS6ShSgLpjJ4QTWbqZq4oKYFL7iuDUa1slYrVuO1hkJ5ntoa4mTbstmox5SLPKrkJ9uF4KpgBHZOtiXLgDoUrngOrEDZOh2PZyfboRbgZBsa4m9gKoDHMu/SqDefsAMA24oU4LaF6X1o1rs3qHHqfTyGXhAau96XW1QKquzNS6TPX7UbTgU1Is5u1sYtGjAYHl/0+tQDUHfCOm593SBqwOJ0jazqFac4YxDx4QlfqHFAwL
FgBQ9rg6AKEkAHkWAZlJ2mHphUi+a3uVjQILQTrEo6M2YIcpamAVk1fSYylkOr9hlQ/Whk+03dh27YFroaVKTSx2kZnKwwDd2UphM2dtmOUZMriYPSrutcJ5wph7F9Ult3Xs7ylHdeb4OB1gw8xBhHcxSeBoJ8x7YRVgWQQFme4hK6W4dJcBJQY5AUBJYGSChXP0dEBpJo2ntqM4cuFgy3QmBRxDjI6gNFsWDnQclF6b2S5QysWzWPkDJAz2CHTF3msPJyff2QVrcSxzSa68axY7AN8xgUd7BO6Ua3WCQmXMhOavRxk23qE4qrKoGtp7WM0YRF8w34aoSjyKuZo6HfPsGxIjR4a8oRolxCr+2Afh29zYE066itDljNUXZ0WOxABOVL54jlThXzKpcwM/tDdXgK272SQ9Wt++WOS7vZX7nUlXJS5UD3PPVVxx8oQWqTLSSWNOw0k349Sl07z6mSUTmWuaxAGnLT2OROiUwxe4eh0QenmhvZqYv7YyY+857heGJPPeLMZ+vp9H3gf3qgpuFkpWp99sfqOxRnT6fw+gTzMfOyofpz0nLza9cjJORm0rWf1jaC+9/Irs9Vk09U4NyniHmMmmWziHiEOuC2XH+fhK4ScnPKrTraPC3oqf0ciIVcz+sqmkHFpC+p+vAX1DoDnelhsVPCXkIUaWswmh+GhANZpTY3b5+ZQ0vmkD//TahzChpC9K8/4I+TqWOKrvPf3+GU+OsPRwXOP//zXcWsCLsVx4HuasycXT8Gq+b/pml32Q8F9cGQgUjdh7wuX5tTTgOrD9kNxEwZ1BxPO9IGK+WHtHWyr9fI7rWQVTOSBt0GpopyK2G/eES6Yg3ZzaS7ySbZV/dXMkpaCLZr2S9HsDebdreF6t66qE1UK8LlmLaNfgvlh6jZzlnvouNbZX11F4L1Sega1dqg8270m+T370K+GlSu0dZzyDtRfZA3NwaJG8pWkVRnvnK7Bp3ZHq2j0mRq/sPQ16v
/AeEUlVU+JAAA</metastore_json>
</workflow_configuration>
```
<img width="918" alt="image"
src="https://github.com/user-attachments/assets/6052b247-cacb-4f6b-9a93-a970c240e5ad";
/>
Am I still miss something. I look up the zip file that upload via remote
execution and i copied xmls from them except pipeline.
my postman response is
<HTML>
<HEAD>
<TITLE>
!RegisterWorkflowServlet.Title!
</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="icon" type="image/svg+xml" href="/static/images/favicon.svg">
</HEAD>
<BODY>
<webresult>
<result>OK</result>
<message>Workflow 'onlyPip' was added to the list with
id d23f034d-a82f-4753-b116-78140d556daf</message>
<id>d23f034d-a82f-4753-b116-78140d556daf</id>
</webresult>
<p>
</BODY>
</HTML>
but when i start it logs says
2025/03/13 13:39:45 - onlyPip - Start of workflow execution
2025/03/13 13:39:45 - onlyPip - WARNING: The Workflow Log pipeline file
'/usr/local/tomcat/webapps/ROOT/config/projects/ftpAndDbPoC/logging/dataRetWorkflowLogging.hpl'
couldn't be found to execute.
2025/03/13 13:39:45 - onlyPip - exec(0, 0, Start)
2025/03/13 13:39:45 - Start - Starting action
2025/03/13 13:39:45 - onlyPip - Starting action [PostgreDBdataRetrieve.hpl]
2025/03/13 13:39:45 - onlyPip - exec(1, 0, PostgreDBdataRetrieve.hpl)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - Starting action
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - Opening pipeline:
[${Internal.Entry.Current.Folder}/PostgreDBdataRetrieve.hpl]
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - ERROR: Unable to run workflow
onlyPip. The PostgreDBdataRetrieve.hpl has an error. The pipeline path
${Internal.Entry.Current.Folder}/PostgreDBdataRetrieve.hpl is invalid, and will
not run successfully.
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - ERROR:
org.apache.hop.core.exception.HopXmlException:
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - The pipeline path
${Internal.Entry.Current.Folder}/PostgreDBdataRetrieve.hpl is invalid, and will
not run successfully.
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl -
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.pipeline.PipelineMeta.loadXml(PipelineMeta.java:1675)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.pipeline.PipelineMeta.<init>(PipelineMeta.java:1663)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.actions.pipeline.ActionPipeline.getPipelineMeta(ActionPipeline.java:633)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.actions.pipeline.ActionPipeline.execute(ActionPipeline.java:342)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:751)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:894)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:453)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.Workflow.startExecution(Workflow.java:313)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:248)
2025/03/13 13:39:45 - PostgreDBdataRetrieve.hpl - at
java.base/java.lang.Thread.run(Thread.java:840)
2025/03/13 13:39:45 - onlyPip - Finished action [PostgreDBdataRetrieve.hpl]
(result=[false])
2025/03/13 13:39:45 - onlyPip - Workflow execution finished
2025/03/13 13:39:45 - onlyPip - Workflow duration : 0.056 seconds [ 0.056" ]
GitHub link:
https://github.com/apache/hop/discussions/5023#discussioncomment-12488783
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
