topic Re: Bacth Generate Schema Report in ArcGIS Pro Questions

Batch Generate Schema Report

ReeceVydrzal1 — Fri, 11 Apr 2025 12:18:15 GMT

Hey,

I have a very large arcgis online webmap that has been developed and refined over the course of the last couple of years. I am wanting to get the schema for these various different features into an excel sheet.

The 'Generate Schema Report' tool when used on a single feature is able to output exactly what I am looking for in an appropriate format when cleaned up a little bit.

Is there a way that I can use this on more than one feature at a time and to have it output a single excel sheet summarizing the entirety of my project. In a vein attempt to make this work I tried doing a batch version of the tool, but it was only able to output a table for a single feature.

Re: Bacth Generate Schema Report

Robert_LeClair — Thu, 20 Jun 2024 20:10:39 GMT

So even though the Generate Schema Report GP tool parameter says - Input Dataset - it will take an entire geodatabase and generate the report for EVERYTHING in that GDB. I tested this where I selected Demo.gdb as the input dataset and generated a pdf with the full report.

Re: Bacth Generate Schema Report

LauraleeGann25 — Thu, 10 Apr 2025 12:07:51 GMT

Good morning Robert,

Are there any means to get a Schema Report from an UNregistered, non-eGDB, just a plain FGDB--I see in the notes that it has to be registered and that has changed recently, as a few months ago, it would work on unregistered FGDB, just looking for a means out side a registed eGDB

Re: Bacth Generate Schema Report

Robert_LeClair — Thu, 10 Apr 2025 19:39:50 GMT

Good afternoon Lauralee! So I examined the help documentation back to ArcGIS Pro 3.2 and the pages say that the datasets must be registered with the geodatabase. So I don't think there's been a change recently in the code.

There's a great blog article here that discusses the Generate Schema Report GP tool. I see that you found the Esri Community Data Management page that discusses this as well and asked Jonathan for the information referenced in your response here. I'd be curious to hear what Jonathan says.

Re: Bacth Generate Schema Report

AyanPalit — Thu, 10 Apr 2025 21:58:41 GMT

@LauraleeGann25 Generate Schema Report GP tool supports a file geodatabase (FGDB) input in addition to enterprise geodatabase (EGDB). I am unsure what you mean by registered vs. unregistered.

Re: Bacth Generate Schema Report

LauraleeGann25 — Fri, 11 Apr 2025 13:30:26 GMT

@AyanPalit @Robert_LeClair Thank you both and I do look forward to someone figuring out why it can only be run on basically an eGDB, when just a few weeks ago you could run the tool on any data, so it's odd that this would be required or need to be registered, Everyone needs a report like this it is only sensible, so I look forward to when the developers "Release" the tool for the GREATER GOOD🌏🌎🌍

Re: Bacth Generate Schema Report

Robert_LeClair — Fri, 11 Apr 2025 14:27:47 GMT

@LauraleeGann25 - so I can confirm that the Generate Schema Report does work on a fGDB as I just ran it without any issues. See images below. The item "datasets must be registered with the geodatabase" only applies to eGDB's and not fGDB's. In eGDB's, when a dataset is registered with the geodatabase, this stores information about the items in the repository system tables. My guess is that help documentation for this item could be improved. Question - are you not able to run the GP tool on your fGDB? If it does not run, then maybe you need to upgrade the fGDB to the current release.

Re: Bacth Generate Schema Report

AyanPalit — Fri, 11 Apr 2025 17:04:07 GMT

@LauraleeGann25 Thanks for referencing the Generate Schema Report documentation. Note the following:

This tool can be run on a workspace (file, mobile, and enterprise), feature class, feature dataset, feature layer, and feature service.

Have you tried a FGDB as input dataset and tool failed or errored? If so, post the error. As posted by @Robert_LeClair and myself, we have run the tool on FGDB with a schema report output.

Re: Batch Generate Schema Report

AyanPalit — Tue, 06 May 2025 14:00:01 GMT

@ReeceVydrzal1 Curious if you tried a FGDB as input dataset and tool failed or errored? If so, post the error. If you found a solution, please post for Esri Community users.

Re: Batch Generate Schema Report

JLau — Fri, 13 Jun 2025 15:38:17 GMT

I am facing an error with the Batch Generate Schema Report. The EGDB that I want to run the report for is very large. When I generate a report on the entire database, the output files are over 20 GB (all the output types were large) and are very laggy to work with. When I run the report as a batch on just the key feature datasets, the tool errors out after outputting the first feature dataset. It does actually generate an output, the report opens fine and just the first dataset listed.

Re: Batch Generate Schema Report

AyanPalit — Fri, 13 Jun 2025 16:05:08 GMT

@JLau I use Generate Schema Report on a regular basis on large models. I have observed the HTML report format generates quickest and has the smallest file size.

There could be various environment factors including access/network connectivity, since you mention performance lag. Some users also face issues due to anti-virus scans running against DB queries from apps like ArcGIS Pro.

Are you able to generate a XML schema? A workaround could be to create a fGDB from the XML and generate schema report against the fGDB. That way, you cut out the network latency, environment factors.

Feel free to open a tech support case, if you are willing to share with them a DB backup.

Re: Batch Generate Schema Report

JLau — Fri, 13 Jun 2025 16:08:04 GMT

Thank you so much, that is a great tip to try it on an XML schema. I will give it a shot.