I have had a Python 2/ArcMap script to compress enterprise geodatabases. The script has worked fine for a while now. I recently converted the script to Python 3/ArcGIS Pro. Now, I keep getting the same error (see below). I've tried referencing the sde connection files using os.path.join and as a single variable (drive/letter/file). I'm looping through a list of geodatabases. Error: Failed to execute. Parameters are not valid. ERROR 000837: The workspace is not the correct workspace type. Failed to execute (Compress). FILE: compress_geodatabases.py, LINE: 41 "arcpy.management.Compress(gdb[0])": Failed to execute. Parameters are not valid. ERROR 000837: The workspace is not the correct workspace type. Failed to execute (Compress). Error compressing CCGIS.sde # compress geodatabases for gdb in geodatabases : try : # start time for compress start_time_compress = time . perf_counter ( ) # compress tool arcpy . management . Compress ( gdb [ 0 ] ) # end time for compress end_time_compress = time . perf_counter ( ) # elapsed time compress elapsed_time_compress = end_time_compress - start_time_compress # round elapsed time elapsed_time_compress_rounded = round ( elapsed_time_compress , 2 ) # add message log_message += '\nCompressed {} in {}-seconds\n' . format ( gdb [ 1 ] , elapsed_time_compress_rounded ) except EnvironmentError as e : log_message += print_errors . print_exception ( e ) log_message += '\nError compressing {}\n' . format ( gdb [ 1 ] ) except Exception as e : log_message += print_errors . print_exception ( e ) log_message += '\nError compressing {}\n' . format ( gdb [ 1 ] ) # end for in

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; } } }

Trouble Running Geodatabase Compress as Python Script

pmckinney

I have had a Python 2/ArcMap script to compress enterprise geodatabases. The script has worked fine for a while now. I recently converted the script to Python 3/ArcGIS Pro. Now, I keep getting the same error (see below). I've tried referencing the sde connection files using os.path.join and as a single variable (drive/letter/file). I'm looping through a list of geodatabases.

Error: Failed to execute. Parameters are not valid.
ERROR 000837: The workspace is not the correct workspace type.
Failed to execute (Compress).

FILE: compress_geodatabases.py, LINE: 41

"arcpy.management.Compress(gdb[0])": Failed to execute. Parameters are not valid.
ERROR 000837: The workspace is not the correct workspace type.
Failed to execute (Compress).

Error compressing CCGIS.sde

<SPAN class="comment token"># compress geodatabases</SPAN>
    <SPAN class="keyword token">for</SPAN> gdb <SPAN class="keyword token">in</SPAN> geodatabases<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="comment token"># start time for compress</SPAN>
            start_time_compress <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>perf_counter<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="comment token"># compress tool</SPAN>
            arcpy<SPAN class="punctuation token">.</SPAN>management<SPAN class="punctuation token">.</SPAN>Compress<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="comment token"># end time for compress</SPAN>
            end_time_compress <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>perf_counter<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="comment token"># elapsed time compress</SPAN>
            elapsed_time_compress <SPAN class="operator token">=</SPAN> end_time_compress <SPAN class="operator token">-</SPAN> start_time_compress
            <SPAN class="comment token"># round elapsed time</SPAN>
            elapsed_time_compress_rounded <SPAN class="operator token">=</SPAN> round<SPAN class="punctuation token">(</SPAN>elapsed_time_compress<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="comment token"># add message</SPAN>
            log_message <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'\nCompressed {} in {}-seconds\n'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> elapsed_time_compress_rounded<SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">except</SPAN> EnvironmentError <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
            log_message <SPAN class="operator token">+=</SPAN> print_errors<SPAN class="punctuation token">.</SPAN>print_exception<SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">)</SPAN>
            log_message <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'\nError compressing {}\n'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> e<SPAN class="punctuation token">:</SPAN>
            log_message <SPAN class="operator token">+=</SPAN> print_errors<SPAN class="punctuation token">.</SPAN>print_exception<SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">)</SPAN>
            log_message <SPAN class="operator token">+=</SPAN> <SPAN class="string token">'\nError compressing {}\n'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>gdb<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="comment token"># end for in</SPAN><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

Kara_Shindle

I am currently running into this. I ran into it after converting to Python 3 on my old server. Just moved to an entirely new set of servers, and I'm having issues getting my admin script to run on the new server. Was working Friday, walked in this morning to see that workspace error - grrr!

JoeBorgione

Love those simple solutions!

pmckinney

It turns out I needed a newer Microsoft SQL server driver installed on the server running the script. gdb[0] was a sde connection file. gdb[1] was a common name for the database.

RandyBurton

Assuming that the error on line 41 referrers to line 7 in your snippet, you might use a print statement to see what the variable gdb[0] is referencing. I also notice that later you are referencing gdb[1] for messaging which is also puzzling. Since gdb appears to be a tuple/list, you might try a print statement just to verify that it is what is expected.

JoeBorgione

The script shown only goes to line 22; which one refers to line 41?

I used the ESRI example to to that maintenance routine, and as I recall, there was something iffy about it either with the 64 bit python and/or python 3.x. I'll ping my former co-workers and ask them about it...

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.