Issue: 'SQL Server - insert row' - "Invalid Mashup Expression using supplied values"

[yoshihirok]

How can I fix the issue "Issue: "Invalid Mashup Expression using supplied values." of action "SQL Server - Insert row" ?

Error:

{ "status": 400, "message": "Invalid Mashup Expression using supplied values.\r\n inner exception: 名前 'ツイート ID' が複数回定義されています。", "source": "127.0.0.1" }

-- inner exception is Japanese.

-- which mean that TweetID name definition exists two or more.

SQL Server : Azure SQL Database.

  TweetID column's Data Type is bigint.

  TweetID column is primary key.

History:

  Before Dec 11, 2016, this action work well.

My try:

  1. delete this Connection fo Azure SQL Datase, and create new this Connection -- But not fix.

  2. Create new Flow which have a Button and Insert Row -- But not fix.

Regards,

Yoshihiro Kawabata.

[abm]

Hi @yoshihirok,

Can you check your insert sql statement? Are you sure that the schema hasn't changed recently?

Thanks

[yoshihirok]

Hi, @abm

The schema of database have changed recently.

The column "TweetID" data type have changed from nvarchar(20) to bigint.

and, after that, my flow work well few days.

-- In Japanese, TweetID is [ツイート ID]

and there are not my insert sql statement,

because my flow use Action 'SQL Server - insert row'.

This action don't need insert statement.

Regards,

Yoshihiro Kawabata

[abm]

Hi  @yoshihirok,

How did the change done for the fields? Can you please describe it? Looks like it seems that you got duplicate names somewhere exists in the system.

Thanks

[yoshihirok]

Hi @abm

My change for database is 'TweetID' data type from nvarchar(20) to bigint by SQL Server Management Studio.

There are not duplicatete name of columns in my database table.

I check it by SQL Server Management Studio.

and, I have re-created the connector of my database table.

but, still this issue are there.

and, There action 'SQL Server - insert row' input parameneters have not duplicate name 'TweetID'.

Regards,

Yoshihiro Kawabata

[abm]

Hi @yoshihirok,

Thanks for your reply. Let me test this and let you know. I will test this using an on-prem connection compared to your Azure.

Thanks

[yoshihirok]

Hi @adm

I don't use On-premises connection for SQL Server.

I will try it within several months.

Regards,

Yoshihiro Kawabata

[abm]

Hi @yoshihirok.,

For me it worked fine. The only difference is I was connecting to my on-prem db. Can you please restart your SQL server?

Thanks

[yoshihirok]

Hi @abm

Thank you for your test.

I'm using Azure SQL Database instead of SQL Server,

and My flow works fine a few weeks.

Regards,

Yoshihiro Kawabata

[abm]

Hi @yoshihirok,

Let me test with Azure SQL. Will let you know soon.

Thanks

[abm]

Hi @yoshihirok,

Created an Azure DB. Added some records and later changed the data type to 'BigInt'. It's all worked fine for me. Can you please run the SQL Server Profiler and see which statement is failing? Good luck.

Thanks

[yoshihirok]

Hi @abm

I contact Microsoft Support, and They are staring research to solve this issue.

Regards,

Yoshihiro Kawabata

[Vicky_Song]

@yoshihirok, how about your issue now? Did you resolve it? And do you still need further help? 

[yoshihirok]

Hi @Vicky_Song

Does NOT resolve.

Current, I'm waiting thier check status response from Microsoft Support in Japan.

My issue is: How can I fix the issue that 'SQL Server - insert row' is ERROR ?

Error:

{ "status": 400, "message": "Invalid Mashup Expression using supplied values.\r\n inner exception: 名前 'ツイート ID' が複数回定義されています。", "source": "127.0.0.1" }

-- inner exception is Japanese.

-- which mean that TweetID name definition exists two or more.

English tranlating the Japanese.

"The name 'Tweet ID is defined more than once"

I turn OFF the flow for collect Tweets to Azure SQL Database.

I hope your help, any information about this,

I waiting 5 days, the response from Micrososoft Customer Japan.

Regards,

Yoshihiro Kawabata

[yoshihirok · Accepted solution]

SOLVE this issue.

Thank you, Microsoft Support Japan.

This issue:

  ERROR "The name 'Tweet ID is defined more than once"

  In Japanese

 { "status": 400, "message": "Invalid Mashup Expression using supplied values.\r\n inner exception: 名前 'ツイート ID' が複数回定義されています。", "source": "127.0.0.1" }

-- inner exception is Japanese.

The cause of ERROR:

  Microsoft Flow make ERROR when the Primary Key column name include space charactor.

  "Tweet ID" column name include a space charactor.

  When "Tweet ID" column of the Database table have primary key, it be ERROR.

Workaround:

  I change the column name from "Tweet ID" to "TweetID", which remove a space charactor.

Thank you.

and I hope that Microsoft Flow support primary key column name include space charactor in Database.

Regards,

Yoshihiro Kawabata