Errors in converting column / Oracle type (ArcSDE log)

[DejanGregor]

We are getting following errors in our ArcSDE 9.2 SP6 (sorry, had a typo!) on Oracle 10gR2 DBMS log file, have no idea what they mean:

Any suggestions, ideas for its causes or what to analyze to get more clues what is going on?

db_map_dbms_to_sde_type::Error in converting Oracle type = 188
db_describe_select::Error converting column 8
db_map_dbms_to_sde_type::Error in converting Oracle type = 23
db_describe_select::Error converting column 9
db_map_dbms_to_sde_type::Error in converting Oracle type = 8
db_describe_select::Error converting column 12
db_map_dbms_to_sde_type::Error in converting Oracle type = 8
db_describe_select::Error converting column 3
db_map_dbms_to_sde_type::Error in converting Oracle type = 188
db_describe_select::Error converting column 6
db_map_dbms_to_sde_type::Error in converting Oracle type = 23
db_describe_select::Error converting column 3
db_map_dbms_to_sde_type::Error in converting Oracle type = 187
db_describe_select::Error converting column 4
db_map_dbms_to_sde_type::Error in converting Oracle type = 23
db_describe_select::Error converting column 58
db_map_dbms_to_sde_type::Error in converting Oracle type = 190
db_describe_select::Error converting column 2

[VinceAngelo]

If you can't find an Oracle doc listing the dataypes associated with type codes (and
I couldn't in a cursory search), then you'll need to check the log file after running
'sdetable -o describe' on each table to track down which tables are generating those
messages.  It's likely they're LOB types or unsupported date/time variants.

Which version of Oracle 10g are you using? 10.2.0.1 has enough known issues, that
this could be related to that (10.2.0.1 is unsupported -- 10.2.0.3 is the minimum
supported release, and 10.2.0.4 requires ArcSDE 9.2 SP5 or higher).

9.2 SP2 is over three years old; if you want your ArcSDE to run with the fewest issues,
you should try to apply service packs within six months of their release.  Even SP6 is
now more than a year old, so you really ought to get your 9.2 to SP6 with the post-SP6
patch (performance issue on connect from Desktop) as soon as possible, and start looking
to get 9.3.1sp2 and/or 10.0 installed in the coming months.

- V

[DejanGregor]

Hi Vince,

I will do the testing with the 'sdetable -o describe' command and report back. It is running on Oracle 10.2.0.3 with patch 27 on Unix (sun Solaris). ArcSDE is 9.2 with SP6.

Thanks!
Dejan

[VinceAngelo]

I found the magic search term that led me to the right directory for OCI include files:

 8 = SQLT_LNG             /* long */
23 = SQLT_BIN             /* binary data(DTYBIN) */
187 = SQLT_TIMESTAMP     /* TIMESTAMP */
188 = SQLT_TIMESTAMP_TZ /* TIMESTAMP WITH TIME ZONE */
190 = SQLT_INTERVAL_DS  /* INTERVAL DAY TO SECOND */

So, we've got two generic binary types and three time types with no mapping to the
supported ArcSDE type list.

You may be able to use a customized view to remap those types to something that
ArcSDE will know how to decode.

- V

[DejanGregor]

Hi Vincent,

you are wonderful! Thank you, you pointed me on the right direction.

Cheers,
Dejan