How can I find a component that has a specific id?

(0) Share

Report

Posted on by Kenco

Hi,

I'm trying to find the component that has a specific id. Does anyone know how to do this? My CRM instance is Online and using "CRM Online Spring '14 (6.1.2.133) (DB6.1.2.112).

The reason I want to find it is that when I attempt to import a managed solution I get the following error:

"A managed solution cannot overwrite the OptionSet component with Id=xxxxx"

I have tried using xrm classes such as RetrieveAllOptionSetsRequest and RetrieveAttributeRequest without any luck e.g.

RetrieveAllOptionSetsRequest retrieveAllOptionSetsRequest = new RetrieveAllOptionSetsRequest();

RetrieveAllOptionSetsResponse retrieveAllOptionSetsResponse = (RetrieveAllOptionSetsResponse)service.Execute(retrieveAllOptionSetsRequest);

RetrieveAttributeRequest retrieveAttributeRequest = new RetrieveAttributeRequest();

retrieveAttributeRequest.MetadataId = new Guid("xxxxxx");

RetrieveAttributeResponse retrieveAttributeResponse = (RetrieveAttributeResponse)service.Execute(retrieveAttributeRequest);

Thanks

Ken

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

I think you don't need to write code..

when you are importing solution.. CRM will give you log file..

This log file is XML file. Open this log file in Excel.. then in second tab you will find which component / option set is failing, and then you can do changes accordingly.

Was this reply helpful? Yes No
Verified answer

Kenco 50 on at

Like (0)

Report

thanks for the reply Mahadeo but in this case the guid wasn't in the log either. Microsoft have taken a copy of the database to do more analysis on this.

By the way another good method of finding a control with a specific GUID is to open a current field in the solution, copy the url, replace the attribute guid in url with the one you are trying to find then paste the new url back into the browser. This will show you the attribute if it is there. Unfortunately the one I was looking for was not there.

Thanks

Ken

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I maked this sql to find in the database where the field is uniqueidentifier and contain id:

select 'select '''+ table_name +''' from ' + a.table_name + ' where '+ column_name +' = ''b422f0ec-372c-e711-80dd-005056bd5340'';' from (

SELECT t.name AS table_name,

c.name AS column_name,

ty.name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

INNER JOIN sys.types ty ON c.user_type_id = ty.user_type_id

where c.name like '%id%' and ty.name = 'uniqueidentifier'

) as a

Hope this can help you

Was this reply helpful? Yes No
Suggested answer

Willem De Backer 20 on at

Like (0)

Report

there is a chrome extension to do things like this, called "level up for dynamics CRM/365".

very easy to use and very helpfull. you can do various things like open record by id , copy the current record id , add logical names to form , and many more ..

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

Hi have explored here more, please look it once:

pravinpawarweb.wordpress.com/.../

Was this reply helpful? Yes No