Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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