ir_GetActivityProperties

[Guest]

Until today I enjoyed working with BCM a lot. I share the databwase with two
other users/computers. However today I couldn't open the items anymore. I do
see the contacts (adresses etc.) but I can not open the emails or notes
anymore. BCM says:
ir_GetActivityProperties is missing in syscomments. The object needs to be
deleted and made again before it can be used"
(Note: I translated the message, because my BCM is in dutch).
I've no idea what I should do to solve this problem. Ideas are very welcome!

Ingeborg

 

[Luther]

I've never seen this before. Sounds like your database may have go
corrupted.

You could try recreating that stored procedure.

1) Find ir_GetActivtyProperties in one of the sql files in the BCM dir
under Program Files.
2) Connect to database with a sql tool.
3) Drop ir_GetActivtyProperties from the database.
4) Re-create using the existing code you found in step 1.

However, chances are there is something more serious wrong with the db,
and the error you saw is just the first symptom.

It may be easier to restore from your most recent backup.

If you can still export from your database, you could do that, create a
new database,
and import your data back into the new database.