Tickets Tagged With:postgresql
Category: Questions
New Skyvia IP 52.190.252.0
Dear users, Please be informed that Skyvia uses the new IP address 52.190.252.0 to access the databases. If you use firewall applications, please make sure that all three IP addresses ....
Created by
Category: Questions
Error in SQL Execution after connecting to YugabyteDB
Hi, I have a free skyvia account and trying to see if I can connect to YugabyteDB. I connect to the database with no issues, afterward when I try to ....
Created by
Latest by
Serhii Muzyka
16 September 2022.
Category: Questions
cannot activate link
i have set the access to public and for any IP address but still cant able to activate my connection but still getting this error to activate? ....
Created by
Latest by
Category: Questions
"You are not authorized to perform this action."
I've got a replication activity going copying Freshdesk data to a Postgresql warehouse. The package created the tables and structures properly but didn't populate with any fields. I can see ....
Created by
Latest by
Mariia Zaharova
10 May 2022.
Category: Questions
Not able to map DT_WSTR to DT_I4 using new skyvia expression int4()
Hi there, I am testing Skyvia's Synchornzation package and I have run into an error while mapping a non-pk id column from Salesforce to an empty table in a postgresql ....
Created by
Latest by
Mariia Zaharova
28 April 2022.
Category: Bug Reports
Postgresql sync with Dynamics 365 - total disaster
After having openning several tickets and having long conversations with support I'm reaching to the community as a last resort. We are having multiple problems in syncing Postgresql with ....
Created by
Latest by
Category: Bug Reports
Postgresql connection error: The server hello message uses a protocol that was not recognized.
When trying to add a connection to a Postgresql database, I get the following following error: The server hello message uses a protocol that was not recognized. I have checked that I ....
Created by
Latest by
Category: Questions
PostgreSQL Connecting As Read-only user
Hi there, We're having an issue where an import into our postgresql 9.6 database is connecting as a readonly user, despite the connection credentials being those of the database owner ....
Created by
Latest by
Category: Questions
DROP CASCADE
Hi, My replaction is failing since I created a view on a atble on which increaments are not possible. I need to do a drop & recreate. https://app.skyvia.com/#/packages/80908/edit ....
Category: Bug Reports
Sync error - PG to Marketo
I am just starting with skyvia, and set up a simple test to sync a tiny 2-row table from PG to Marketo. The first run, it actually did put my ....
Created by
Latest by
Category: Questions
An exception .. during initialization: Updating field with name xyz does not exist in schema
Hi, I have two failed packages with error message above. What's wrong? Is there any extra logging available? cheers, Bart. ....
Created by
Latest by
Mariia Zaharova
16 October 2019.
Category: Questions
Synchronization Integration won't allow Target to Source "Id" column synchronization
Hello there. I have successfully synced a SFDC object/table to a table in a PostgreSQL database. I added a new primary-key column (named "_id") and am able to sync records back ....
Created by
Latest by
Mariia Zaharova
21 March 2019.
Category: Questions
Problems importing to Postgresql using auto-generated id
Hi, I would like to import new rows into a Postgresql table where the primary key uses uuid_generate_v4() to generate unique Id's. The problem is that Skyvia requires me to map ....
Created by
Latest by
Mariia Zaharova
19 February 2019.
Category: Questions
Sync job failure - Value does not exist or does not match filter criteria.
Hey there, I have an error that's cryptic and non-explanatory when I insert a value into my PostgreSQL database and then run a data sync job to (ideally) have it ....
Created by
Latest by
Mariia Zaharova
12 October 2018.
Category: Questions
Salesforce and Syncing - "... It does not have 'IsDeleted' column."
Hey there,Attempting to sync the RecordType table of a SFDC org to a table I've created in a Postgres database. Unfortunately getting the error: Table cannot be used in synchronization. ....
Created by
Latest by
Mariia Zaharova
05 October 2018.
Category: Questions
Bi-directional synchronizing Salesforce with PostgreSQL
Hey there,I am attempting to create a "clone" more or less of a few different tables from Salesforce in an external Postgres database. The synchronization tool sounds like it's exactly ....
Created by
Latest by
Category: Questions
Accessing Postgresql on Heroku
Hi I'm looking at exporting data from a Postgresql database hosted on Heroku, unfortunately, the DB is set to require SSL but Heroku don't make the certificate details available. When I ....
Created by
Latest by
Mariia Zaharova
11 May 2018.
Category: Questions
Clear or erase a table completely before syncing
I have a table in PostgreSQL which I want to keep sync'd with MailChimp. I currently use the UPSERT operation and it works okay. But when subscribers are removed from MailChimp, ....
Created by
Latest by
Mariia Zaharova
20 November 2017.
