The ArcSDE(64 bit)'s bug: ORA01480 ?

[szcszc]

Oracle: 10.2.0.4, 64 bit
ArcSDE: 9.3.1, 64 bit
OS: Windows Server 2008, 64 bit


When I import vector datas into SDE Geodatabase, and the type of geometry field is ST_Geometry,
then the ORA01480 error appears.

I ask an esri stuff, he says that this is 64bit SDE' bug,  does the ArcGIS 10 have this bug?

[huangJary]

Me too, in this circumstance, the data can't be imported into SDE Database, when the type of shape field is ST_GEOMETY.

When the type of shape field is BLOB or SDO, the data can be imported succesfully.

Do you anybody know the reason?

[VinceAngelo]

A search with "ORA-01480" turned up this bug report.  I avoided Oracle 10.2.0.4
and have moved on to 11g (11.1.0.7), and I haven't seen this problem.

- V

[szcszc]

A search with "ORA-01480" turned up this   bug report. I avoided Oracle 10.2.0.4 
and have moved on to 11g (11.1.0.7), and I haven't seen this problem. 
  
- V

the version of ArcSDE is latest, and the version of oracle is 11.1.0.7.0,
in the third step the ORA-01480 error appear.


Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
ArcSDE Version 9.3.1
ArcSDE Server Build for Oracle11g Build 3055 Mon May 10 10:12:50
2010

C:\Users\Administrator>sdetable -o create -t POI3 -d "OBJECTID integer,GLOBAL_ID
integer(10),MESH_ID string(10),POI_ID integer(10),POI_TYPE string(6),AD_CODE st
ring(6),NAME string(160),ADDRESS string(160),IMPORTANCE smallint(3),PIC_ID strin
g(24),TELEPHONE string(36),FAX string(36),POSTCODE string(6),BIRTHDAY string(15)
,COORD_TYPE string(1),DISPLAY_CLASS string(2)" ------(1)

C:\Users\Administrator>sdetable -o alter_reg -t POI3 -c objectid -C SDE -M 1 -N ------(2)

C:\Users\Administrator>sdelayer -o add -l POI3,shape -e p -k DEFAULTS -t ST_GEOM
ETRY ------(3)

ArcSDE 9.3.1 for Oracle11g Build 3055 Mon May 10 10:12:50 2010
Layer Administration Utility
-----------------------------------------------------
Error: Underlying DBMS error (-51).
Error: Cannot Create Layer.
ORA-01480: trailing null missing from STR bind value

[VinceAngelo]

Is your database 10g or 11g, or did you have this problem with both databases?

I rarely use 'sdelayer' to create geometry columns. I wonder if the problem is
more with 'sdelayer' than the underlying SE_layer_create API call.

I'm also wondering if it has to do with the lack of coordinate reference information
(no "-G" and "-x" [or "-R"]). What happens if you define a proper coordref?

The 'sdelayer' command accepts a flag to register the rowid column during
'-o add' -- what happens if you skip the 'sdetable -o alter_reg' and just add
"-C objectid" to 'sdelayer -o add'?

The objectid column is required to be NOT NULL -- what happens if you
define it that way with 'sdetable -o create'?

- V

[szcszc]

Is your database 10g or 11g, or did you have this problem with both databases?

I rarely use 'sdelayer' to create geometry columns. I wonder if the problem is
more with 'sdelayer' than the underlying SE_layer_create API call.

I'm also wondering if it has to do with the lack of coordinate reference information
(no "-G" and "-x" [or "-R"]). What happens if you define a proper coordref?

The 'sdelayer' command accepts a flag to register the rowid column during
'-o add' -- what happens if you skip the 'sdetable -o alter_reg' and just add
"-C objectid" to 'sdelayer -o add'?

The objectid column is required to be NOT NULL -- what happens if you
define it that way with 'sdetable -o create'?

- V

My Oracle Database is 11g, The proplem appears only if ArcSDE is 64bit

The error appears also when  I using ArcCatalog.

C:\Documents and Settings\hongwei.yu\sdetable -o create -t POI2 -d "OBJECTI
D integer NOT NULL,GLOBAL_ID integer(10),MESH_ID string(10),POI_ID integer(10),POI_TYPE s
tring(6),AD_CODE string(6),NAME string(160),ADDRESS string(160),IMPORTANCE small
int(3),PIC_ID string(24),TELEPHONE string(36),FAX string(36),POSTCODE string(6),
BIRTHDAY string(15),COORD_TYPE string(1),DISPLAY_CLASS string(2)" -i 5153 -s 172
.20.2.9 -u SDE -p ACCPTest

ArcSDE 9.3 for oracle 11g Build 1632 Thu Feb 26 12:05:37 2009
Attribute Administration Utility
------------------------------------------------------------
Successfully created table POI2


C:\Documents and Settings\hongwei.yu\sdelayer -o add -l POI2, shape -e p -k DEFAULTS -C objectid ,sde,1,-t ST_GEOMETRY -R 3 -i 5153 -s 172.20.2.9 -u SDE -p ACCPTest

ArcSDE 9.3 for oracle 11g Build 1632 Thu Feb 26 12:05:37 2009
Attribute Administration Utility
------------------------------------------------------------
Error: Underlying DBMS error <-51>.
Error: Cannot create Layer.
ORA-01480:

[huangJary]

The proplem is the bug of ArcSDE 64bit, it appeared two years ago, but ESRI hasn't modified this bug up to now