Tickets Tagged With:postgresql

0
votes
0
answers
153 views

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 Olena Romanchuk Olena Romanchuk 13 December 2021.

0
votes
1
answers
11 views

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 joy james joy james 4 weeks ago.

Latest by Nataliia Nikulina Nataliia Nikulina 4 weeks ago.

0
votes
1
answers
34 views

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 Ali Tariq Ali Tariq 07 May 2022.

Latest by Mariia Zaharova Mariia Zaharova 10 May 2022.

0
votes
1
answers
21 views

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 Azeef Hassan Azeef Hassan 27 April 2022.

Latest by Mariia Zaharova Mariia Zaharova 28 April 2022.

0
votes
4
answers
105 views

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 alberto Robles alberto Robles 22 July 2021.

Latest by alberto Robles alberto Robles 05 August 2021.

0
votes
3
answers
536 views

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 Odette Melvin Odette Melvin 04 February 2021.

Latest by Sabina Bashuk Sabina Bashuk 13 May 2021.

0
votes
1
answers
73 views

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 Grant Furick Grant Furick 03 June 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 04 June 2020.

0
votes
5
answers
106 views

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   ....

Created by Bart Jonk Bart Jonk 24 February 2020.

Latest by Bart Jonk Bart Jonk 25 February 2020.

0
votes
2
answers
525 views

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 Spencer Carlson Spencer Carlson 01 November 2019.

Latest by Spencer Carlson Spencer Carlson 13 November 2019.

0
votes
3
answers
166 views

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 Bart Jonk Bart Jonk 16 October 2019.

Latest by Mariia Zaharova Mariia Zaharova 16 October 2019.

0
votes
10
answers
766 views

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 Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 21 March 2019.

0
votes
1
answers
274 views

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 Elena O'Neil Elena O'Neil 18 February 2019.

Latest by Mariia Zaharova Mariia Zaharova 19 February 2019.

0
votes
4
answers
456 views

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 Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 12 October 2018.

0
votes
1
answers
390 views

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 Jacob Widmer Jacob Widmer 04 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 05 October 2018.

0
votes
8
answers
584 views

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 Jacob Widmer Jacob Widmer 08 August 2018.

Latest by API User Reporting API User Reporting 15 August 2018.

0
votes
5
answers
744 views

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 Ben Long Ben Long 09 May 2018.

Latest by Mariia Zaharova Mariia Zaharova 11 May 2018.

0
votes
1
answers
835 views

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 Michael Fielding Michael Fielding 18 November 2017.

Latest by Mariia Zaharova Mariia Zaharova 20 November 2017.

Close