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

When I'm trying to load the data from XML to SQLServer, I'm getting xml handler exception

Beginner Asked on January 14, 2020 in Diyotta Monitor.
Add Comment
1 Answer(s)

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

Expert Answered on January 17, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.