Postgres Bulk load doesn't load data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm trying to load data from yxdb file to Postgres table using Bulk option.
I can see connection is fine as my pre-sql statement to truncate the table is working fine and field mapping is also correct.
Workflow runs successfully without any warnings/errors but when checked in DB table, no records are inserted.
Any idea what is the concern here and how to resolve it.
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
There are a few questions here:
1) Can you confirm that the correct number of records are going into the output tool. (ie add a browse tool before your output data/datastream in)
2) Where are you checking to see if your records have been written? (ie is it possible they are being written but you are looking at cached output)
3) If you are using output-data to write can you swap to datastream in?
4) Can you try creating a blank new table? does the metadata populate?
also this:
The use of Delete Data and Append in the output options can cause loss of data in the record. When you choose the Delete Data and Append option in the output options, there is a possibility that data is deleted but no new data is written. This happens when the fields in Alteryx don’t match the fields in the database table. For example, if the database table was created with two fields of numeric types and you decide to run a workflow where the output to the table is a string datatype, the data in the table will be deleted but the strings can’t be written to the numeric fields, therefore output is empty. However, Designer will say that records were written successfully.
https://help.alteryx.com/20214/designer/configure-posgresql-bulk-connection-writing-data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was able to resolve myself.
Steps that I took.
1. Column order to match with the DB table.
2. Column size to match with the DB table.
![](/skins/images/12A9B4B958288E867BE947DD48612FB8/responsive_peak/images/icon_anonymous_message.png)