search

Azure / LogicAppsUX

https://learn.microsoft.com/azure/logic-apps
MIT License
77 stars 83 forks source link

In logic app standard, creating new built-in SQL connection is failing in new designer #4789

Open saroja-sattigeri opened 6 months ago

saroja-sattigeri commented 6 months ago

Describe the Bug with repro steps

Customer is getting below error while creating a new connection for built-in SQL connector

image

Captured HAR traces, see same above error however, same works fine(able to create new connection) when customer switches to old designer, [https://aka.ms/lafallback]

What type of Logic App Is this happening in?

Standard (Portal)

Are you using new designer or old designer

New Designer

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

No response

Screenshots or Videos

No response

Browser

Edge

Additional context

No response

preetriti1 commented 6 months ago

@saroja-sattigeri - This is not a repro normally, so we would like to know the following -

  1. Exact repro steps. Always create new connection, update action and save?
  2. Does this always happen for the customer? like 100% repro?
  3. HAR files captured please send it to psamband@microsoft.com
saroja-sattigeri commented 6 months ago

@preetriti1 , Repro steps: on 'execute SQL query' built-in SQL action click on add new connections-> create new one by providing connection name and connection string-> save, workflow won't get saved due to above error. Yes, it always happens. Shared HAR traces via an email.

github-actions[bot] commented 6 months ago

We requested more information to triage this issue. If the issue goes more than 7 days with no more information it'll be automatically closed.

saroja-sattigeri commented 6 months ago

I've shared requested details.

preetriti1 commented 5 months ago

@saroja-sattigeri - The connections.json has lot of incorrect data image

Please ask the customer to delete the highlighted and then save connections.json before doing anything in the designer. All these highlighted text seems to have gotten out of the serviceProviderConnections object and that is what is causing the issue. Once user has updated the connections.json, then try the designer to create new connection and see if save works. If it doesnt then we need to investigate.

saroja-sattigeri commented 5 months ago

@preetriti1 , I updated status for above over teams chat separately please have a look. Thank you!