Book a Demo

Author Topic: Timestamp in diagram notes at 00:00:00  (Read 3520 times)

Steve 5519

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Timestamp in diagram notes at 00:00:00
« on: July 30, 2012, 05:41:03 pm »
Hi
I'm new to EA and I am having a problem with the "Created " and "Updated" timestamps. When added to the diagram they are correct but when the diagram is saved then the timestamps read. 00:00:00. What am I missing.

I'm using EA version 7.5.850.

Exart

  • EA Novice
  • *
  • Posts: 14
  • Karma: +0/-0
    • View Profile
Re: Timestamp in diagram notes at 00:00:00
« Reply #1 on: August 22, 2012, 09:46:55 pm »
Are you using MySQL database?
I'm asking about it because there is a little bug in MySQL Schema.
There is:
DROP TABLE IF EXISTS `t_diagram`;
CREATE TABLE `t_diagram` (
[...]
  `CreatedDate` date DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
[...]
It should be:
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,

You can modify schema as below:
ALTER TABLE `t_diagram` CHANGE `CreatedDate` `CreatedDate` DATETIME NULL DEFAULT NULL;
ALTER TABLE `t_diagram` CHANGE `ModifiedDate` `ModifiedDate`  DATETIME NULL DEFAULT NULL;

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Timestamp in diagram notes at 00:00:00
« Reply #2 on: August 22, 2012, 10:10:54 pm »
I just check in our model (SQL Server) and we don't seem to have an issue with that.
All timestamps are filled in correctly (up to the seconds)

Geert

Steve 5519

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Timestamp in diagram notes at 00:00:00
« Reply #3 on: August 29, 2012, 04:06:15 am »
 My thanks to Exart. The problem is fixed.