Copy Table Data from Data Source

RE: Copy Table Data from Data Source

Vic Liang — Tue, 23 Dec 2025 23:01:04 GMT

When reading from MariaDB where a column is defined as MEDIUMTEXT or LONGTEXT, the copy fails with an error: Error looking up from copy Table: Key is <index of last column> Unknown column <value> in 'field list'

Target can be MEDIUMTEXT or LONGTEXT. But it seems the query is causing issues when source column is MEDIUMTEXT or LONGTEXT

RE: Copy Table Data from Data Source

John Josef — Wed, 08 May 2024 06:23:57 GMT

Hi, we tried running test using the plugin and sharing here is the error log from tomcat:

Other details: Source Table: Postgres (RDS)

06:14:37.652 [Appian Work Item - 6847 - WorkID 233 - execution01 - process 268440750 - model 2333 : UnattendedJavaActivityRequest] ERROR copytabledata.MoveTableData - Error looking up from copy Table: Key is 12 (conn=661829) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '08:45:57.552,LNKCARD,2021-11-24 08:45:57.552,LNKCARD,5117,128000,6436,N)' at line 1

RE: Copy Table Data from Data Source

Appian AppMarket — Tue, 05 Sep 2023 22:00:40 GMT

v1.2.1 Release Notes

Fixed an issue where an error is thrown when the columns contain strings with escape sequences.
Updated libraries.

RE: Copy Table Data from Data Source

Vic Liang — Sat, 05 Aug 2023 04:08:18 GMT

A minor bug identified: if the last character is a backslash \, it needs to be escaped, else it is treated as escaping the closing double-quote, i.e. \", and therefore causing a syntax error

RE: Copy Table Data from Data Source

Appian AppMarket — Mon, 24 Apr 2023 21:58:33 GMT

v1.1.1 Release Notes

Bug fixes

RE: Copy Table Data from Data Source

Appian AppMarket — Tue, 18 Apr 2023 21:58:38 GMT

v1.1.0 Release Notes

Included support for parallel processing
Modified the plugin to support more than 500000 data

RE: Copy Table Data from Data Source

Appian AppMarket — Mon, 27 Mar 2023 21:58:59 GMT

v1.0.1 Release Notes:

Included support for DB2 databases

RE: Copy Table Data from Data Source

udayasai — Fri, 03 Jun 2022 13:41:55 GMT

will this support data migartion from appian internal db(maria db) to synapse? Because synapse db will not support jdbc drivers

RE: Copy Table Data from Data Source

AllenP — Fri, 17 Sep 2021 19:56:32 GMT

Getting the following error: "Error looking up from copy Table: Key is 7 Incorrect syntax near the keyword 'INTO'."