Issue @ DB insertion using "LOAD DATA LOCAL INFILE"


#1

Hi, I am trying to insert record by using LOAD DATA LOCAL INFILE but it gives an error only for this query

myodbc8w.dll : ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.41-log]The used command is not allowed with this MySQL version

I used latest ODBC 8.0 deriver
This query was executed successfully in to MYSQL Workbench
Other Query also work through UiPath

Please give the solution for that problem


Issue with database queries
Exception Type: JsonSerializationException
#2


Copy to Clipboard then get details as follows

An error has occurred

Source: Newtonsoft.Json

Message: Cannot create and populate list type System.Data.Odbc.OdbcErrorCollection. Path ‘$values’, line 1, position 175.

Exception Type: JsonSerializationException

Newtonsoft.Json.JsonSerializationException: Cannot create and populate list type System.Data.Odbc.OdbcErrorCollection. Path ‘$values’, line 1, position 175.
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateNewList(JsonReader reader, JsonArrayContract contract, Boolean& createdFromNonDefaultCreator)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateList(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, Object existingValue, String id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadMetadataProperties(JsonReader reader, Type& objectType, JsonContract& contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue, Object& newValue, String& id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateISerializableItem(JToken token, Type type, JsonISerializableContract contract, JsonProperty member)
at Newtonsoft.Json.Serialization.JsonFormatterConverter.Convert(Object value, Type type)
at System.Runtime.Serialization.SerializationInfo.GetValue(String name, Type type)
at System.Data.Odbc.OdbcException…ctor(SerializationInfo si, StreamingContext sc)
at Void .ctor(System.Runtime.Serialization.SerializationInfo, System.Runtime.Serialization.StreamingContext)(Object )
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateISerializable(JsonReader reader, JsonISerializableContract contract, JsonProperty member, String id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.SetPropertyValue(JsonProperty property, JsonConverter propertyConverter, JsonContainerContract containerContract, JsonProperty containerProperty, JsonReader reader, Object target)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
at UiPath.Shared.JsonParser.DeserializeObject[T](String jsonValue)
at UiPath.Models.UiPathDuplexProxy.<>c__DisplayClass21_0.b__0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()

If any one have solution then , Please help me out.


#3

@suraj23 I think there is syntax error in query check it


#4

I checked that, because Same query was execute successfully through MySQL workbench


#5

@suraj Can you share your workflow


#6

Main.zip (245.5 KB)


#7

@suraj You are trying to insert from excel data to database?


#8

I am trying to insert data from .CSV file not from excel file and this .CSv file contains more than 70k records of 39 column
I refer your solution to insert data into DB, but it take too much time


#9

Hi Suraj,

Did you got the solution for the above LOAD DATA INFILE issue… Even I am facing the same issue.
Please let me know if you got the solution.

Thanks & Regards
Anshul


#10

@anshul_nema, Yes, I got a solution, Please refer image
input text is
"cd \ [k(enter)] cd Program Files\MySQL\MySQL Server 5.6\bin [k(enter)] mysql -uroot -p [k(enter)]root@123[k(enter)]LOAD DATA local INFILE 'D:\\TATA Capital Phase 3.1 MIS\\Destination\\Open Item.csv' INTO TABLE tatacapital_mis.tbl_openitem FIELDS TERMINATED BY ',' ENCLOSED BY '"+chr(34)+"';[k(enter)]"