topic Re: Problem with creating InsertCursor in Python Questions

Problem with creating InsertCursor

ChristofLink — Tue, 16 Sep 2014 06:50:43 GMT

Hi,

I want to write a small tool, which insert some data into an MS-Access database (.mdb). But i have a problem to initialize the cursor.

The Code is very simple :

strOutputPath = r"I:\Data\Test.mdb\FS_BASEMAP\FCL_B_COVERSHEET_A"
icur = arcpy.InsertCursor(strOutputPath)

There is some more code but it stoped at this point and I get this error message:

Traceback (most recent call last):
  File "I:\Skript\AddFeatureSkript.py", line 70, in <module>
    icur = arcpy.InsertCursor(strOutputPath)
  File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\__init__.py", line 1214, in InsertCursor
    return gp.insertCursor(dataset, spatial_reference)
  File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\geoprocessing\_base.py", line 369, in insertCursor
    self._gp.InsertCursor(*gp_fixargs(args, True)))
RuntimeError: ERROR 999999: Fehler beim Ausführen der Funktion.
COM-Komponente der Objektklassenerweiterung konnte nicht erstellt werden. [FCL_B_COVERSHEET_A]

The error message is in german so I translate it:

ERROR 999999: Error when executing the function.
COM component object class extension could not be created. [FCL_B_COVERSHEET_A]

I don't know what the problem is, so hopefully some can help me.

Thanks, Regards

Re: Problem with creating InsertCursor

JakeSkinner — Tue, 16 Sep 2014 11:08:47 GMT

Hi Christof,

I believe you are running your script with Python 64-bit, which no longer supports personal geodatabases (.mdb). You will want to run the script with Python 32-bit. Take a look at the section 'Python scripting' in the following link:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: Problem with creating InsertCursor

ChristofLink — Tue, 16 Sep 2014 11:46:44 GMT

Hey Jake,

thanks for your answer, but I have only a 32 bit version of python installed on my computer and even the ArcGIS is 32 bit.

I just looked it up.

Re: Problem with creating InsertCursor

ChristofLink — Mon, 22 Sep 2014 13:13:52 GMT

*push*

Re: Problem with creating InsertCursor

JakeSkinner — Mon, 22 Sep 2014 13:18:32 GMT

As a test, can you copy the data to a File Geodatabase and see if you receive the error?

Re: Problem with creating InsertCursor

JoshuaBixby — Tue, 23 Sep 2014 19:54:56 GMT

What is the error message if you use arcpy.da.InsertCursor instead of arcpy.InsertCursor? Do you have a requirement to use the older InsertCursor? Besides better performance, the data access InsertCursor supports Python's with statement, which I find to be a big plus.

Re: Problem with creating InsertCursor

ChristofLink — Wed, 24 Sep 2014 05:42:28 GMT

If I use arcpy.da.InsertCursor. I get this error message:

Traceback (most recent call last):

File "I:\Skripte\\AddFeatureSkriptv.py", line 70, in <module>

icur = arcpy.da.InsertCursor(strOutputPath, ["SHAPE@"])

RuntimeError: cannot open 'I:\Test.mdb\FDS_BASEMAP\FCL_B_COVERSHEET_A'

Re: Problem with creating InsertCursor

ChristofLink — Wed, 24 Sep 2014 06:14:56 GMT

So I tried it with a .gdb and used arcpy.da.InsertCursor and I works. I get no error message there, but unsing a .gdb isn't an option because the provided data is in the .mdb format.

Re: Problem with creating InsertCursor

JoshuaBixby — Thu, 25 Sep 2014 01:40:46 GMT

A few things come to mind.

I: drive, mapped network drive or local storage? If mapped network drive, have you tried copying the MDB to local storage and testing it.
Can you create a new MDB and copy the data into it? If so, does that give same error messages?
Can you make an OLE DB connection to the MDB in question?

Re: Problem with creating InsertCursor

ChristofLink — Wed, 08 Oct 2014 13:30:09 GMT

Sry I was on vacation the last 2 weeks.

1. The I drive is a network drive but I also tried it with the local drive and I get the same error message.

2. I creaded a new MDB but even this dosen't work.

3. Yes I can make a OLE DB connection to the MDB.

Re: Problem with creating InsertCursor

JoshuaBixby — Wed, 08 Oct 2014 15:40:54 GMT

Do you have another machine to try it on? Does this happen with all machines you are working on or just one?

Re: Problem with creating InsertCursor

ChristofLink — Thu, 09 Oct 2014 05:57:39 GMT

I have two other virtual maschines running on a server. One of them has ArcGIS v.10.2.2 installed, the other ArcGIS v 10.1.1 . I tried it on both maschines but this doesn't work either. The same error message...

Re: Problem with creating InsertCursor

JoshuaBixby — Thu, 09 Oct 2014 13:48:46 GMT

I was really thinking it might be something specific to that machine, but obviously that isn't the case. I would say or suggest opening Support case, but best case scenario would be a bug that will be very low in terms of priority since it involves personal geodatabases. This is where I would just find a workaround and say c'est la vie.

Good luck

Re: Problem with creating InsertCursor

ChristofLink — Thu, 09 Oct 2014 13:55:18 GMT

Ok thank you very much for your help.

I will open a Support case and if I got an solution I will post it here.

Re: Problem with creating InsertCursor

RandyKreuziger — Thu, 11 Dec 2014 19:29:55 GMT

Christof,

Did you open a case and if you did is it a known bug?