topic Re: Data Load Issue in Data Management Questions

Data Load Issue

User35489 — Tue, 09 Apr 2013 03:02:36 GMT

Dear Admins,

We installed new server with RHEL 6, Oracle 11.2.0.3.0, ArcSDE 10.1. Our old server is on RHEL 5, Oracle 10.2.0.3, ArcSDE 9.3.
When i tried to import the feature class to new server or copy the feature class from old to new one, migrate storage etc. I faced errors given below. I donot know whether it is because of the change of Geometry type, as in 9.3 we used to have SDEBINARY and in 10.1 we have ST_BINARY.
Please look into this issue.

1. Error 000210: Cannot create output Database Connections\ ...
2. Failed to paste [FeatureClassName]
    Underlying DBMS error [ORA-00604: error occurred at recursive SQL level 1
    ORA- 04063 ...
    ORA- 06508 ...
3. ERROR 000955: Error encountered migrating the database storage ...

Thanks
Abdullah

Re: Data Load Issue

VinceAngelo — Tue, 09 Apr 2013 10:07:51 GMT

You should really include the full error message cascade. Without it, there
isn't much we can do to help you. (Note: the alternative of SDEBINARY is
ST_GEOMETRY, not ST_BINARY).

- V

Re: Data Load Issue

User35489 — Tue, 09 Apr 2013 19:27:58 GMT

Yup, Vince
It was a typo. It is ST_GEOMETRY.
Please find the errors attached.

Thanks
-AS

Re: Data Load Issue

VinceAngelo — Tue, 09 Apr 2013 19:31:31 GMT

I won't open .doc files. ASCII text is best; images are tolerable if they're
in an image format (but I'm less likely to look at them).

- V

Re: Data Load Issue

User35489 — Wed, 10 Apr 2013 04:29:37 GMT

Vince,
FYR,

Error 1:

Paste Failed

Failed to paste NAMEOFLAYER
Underlying DBMS error [ORA-29876: failed in the execution of the
ODCIINDEXDELETE routine
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at "SDE.SPX_UTL", line 1860
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2237
][SDE.GDB_Items][STATE_ID=0]
Underlying DBMS error [ORA-29877: failed in the execution of the
ODCIINDEXUPDATE routine
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SQL", line 1199
ORA-06512: at "SDE.SPX_UTL", line 1860
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2237
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2371
][SDE.GDB_Items]

Another thing i want to make sure about is the size of the tables in SDE user after "Enable Enterprise Geodatabase" is successful. I alloted 1GB for SDE tablespace. It is filled 3.5%. i.e. 35MB only. Is it normal ?

Thanks for you interest
-AS

Re: Data Load Issue

VinceAngelo — Wed, 10 Apr 2013 10:04:19 GMT

You should probably contact Tech Support, since I don't think your install
procedure succeeded. Your alternative is to reinstall from scratch, then
if it fails again, contact Tech Support. DO NOT UNDER ANY CIRCUMSTANCES
DROP THE SDE USER WHILE GIS DATA OWNERS HAVE TABLES WITH
ST_GEOMETRY TYPE COLUMNS -- THIS WILL CORRUPT YOUR ORACLE
INSTANCE.

- V

Re: Data Load Issue

User35489 — Wed, 10 Apr 2013 11:00:18 GMT

You should probably contact Tech Support, since I don't think your install
procedure succeeded. Your alternative is to reinstall from scratch, then
if it fails again, contact Tech Support. DO NOT UNDER ANY CIRCUMSTANCES
DROP THE SDE USER WHILE GIS DATA OWNERS HAVE TABLES WITH
ST_GEOMETRY TYPE COLUMNS -- THIS WILL CORRUPT YOUR ORACLE
INSTANCE.

- V

Even i doubt that the SDE tablespaces are not as less as 35MB. I will cross check the space SDE System tables aquires, if anyone else has the ArcSDE 10.1 installed.
Anyways thank you so much for the guidence. Will share the updates with you.

Thanks
-AS

Re: Data Load Issue

User35489 — Mon, 22 Apr 2013 03:01:25 GMT

Update:

The above error is resolved by fixing the privilege. i.e. granting the privilege execute on DBMS_SQL to the Schema account. But unfortunately, the paste once again failed as it gives out below error,

"Failed to paste "LayerName"
Underlying DBMS error [ORA-04020: deadlock detected while trying to lock object SDE.ST_DOMAIN_METHODS]

Trying to resolve this issue .....

Thanks
-AS

Re: Data Load Issue

EmadAl-Mousa — Mon, 22 Apr 2013 07:07:06 GMT

you need to kill one of the oralce sessions to elminate the "dead lock".

also, the packages are granted seperatly to eache schema user for the geodatabase, or you are granting them to public ? (DBMS_SQL,UTIL,..etc) ?

also, you need to increase the tablespace of your schema not the sde tablespace while migrating to a different storage, if i am mistaken the conversion is done within tablespace, unless you want to create a new fresh schema (duplicate) from the original one with "st_geoemtry" storage then you need to create also another dbtune conifugration keyword.....

please clarify to us your steps to help you.

Regards,

Re: Data Load Issue

User35489 — Sat, 18 May 2013 04:09:36 GMT

Good Day,

Removing SDE Administrator account and recreating it, fixed the problem.

Thanks all for support.
With Best Regards

-Abdullah

Re: Data Load Issue

VinceAngelo — Sat, 18 May 2013 15:15:53 GMT

If the "reinstall from scratch" approach worked, you should probably put the response
that suggested it as the solution. This isn't an issue about points -- the caveat to the
dangers of dropping the SDE user while ST_GEOMETRY layers exist is very important
(doing so will corrupt your Oracle instance irrevocably).

- V