POST
|
I am checking in some data and I get an ORA-14452 error by Oracle. We are using Oracle 11.1.0.6 with ArcSDE 9.3 with Service Pack 1 and the Compress with Concurrent Editors and Memory Allocation patches. The logfile shows: [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] S_delete_shared_logfile_data_table() USER Transaction Logfile Delete - No Commit on Delete [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 955 ORA-00955: name is already used by an existing object [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] S_execute_dmlsql ("CREATE GLOBAL TEMPORARY TABLE sdetemp37392_906396 ON COMMIT PRESERVE ROWS AS SELECT OB JECTID, SDE_STATE_ID, ROWID ORA_ROWID FROM BP.A37392 WHERE 1 = 2") Execute Immediate error (955). Error when removing rows from the adds table [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] DB_registered_table_restore_rows_from_lineage_by_rowid(): Error creating temporary table. [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] S_delete_shared_logfile_data_table() USER Transaction Logfile Delete - No Commit on Delete [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 14452 ORA-14452: attempt to create, alter or drop an index on temporary table already i n use [Tue Aug 3 11:21:36 2010] [906396] [IGSKBTHIWS001] SDE_Oracle Error: 14452 ORA-14452: attempt to create, alter or drop an index on temporary table already i n use [Tue Aug 3 11:21:45 2010] [906396] [IGSKBTHIWS001] Error release logfile pool table 10 (-43). [Tue Aug 3 11:21:45 2010] [906396] [IGSKBTHIWS001] Error release logfile pool table 10 (-43). I see that the global temporary table above has been created and is valid. OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ------------------------- ------------------- ------ TRE_WSUSER SDETEMP37392_906396 TABLE VALID
... View more
08-12-2010
03:03 PM
|
0
|
1
|
474
|
POST
|
We have a developer who is experiencing the following errors. Any assistance would be greatly appreciated. Thanks, Debug file for Job: 23628 Step: CheckIn -------------------------------------------------------------- -------------------------------------------------------------- Message: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) Stack trace: at ESRI.ArcGIS.GeoDatabaseDistributed.CheckInDataSynchronizerClass.Synchronize2(IDataChanges DataChanges, String editVersionName, IWorkspaceName ParentWorkspace, Boolean reconcileCheckout, esriReplicaReconcilePolicyType reconcilePolicy, Boolean columnLevel, Boolean createOIDMappingTable) at USGSJTXCustomSteps.ProcessUpdates.CheckIn(ITable& loadHistoryTable, String checkInGdbFileLocation, IPropertySet sdeConnectionProperties, Int32 jobID, String& editVersionName, Boolean createOidMappingTables) Target site: Boolean Synchronize2(ESRI.ArcGIS.GeoDatabaseDistributed.IDataChanges, System.String, ESRI.ArcGIS.Geodatabase.IWorkspaceName, Boolean, ESRI.ArcGIS.Geodatabase.esriReplicaReconcilePolicyType, Boolean, Boolean) **************************** 7/7/2010 11:06:52 AM.......CheckIn execution started 7/7/2010 11:06:59 AM.......Check-In Disconnected Edit Process for Job: 23628 7/7/2010 12:07:10 PM.......Execution failed: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) ERROR: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
... View more
07-08-2010
09:51 AM
|
0
|
0
|
394
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|