Hi, I'm fairly new to power apps and I'm struggling to get the app to commit to the database
I've used the auto generated 3 page app using the PostgreSQL connector.
It pulls the data, searches and everything, just when I make changes and try to push them to the database, I get a network error
I'm using on prem hosted PostGIS / PostgreSQL database and a data gateway on my local machine with npgsql 4.0.1 installed (GAC Enabled)
Here is a list of the errors:
Here is the response from the initial patch row (line 5)
{
"duration": 4242.5,
"size": 569,
"status": 400,
"headers": {
"Cache-Control": "no-cache,no-store",
"Content-Length": 569,
"Content-Type": "application/json",
"Date": "Tue, 02 Jul 2024 08:14:25 GMT",
"expires": -1,
"pragma": "no-cache",
"strict-transport-security": "max-age=31536000; includeSubDomains",
"timing-allow-origin": "*",
"x-content-type-options": "nosniff",
"x-frame-options": "DENY",
"x-ms-apihub-cached-response": false,
"x-ms-apihub-obo": false,
"x-ms-connection-gateway-object-id": "60702e10-7ef6-44f1-ae2d-3eaae222e5b7",
"x-ms-environment-id": "f13fae7c-53e3-e29d-be8c-f29853ac77ad",
"x-ms-request-id": "4c2419cf-e406-426a-a555-f834dfccdbd5",
"x-ms-user-agent": "PowerApps/3.24063.22 (Web AuthoringTool; AppName=637e7d07-7b99-4529-95af-7b007b3b4697)",
"x-ms-client-request-id": "4c2419cf-e406-426a-a555-f834dfccdbd5"
},
"body": {
"status": 400,
"message": "PostgreSQL: 42704: unrecognized configuration parameter \"my_trigger_disabled\"\r\n inner exception: PostgreSQL: 42704: unrecognized configuration parameter \"my_trigger_disabled\"\r\nclientRequestId: 4c2419cf-e406-426a-a555-f834dfccdbd5",
"error": {
"message": "PostgreSQL: 42704: unrecognized configuration parameter \"my_trigger_disabled\"\r\n inner exception: PostgreSQL: 42704: unrecognized configuration parameter \"my_trigger_disabled\""
},
"source": "postgresql-ukw.azconn-ukw-001.p.azurewebsites.net"
},
"responseType": "text"
}
I'm not sure where the parameter [my_trigger_disabled] is coming from and don't know how to troubleshoot this, any help would be greatly appreciated 🙂
