Data360 Analyze

 View Only
  • 1.  Unexpected Error Help

    Posted 03-31-2023 08:01
    Edited by Dhinmar James Cayog 04-03-2023 05:43

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



  • 2.  RE: Unexpected Error Help

    Employee
    Posted 04-05-2023 04:45

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



  • 3.  RE: Unexpected Error Help

    Posted 04-20-2023 12:00

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