Analytics | ETL process fails with error: 'Task: ProjectETL : Invalid year value'

Document created by olivier.pathy Employee on Jun 1, 2018
Version 1Show Document
  • View in full screen mode

Summary

Issue Encountered: ETL process is failing everyday with the following error: 'Task: ProjectETL : Invalid year value'

Environment

Hosted, Cloud

Expected Result

  • ETL process runs automatically, successfully every day.

Actual Result

  • ETL process fails every day with the error, 'Task: ProjectETL : Invalid year value'

Cause

  • As the error indicates, the issue is with an invalid year value and the failing task is of the Projects.

Resolution

  • Correct the invalid year value in the Database (under projects)

Workaround

  • Run the following query on Analytic Database.

SELECT projectID, latestStatusID, dueDateNull, startDate, dueDate, creationDate, modificationDate, parentObjectType, parentObjectID, userID, status FROM jiveProject ORDER BY projectID;

  • Check for timestamps of Project Start Date/End Date that stands out from the rest.
  • Get the projectID(xxxx) of those projects
  • Run the following query on Analytic Database.

SELECT * FROM jiveproject WHERE projectid=xxxx;

  • Once you have the Project name, navigate to the project on the front end.
  • The click Manage > Settings > About and check what is set for the Project Start Date/End Date. (sample image)
Project's 'About'
  • Correct any invalid/incorrect 'Year' entries in the dates.

Note

  • You can also check on the projects having the last modified on the date(ETL started failing from next day of modification date)

Attachments

    Outcomes