hpbrantley

Need help with arcpy with ARCSDE with Oracle

Discussion created by hpbrantley on Dec 22, 2010
Latest reply on Jan 4, 2011 by hpbrantley
I have written a script that imports cad drawings into a geodatabase.  I first was importing into a file gdb and have since modified it to use SDE with Oracle as a db.  Troubleshooting has a been a nightmare.  The overall error is:

ERROR 999999: Error executing function.
Underlying DBMS error [ORA-00911: invalid character
(SDE.VU_0029_04_dwg_Point)] [SDE.VU_0029_04_dwg_Point]
Failed to execute (Merge).

But, after testing the tablename throughly I came to the conclusion the problem lies within the column names. So, I added code to check those and this is the result:

Fieldname EntLinetype changed to EntLinetyp
Fieldname BlkLinetype changed to BlkLinetyp
Fieldname APPLICATION changed to APPLICATIO
Fieldname FILE_VERSION changed to FILE_VERSI
Fieldname INTERNAL_UNITS changed to INTERNAL_U
Fieldname FACILITY_ID changed to FACILITY_I
Fieldname LEGEND_POINT_X changed to LEGEND_POI
Fieldname LEGEND_POINT_Y changed to LEGEND_POI

Now my real question is why is arcpy truncating my column names to 10 characters when my db supports 30 characters?   Is there a way I can get around this?

Outcomes