Menu

#3 Key Field Limit of 16,777,215

open
None
5
2003-03-17
2003-03-17
Anonymous
No

I am running dbms2sde on a large table of points. Each
point has a unique id number that is the key on the
table. When that value gets above 16,777,215 (which in
binary is 1111 1111 1111 1111 1111 1111), only the
even rows get updated. It seems that I am losing the
last bit when the value goes above this threshold. The
table has 27,000,000 records so it is very important for
me to process values higher than 16.7 million. Any
suggestions for a work around would be greatly
appreciated.

Info-->
Name: Paul Viola
email paul@vra.net
Database: Oracle 9.2.0.3
SDE: 8.2
OS: Red Hat Linux, 7.2, Kernal 2.4.7-10

Example of syntax used to execute:

dbms2sde -o point \ -l incident,shape \ -xname longitude \ -yname latitude \ -key ct_incident_id \ -w "shape is null and latitude is not null" \ -c 1000 \ -u $CTDBID \ -p $CTDBPW

Example of error that I get when running:

Failed query (CT_INCIDENT_ID=16777216 and (shape is
null and latitude is not null))

Discussion

  • Mark Ohrenschall

    • assigned_to: nobody --> markaohrenschal
     
  • Mark Ohrenschall

    Logged In: YES
    user_id=586167

    Could you do a describe table on incident and send me the table definition?

     

Log in to post a comment.