Importing solution error: picklist value has to be one of the option values.

[CassandraG]

I keep receiving this error message when trying to import an unmanaged solution: error code: 80040203 "picklist value has to be one of the option values."

I've downloaded the xml log and see it processes all of the option sets but errors when it gets to the first table, with the message: "Specified argument was out of the range of valid values. Parameter name: Default picklist value has to be one of the option values." 

I've gone through all the choice fields and set the default to N/A. Still no change.

I've tried "add required objects" to the Accounts table - at first I didn't bring into the solution any objects/metadata. That didn't seem to fix anything.

I've run the solution checker, and the only item it reports is: The solution 21st Readiness Surveys contains a managed entity account with all assets. etc. This is a medium severity item.

When I show dependencies for the solution, the screen doesn't reveal any ("We didn't find anything to show here.")

I've also followed this guidance and searched for the <MissingDependencies> tag in the solution file. There are some, but nothing that really helps be determine which column may have a picklist error.

Anyone see this before and know how to debug it?

Thanks!

[Michaelfp]

This picklist you trying exporting is from the same publisher? 

Can you provide more information about it?

[jjpreston291]

@CassandraG  - also getting this error. Did you find the fix ?

[rampprakash]

Hi @CassandraG 

I faced the same issue, i overcome this issue by deleting the filed in Target Entity and imported the solution.

Note:

If there is no critical data available

Else check the below points

1. Make sure the publisher is same

2. Make Sure the Optionset Text and Value Same

3. Make Sure the Option Set Data type is same

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

[jjpreston291]

@rampprakash - that did not work for them but thanks

[ThePowerBro]

Have you included the Option set in unmanaged solution before exporting?

[CassandraG]

Just to follow up on this issue -- I was able to resolve it by identifying the column with the picklist issue and giving it a default value. I set the value based on a dataflow, so for this case, having a default value listed wasn't an issue. I believe the issue was caused by adding a column and using a global picklist with a default, and then changing that later.