Companies are added every time process is imported

0

Hi Adam,

Is there any chance that companies were created by hand on each environment, and not with import/export?
You could check it by running query below on each environment - if Guids are different, thats the reason why new companies are created.

SELECT COM_Name, COM_Guid, COM_ID FROM Companies

You should import companies from production env to dev/test, this will create new ones with same guid, and then correct any rules, which used the wrong ones.

Dear Maks,
thanks for that. I should have looked in DBs at first place :)
Just curious what happens if I change GUIDs in TEST DB to match those in PROD directly on DB. Seems that values from COM_ID are used in other tables (i.e. WFElements).

Have you tried that before?

Hi Adam,

yes, COM_ID is used but not COM_GUID which is used for the transport.

I didn't update the COM_GUID but I had to synchronize the IDs of global constants/fields which had been created manually on other environments.

Best regards,
Daniel

I've never tried it, so can't tell - i'm avoiding any updates on the database i'd rather not miss something that will cause more troubles :)
I'm using API if i need to do some digging - this way i know all the logic of database is handled by the WEBCON, but in that case API is no help.

Although if other places are using ID's (i've not checked it), not GUID's it might work.

OK. Took a risk and updated GUIDs on TEST env DB with the ones from PROD. IDs were the same. Then I have exported one application from test env to prod env and during the import in prod it was OK. No information about creating new companies during import. I didn't finished / confirmed the import process to prod env assuming that information displayed in import wizard is valid :)

Personally I do also prefer to avoid any changes in DBs, but it's still easier than changing IDs of companies used.

Thanks for your support.