GitHub user shivanandullagaddi added a comment to the discussion: Question
About Database Connections in Apache Hop Server Mode
for this request can you check the where configuration is missing
<?xml version="1.0" encoding="UTF-8"?>
<pipeline_configuration>
<pipeline>
<info>
<name>pipeline_example_1</name>
<name_sync_with_filename>Y</name_sync_with_filename>
<description></description>
<extended_description></extended_description>
<pipeline_version></pipeline_version>
<pipeline_type>Normal</pipeline_type>
<parameters></parameters>
<capture_transform_performance>N</capture_transform_performance>
<transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
<transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit>
<created_user>-</created_user>
<created_date>2025/10/21 12:51:22.638</created_date>
<modified_user>-</modified_user>
<modified_date>2025/10/21 12:51:22.638</modified_date>
</info>
<notepads></notepads>
<order>
<hop>
<from>Salesforce input</from>
<to>Salesforce insert</to>
<enabled>Y</enabled>
</hop>
</order>
<transform>
<name>Salesforce input</name>
<type>SalesforceInput</type>
<description></description>
<distribute>Y</distribute>
<custom_distribution></custom_distribution>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name></schema_name>
</partitioning>
<targeturl>https://login.salesforce.com/services/Soap/u/50.0</targeturl>
<username>[email protected]</username>
<password>Encrypted
53686976754032337232595156746166cdf3fca602c3c6a5801ab856d0a780dc</password>
<timeout>60000</timeout>
<useCompression>N</useCompression>
<module>Account</module>
<condition></condition>
<specifyQuery>Y</specifyQuery>
<query>Select id, name, phone, description from account</query>
<include_targeturl>N</include_targeturl>
<targeturl_field></targeturl_field>
<include_module>N</include_module>
<module_field></module_field>
<include_rownum>N</include_rownum>
<include_deletion_date>N</include_deletion_date>
<deletion_date_field></deletion_date_field>
<rownum_field></rownum_field>
<include_sql>N</include_sql>
<sql_field></sql_field>
<include_Timestamp>N</include_Timestamp>
<timestamp_field></timestamp_field>
<read_from></read_from>
<read_to></read_to>
<records_filter>all</records_filter>
<queryAll>N</queryAll>
<fields>
<field>
<name>Id</name>
<field>Id</field>
<idlookup>N</idlookup>
<type>String</type>
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Name</name>
<field>Name</field>
<idlookup>N</idlookup>
<type>String</type>
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Phone</name>
<field>Phone</field>
<idlookup>N</idlookup>
<type>String</type>
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
<field>
<name>Description</name>
<field>Description</field>
<idlookup>N</idlookup>
<type>String</type>
<length>-1</length>
<precision>-1</precision>
<trim_type>none</trim_type>
<repeat>N</repeat>
</field>
</fields>
<limit>0</limit>
<attributes></attributes>
<GUI>
<xloc>384</xloc>
<yloc>224</yloc>
</GUI>
</transform>
<transform>
<name>Salesforce insert</name>
<type>SalesforceInsert</type>
<description></description>
<distribute>Y</distribute>
<custom_distribution></custom_distribution>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name></schema_name>
</partitioning>
<targeturl>https://login.salesforce.com/services/Soap/u/50.0</targeturl>
<username>[email protected]</username>
<password>Encrypted
536869767540313349587957746f354557fcf9e1bc06df8abdb10aa824cba3a189</password>
<timeout>60000</timeout>
<useCompression>N</useCompression>
<module>Account</module>
<batchSize>10</batchSize>
<salesforceIDFieldName>Id</salesforceIDFieldName>
<fields>
<field>
<name>Name</name>
<field>Name</field>
<useExternalId>N</useExternalId>
</field>
<field>
<name>Phone</name>
<field>Phone</field>
<useExternalId>N</useExternalId>
</field>
<field>
<name>Description</name>
<field>Description</field>
<useExternalId>N</useExternalId>
</field>
</fields>
<rollbackAllChangesOnError>Y</rollbackAllChangesOnError>
<attributes></attributes>
<GUI>
<xloc>528</xloc>
<yloc>224</yloc>
</GUI>
</transform>
<transform_error_handling></transform_error_handling>
<attributes></attributes>
</pipeline>
<pipeline_execution_configuration>
<run_configuration>local</run_configuration>
<log_level>Basic</log_level>
<clear_log>Y</clear_log>
<show_subcomponents>Y</show_subcomponents>
</pipeline_execution_configuration>
<metastore_json></metastore_json>
</pipeline_configuration>
Response:
<HTML>
<HEAD>
<TITLE>
!RegisterPipelineServlet.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>
<p>
<pre>
org.apache.hop.core.exception.HopXmlException:
Error reading information from XML string :
Premature end of file.
at org.apache.hop.core.xml.XmlHandler.loadXmlString(XmlHandler.java:719)
at org.apache.hop.core.xml.XmlHandler.loadXmlString(XmlHandler.java:699)
at org.apache.hop.core.xml.XmlHandler.loadXmlString(XmlHandler.java:673)
at
org.apache.hop.pipeline.PipelineConfiguration.fromXml(PipelineConfiguration.java:79)
at
org.apache.hop.www.RegisterPipelineServlet.generateBody(RegisterPipelineServlet.java:54)
at org.apache.hop.www.BodyHttpServlet.doGet(BodyHttpServlet.java:65)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at org.apache.hop.www.BaseHttpServlet.service(BaseHttpServlet.java:102)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:234)
at
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:567)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:882)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1036)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: org.xml.sax.SAXParseException; Premature end of file.
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.apache.hop.core.xml.XmlHandler.loadXmlString(XmlHandler.java:710)
... 40 more
</pre>
<p>
</BODY>
</HTML>
GitHub link:
https://github.com/apache/hop/discussions/4634#discussioncomment-14865499
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
