Tagged Values - t_objectproperties

[OpenIT Solutions]

Hi All,

Can someone (from Sparx?) explain how the ea_guid is populated in the t_objectproperties table?

The reason i ask is that we created a BPMN profile, based upon the standard BPMN1.1 profile (minus some elements we didn't want our users to use). We now want to upgrade to BPMN v2.

The Sparx migration script doesn't work. Not suprised as i've change the profile name from BPMN1.1 to DBBPMN1.1. So i've run the following sql:

update t_xref set description = REPLACE (cast(description as nvarchar (max)), 'DBBPMN', 'BPMN')where description like '%DBBPMN%';
update t_diagram set StyleEx = REPLACE (cast(StyleEx as nvarchar (max)), 'DBBPMN', 'BPMN')where StyleEx like '%DBBPMN%';

The migration script now starts but crashes Sparx when it hits the migration of tagged values. If i delete all tagged values from t_objectproperties and re-run the migration script is fine.

Some digging suggests that the ea_guid in t_objectproperties is a combination of the type of tagged values internal ID and something else...i understand that the internal id would relate to our version of the BPMN profile (DBBPMN profile) so i need to update the ea_guid before the migration script will run...just need to understand how to update...

Any hints / pointers much appreciated.

Regards,

Jon.

[qwerty]

I remember a thread where this has been explained by one of the Sparxians. Especially I remember Geerts comments which more or less was: WTF. Maybe you're lucky in searching for it.

q.

[edit:] Tried a search but that server just hung. I guess this YABB piece only has a plain text search and no database or full text engine.

[OpenIT Solutions]

Thanks - couldn't find the thread however - any pointers anyone to it - or an answer to the specific quesion above ?

Again any help much appreciated,

Regards,


Jon.

[qwerty]

http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1317648108

I had to search by paging through the thread list! Scrap this YABB search!

q.

[OpenIT Solutions]

Many thanks for digging out the link - confirms my findings. I have a workaround of sorts - i need to test it today. But looks to work.

- run the updates in first post to change to your new profile. Then set the ea_guid of effected t_objectproperties to null and run Sync Tagged Values (from menu option on mdg resource - if you have imported it, from palette of mdg or via script) on the effected properties using your new profile.

It looks like this makes Sparx repopulate the ea_guid - without wiping existing values.

In my case i'm then able to run the BPMN1.1 to BPMN2.0 migration script without Sparx crashing !

Need to do some more testing, ill post back confirmation at the end of day...

Regards,

Jon.

[OpenIT Solutions]

Hi All,

FYI, i have confirmed that my workaround posted above works. One observation and question however - when you run the BPMN1.1 to v2 migration it looks like you are left with SubProcessType under the old 1.1 profile against Activities - why ? Also the migrated tagged values now in the v2 profile against Task (or event, decision etc) don't appear in compartments. If you create a BPMN v2 element from the v2 palette they do ? I'm assuming there is something missing in the migration function - can Sparx look at this or suggest a workround ?

Thanks,

Jon.