Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Duplicate key error with Table input

I have an Orchestration which creates this table:

CREATE TABLE public.mt_documents
(
activityid varchar(2000),
displayname varchar(2000),
endtime timestamp,
groupid varchar(2000),
starttime timestamp,
"user" varchar(2000),
devicename varchar(2000)
)

Now, I want to use this table as a table_input in a Transformation. Whenever I add anything to Column Names I get the error "duplicate key activityid". There certainly are duplicate values in activityid. How do I get past this error? Why are duplicate value being checked for?

4 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Quinn,

I am unable to reproduce this issue. I created your table and inserted duplicate values and still works fine.

Please check if you the DDL above is incomplete.

Best
Kalyan


Quinn Wildman —

I am quite certain my DDL is correct. I am using SQL Workbench/J to get the meta data.

I also created a table with a primary key and verified that SQL/Workbench/J reports the primary as such.


Matillion Agent  

Kalyan Arangam —

Hi Quinn,

I would recommend we start by replicating this in a separate table.
Please make a copy of your table with some duplicate rows and see if you get the same issue on the new table.

If you do, please email us the DDL for the table and sample data. Its important we replicate this at our end. Also send us your log file from the Admin menu.
Note that you may not be able to attach items to this call. Please email the requested items with subject referencing ticket 15370.

Best
Kalyan


Quinn Wildman —

Just getting back to this. I will do as you have requested tomorrow morning.

Post Your Community Answer

To add an answer please login