topic Re: X-ray Error in State & Local Government Questions

X-ray Error

PatriciaMoehring — Mon, 15 Oct 2012 16:42:06 GMT

Trying to export xml of one dataset and getting error -- "XML Export Datasets Error: Unable to cast COM object of type 'System._ComObject' to interfacet type 'ESRI.ArcGIS.Catalog.IGxObject'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BDBBB3EB-D0B2-11D1-AED9-080009EC734B}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

I don't know what this means or why it isn't working. Seems like I'm doing exactly what Steve is doing in the video?

Any ideas?

Re: X-ray Error

SteveGrise — Mon, 12 Nov 2012 20:05:28 GMT

Could you post your xml workspace document or email it to me?

Steve

Re: X-ray Error

ScottOppmann — Thu, 15 Nov 2012 02:25:00 GMT

Steve -

We were able to reproduce this error late today and will get with you on the details. We'll also be updating the help documentation to clarify the specific steps required.

Scott

Re: X-ray Error

LindsayThomas — Thu, 15 Nov 2012 22:25:46 GMT

Hi Patricia,

We have logged this issue as a bug. (this issue occurs in the 10.0.82 version of the addin)

In the meantime, we have a workaround for you (I past this on to the tech support person who was helping you as well, but thought I would response so others can see the workaround)

Workaround

In Step 4 B. of the help http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#/Migrating_your_data_to_the_Local_Government_geodatabase/028s00000049000000/

We say select the feature class in the Catalog Tree. This will expose a bug. You will get the error message you posted below when importing the xml to the gdb if your selection is in the catalog tree only.

If you select in the Content tab when selecting the feature dataset\class to get the spatial reference you will not get this error. (ensure that the content tab has a selection)

hopefully this helps.

Cheers,
Lindsay Thomas

Re: X-ray Error

AndrewFarrar — Tue, 27 Nov 2012 15:36:07 GMT

I have a similar problem when trying to import the LocalGovernment.xml to a file geodatabase. I get the same exact error message except that it comes up as an "XML Import Error:" I followed the workaround on this thread assuming that it may be the same issues (selecting all of the inputs from the "Contents" tab in arccatalog. I'm curious if there has been any more development on this issue? I'm following step-by-step the directions and doing everything locally.

Any help would be much appreciated! Thanks!

Andrew

Re: X-ray Error

SteveGrise — Fri, 07 Dec 2012 16:02:42 GMT

Hi folks, new versions of the Addins for 10.0 and 10.1 were posted today - includes fixes that are intended to solve this issue.

Re: X-ray Error

AndrewFarrar — Fri, 07 Dec 2012 17:39:27 GMT

Thanks for the update Steve. I was able to work around it, but hopefully the new versions have really fixed it.

Re: X-ray Error

Anonymous User — Thu, 07 Feb 2013 14:01:00 GMT

I have a little different problem. I made some significant changes (feature class/domain/attribute additions) for a public safety implementation using the X-Ray spreadsheets, and now I am getting an error on import.

OS/Software
Windows 7 x64
ArcGIS for Desktop Advanced 10.1 SP1 (Build 3143)
X-Ray v10.1.90 November 16, 2012 (this was the latest download I could find)

After making the necessary modifications in the spreadsheets, both for the datasets and the domains, I tried both the Import to Geodatabase and the Import Using Geoprocessing... options. Here are the errors respectively:

Import to Geodatabase
XML Import Error:The table name is invalid.

Import Using Geoprocessing...
GeoProcessing Error Messages:

Python Error messages:
Traceback Info:
File "C:\Users\jwood\AppData\Roaming\ESRI\Desktop10.1\ArcToolbox\My Toolboxes\ImportUsingGeoprocessing.py", line 116, in main
createFields(dataset)

File "C:\Users\jwood\AppData\Roaming\ESRI\Desktop10.1\ArcToolbox\My Toolboxes\ImportUsingGeoprocessing.py", line 320, in createFields
fullClassPath= findClassPath(className)

File "C:\Users\jwood\AppData\Roaming\ESRI\Desktop10.1\ArcToolbox\My Toolboxes\ImportUsingGeoprocessing.py", line 573, in findClassPath
fds.Reset()

Error Info:
<type 'exceptions.AttributeError'>: 'list' object has no attribute 'Reset'

Completed script ImportUsingGeoprocessing...
Failed to execute (ImportUsingGeoprocessing).
Failed at Thu Feb 07 09:34:07 2013 (Elapsed Time: 22.00 seconds)

I did not manipulate any table names or add any tables to the LGIM 10.1 schema. Neither error message tells me which object it's having a problem with. Anybody have any ideas?

Many thanks in advance,
James

Re: X-ray Error

ScottOppmann — Thu, 07 Feb 2013 21:52:26 GMT

James -

I would suggest you use X-Ray to validate your XML workspace before attempting to import it. You'll find the Validate tool under theTools dropdown. The validate tool will check your XML workspace document and give you a report of the errors.

The error you mention below sounds like the name you assigned to the feature class may not match the name of the worksheet. Also keep in mind the Import Using Geoprocessing only works with simple features and does not support many of the complex data types that are in the Local Government Information Model (parcel fabric, etc.). This tool (while powerful) should really only be used to cycle on simple changes (new feature classes, tables, domains, etc.) you want to make to you current model.

Scott

Re: X-ray Error

Anonymous User — Fri, 08 Feb 2013 02:57:09 GMT

Scott,

Thanks very much for the suggestion. I've validated both my modified XML workspace and the original XML workspace provided with the LGIM 10.1 download. They are both in the attached zip file. I'm assuming the Errors are the ones that are causing problems, as the Warnings seem less prohibitive, especially since I am importing into a file geodatabase. There are 20 errors present from the validation of the original download (which surprised me, but obviously some errors are OK), and I have 28. The problem is that none of the listed feature and relationship classes in the Errors list are any of the ones that I modified. Furthermore, all of the missing classes with their associated datasets have a tab present in the GISDatasets workbook. The two that are missing associate datasets are actually pointers to Parcel Fabric sublayers which do not have a spreadsheet tab (there is only the one tab for ParcelFabric). All of the type mismatches have to do with the attachment relationship classes (which are similar in the original validation). That leaves the one NoDatasetName, which seems to suggest that there is either an empty spreadsheet cell defining the name or an empty spreadsheet tab, but I have gone through all of the tabs in the GISDatasets workbook and did not find anything missing in that regard (i.e., all B1 cells are populated, all FeatureDataset definitions are either populated or null [for some root-level relationship classes] and there are no empty tabs). BTW, a great way to surf through the tabs is to use Ctrl+PageUp/PageDown.

So, I'm left scratching my head, and I may be misinterpretting the validation output, but at least this gives me something to go on to keep digging.

Thanks again,
James

Re: X-ray Error

Anonymous User — Fri, 08 Feb 2013 03:55:07 GMT

OK, so the NoDatasetName was referring to the AddressPoint feature class, which is present in the geodatabase I derived the xml workspace doc from, but apparently did not carry over. I added it in from the original LGIM xml workspace and (even though I now have 26 errors) it imported fine. A couple of other observations:

Running Analyze Differences between the GDB and the derived XML will help understand what's missing as well.

You can't just save the Excel workbook, you must also hit the Save edits to selected XML Workspace icon in ArcCatalog for changes to be kept.

Thanks again Scott for pointing me in the right direction.
James

Re: X-ray Error

philippenn — Thu, 28 Feb 2013 23:22:39 GMT

Getting a similar error for trying to export a single FeatureDataset on v10.0.90 of the ArcCatalog XRay Addin running ArcGIS Destkop v10.0 SP4.

I can export the whole Geodatabase just fine but if I select a single FeatureDataset and export (followed by "Yes") then I get

XML Export Datasets Error: Unable to cast object of type
'System.__ComObject' to type 'ESRI.ArcGIS.Catalog.GxCatalogClass'.

I've tried different FDs, tried selecting the FD in the tree or in the Contents pane. Same result.

Any ideas or workarounds gratefully received.

Phil

Re: X-ray Error

PeterPalacios — Mon, 03 Jun 2013 17:37:27 GMT

I've made minor changes to existing SDE datasets and domains and cannot get the Import Using Geoprocessing tool to run without the following error:

Output Geodatabase does not exist
GeoProcessing Error Messages:

Python Error messages:
Traceback Info:
File "C:\Users\pp0003\AppData\Roaming\ESRI\Desktop10.1\ArcToolbox\My Toolboxes\ImportUsingGeoprocessing.py", line 74, in main
    exit(-1)

File "C:\Python27\ArcGIS10.1\Lib\site.py", line 372, in __call__
    raise SystemExit(code)

Error Info:
    <type 'exceptions.SystemExit'>: -1

Completed script ImportUsingGeoprocessing...
Failed to execute (ImportUsingGeoprocessing).

I've tried multiple configurations for the input parameters (use in-tool dialogue boxes to navigate, drag/drop, local paths, UNC paths) to no avail. Aside from SQL Reserved Word warnings I don't have any errors according to the Validate tool and the Analyze Differences confirms the changes I've made. Anyone have insight to share about this error?

XRay version 10.1.88
Win7 Enterprise SP1 64-bit
ArcDesktop 10.1, SDE 10.1
SQL Server 2008

Re: X-ray Error

JaredCollier — Mon, 03 Jun 2013 18:00:08 GMT

I am getting a similar but different error. Any ideas?

Scenario:
Select File GDB to populate dialog, Rename the xml by adding a few letter to ID Feature dataset I would like to extract the xml for (in this case SewerStormwater I added SSW).
I then clicked on the Feature Dataset SewerStormwater in the contents window.
Then I click the export to xml button and this is the error I eventually get after it thinks for a moment. Note that if I delete SewerStormwater_Net it errors the same just with the next feature class in line.

Error in XML Document processing: An error occurred while loading document 'C:\Users\xxx\AppData\Local\ESRI\Desktop10.1\AssemblyCache\{C70C3622-9C........\Working\SewerStormwater_Net_Junctions.xml'. See InnerException for a complete description of the error.

Jared

Re: X-ray Error

OvidioRivero — Mon, 18 May 2015 20:42:05 GMT

Hello all,

I am having a very similar error to the one shown on this thread. The error says: "Xml Import Error: Type Mismatch. (Exception from HRESULT:0x002005). DISP_E_TYPEMISMATCH))

This happens when I try to import the xml schema. I have validated it until it has no errors. I have also tried the workaround about the about the spatial reference described on this thread. I have set it via the Options menu and by selecting a feature dataset on the database.

I have also looked for empty worksheets on the spreadsheets but no success there either. I am using Arc 10.2.03348 and version 10.2.2 of the add-in. Any ideas?

Thanks,

Ovidio

Re: X-ray Error

JeffWard — Mon, 18 May 2015 20:51:39 GMT

X-Ray for ArcCatalog is very fussy. You have to click things in the right place and at the right time and follow the instructions exactly.

I wrote a blog entry mostly for my own reference to help me when I needed to do it again. You need to follow these instructions. When it tells you to select things in the contents window that's where you need to select it. Don't forget the step that directs you to save the xml schema after you set the spatial reference.

Re: X-ray Error

OvidioRivero — Mon, 18 May 2015 21:24:10 GMT

I tried this too. I even closed the catalog tree so that I only had the contents window available. I am able to export out and import back in other databases. I think I am using the tool correctly and the error is probably something I introduced on the spreadsheets and the xml but the error message is so cryptic that it does not help me troubleshoot the problem.

Re: X-ray Error

SteveGrise — Mon, 18 May 2015 21:57:05 GMT

I will look at the Xml workspace document for the error if you send it to me. It is likely a different problem than the last few people have reported. This error is reported by the esri Xml Importer so there is little I can do to improve the messages, but there are many different things that can go wrong. steve (at) vertex3 (dot) com

Re: X-ray Error

OvidioRivero — Wed, 20 May 2015 15:07:50 GMT

Here is the file. My current theory is that an escape character got introduced somewhere but I have not figured out how to remove it yet. I have this theory because if I use the Import Using Geoprocessing option it is crashing at a list of countries where there are some foreign characters but the ones I have looked at are completely valid in UTF 8. Therefore I am thinking I am getting a bogus carriage return.

Thanks,

Ovidio

Re: X-ray Error

SteveGrise — Wed, 20 May 2015 16:17:31 GMT

On the Feature Class HypsographyPnt, the FCSubtype DefaultValue for SubtypeCode 100355 (the first one) has a value of 'noInformation' rather than 100355. This string in the integer field appears to be the source of the issue.

Once I replaced that I was able to import that and other parts of the model.