Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Search may be unavailable 11:30 PM on Aug 24 to 1:30 AM on Aug 25. Thank you for your patience.
cancel
Showing results for 
Search instead for 
Did you mean: 
amak-hl
Contributor
Contributor

Cannot save or update Postgres integration on Stitch UI

Our vender informs us the IP address for the SSH Host had been changed and we need to update to a new IP address. Nothing else has been changed.

In the configure your PostgreSQL Integration UI.

I updated the IP in SSH Host -> click update settings but nothing happened (no error messages in the front end).

We find status code 400 Bad Request and the following error message in the Chrome's dev mode under "Network".

However, we are not an expert in this area. What could be the issues? Vendor confirmed all the information we enter are correct.

{
"error": "LocalUriProperties",
"data": {
"message": "one or more properties could not be resolved to an address",
"bad_properties": [
"host"
],
"report_card": {
"type": "platform.hp-postgres",
"current_step": 2,
"current_step_type": "fully_configured",
"steps": [
{
"type": "form",
"properties": [
{
"name": "accumulator_size",
"value": "[REDACTED]"
},
{
"name": "anchor_time",
"value": "[REDACTED]"
},
{
"name": "cron_expression",
"value": "[REDACTED]"
},
{
"name": "dbname",
"value": "[REDACTED]"
},
{
"name": "default_replication_method",
"value": "[REDACTED]"
},
{
"name": "filter_dbs",
"value": "[REDACTED]"
},
{
"name": "frequency_in_minutes",
"value": "[REDACTED]"
},
{
"name": "host",
 "tap_mutable": false,
"property_type": "user_provided",
"system_provided": false,
"clonable": true,
"json_schema": {
"type": "string",
"anyOf": [
{
"format": "hostname"
},
{
"format": "ipv4"
},
{
"pattern": "^(?:[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?\\.)*[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?$"
}
]
},
"is_credential": false,
"provided": false
},
},
{
"name": "image_version",
"value": "[REDACTED]"
},
{
"name": "include_schemas_in_destination_stream_name",
"value": "[REDACTED]"
},
{
"name": "incremental_limit",
"value": "[REDACTED]"
},
{
"name": "itersize",
"value": "[REDACTED]"
},
{
"name": "logical_poll_total_seconds",
"value": "[REDACTED]"
},
{
"name": "password",
"value": "[REDACTED]"
},
{
"name": "port",
"value": "[REDACTED]"
},
{
"name": "replication_slot_name",
"value": "[REDACTED]"
},
{
"name": "socket_timeout",
"value": "[REDACTED]"
},
{
"name": "ssh",
"value": "[REDACTED]"
},
{
"name": "ssh_host",
"value": "[REDACTED]"
},
{
"name": "ssh_port",
"value": "[REDACTED]"
},
{
"name": "ssh_user",
"value": "[REDACTED]"
},
{
"name": "ssl",
"value": "[REDACTED]"
},
{
"name": "user",
"value": "[REDACTED]"
},
{
"name": "use_log_based_replication",
"value": "[REDACTED]"
}
]
},
{
"type": "discover_schema",
"properties": []
},
{
"type": "field_selection",
"properties": []
},
{
"type": "fully_configured",
"properties": []
}
]
}
}
}

 

 

 

Labels (1)
0 Replies