Hello, I am using ArcGIS 10.5 Basic. I try to create an Report using Python. I always get an error. So finally I tried the Example 1 from the online-help (ExportReport—Help | ArcGIS Desktop 😞 I created a mxd with the File name C:\Project\Project.mxd, I created a Feature-Layer "Accidents" with some polygons. I created a report using VIEW > REPORTS > CREATE REPORT and saved it as "C:\Project\Project.rlf" Finally I copied the code in a script "C:\Users\or\Documents\ArcGIS\test1.py" and run. This is the message: Traceback (most recent call last): File " ", line 254, in run_nodebug File "C:\Users\or\Documents\ArcGIS\test1.py", line 8, in "SELECTED") File "C:\WinApps\CAD-GIS\GIS\ArcGIS\Desktop10.5\ArcPy\arcpy\utils.py", line 182, in fn_ return fn(*args, **kw) File "C:\WinApps\CAD-GIS\GIS\ArcGIS\Desktop10.5\ArcPy\arcpy\mapping.py", line 532, in ExportReport return report_source._arc_object.ExportReport(*gp_fixargs((report_layout_file, output_file, dataset_option, report_title, starting_page_number, page_range, report_definition_query, extent, field_map), True)) RuntimeError: Error in generating report. Any Idears? Thanks, Oliver

Since enabling/disabling Backgrount geoprocessing in ArcMap (geoprocessing options) made no difference, I now uninstalled "Background Geoprocessing (64-bit)". This made a bit confusion: I could not find IDLE any more and PyScripter didn't start, so I had to reinstall PyScripter and find the IDLE.bat but now it works. And you were perfectly right: my script runs like a charm from PyScripter, from IDLE and from command prompt. Thank you very much.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy.mapping.ExportReport: Error in generating report

OliverRaskop

Hello,

I am using ArcGIS 10.5 Basic.

I try to create an Report using Python. I always get an error. So finally I tried the Example 1 from the online-help (ExportReport—Help | ArcGIS Desktop 😞 I created a mxd with the File name C:\Project\Project.mxd, I created a Feature-Layer "Accidents" with some polygons. I created a report using VIEW > REPORTS > CREATE REPORT and saved it as "C:\Project\Project.rlf"

Finally I copied the code in a script "C:\Users\or\Documents\ArcGIS\test1.py" and run.

This is the message:

Traceback (most recent call last):
File "<string>", line 254, in run_nodebug
File "C:\Users\or\Documents\ArcGIS\test1.py", line 8, in <module>
    "SELECTED")
File "C:\WinApps\CAD-GIS\GIS\ArcGIS\Desktop10.5\ArcPy\arcpy\utils.py", line 182, in fn_
    return fn(*args, **kw)
File "C:\WinApps\CAD-GIS\GIS\ArcGIS\Desktop10.5\ArcPy\arcpy\mapping.py", line 532, in ExportReport
    return report_source._arc_object.ExportReport(*gp_fixargs((report_layout_file, output_file, dataset_option, report_title, starting_page_number, page_range, report_definition_query, extent, field_map), True))
RuntimeError: Error in generating report.

Any Idears?

Thanks,

Oliver

Find more posts tagged with

Accepted answers

All comments

José_LuisCc

I found the same error message. the solution is in the printer configuration.

XanderBakker

Since I can't reproduce it, it would be best to contact support, since this might have something to do with your specific installation.

Do you try with the "Background Geoprocessing (64-bit) switch off?

OliverRaskop

I ran the script from PyScripter, Idle, command prompt: no success

I ran the script with and without background processing switched on: no difference

I ran the script from PyScripter with or without ArcMap running: no difference

I ran the script from the Toolbox and from a python window in ArcMap: successful!

I ran the script from the Toolbox and from a python window in project.mxd or with a new ArcGIS-project open: no difference (in both cases successful).

I ran the script with or without "dataset_option": no difference

I modified the script for for debugging:

import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\Project\Project.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "Transportation")[0]
lyr = arcpy.mapping.ListLayers(mxd, "Accidents", df)[0]
outPDF =r"C:\Project\Output\ProjectReport.pdf"
RLFfile =r"C:\Project\Project.rlf"
try:
   print(lyr)
   print(outPDF)
   print(RLFfile)
   print("start try")
   arcpy.mapping.ExportReport(report_source=lyr,
                                                report_layout_file=RLFfile,
                                                output_file=outPDF)
   print("end try")
finally:
   print("start finally")
   del mxd

The result (PyScripter) is:

Accidents
C:\Project\Output\ProjectReport.pdf
C:\Project\Project.rlf
start try
start finally
Traceback (most recent call last):
File "<string>", line 254, in run_nodebug
File "C:\Project\reportscript.py", line 15, in <module>
output_file = outPDF)
File "C:\WinApps\CAD-GIS\GIS\ArcGIS\Desktop10.6\ArcPy\arcpy\utils.py", line 182, in fn_
return fn(*args, **kw)
File "C:\WinApps\CAD-GIS\GIS\ArcGIS\Desktop10.6\ArcPy\arcpy\mapping.py", line 532, in ExportReport
return report_source._arc_object.ExportReport(*gp_fixargs((report_layout_file, output_file, dataset_option, report_title, starting_page_number, page_range, report_definition_query, extent, field_map), True))
RuntimeError: Error in generating report

The error-message does not give me any hints.

I'm stumped.

XanderBakker

I ran the script as stand alone script using PyScripter and that worked too. You may also want to test with the background processing switched off. It should be possible to run the script from IDLE, or as stand alone script, from the Python window and as a tool.

OliverRaskop

It seems I found the solution:

I always run the script from the IDLE. If I run it by a tool (without parameters) from the toolbox it does not fail.

Thank you for your help. You put me on the right path...

XanderBakker

I just downloaded your ZIP and extracted it to C:\Project and changed the output name of the PDF and it ran without any problems. I'm using 10.6 (advanced license).

See PDF attached.

I do notice from your error message that you didn't install ArcGIS in the default path. Any specific reason to do that? What other things have you changed during installation?

ProjectReport_test_xb.pdf

OliverRaskop

In the "project.zip" you find the mxd, the data (accidents-shape), the report and the script.

As you see I followed your suggestion with the named parameters but without success.

I also tried a point-shapefile instead of a polygon-FC (default.gdb) - same result.

It would be appreciated, if you could have a look into my data.

Thank you.

Oliver

Project.zip

XanderBakker

It seems that you copied the exact same code as used in Example 1 on the help page ExportReport—Help | ArcGIS Desktop . Since the error occurs on line 8 using the "EXTENT" parameter, apparently you have an mxd, a data frame and a layer with the same name as used in the example.

My first suggestion would have been to used named parameters, like this:

<SPAN class="keyword token">import</SPAN> arcpy
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Project\Project.mxd"</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Transportation"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Accidents"</SPAN><SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ExportReport<SPAN class="punctuation token">(</SPAN>report_source<SPAN class="operator token">=</SPAN>lyr<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; report_layout_file<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\Project\Project.rlf"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; output_file<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\Project\Output\ProjectReport.pdf"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataset_option<SPAN class="operator token">=</SPAN><SPAN class="string token">"EXTENT"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; extent<SPAN class="operator token">=</SPAN>df<SPAN class="punctuation token">.</SPAN>extent<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> mxd<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

... but since the help page shows you can do this, it shouldn't be the problem. Could it be data related? Can you share the mxd, report and data to see what the problem is?

OliverRaskop

Thanks for your reply.

I used exactly the example from the online Help which is:

<SPAN class="keyword token">import</SPAN> arcpy
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\Project\Project.mxd"</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Transportation"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Accidents"</SPAN><SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ExportReport<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r<SPAN class="string token">"C:\Project\Project.rlf"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r<SPAN class="string token">"C:\Project\Output\ProjectReport.pdf"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"EXTENT"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; extent<SPAN class="operator token">=</SPAN>df<SPAN class="punctuation token">.</SPAN>extent<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> mxd<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

To do so I created all necessarily Data to match the script:

- Create a path in c:\Project

- create a new Project.mxd

- rename the "Layers"-Dataframe to "Transportation"

- create a FC and Layer "Accidents" (located in the default-fGDB: C:\Users\or\Documents\ArcGIS\Default.gdb) with three polygons.

- create a Project.rlf file from Layer "Accidents" by using VIEWS>REPORTS>CREATE REPORTS (Report Fields: ObjectID, Shape_length, Shape_Area; all other settings: default)

Hope this helps.

Oliver

bixb0012

Although providing the error message, and especially the traceback, is helpful; it isn't always enough to provide meaningful suggestions. What parameters did you pass to ExportReport and how are those defined?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.