Problems updating to Rev.72 in UIS upgrade

[Former Member]

Hey all,

Wondering if anyone has seen a problem like this before. After upgrading to Revision 72, UI Integration services is broken. When you do:

http://hana:8001/sap/hana/uis/server/rest/rest.xsjs

You should get: Path 'rest.xsjs' not registered with GET

Instead, I get:

Found the following errors:

===========================

Error: import: failed to load the library (line 19 position 0 in /sap/hana/uis/server/rest/rest.xsjs)

As I'm getting deeper into this, it looks like something is badly messed up... I'm getting horrible index server errors like:

INSERT INTO _SYS_REPO.OBJECT_HISTORY (PACKAGE_ID,OBJECT_NAME,OBJECT_SUFFIX,VERSION_ID,ACTIVATED_AT,ACTIVATED_BY,IS_DELETION,CLOB_DIFF_STRATEGY,DIFFERID,DIFFERVERSION,CVERSION,BVERSION,FORMAT_VERSION,DELIVERY_UNIT,DU_VERSION,DU_VENDOR,DU_VERSION_SP,DU_VERSION_PATCH,CHANGE_NUMBER,RELEASED_AT) select o.package_id, o.object_name, o.object_suffix, o.version_id version_id, o.activated_at, o.activated_by, 0 is_deletion, 1 clob_diff_strategy, 1 differId, '1.0' differVersion, o.cdata, o.bdata, o.format_version, o.delivery_unit, o.du_version, o.du_vendor, o.du_version_sp, o.du_version_patch, o.change_number, o.released_at from _SYS_REPO.ACTIVE_OBJECT as o inner join _SYS_REPO.ACTIVATION_HELPER2 as h on o.package_id = h.package_id and o.object_name = h.object_name and o.object_suffix = h.object_suffix where h.has_active_version = 1 and h.version_id > 1'

failed:

unique constraint violated: TrexUpdate failed on table '_SYS_REPO:OBJECT_HISTORY' with error: unique constraint violation on pos=2675 for table _SYS_REPO:OBJECT_HISTORYen, key: $trexexternalkey$=39,sap.hana.uis.widgets.catalog_table.test;24,havanaIncludeFileExample;2,js;1 already exists as udiv=96255, rc=55 at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_update.cc:2225

exception  1: no.71000301  (ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_update.cc:2225)

    TrexUpdate failed on table '_SYS_REPO:OBJECT_HISTORY' with error: unique constraint violation on pos=2675 for table _SYS_REPO:OBJECT_HISTORYen, key: $trexexternalkey$=39,sap.hana.uis.widgets.catalog_table.test;24,havanaIncludeFileExample;2,js;1 already exists as udiv=96255, rc=55

NO exception throw location recorded. Stack generation suppressed

John

20:09:19.485 - ERR :   Cannot import delivery unit /sapmnt/HDB/global/hdb/auto_content/HANA_UI_INTEGRATION_SVC.tgz

20:10:48.005 - INFO:   Messages from trace files

20:10:47.994 - INFO:     statisticsserver_saphana1.30505.000.trc: [24118]{-1}[15/-1] 2014-02-22 20:08:53.988126 e TableReload      TRexApiSystem.cpp(00567) : Got exception: exception  1: no.70028101  (TRexUtils/Streaming/Serializer.cpp:378)

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.071738 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _CV0x7fbf6aba42d0

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.071793 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _EX0x7fbf6aba44a0

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.074584 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _CV0x7fbf6aed02d0

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.074600 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _EX0x7fbf6aed04a0

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.087623 e REPOSITORY       SqlScript.cpp(01331) : invalid table name:  Could not find table/view sap.hana.uis.db::INTENT_ALIAS_MAPPING in schema UIS: line 56 col 27 (at pos 2304)

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.374410 e mdx              deployCalcView.cpp(03516) : Consumption XML: <?xml version="1.0" encoding="UTF-8" standalone="no"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createHanaCube" version="3"><sqlScriptView name="sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA"  schema="_SYS_BIC" sqlScriptFunctionSchema="_SYS_BIC" sqlScriptFunctionName="sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc" registerViewForApsFlag="false" registerViewForSqlApsFlag="false"><dimensionAttributes><dimensionAttribute name="id$attr"><columnMappings><columnMapping column="id" name="id" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="applicationType$attr"><columnMappings><columnMapping column="applicationType" name="applicationType" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="applicationData$attr"><columnMappings><columnMapping column="applicationData" name="applicationData" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="postParameters$attr"><columnMappings><columnMapping column="postParameters" name="postParameters" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="text$attr"><columnMappings><columnMapping column="text" name="text" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="applicationAlias$attr"><columnMappings><columnMapping column="applicationAlias" name="applicationAlias" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="url$attr"><columnMappings><columnMapping column="url" name="url" type="k

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.496721 e mdx              deployCalcView.cpp(03869) : Set Schema DDL statement: set schema "UIS"

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.496730 e mdx              deployCalcView.cpp(03870) : Type DDL: create type "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc/tabletype/VAR_OUT" as table ("id" VARCHAR(256), "applicationType" VARCHAR(50), "applicationData" VARCHAR(100), "postParameters" VARCHAR(2000), "text" VARCHAR(2000), "applicationAlias" VARCHAR(100), "url" VARCHAR(2000))

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.496732 e mdx              deployCalcView.cpp(03871) : Procedure DDL: create procedure "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc" ( IN IN_TAG VARCHAR(256),  OUT var_out "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as 

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.498759 e mdx              handle_mdx.cpp(00082) : deploy_mdx_model for : sap.hana.uis.db/GET_NAVIGATION_TARGET_DATAreturned :Internal Error:Deploy Calculation View: SQL: transaction rolled back by an internal error: invalidated procedure: sap.hana.uis.db/GET_NAVIGATION_URL: line 4 col 15 (at pos 310)

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.498905 e REPOSITORY       biRuntime.cpp(00330) : Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: transaction rolled back by an internal error: invalidated procedure: sap.hana.uis.db/GET_NAVIGATION_URL: line 4 col 15 (at pos 310)

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:13.557601 e REPOSITORY       activator.cpp(00871) : Activator::checkAndHandleRollback, activation ID 7459: Commit or rollback in Runtime::generate detected. TID before generate: 6495922, TID after generate: 6495923, tx state after generate: ACTIVE

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:13.557898 e REPOSITORY       activator.cpp(00813) : activateObjectsInternalFast2: ActivationID 7459, activation phase: Fatal generate error during generate call of runtime sqlproc-runtime.

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:17.249796 e REPOSITORY       ODataRuntime.cpp(00096) : Failed to read object {tenant: , package: sap.hana.uis.odata, name: uis_fioricatalogs, suffix: xsodata} from repository, cannot continue

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:19.080972 e TableImport2Runt RuntimeAlgorithms.cpp(00200) : Activation failed with the following error: 40204: Table import target table cannot be found.Table import target table cannot be found.

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:19.256667 e REPOSITORY       activator.cpp(00842) : Repository: Activation failed for at least one object;At least one runtime reported an error during activation. Please see CheckResults for details

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:19.275001 e REPOSITORY       activator.cpp(00450) : Repository: Activation failed for at least one object;At least one error was encountered during activation. Please see the CheckResult information for  detailed information about the root cause. All objects without errors have been activated.

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23583]{202294}[185/-1] 2014-02-22 20:10:41.997488 e REPOSITORY       sourceCodeMove.cpp(00163) : Most likely another version of the object (healthcare.ui.widgets.LumiraTest, LumiraTest, html)healthcare.ui.widgets.LumiraTest;LumiraTest;html;0;1;1;2;2;1;1 has already been activated by another activation call. The latest version id: 2. Your inactive version id: 2.

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23583]{202294}[185/-1] 2014-02-22 20:10:41.997739 e REPOSITORY       activator.cpp(00935) : Activator::moveSourceCode: Source code move failed for activation 7463.

20:10:47.995 - INFO:     indexserver_alert_saphana1.trc: [23583]{202294}[185/-1] 2014-02-22 20:10:42.000554 e REPOSITORY       repository.cpp(00279) : Fatal activation error: exception  1: no.70040129  (repository/base/activation/sourceCodeMove.cpp:164)

20:10:47.998 - INFO:     xsengine_saphana1.30507.001.trc: [23845]{-1}[-1/-1] 2014-02-22 20:09:03.857073 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00118) : sap.bi.launchpad.logic.lib.ApplicationException: [ServerInternal]

20:10:47.998 - INFO:     xsengine_saphana1.30507.001.trc: [23845]{-1}[-1/-1] 2014-02-22 20:09:37.448234 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00118) : sap.bi.launchpad.logic.lib.ApplicationException: [ServerInternal]

20:10:47.999 - INFO:     statisticsserver_alert_saphana1.trc: [24118]{-1}[15/-1] 2014-02-22 20:08:53.988126 e TableReload      TRexApiSystem.cpp(00567) : Got exception: exception  1: no.70028101  (TRexUtils/Streaming/Serializer.cpp:378)

20:10:48.000 - INFO:     xsengine_alert_saphana1.trc: [23845]{-1}[-1/-1] 2014-02-22 20:09:03.857073 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00118) : sap.bi.launchpad.logic.lib.ApplicationException: [ServerInternal]

20:10:48.000 - INFO:     xsengine_alert_saphana1.trc: [23845]{-1}[-1/-1] 2014-02-22 20:09:37.448234 e xsa:sap.bi.launc sap.bi.launchpad.logic.lib:ResponseHandler.xsjslib(00118) : sap.bi.launchpad.logic.lib.ApplicationException: [ServerInternal]

20:10:48.001 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.071738 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _CV0x7fbf6aba42d0

20:10:48.001 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.071793 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _EX0x7fbf6aba44a0

20:10:48.001 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.074584 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _CV0x7fbf6aed02d0

20:10:48.001 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[181/6495918] 2014-02-22 20:09:08.074600 e SERVER_TRACE     TRexApiSearch.cpp(19483) : invalid attribute requested _SYS_RT:_UIS_APPSITESen _EX0x7fbf6aed04a0

20:10:48.001 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.087623 e REPOSITORY       SqlScript.cpp(01331) : invalid table name:  Could not find table/view sap.hana.uis.db::INTENT_ALIAS_MAPPING in schema UIS: line 56 col 27 (at pos 2304)

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.374410 e mdx              deployCalcView.cpp(03516) : Consumption XML: <?xml version="1.0" encoding="UTF-8" standalone="no"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createHanaCube" version="3"><sqlScriptView name="sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA"  schema="_SYS_BIC" sqlScriptFunctionSchema="_SYS_BIC" sqlScriptFunctionName="sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc" registerViewForApsFlag="false" registerViewForSqlApsFlag="false"><dimensionAttributes><dimensionAttribute name="id$attr"><columnMappings><columnMapping column="id" name="id" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="applicationType$attr"><columnMappings><columnMapping column="applicationType" name="applicationType" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="applicationData$attr"><columnMappings><columnMapping column="applicationData" name="applicationData" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="postParameters$attr"><columnMappings><columnMapping column="postParameters" name="postParameters" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="text$attr"><columnMappings><columnMapping column="text" name="text" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="applicationAlias$attr"><columnMappings><columnMapping column="applicationAlias" name="applicationAlias" type="key"/></columnMappings></dimensionAttribute><dimensionAttribute name="url$attr"><columnMappings><columnMapping column="url" name="url" type="k

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.496721 e mdx              deployCalcView.cpp(03869) : Set Schema DDL statement: set schema "UIS"

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.496730 e mdx              deployCalcView.cpp(03870) : Type DDL: create type "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc/tabletype/VAR_OUT" as table ("id" VARCHAR(256), "applicationType" VARCHAR(50), "applicationData" VARCHAR(100), "postParameters" VARCHAR(2000), "text" VARCHAR(2000), "applicationAlias" VARCHAR(100), "url" VARCHAR(2000))

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.496732 e mdx              deployCalcView.cpp(03871) : Procedure DDL: create procedure "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc" ( IN IN_TAG VARCHAR(256),  OUT var_out "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as 

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.498759 e mdx              handle_mdx.cpp(00082) : deploy_mdx_model for : sap.hana.uis.db/GET_NAVIGATION_TARGET_DATAreturned :Internal Error:Deploy Calculation View: SQL: transaction rolled back by an internal error: invalidated procedure: sap.hana.uis.db/GET_NAVIGATION_URL: line 4 col 15 (at pos 310)

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:12.498905 e REPOSITORY       biRuntime.cpp(00330) : Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: transaction rolled back by an internal error: invalidated procedure: sap.hana.uis.db/GET_NAVIGATION_URL: line 4 col 15 (at pos 310)

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:13.557601 e REPOSITORY       activator.cpp(00871) : Activator::checkAndHandleRollback, activation ID 7459: Commit or rollback in Runtime::generate detected. TID before generate: 6495922, TID after generate: 6495923, tx state after generate: ACTIVE

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:13.557898 e REPOSITORY       activator.cpp(00813) : activateObjectsInternalFast2: ActivationID 7459, activation phase: Fatal generate error during generate call of runtime sqlproc-runtime.

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:17.249796 e REPOSITORY       ODataRuntime.cpp(00096) : Failed to read object {tenant: , package: sap.hana.uis.odata, name: uis_fioricatalogs, suffix: xsodata} from repository, cannot continue

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:19.080972 e TableImport2Runt RuntimeAlgorithms.cpp(00200) : Activation failed with the following error: 40204: Table import target table cannot be found.Table import target table cannot be found.

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:19.256667 e REPOSITORY       activator.cpp(00842) : Repository: Activation failed for at least one object;At least one runtime reported an error during activation. Please see CheckResults for details

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23575]{201045}[179/-1] 2014-02-22 20:09:19.275001 e REPOSITORY       activator.cpp(00450) : Repository: Activation failed for at least one object;At least one error was encountered during activation. Please see the CheckResult information for  detailed information about the root cause. All objects without errors have been activated.

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23583]{202294}[185/-1] 2014-02-22 20:10:41.997739 e REPOSITORY       activator.cpp(00935) : Activator::moveSourceCode: Source code move failed for activation 7463.

20:10:48.002 - INFO:     indexserver_saphana1.30503.000.trc: [23583]{202294}[185/-1] 2014-02-22 20:10:42.000554 e REPOSITORY       repository.cpp(00279) : Fatal activation error: exception  1: no.70040129  (repository/base/activation/sourceCodeMove.cpp:164)

20:10:48.005 - ERR :   Check the log file for SAP HANA Database error messages

[Former Member · Accepted solution]

OK so I fixed this. It turns out that we had a delta corruption on table ACTIVE_OBJECT and the person that rebuilt the table rebuilt it without a primary key. So, we had multiple lines in the ACTIVE_OBJECT table for each item.

So, I rebuilt the table using the following script. It comes with no warranty, but it fixed my problem!

Note that I had to re-import Delivery Unit HANA_UI_INTEGRATION_SVC after this. Then, everything started working.

John

SET SCHEMA _SYS_REPO;

create column table active_object2 as (select * from active_object)

DROP TABLE ACTIVE_OBJECT;

CREATE COLUMN TABLE "_SYS_REPO"."ACTIVE_OBJECT" ("PACKAGE_ID" NVARCHAR(256),

  "OBJECT_NAME" NVARCHAR(256),

  "OBJECT_SUFFIX" NVARCHAR(255),

  "VERSION_ID" INTEGER CS_INT NOT NULL ,

  "ACTIVATED_AT" LONGDATE CS_LONGDATE NOT NULL ,

  "ACTIVATED_BY" NVARCHAR(256) NOT NULL ,

  "EDIT" TINYINT CS_INT DEFAULT 1 NOT NULL ,

  "CDATA" NCLOB ST_MEMORY_LOB,

  "BDATA" BLOB ST_MEMORY_LOB,

  "COMPRESSION_TYPE" INTEGER CS_INT,

  "FORMAT_VERSION" NVARCHAR(16),

  "DELIVERY_UNIT" NVARCHAR(256),

  "DU_VERSION" NVARCHAR(256),

  "DU_VENDOR" NVARCHAR(256) DEFAULT '',

  "DU_VERSION_SP" NVARCHAR(16) DEFAULT '',

  "DU_VERSION_PATCH" NVARCHAR(16) DEFAULT '',

  "OBJECT_STATUS" TINYINT CS_INT DEFAULT 0 NOT NULL ,

  "CHANGE_NUMBER" INTEGER CS_INT DEFAULT 0,

  "RELEASED_AT" LONGDATE CS_LONGDATE,

  PRIMARY KEY ("PACKAGE_ID",

  "OBJECT_NAME",

  "OBJECT_SUFFIX")) UNLOAD PRIORITY 0 AUTO MERGE

;

SELECT A.* FROM ACTIVE_OBJECT2 A

RIGHT OUTER JOIN (SELECT "PACKAGE_ID", "OBJECT_NAME","OBJECT_SUFFIX",

MAX("VERSION_ID") AS VERSION_ID ,MAX("ACTIVATED_AT") AS ACTIVATED_AT

FROM ACTIVE_OBJECT2 A

GROUP BY "PACKAGE_ID", "OBJECT_NAME","OBJECT_SUFFIX") B

ON A.PACKAGE_ID=B.PACKAGE_ID

AND A.OBJECT_NAME=B.OBJECT_NAME

AND A.OBJECT_SUFFIX=B.OBJECT_SUFFIX

AND A.VERSION_ID=B.VERSION_ID

AND A.ACTIVATED_AT=B.ACTIVATED_AT

INTO ACTIVE_OBJECT;

MERGE DELTA OF ACTIVE_OBJECT;

DROP FULLTEXT INDEX "FTI_ACTIVE_OBJECT_CDATA";

CREATE FULLTEXT INDEX "FTI_ACTIVE_OBJECT_CDATA" ON "_SYS_REPO"."ACTIVE_OBJECT" ("CDATA") ASYNC LANGUAGE DETECTION ('EN') PHRASE INDEX RATIO 0.000000 FUZZY SEARCH INDEX ON SEARCH ONLY OFF FAST PREPROCESS OFF TEXT MINING OFF TEXT ANALYSIS OFF TOKEN SEPARATORS '\/;,.:-_()[]<>!?*@+{}="&'

DROP TABLE ACTIVE_OBJECT2;