Hi All,
I am trying to import CSV file to database, first I am reading the CSV file through rule and mapping the values to CDT. After that I am trying to insert the data into DB, But I am getting below error.
Please provide Solution on this.
Thanks,
Kiran
Discussion posts and replies are publicly visible
The main error for this is in the middle where it says "Bad value for type int". Can you share what the value of your variable is that you're trying to write to the database? Is it possible that you have an integer value that is either too long or that is the wrong type?
We are using int8 data type for number on PostgreSQL.
Are you using int8 for your primary key? I think that could be causing the problem here. Appian only supports integers up to 2^32 - 1, so you should only use int4 in PostgreSQL to match that number.
Hi Peter,
I tried with your suggestion, making primary key as int4 and we have one more column having data type as float8. But still I am getting the same error.
NOTE: We are using int8 as a primary key in other table there it is working.
Did you also change the CDT after you updated the database? You will need to make sure the data structure matches between them. It would also be helpful to identify which field is actually causing the problem. Can you share what data you're using in this process by showing a screenshot of your process variables from the monitoring view? Did you also try removing a few columns from the CDT to try and isolate which field is causing the issue?
Thanks Peter,
It worked after converting data type to int4.
But, the another question is int8 as I mentioned above we are using it as a primary key.
Hmm, I'm not sure why it would be working with int8 in another table - in general I've found that you shouldn't use numbers that exceed the limit that Appian supports: docs.appian.com/.../Appian_Data_Types.html