Failing to Import Solution

[JoseEduardo]

I'm getting this error every time I try to import (pipeline or manuel import) my solution

Solution "GVR IT Application Portfolio Management" failed to import: The FetchXml (<fetch version="1.0" mapping="logical" savedqueryid="ce18a8f2-4635-ee11-bdf4-000d3a3707f7"><entity name="lha_gvrglobalappinventoryintake"><attribute name="lha_gvrglobalappinventoryintakeid" /><filter type="and"><condition attribute="statecode" operator="eq" value="0" /></filter><attribute name="lha_applicationname" /><attribute name="lha_description" /><attribute name="lha_version" /><attribute name="lha_vendor" /><attribute name="lha_applicationtype" /><attribute name="lha_hostingtype" /><attribute name="lha_businessportfolio" /><attribute name="lha_supportdocumentationavailable" /><attribute name="lha_location" /><attribute name="lha_region" /><attribute name="lha_businessowner" /><attribute name="lha_itowner" /><attribute name="lha_ofusers" /><attribute name="lha_businessfitnessbusinessfit" /><attribute name="lha_businessfitnessinfoqualitytimelinessprivacy" /><attribute name="lha_businessfitnessfuturepotential" /><attribute name="lha_businessfitnessprivacy" /><attribute name="lha_technicalfitnessrelianceonskillsandsmes" /><attribute name="lha_technicalfitnessmaintainability" /><attribute name="lha_technicalfitnessvendorviabilityandsupport" /><attribute name="lha_technicalfitnessarchitecturalalignment" /><attribute name="lha_technicalfitnessproductionstability" /><attribute name="lha_technicalfitnesssecurity" /><attribute name="lha_technicalfitnesscloudsuitability" /><attribute name="lha_costfitnesssvcmaintandenhancementcosts" /><attribute name="lha_criticality" /><link-entity alias="a_8a5abb22c78b45a592ad34de119e144f" name="crf0b_gvritappresourcetoapptable" to="lha_crf0b_gvritappresourcetoapptable" from="crf0b_gvritappresourcetoapptableid" link-type="inner"><filter type="and"><condition attribute="crf0b_applicationname" operator="eq" value="PC Factory" /></filter></link-entity></entity></fetch>) is invalid. Failure ('lha_GVRGlobalAppInventoryIntake' entity doesn't contain attribute with Name = 'lha_crf0b_gvritappresourcetoapptable' and NameMapping = 'Logical'. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = True, Timestamp=1332407771, MinActiveRowVersion=1332407771, MetadataInstanceId=51696442, LastUpdated=2024-06-19 03:32:06.533, OrgId=f2b6c82a-f12b-4a08-973f-7fda773bfe2b) occurred while calculating dependencies for SavedQuery (Id=ce18a8f2-4635-ee11-bdf4-000d3a3707f7).

I made some changes to the sokution in Dev mostly related to relationships, I delet them and recfeate the again.
but even though I create the again with same name it is failing

I also delete the whole solution from the Environment where I want to import but didn't  solve the error 

[Mira_Ghaly]

@JoseEduardo

 Can you verify that on the environment you are importing to , the below field exists ?

'lha_GVRGlobalAppInventoryIntake' entity doesn't contain attribute with Name = 'lha_crf0b_gvritappresourcetoapptable

Try to publish all customization after making sure that the field "lha_crf0b_gvritappresourcetoapptable" exists on the table lha_GVRGlobalAppInventoryIntake

[JoseEduardo]

The Solution was deleted 

should I check on the tables?

[Mahender]

Hi,

When you delete unmanaged solution, it won't delete component of the solution from system they still exists in the based solution (Default solution), check table under base solution and verify this field exists there under columns. 

HTH 

[JoseEduardo]

The solution deleted was a Managed Solution is there anything I'm missing?

[Mira_Ghaly]

@JoseEduardo Then you will need to re-import it but to answer your question you will need to check the default solution to be able to see your table and the fields within it

[parvezghumra]

@JoseEduardo As suggested above, the error suggests that there's an object in your solution which is still holding a dependency to an object that you have previously deleted. I'm wondering whether you have you modified any objects outside of the maker portal (for example, a system view definition which uses such a FetchXml query)? This could have caused this error. I would recommend unzipping the solution file, searching the resulting files for this column logical name, and then removing the reference to the deleted column. Then rezip the files and try to import the resulting solution again