[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1477
  • Last Modified:

Microsoft CRM 4.0 - One or more of the option values for this picklist are not in the range of the allow values

We are applying payments (custom entity0 against invoices in CRM 4.0 and are getting the following error:
"One or more of the option values for this picklist are not in the range of the allow values"

We have compared the values in the picklists, the relationships for the entities, the unassigned value for each picklist amd revoew posts on the web related to this error.

So far we cannot find any reason why this message pops up for some invoices/payments but not others.

Any insight on this or a way to resolve it would be greatly appeciated.

Thanks



0
apollo7
Asked:
apollo7
  • 7
  • 6
1 Solution
 
Chinmay PatelEnterprise ArchitectCommented:
Hi apollo7,

This error indicates that there were some old pick list values which were removed from system for that entity[Payment].
Generally if you want to remove a Picklist value you change the records with that value to a newer value.

Let me know if you nee help with this.

Regards,
Chinmay.
0
 
apollo7Author Commented:
So it appears that is the problem.

On our Acceptance server (which works without the error), the picklist is setup differently than the Production server (which is throwing the error)

When I compare the picklists, the Production server has nine items numbered 1, 2, 3, 4, 200,000, 200,001, 200,002, 200,003, 200,004

The Acceptance server picklist has eight items numbered 1, 2, 3, 4, 200,000, 200,001, 200,002, 200,003

Is there a straightforward fix for this?

Thanks

0
 
Chinmay PatelEnterprise ArchitectCommented:
Yes insert the missing one on Production Server.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Chinmay PatelEnterprise ArchitectCommented:
Sorry I was rushing and I did not read it properly, seems missing one is on Acceptance Server. Also if the error is coming on Production server then check with other picklists. Maybe some other picklist is causing this error. Also are you migrating data from Acceptance server to Production server[Which I believe can not be the case here]?
0
 
apollo7Author Commented:
Right on all counts :)

I will check other picklists to see if another one has been cleared out on production.
Also, you are correct, we are not migrating data from Acceptance to Production.

Thanks - will go take a look at the other picklists.
0
 
Chinmay PatelEnterprise ArchitectCommented:
No problem.
0
 
apollo7Author Commented:
Chinmay,

Checked the picklists, relationships and onload for payment and invoices on production compared to acceptance - no apparent differences.

Let me know if you can think of anything else that might be causing this or if you have seen it anywhere else.

Thanks
0
 
Chinmay PatelEnterprise ArchitectCommented:
I know this might be too much but could you check the value of the picklist? Maybe soneone created it and after sometime dropped it and then recreated the picklist with some other value.
0
 
apollo7Author Commented:
Not sure what you mean by checking the value of the picklist?

Do you mean the attribute name or some other characteristic?

Do you mean some value in the database?

Thanks
0
 
Chinmay PatelEnterprise ArchitectCommented:
Each picklist option has a corresponding value stored in crm. I'm asking to check that value.
0
 
apollo7Author Commented:
Oh, are you referring to the number that goes with the picklist selection?  For example, for the credit card list, we have Visa, Discover, Amex, etc and each has a number (like 1, 2, 3, then 200,000, 200,001 and so on)

Yes, I checked these numerical values for every entry in each list by clicking edit then reviewing/comparing the wording and the numbers.

All are the same between production and acceptance.

Thanks
0
 
Chinmay PatelEnterprise ArchitectCommented:
Hmmmm...then we will have to check individual records. Do you have those records with you?
0
 
apollo7Author Commented:
Thanks - had to expand my search to other picklists and found the one causing the issue.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now