Hello, I want to store the repository information into postgres and I installed Postgresql on my computer. In the database tab of statistics gathering, I have configed the options properly and created tables successfully. But after the render jobs complete, there are no datas in the tables of the database, and when I click the ‘view repository stastics’ menu in the monitor, it pops out a windown to tell me that there are serval XML statistics entries and ask me whether I would add them to the database. After I click the ‘yes’ button, come out anthor window to tell me that the files cannot be added to the database and ask me to check the log file for more information, but I can not find the log file which tell what happen, is there anyone can help me?
To find the log file from the Monitor, select Help -> Explore Log Folder. Send us the Monitor log and we’ll take a look.
Thanks!
- Ryan
Hello, rrussell, I found the logs and them looks like below:
2012-10-08 12:31:03: Error Importing: \10.67.2.31\DeadlineRepository\reports\statistics\jobs\2012-08\999_050_999_1ddb9763.stats Message: ERROR: 22008: date/time field value out of range: “13/08/2012 09:44:41”
2012-10-08 12:31:03: Error Importing: \10.67.2.31\DeadlineRepository\reports\statistics\jobs\2012-08\999_050_999_4ea0cb7e.stats Message: ERROR: 22008: date/time field value out of range: “03/08/2012 11:31:56”
and I found in the database, the time fileds(like StartedDateTime and CompletedDateTime) are ‘timestamp without time zone’ type. Is there anything wrong?
Hello, rrussell, I have found the question when I changing some fields’ type ‘text’ in postgres, and I found that the datas were not in the proper place. what I got in table Slave likes below:
status |CpuUsage | MemoryUsage |Name | EntryCreationTime
Rendering |13 |1866436608 | 08/10/2012 15:15:06 | Cyl-think
Idle | 0 |1972117504 |08/10/2012 15:28:22 | Cyl-think
From above data, It’s easy to find that the datas in filelds Name and EntryCreationTime swaped. There are similar problems in table Job and Repository. Maybe you should check it out carefully and I wonder if this same problem exists in Deadline6.
Hello Diamond,
To solve the first error, there is a database setting in postgresql.conf. Please set “datestyle” to “dmy”. You’ll need to restart postgres for the setting to take effect.
I believe the order of the table columns may have changed when altering the column types. If possible, I would suggest dropping and recreating the tables to ensure the columns are in the original order. If there is no valid data stored yet, it might be easier to drop and recreate the database.
-Matt