SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 10952: "WARNING: Invalid value for DATETIME" in IT Resource Management (ITRM) XTC2TSK and XTC2DBD tables

DetailsHotfixAboutRate It
It is possible to receive the following warning message in IT Resource
Management (ITRM) for tables XTC2TSK and XTC2DBD:

   WARNING: Invalid value for DATETIME

This is because for tables XTC2TSK and XTC2DBD, DATETIME is associated
with the external variable name CREATIME, and it is possible that
CREATIME may contain missing values.

The circumvention is to use CPDDUTL to update the external name of the
DATETIME variable in tables XTC2TSK and XTC2DBD using the following
CPDDUTL control statements:

   SET TABLE
       NAME=XTC2TSK ;

   UPDATE VARIABLE
       NAME= DATETIME
          EXTNAME=STRTTIME;
   SET TABLE
       NAME=XTC2DBD ;

   UPDATE VARIABLE
       NAME= DATETIME
          EXTNAME=STRTTIME;


This will not affect existing data in the PDB, but once new data is
subsequently processed, reports may show gaps or overlaps where the
DATETIME variable has been changed.

The reference to the external variable will be changed in a future
release of IT Service Vision.

A Technical Support hot fix for SAS IT Resource Management Release 2.6
for this issue is available at:

http://www.sas.com/techsup/download/hotfix/itrm26.html


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS IT Management Solutions Core Components MVA Dataz/OS2.62.7
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.