Skip to main content
Question

postgres writer inserts 0 instead of actual value

  • June 17, 2020
  • 2 replies
  • 20 views

istvanv
Participant
Forum|alt.badge.img

I got a workspace that I run and as an output it creates one row with statistics.

If I run the workspace the output is correct both with inspector and the row written to postgres.

If I use another workspace with a workspace runner to run the workspace for multiple areas, one of my column values is 0 in every row.

Any thoughts?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • June 17, 2020

0 is probably the default value for the attribute in the table.

So, could it be that the attribute does not get a value (or not a valid value: char instead of number) if you run it for multiple areas?

Hope this helps finding the issue.


istvanv
Participant
Forum|alt.badge.img
  • Author
  • Participant
  • June 17, 2020

0 is probably the default value for the attribute in the table.

So, could it be that the attribute does not get a value (or not a valid value: char instead of number) if you run it for multiple areas?

Hope this helps finding the issue.

my last row is running the workspace manually the rows before that are when it's being run with a workspace runner. the tables are being created by me, and i haven't set any default values,