RE: When I’m trying to load the data from XML to SQLServer, I’m getting xml handler exception
Scenario: I’m trying to load the data from XML source into SQLSERVER target. it is throwing XML handler issue. Let me know why this issue is coming up and how to overcome this
The error occurs when there is no java available in the agent installed on the environment.
Steps to install the jdk installer in the Agent.
Step1: Login to the SSH Session (putty) using the agent user in environment.
Step2 : Then download the jdk installer to below mentioned path.
Path: /app/diagnt/
Step3: Then after the jdk download is completed, untar the gz format file using the below command at the same path.
Command: tar -zxvf jdk-8u151-linux-x64.tar.gz
Step4: Once the untar command is completes, add below environment variables in bash_profile of the agent user.
export JAVA_HOME=/app/diagnt/jdk1.8.0_151
export PATH=$JAVA_HOME/bin:$PATH
Step5: After setting up the environment variables, logout and login from the putty session and restart the agent.
Then run the job, it should work as expected.
Download Command:
wget https://downloads.diyotta.com/jdk-8u151-linux-x64.tar.gz