Hi

i was running one transformation which actully sets result set for the next transformation. i mean, i want to use first transformation's ouput as a input of next transformation. so i used "set result set" step in my first transformation.
whenever i run this transformation locally then it work fine and didn't give me any error. but whenever i run this on server then it gave me error ........as following.......


Unable to access transformation details :
org.pentaho.di.core.exception.KettleXMLException:
Error reading information from XML string :
<?xml version="1.0" encoding="UTF-8"?>
<transstatus>
<transname>Set job meta-data information</transname>
<status_desc>Finished</status_desc>
<error_desc/>
<stepstatuslist>
<stepstatus><stepname>Get start date and time</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>1</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.0</seconds><speed>25.6</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>set status and user</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>2</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.0</seconds><speed>44.4</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Get Job id for delta processing </stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>1</linesWritten><linesInput>1</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.0</seconds><speed>38.4</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Get audit_id for this run</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>1</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.0</seconds><speed>27.7</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Remove unwanted columns</stepname><copy>0</copy><linesRead>8</linesRead><linesWritten>8</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>124.9</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Create rows for linking files to job run</stepname><copy>0</copy><linesRead>8</linesRead><linesWritten>8</linesWritten><linesInput>0</linesInput><linesOutput>8</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>111.1</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Lookup the source id based on filename</stepname><copy>0</copy><linesRead>9</linesRead><linesWritten>16</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>262.2</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Select filename and audit_id</stepname><copy>0</copy><linesRead>8</linesRead><linesWritten>8</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>123.0</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>get_file_names_for_source_type</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>1</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>19.2</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Select values</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>1</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>18.8</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>insert row in elt_run table</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>1</linesWritten><linesInput>0</linesInput><linesOutput>1</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>16.6</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Modified Java Script Value</stepname><copy>0</copy><linesRead>1</linesRead><linesWritten>9</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>163.6</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Generate Rows</stepname><copy>0</copy><linesRead>0</linesRead><linesWritten>1</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.0</seconds><speed>166.6</speed><priority>-</priority></stepstatus>
<stepstatus><stepname>Copy rows to result</stepname><copy>0</copy><linesRead>8</linesRead><linesWritten>8</linesWritten><linesInput>0</linesInput><linesOutput>0</linesOutput><linesUpdated>0</linesUpdated><linesRejected>0</linesRejected><errors>0</errors><statusDescription>Finished</statusDescription><seconds>0.1</seconds><speed>115.9</speed><priority>-</priority></stepstatus>
</stepstatuslist>
<logging_string><![CDATA[H4sIAAAAAAAAANVdbW/bOBL+fr+ChwKHFHBcK0m7ToBckU2yuym67SLO7n4IAkOR6VpXWfJKlNPs4f77DSk5lm2+i7RroG0cS5r3eTgkR+xRr9d/0zt9E/RR8MNZ7+Ts+C06RANM0H+yRzTFJDwchSREcTrO8mlI4iyF61dxMQtJNInTL6ggYU7wCMF1RPIwLZY33kvpPPzjyIr53SQuEPxJM4JClONZEj6vcbakfANKlOkIBSdoFI/HOMcpAf3wrEAkQ0lYptGka0n7IkmyCH4Bi+XZU4FJ0e3a0uIQY+anoqIeOjz8N/oZk8ozCJ7HKAStSDzFtgzRLMfzKJvFuEDnKOigFH8j1e/nga0fV4MlrHSCSErxU60Wuhfo0QUtUVFdI2XBvi8LnHd7tlG1sCnwDwyNipAPPwaMJUfHvfMh10/w8BdMhuM4wcM0nOJiCGSGRVbmER6S5xlu4crvTtMBTnBE0DxMSlw4idFjg4DxE59HLynxAUjE1QAwwglQmeVZhIuCPrZ3LlQpxPxJbwrLUUyG9W2Ejkl5mTrx7Ymtsf04+viFN1flvfSwwHm1a7kDjgPHvjU2rh+PnjCmt3iazTEq06cwpdJFWVJO02Lv/CnQg3nzMsfUi/RWpn4Sp1+pSeiww4o6yt1V3r4ztLQf575lLHUV96K1mQh+zPCOyfAxy76WM0gnjKrSgmLnY1iA3ECCSkJrj70LeT21mqXH4jsGaAuo2ccSy0B1ITA4yPV+u4jzE/M/MAlkHt87d8vDlyJ8NnuuMAYQJcdFmRAnDj61Ma8ft/YZX/lsae8cq5r8AZ1fs1E8juG5D+E8RIMoj2cE/UHnUG6m+T07U/tx8mkzuKqJ4t75dG2aC4/FKcw/Cb0BPiKYrwzpgE/Cx8SRDzlrNRxLelqhqVaFJDr6UVDN15O+1QqDOC33LmBlCAM0dGsNF4F8ZGFvT25eLDakOKcF/C3csHeeXZH+ZWIvX9hx4UbeuhzHnp48V60mcEoiT5oJ+Vnr11BvwDZe/sV+XsGdLfZL1kImLlD4mJWEyrsIn0oj0X7DA8rGiA3+94NnuHN6AwxE8SLbsxjFBcnjx7IK3YjEc2pdC0ID+j01U60ApQcyPpZ034qajWYDmcAcfCTZaZJzAINQQ56hNI/TWUnOA/gEdmMfLSj+nBEGCHFWFpW9x3k2lRj9Vc9q7VEmA1MEojShURCc2ajxE9skrAn5WVSUsa8cQFXoUh1aKbGg5Xq3Tco5TuNiApAyWu4iO0rsSVg0xoOQ5QCNszNxjHV7/kGFY7oGoFxmKVxMiciWwk0lJwggpi7L/iNDaqLM51rmlc0WtoizZr6LHhflupMsETHVz3C52GvZ7Xof9jsRX3NzVchrJ3DEC/xtQJGqCm7g0tWPH7JY2KWjtU9qXO0oKborezRY2dY/6v1jSSEk984LNqonZ1qSGJRDSlp8rHQ3D9MSwqw60tSJUyb56BHQk2hn5ZM0MrcFXlyTNqdn+K8SpxGW2VhcqLuDFxkPW1yRTDAkgCKwWKPKsmjgkYtjgCpiIqLSy1fmiSUxwxSVRhwwcTxzlEiwM/DgR+E2UEOwDbyCGbSCZEuqhciusi4TozJHRsgN/Mg52ICPjKIIeoRmr4GnVWuGTCBN8JGR4EGPz8YDmSz64KPWaA16/HZOScXZCQ6JQnIbKKRrzwYs3dGtvM/MZSIb63vJFKaMKLvBLUOWMiATOdSIhQjZ9F1ZQ51Zp6WRjJpgZ0STh35+ocJMvJ1gh7bTtwEmemPRylpO9YjIASYNhU5y3YihzUq0AQNRnutauc5y474IAxE109yAIi/JPbdDGEinX/QYq7xWA3lvpd13rY2LWRPZdgLlmnm9DSCXhZThBFXZKesGuDXY2MwwlWRFIC23oIu5plI0TXBW0mk567Tt9FdIpQ9KmgquQZHrDm+VDDuBHGmUbgNo5Hu8K5Xib3kWicyr0bXtBma0GNkAjQZhEdSobFiDDWdr114WTWzRoMRDF9cdARpi6MOJtk5rgOLpzQIdcXaCLYqw3GIZU7Vg2NUtjZcGjNapNh93Wues0G1R2DToKCqZhRGN0YT39oVJYdJ40AQrtM82WGdiXFhsCMivJNq/frLBbZc1Qx0P20hjibnMlqWldjfNcBUxN/mu5mKz3qyiKsICqSdqZNB5V0zFXxMhVGR4eOEoG5Wsd5KbMv9sI1PFBUxz9GVfs2/hfpGBFYt+RqmqoOUmU5VMbIZpBVFRnsr8UKep1Xu7CnE001ZBhZe1nopnhST6pYCWSmt1gedlbZVIOwEoSWBup1Ov0fbZgCT4tb6U5eIOpvWWUcM24vXHXTX1bdLdQJqeTiPfOh2T9rL1ZwUtZS6bbjdY7qiHrBlRW+nY2Fx3XI3k4i67rb4WbWvzVi5N41lExFHPhZC6VXuFgJqwk4Jn4tXy1uQYExF73SYJweOS6tbRqrWQ825aHThesU44dlrr2rmwUZiiR1wf3Qrcn2IyWRzkSttczxCHlyX/mzQmcZjEDOaCk+o4V7sXYm/LNKVUgG6RhHPACZzPcQ4B+yZo9aaJDWEQ8gs8czjCc/jtE3iPKk/LFhRlaQrBSfUf4XGcSt+4EfcK70oq0UKTjTxGjUU2DFTTUxuamzNnGyoalXwL4cTA1z5sLqtIAWAABy3ix0Ej0ZYlk7XM2UKJOFv5oolf+3UEH0ps24FcotHUzujr5a8NFcUUcWdI65yGUYKsPnpRwiNRNp3GBOrYcft0bxV5RopoQG1TO1LmKZV3PO5U6TIqIUqhAqu4TQBSE7y4meJrniXJYxh9dWlIDZm3Z0CjYZpLGd032D+gg0r/86DXe+3QaC1UVBUKO9RKVUIPZCfjwKQGbq9q7L9B+nESPoHTiuTZ9rSegejMDF+sNBZHvPEVvafohaG4ldMLO4P3Arzw117Y9cJd0Y7nhaeyb8enpi8dAF6YyDcPvbCUbnR4QoSVatNTWnJXpgxZaR1NRulDelucPaRJwOzIEB1qGkcDqMhoveCrImL3+p2SqmotWUXA8GzG1UXG4GSxHs3cvTxR0GTLRVNQmxea1PEh3AppxNzBzXmvgz7Tf27pP3+eBx30O/10fS4s23Q3zlUiavfKqB0tbKtTPWrSI6wphsZLDUqs+Z7mupdLjs1qP0oyCNB/7nzJZoKjr/UBo2fofnl5yO5/6KD76oOWoFc/XlCgZ06KAAxoLILXCJ7S/10N1L//L3qPztk11cnbB+j96//Zdgr9luNZmIO7ihfuZ+jm0+D69g5+3H1GmCRd+EsfOwCQgxDrvARbB9VXhmzUG9LBbvkdTLFmCSa48TUlUI1t1e90cHuN/rj4+Pv1gOrRQZt/9SZ1VsFjdrTQKpwFL3AWuIGz6vDiV334iO7Zf7m3dPoD3aMrKU6DExl8s6ctV9bY7lNFoaLLdoEWp4KzTUjKo9rbKwgMTtODwlKrT1lVEbGza6uLTDe9fHYACYM6y2Z1oK9m2eD64/XlXT0a0grnYoDGGI/ox59uP/9ahf83gvM0TBZZR29Af/5yfXu9eDDHEY7nla8ga98jdPHpCjWTlH5p2SsDJqRbhcNBVRQy83XXi4q6YowWKMX+H8h5GDNksavtlOO4buCbLE/qoix8CPpv6Y+T4CSgPzm8u8e9vuLSkgP9rQ6dxsdDxu6QUui9C44Pw4h0yTfSEVxOiyfpZfnDf8uu/pWMZJeLUHZ1Hkeyy0/sYbXarU62bRtGRtW/3rjGSezhYrBbDnI1IKwPVMKBSXWmptQQR2pDOMBIk/d22vpN8upAW9Jq5MTgAZ1xR7dfUSrx6VZ8p938zZE1MLGuA1ltXnsXmfiUif1OLbfWGUsiLn3Kpa8d1Rrv1LblpOyDasvAgZ/tzqrhCN7nC/5/Y1XY55J7AAA=]]></logging_string>
<result><lines_input>0</lines_input>
<lines_output>0</lines_output>
<lines_read>0</lines_read>
<lines_written>0</lines_written>
<lines_updated>0</lines_updated>
<lines_rejected>0</lines_rejected>
<lines_deleted>0</lines_deleted>
<nr_errors>0</nr_errors>
<nr_files_retrieved>0</nr_files_retrieved>
<entry_nr>0</entry_nr>
<result>N</result>
<exit_status>0</exit_status>
<is_stopped>N</is_stopped>
<result-file></result-file><result-rows><row-meta><value-meta><type>Integer</type>
<storagetype>0</storagetype>
<name>audit_id</name>
<length>-1</length>
<precision>-1</precision>
<origin>Get audit_id for this run</origin>
<comments/>
<conversion_Mask>#;-#</conversion_Mask>
<decimal_symbol>.</decimal_symbol>
<grouping_symbol>,</grouping_symbol>
<currency_symbol/>
<trim_type>none</trim_type>
<case_insensitive>N</case_insensitive>
<sort_descending>N</sort_descending>
<output_padding>N</output_padding>
<date_format_lenient>N</date_format_lenient>
<date_format_locale>en_US</date_format_locale>
</value-meta><value-meta><type>String</type>
<storagetype>0</storagetype>
<name>file_name</name>
<length>-1</length>
<precision>-1</precision>
<origin>Select filename and audit_id</origin>
<comments/>
<conversion_Mask/>
<decimal_symbol>.</decimal_symbol>
<grouping_symbol>,</grouping_symbol>
<currency_symbol/>
<trim_type>none</trim_type>
<case_insensitive>N</case_insensitive>
<sort_descending>N</sort_descending>
<output_padding>N</output_padding>
<date_format_lenient>N</date_format_lenient>
<date_format_locale>en_US</date_format_locale>
</value-meta></row-meta><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-act.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-nsw.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-nt.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-nz.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-qld.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-sa.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-vic.txt</string-value>
</value-meta></row-data><row-data><value-data><integer-value>4141</integer-value>
</value-meta><value-data><string-value>staging-delta-20080613-wa.txt</string-value>
</value-meta></row-data></result-rows></result></transstatus>
The element type "value-data" must be terminated by the matching end-tag "</value-data>".
at org.pentaho.di.core.xml.XMLHandler.loadXMLString(XMLHandler.java:698)
at org.pentaho.di.http://www.SlaveServerTransStatus.fr...tatus.java:152)
at org.pentaho.di.cluster.SlaveServer.getTransStatus(SlaveServer.java:629)
at org.pentaho.di.ui.spoon.SpoonSlave.refreshView(SpoonSlave.java:450)
at org.pentaho.di.ui.spoon.SpoonSlave.refreshViewAndLog(SpoonSlave.java:255)
at org.pentaho.di.ui.spoon.SpoonSlave$6$1.run(SpoonSlave.java:234)
at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:873)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5626)
at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5722)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)
Caused by: org.xml.sax.SAXParseException: The element type "value-data" must be terminated by the matching end-tag "</value-data>".
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.pentaho.di.core.xml.XMLHandler.loadXMLString(XMLHandler.java:687)
... 18 more



And if i replace "set result set" step by any database table or "dummydo nothing " stept then it didn't give me any error.

please help me in this issue.

if you need more infomation then please let me know.

in my transformaiton i am using java-script, and stored procedures.

thanks in advance.