Status Reason Values

(0) Share

Report

Posted on by Community Member

Hi,

We are using ClickDimensions Events and created a unmanaged solution to change fields.

For the Status Reason (aka statuscode) field, we created scheduled (instead of Active) and Deactivated (Instead of Inactive) to avoid confusion among users since the Status (aka statecode) field also has Active/Inactive. However after deleting the Active/Inactive from Status Reason, we are now getting errors in the application and even in any events (ClickDimensions Entity) that had a reference to it.

Can't even access the Status Reason field to change it back.

6013.error.JPG

Is there a way to restore these status reasons Active/Inactive ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Did you actually delete the Status Reasons or Rename (change the label) them?

Was this reply helpful? Yes No
Verified answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi Gagandeep,

is it possible for you to get a solution from other environment including this field and import it to this organization.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We created the new ones and deleted the existing ones.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You mean the unmanaged solution or the default one by MS ?

We are configuring our sandbox environment. That's where we deleted the status reason values.

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (2)

Report

That is most likely the problem, as the number (codes) for the Status Reasons are not incorrect and what is causing this issue. If you have the ability to reimport those fields (OOB) from a DEV environment that would be the best (as Rawish mentioned above).

If not, you can possibly change the values of the existing fields (not sure what the original ones are) using the following code (in a C# console application):

private void InsertStatusReasonValue(string entityLogicalName, int stateCode, int statusCode, string label)

{

InsertStatusValueRequest insertStatusValueRequest = new InsertStatusValueRequest

{

AttributeLogicalName = "statuscode",

EntityLogicalName = entityLogicalName,

Label = new Label(label, 1033),

Value = statusCode, // integer value of current State Code

StateCode = stateCode // integer value of new Status Code

};

int _insertedStatusValue = ((InsertStatusValueResponse)service.Execute(insertStatusValueRequest)).NewOptionValue;

}

This way you can reset the status code to the correct value, but first you need to find out what they are.

EDIT: One more thing. Your status codes are most likely Active = 1 and Inactive = 2, as these are the default values for most Status Reasons (codes)

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Aric,

I came across another post that mentioned the same thing.

The only issue remaining now is how to get the default values of the status codes we deleted.

Will try 1 and 2 see if it works.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Not sure which entity this is for, but the default ones are Active (1), and Inactive (2). Usually they are not modified.

If you need to change these after you fix the issue, I would just rename the existing ones.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Aric and Rawish.

We created an unmanaged solution in the PROD (still out of the box) and just added the Events entity with the default Status Reason values and imported in our Sandbox. That seems to have somehow fixed the issue for now.

Even though we were expecting to see Active/Inactive, it shows the customized values(Scheduled/Deactivated) but is working fine and we are able to open the field and also the events seem to be working fine.

Was this reply helpful? Yes No
Rawish Kumar 13,758 on at

Like (0)

Report

Glad it worked :)

would you mind closing this thread then by marking suggestions as verified so that it can help others.

Was this reply helpful? Yes No