× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
juhisindhani reported 2020-03-17T10:12:24Z  · shubham.tripathi last modified 2021-10-20T15:46:54Z

Improve Import of XML datatype using Import Functionality for Database Servers which have xml datatype


Requires Documentation
Dev
Kunal Sharma
kunalsharma
QA
Priority Low
Complexity Unknown
Component Tools - Import Tool
Version 22.1

Issue :- Unable to import data into xml datatype 

This issue is for all the database servers which have xml datatype for example DB - SQL Server, I wrote the steps to reproduce for DB - DB2 LUW

Below are the steps to reproduce:
 
- I was trying to import XML into an DB2 LUW database : DB2 LUW 172.24.1.44 v11.5, Schema name= Tom, Table = "tb_xml" ( XML datatype ).
- Right click on "tom.tb_xml" > Tools > Import > now select the attached xml_data.csv file (see the attached file) for import.
- Click Next > Again Click Next > Under the Destination dropdown select "Import into Database" and click Next >  and in the last Import wizard page , set the "Transaction Type" to Batch , and complete the import.
 
Result : 
Execute batch failed: [jcc][t4][102][10040][4.26.14] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
 
Error for batch element #1: XML document contains an invalid document structure.. SQLCODE=-16132, SQLSTATE=2200M, DRIVER=4.26.14
 
Note : It is Working fine for Table Editor functionality , I used same data "xml_data.csv" file for testing.

 

19 attachments

Issue #15783

Verified
Fixed
Resolved 2021-09-21T08:40:22Z
 
 
Completion
No due date
Fixed Build DEV BUILD 20
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017