Synchronizing a replica returns the error message "ORA-01555: snapshot too old: rollback segment number 10 with name "$TEMPUNDOSEG" too small" in short transaction scenarios in ArcGIS for Desktop.

参考情報

対処法

Execute the following workflow to use SDE Logfile Permanent tables:

1. Update the server config parameters to remove legacy parameters and allow for permanent SDE Logfile tables:

In SQLPlus as SDE:

-- Ottawa has the following Legacy Parameters set that are no longer used:

-- TCPKEEPALIVE is specific to the historic ArcSDE Services and is no longer used.

-- DISABLEAUTOREG is specific to automatically registering spatial tables and is not used in versions 10.2 and higher.

UPDATE SDE.SERVER_CONFIG SET NUM_PROP_VALUE=0 WHERE PROP_NAME='TCPKEEPALIVE';

DELETE FROM SDE.SERVER_CONFIG WHERE PROP_NAME='DISABLEAUTOREG';

-- Set SDE Logfile parameters to allow permanent tables:

UPDATE SDE.SERVER_CONFIG SET NUM_PROP_VALUE=1 WHERE PROP_NAME='ALLOWSESSIONLOGFILE';

UPDATE SDE.SERVER_CONFIG SET NUM_PROP_VALUE=0 WHERE PROP_NAME='MAXSTANDALONELOGS';

UPDATE SDE.SERVER_CONFIG SET NUM_PROP_VALUE=0 WHERE PROP_NAME='LOGFILEPOOLSIZE';

commit;

2. Drop the current Global Temporary Table SDE_LOGFILE tables owned by SDE and the user executing the Python scripts and the Replica Synchronization to update the attributes.

NOTE: If the attribute update and synchronize is carried out by GISDATA, then carry out steps 2 to 4 as GISDATA in SQLPlus as well.

drop table "SDE"."SDE_LOGFILES" cascade constraints PURGE;

drop table "SDE"."SDE_LOGFILE_DATA" cascade constraints PURGE;

drop SEQUENCE sde.sde_logfile_lid_gen;

3. Recreate them as permanent tables, as seen below.

CREATE TABLE sde.sde_logfiles (

       "LOGFILE_NAME" NVARCHAR2 (256) NOT NULL,

       "LOGFILE_ID" NUMBER,

       "LOGFILE_DATA_ID" NUMBER NOT NULL,

       "REGISTRATION_ID" NUMBER NOT NULL,

       "FLAGS" NUMBER NOT NULL,

       "SESSION_TAG" NUMBER NOT NULL,

       "LOGFILE_DATA_DB" NVARCHAR2 (32),

       "LOGFILE_DATA_OWNER" NVARCHAR2 (32),

       "LOGFILE_DATA_TABLE" NVARCHAR2 (98),

       "COLUMN_NAME" NVARCHAR2 (32),

       CONSTRAINT "SDE_LOGFILES_PK" PRIMARY KEY ("LOGFILE_ID") VALIDATE,

       CONSTRAINT "SDE_LOGFILES_UK" UNIQUE ("LOGFILE_NAME") VALIDATE

)

TABLESPACE "SDE_TBS"

PCTFREE 0

INITRANS 4

MAXTRANS 255

STORAGE (INITIAL 1024 K BUFFER_POOL DEFAULT)

LOGGING;

CREATE TABLE sde.sde_logfile_data (

  "LOGFILE_DATA_ID" NUMBER NOT NULL,

  "SDE_ROW_ID" NUMBER NOT NULL

)

TABLESPACE "SDE_TBS"

PCTFREE 0

INITRANS 4

MAXTRANS 255

STORAGE (INITIAL 1024 K BUFFER_POOL DEFAULT)

NOLOGGING;

CREATE SEQUENCE sde.sde_logfile_lid_gen

  NOCYCLE

  NOORDER

  CACHE 20

  NOMAXVALUE

  MINVALUE 1

  INCREMENT BY 1

  START WITH 1;

CREATE INDEX sde.sde_logfile_data_idx1

  ON sde.sde_logfile_data ("LOGFILE_DATA_ID", "SDE_ROW_ID")

  TABLESPACE "SDE_TBS"

  PCTFREE 0

  INITRANS 4

  MAXTRANS 255

  STORAGE (INITIAL 1024 K BUFFER_POOL DEFAULT)

  NOLOGGING;

CREATE INDEX sde.sde_logfile_data_idx2

  ON sde.sde_logfile_data ("SDE_ROW_ID")

  TABLESPACE "SDE_TBS"

  PCTFREE 0

  INITRANS 4

  MAXTRANS 255

  STORAGE (INITIAL 1024 K BUFFER_POOL DEFAULT)

  NOLOGGING;

4. Grant privileges on the SDE Logfile tables to PUBLIC.

 GRANT DELETE ON "SDE"."SDE_LOGFILE_DATA" TO PUBLIC;

 GRANT INSERT ON "SDE"."SDE_LOGFILE_DATA" TO PUBLIC;

 GRANT SELECT ON "SDE"."SDE_LOGFILE_DATA" TO PUBLIC;

 GRANT UPDATE ON "SDE"."SDE_LOGFILE_DATA" TO PUBLIC;

 GRANT DELETE ON "SDE"."SDE_LOGFILES" TO PUBLIC;

 GRANT INSERT ON "SDE"."SDE_LOGFILES" TO PUBLIC;

 GRANT SELECT ON "SDE"."SDE_LOGFILES" TO PUBLIC;

 GRANT UPDATE ON "SDE"."SDE_LOGFILES" TO PUBLIC;

再現の手順