Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

When Whenever a " Date Interval " is created with the "Date" attributes as "Start" and "End" it happens that
iteraplan doesn't and this date interval has date attributes as <Start> and/or <End> assigned, it might happen that iteraplan does no longer respond and an error appears. This is only appears the case when the "Date" date attributes are not activated
for the same " Building Block Types " as the " Date Interval "itself

Solution

You can use the following SQL Queries statements to fix that iteraplan doesn't responds:

  • MYSQL

UPDATE ATTR SET the problem

Code Block
languagesql
titleMySQL
UPDATE ATTR SET LAST_MOD_USER='-', LAST_MOD_TIME='2000-01-01 00:00:00' WHERE LAST_MOD_USER is NULL or LAST_MOD_TIME is NULL;

...

 
  • ORACLE

...

Code Block
languagesql
titleOracle
UPDATE "ATTR" SET LAST_MOD_USER = '-', LAST_MOD_TIME = TO_TIMESTAMP('2000-01-01 00:00:00.000000000', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE LAST_MOD_TIME is NULL or LAST_MOD_USER is NULL;

...

Code Block
languagesql
titleMS SQL
UPDATE ATTR SET LAST_MOD_USER='-', LAST_MOD_TIME='2000-01-01 00:00:00' WHERE LAST_MOD_USER is NULL or LAST_MOD_TIME is NULL;


When iteraplan work's is running again, please check if the "End" <End> date attribute of the " Date Inteval" Interval was set.