Activities storetype changed! – Migration from Connections 4 to 4.5
I just upgraded our Connections environment from 4 to 4.5. Unfortunately it didn’t run as smoothly as expected.
I did a side-by-side migration (no application artifacts export) and copied all content stores to the new server
A really nasty problem was that all activities file uploads could not be accessed after the upgrade 🙁
So I checked logs and the DB tables and found out that the storetype of activities uploads changed from filesystem to filestore
-> everytime I tried to download pre-migration files Connections did a lookup for the storetype filesystem which was not defined in oa-config.xml
Fixup was easy, just change the storetype in oa-config.xml to filesystem
If you uploaded files to activities after migration but before changing oa-config.xml you have to define a second storetype in oa-config.xml or you can go to your DB2 server and change the field STORETYPE of all new files in table ACTIVITIES.OA_CONTENTREF to filesystem.