Modify Project Calendar through database

[Mikaelo]

Hello!

I need to modify enterprise calendars through mssql database.
I insert/delete exceptions with simple sql-query
insert into msp_calendar_data(proj_id, cal_uid, cd_uid, ...)
(like in project server documentation - pjdb.chm)

after updating i set proj_ext_data to 1 for global ent project

but i have some troubles
Situation 1
I modify calendar through sql and reopen project which has this calendar.

When i look to its calendar(Change Working Time menu) it has previous
calendar dates without new, but when i open global ent project it has
modified calendar dates

Situation 2
I modify calendar through Project UI and reopen project which has this
calendar
When i look to its calendar(Change Working Time menu) it has modified
calendar dates like global ent project

Is there any ideas about what wrong in Situation 1?
when i compare MSP_CALENDAR_DATA from S1 and S2, they look equal

Thanks

 

[Ed Morrison]

The calendar stores information in the binary fields. Therefore, if you do
not open then Enterprise Global after (or while) modifying it, it will not
change the calendar information in the binary field.

Try setting the proj_ext_data of the projects that use the modified
calendar. If that doesn't work, you may have to open the Enterprise Global
to force the processing.

 

[Mikaelo]

thanks for info about binary data

setting proj_ext_edited for project didn't help

interesting how it instruct projects to reload their calendars ?

Thanks