We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Aggregation Javaheap Error and PostgreSQL Tasks Orphans

Comments

3 comments

  • Avatar
    Adrian Williams

    The Postgres tasks are created by PostgreSQL as required and are are used by the Analyze database. These tasks are not associated with the running of nodes. 

    A number of issues relating to Out Of Memory errors have been fixed recently. Can you let us know which version of the product you are using? You can get the details using the information (i) button on the menu --> About Data3Sixry Analyze.

     

    0
    Comment actions Permalink
  • Avatar
    Kyle Salvador

    Hi Adrian,

    Version: "3.4.0.4934"

    Also the PostgreSQL tasks are a separate issue.  There seem to be many orphaned tasks, left over from our night time schedule of Extractions.  We have many REST APIs scheduled to run in the night, and then along with the REST APIs, the TRANSFORM and LOAD of data from our staging tables to the Data Warehouse.

    We are finding that if an scheduled ETL fails during the night, it orphans a task in the Windows Task Manager.  We wanted to know if there was a setting in Data3Sixty to kill those tasks.

    Thanks!

    Kyle

    0
    Comment actions Permalink
  • Avatar
    Kyle Salvador

    Update:

    We are using the Aggregate for strings, and it was recommended to us by Paul from Infogix, to use the Transform node instead.  We are currently looking into this method and will reporting on its functionality.

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk