strange state update on "letter" entity

(0) Share

Report

Posted on by Emre GULCAN

2,379

Hi all,

We use letter activity entity for SMS integration and I have a strange "state update" some of my records.

"SYSTEM" user update just "statecode" and break my record state/status matching, so my record status changed to "cancelled (2) - draft (2)"

I got this sql command from trace log data

update [ActivityPointerBase] set [StateCode]=2, [ModifiedOn]='06/07/2017 09:37:55', [ModifiedBy]='SYSTEMUSERID', [ModifiedOnBehalfBy]='MY USER ID' where ([ActivityId] = 'ACTIVITY ID')

My environments is MS CRM 2015 7.0.0.3543 (DB 7.0.0.3543)

Do you have any idea?

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Emre GULCAN 2,379 on at

Like (0)

Report

RE: strange state update on "letter" entity

I found reason after some deep digging on letter and related entities.

It occurs if letter (activity) 's "regardingobject"'s state/status changes and if activity is "open", SYSTEM cancel/close it.

However there is a bug (or some overlook points) about State-Status matching, because as you can see code above just update "StateCode" on activity entity and there is no "StatusCode" mapping.