Hi,
Just to update on this, I was able to resolve this issue by using the JDBC Store node.
------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
------------------------------
Original Message:
Sent: 04-05-2023 04:44
From: Adrian Williams
Subject: Unexpected Error Help
I'm not sure the error message relates to whether there are Null values in the DB Store node's input data. It may be that there is a problem with the data flow itself rather than the particular node.
You could try running the 'Apply Auto-Fixes' tool from the Errors panel to see whether that rectifies the issue. You could also try exporting the data flow as a .lna file and re-importing it to a different folder in the Analyze directory.
If the issue persists create a support case in the Support Portal and attach the data flow .lna file plus the System logs ( Click the information (i) button and select 'About Data360 Analyze' -> 'Download Server Logs').
------------------------------
Adrian Williams
Precisely Software Inc.
Original Message:
Sent: 03-31-2023 08:01
From: Dhinmar James Cayog
Subject: Unexpected Error Help
Hi,
I'm receiving the error prompt below whenever I execute the DB Store Node. Though after closing the dialog box, I can see that the record are being inserted.

I have 3 non-nullable columns in the target table, of which 2 are string.

But before the DB Store node, I can see that the incoming records for those are not null. So I wonder what triggers the error and how should I resolve it.


It would be greatly appreciated if you can help me out on this. Let me know if more information is needed.
------------------------------
Dhinmar James Cayog
Knowledge Community Shared Account
------------------------------