[Bug] shared_odbc with on-prem fails pointing to placeholder URL
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 45/100
- Issue type
- Bug
- Clarity
- Mostly clear
- Activity status
- Active
- Tech stack
- typescript
- Domain
- api, backend-api-design
Research direction
Start with config.json and the connection handling exercised by npx pa connection list-datasets and npx pa connection list-tables. Reproduce the shared_odbc flow with an on-premises connection and inspect how the gateway or connector URL is selected. Done means both commands return tables and data instead of the 502 placeholder-host error.
Written by the indexing model from the issue text.
Description
Describe the bug
When trying to use a shared_odbc connection, the route fails with the error
{ "success": false, "error": { "message": "{\"error\":{\"code\":502,\"message\":\"The remote name could not be resolved: \\u0027odbc.connector.com\\u0027\",\"source\":\"Removed.09.common.uk.azure-apihub.net\",\"path\":\"forward-request\",\"policyId\":\"\",\"clientRequestId\":\"Removed\",\"dreeSet\":\"true\"}}", "status": 502, "requestId": "Removed" } }
It seems the connector is pointing to a generic odbc.connector.com and not being re-routed.
gateway is correctly configured ion config.json
Steps to Reproduce
use dataflows to create an odbc connection
add connection to code app, use npx pa connection list to find the id
run npx pa connection list-datasets
run npx pa connection list-tables
Expected behavior
Return tables/data
Actual behavior
Error
- Dominant language
- TypeScript
- Stars
- 504
- Forks
- 145
- Avg merge
- 4h 3m
- Merged PRs (30d)
- 1
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from microsoft/PowerAppsCodeApps
-
Difficulty 5/5 Over a week Newbie friendliness 25/100
microsoft/PowerAppsCodeApps#464 · 1 comment · 5 reactions ·
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 35/100
microsoft/PowerAppsCodeApps#463 ·
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 48/100
microsoft/PowerAppsCodeApps#462 ·
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 48/100
microsoft/PowerAppsCodeApps#461 ·
-
bug
Difficulty 5/5 Over a week Newbie friendliness 28/100
microsoft/PowerAppsCodeApps#460 · 2 comments ·
All issues in microsoft/PowerAppsCodeApps
Similar issues
-
clawsweeper:linked-pr-open clawsweeper:no-new-fix-pr clawsweeper:source-repro impact:message-loss issue-rating: 🦞 diamond lobster maturity:stable P2
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
Eynzof/Hermes-CN-Desktop#616 ·
-
ZCode 3.14.3 に対応する Open
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
supermomonga/zcode-acp#24 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
growthbook/growthbook#7100 ·
-
triage
Difficulty 1/5 1-3 hours Newbie friendliness 88/100