Answered

Error statut 400 : Insert teradata new line

(0) Share

Report

Posted on by cadaver

Hello,

I created a flow in order to insert a new line in a teradata table but when my flow run I've an error statut 400 with no more explanation. I check the data format, and when it's wrong I've another error message, and my On-premises Gateway and everything seems fine.

I don't know how to solve my problem. I saw in a previous post an user that post this solution :

"I added an index to my mysql table I was writing to and it solved my error."

but I don't kwon what this mean.

if someone can help me.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @cadaver index could be a new column with timestamp type

Was this reply helpful? Yes No
cadaver 15 on at

Like (0)

Report
Copy link

Link copied!

Hello, thanks for your help, I'm not the administrator of the table and I can't create new column. When I look at the definition of the table I insert value into all the column. But in the same time I've a timestamp column but I'm not sure to put the correct data format inside. With power automate I put utcNow() data for this timestamp column. Is that correct ?

Was this reply helpful? Yes No
ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@cadaver yes you are right or try just leaving the field empty.

Was this reply helpful? Yes No
cadaver 15 on at

Like (0)

Report
Copy link

Link copied!

Same error

Was this reply helpful? Yes No
cadaver 15 on at

Like (0)

Report
Copy link

Link copied!

Hello, does someone has an idea ?

Was this reply helpful? Yes No
Verified answer

cadaver 15 on at

Like (0)

Report
Copy link

Link copied!

Hello, I've found my solution. My Table must have a UNIQUE primary index !

Was this reply helpful? Yes No