SUM - Error in Phase MAIN_NEWBAS/PARCONV_UPG were negative

[Former Member]

Hi Experts,

Could you please assist,

Error in phase MAIN_NEWBAS/PARCONV_UPG were negative!   

Last error code set: Conversion entries have been found in '/usr/sap/SUM/SUM/abap/log/TBATGCHK.LOG', see phase log for more details

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

ERROR:

-------------
Detected the following errors:

# /usr/sap/SUM/SUM/abap/log/NCONV00.CEI:
4 EGT231 "FUZZY SEARCH INDEX ON"
4 EGT231 "PHRASE INDEX RATIO 0.20"
4 EGT231 "TOKEN SEPARATORS ' \;,.:-_()[]<>!?*@+{}='&)/'"
2 ED0314 invalid index name: column already indexed
4 EDA093 "DDL Time(___1):" ".........2" milliseconds
2EEGT236 The SQL statement was not executed
2EEDI006 Index " " could not be created completely in the database
2EEGT082 "Index" "RSLTIPT-010" could not be created
2 EGT067 Request for "RSLTIPT" could not be executed
1 ED0302X=========================================================================
1 ED0314 DD: Execution of Database Operations
1 ED0302 =========================================================================
1 ED0327 Process..................: "********-SID_12_30474"
1EED0319 Return code..............: "8"

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

System Info:

------------

NW - 7.4

DB - HANA - 1.00.094.00.1427101515

Regards,

MPeter

[mukesh_mahadik]

Hi,

Error was resolved by executing below sql statement in HANA studio:

DROP FULLTEXT INDEX "<SCHEMA ID>"."RSOS_RSLTIPT_DESCRIPTION"

[floK]

Hello

Had exactly same problem. Tryed manual recreation, delete from HDB, nothing worked :-).

Found solution for this :-), just delete the entry from TBATG and recreate the index after the upgrade:

delete from TBATG where TABNAME = 'RSLTIPT';

Alternatively you can open an OSS message and pray....

[kishore_soma]

Hi Peter,

Try renaming the index and the continue from point of failure, it should run. We had same issue with other tables while upgrading from EHP5 to EHp7.

Regards,

Kishore Soma

[hemanth2]

Dear Peter,

Hope you are doing good.

This is a very common issue. Please check note 885441 and all the migration issues mentioned in teh note.

Hope this helps.

_ _ _ _ _ _ _ _ _

Kind Regards,

Hemanth SAP Active Global Support

_ _ _ _ _ _ _ _ _

[former_member5192]

I have the same issue under HANA 97.2 doing some SPs for a Simple Finance 1503 / IBPF system and just logged a call.

Note 885441 is from 2006, I doubt it helps much much fixing an error with a HANA index column in a full text index for Enterprise Search, although testing the very latest R3trans/R3load can be a solution.

SAP note 2221783 seems to describe the issue accurately but does only contain correction instructions for 7.5 and not yet for 7.4 although future SAPKB74014 is mentioned.

But by default notes cant be applied during upgrades/SP implementation anyway.

This is our failing statement, can someone advise on the correct HANA SQL syntax,
might help to create the index by hand:

2XRequest: Create "Index RSLTIPT-010 (DDIC/24.10.15/07:53)"

4 EGT281 sql:

4 EGT231      "CREATE FULLTEXT"

4 EGT231      "INDEX 'RSLTIPT~010' ON 'RSLTIPT'"

4 EGT231      "('DESCRIPTION')"

4 EGT231      "FAST PREPROCESS ON"

4 EGT231      "SYNC"

4 EGT231      "SEARCH ONLY ON"

4 EGT231      "FUZZY SEARCH INDEX ON"

4 EGT231      "PHRASE INDEX RATIO 0.20"

4 EGT231      "TOKEN SEPARATORS ' \;,.:-_()[]<>!?*@+{}='&)/'"

2 ED0314 invalid index name: column already indexed

4 EDA093 "DDL Time(___1):" ".........2" milliseconds

2EEGT236 The SQL statement was not executed

2EEDI006 Index " " could not be created completely in the database

2EEGT082 "Index" "RSLTIPT-010" could not be created

[former_member5192]

Running the SQL statement by hand did not help, still error:

SAP DBTech JDBC: [261]: invalid index name: column already indexed.

Found one comment saying HANA automatically creates indexes for text fields,

might be the case here or not. 

[Former Member]

Hi Norbet,

It's good you've opened a message.

I just cross checked in my system and RSLTIPT.DESCRIPTION is defined as a LOB.

Anyway, as you've already seen the error states that another index already contains the indexed field.

Please run the following statement which should show you all indexes on RSLTIPT with the index fields. At least that way you'll know which existing index is causing you the problem.

select index_name, column_name,position from sys.index_columns where table_name = 'RSLTIPT' order by index_name, position

Kindest Regards,

Amerjit

[former_member5192]

Hi Amerjit,

SE11 said STRING but if I look at the HANA definition the field DESCRIPTION is a LOB in our system as well.

Our FI consultants will want to continue developing on Monday morning but it could take a long time before I get any helpful reply from SAP.

Depending on how this SUM phase works, would it make sense to
- unlock the system
- remove the definition of the index from SE11

- lock the system and continue ?

Would that work ? An index can always be added again later.

Kind Regards, Norbert

[former_member5192]

Hmm, I checked the other index:

SE11 says
- Index 01 OBJNM
- Index 10 DESCRIPTION (this one fails)

HANA says:
- Index 1 DESCRIPTION

I could try try removing this index 1 in HANA but better if SAP could tell us how the indexes should be named. And who knows after this one the same issue could come up for another group of tables and indexes.

[former_member5192]

I've dropped the HANA index called RSOS_RSLTIPT_DESCRIPTION and continued with SUM.

It was recreated automatically as RSLTIPT~010 with a phrase index ration of 0.2 (was 0.0).

So far so good.

[Former Member]

Hi Norbert,

I have same issue and got one sql command to drop index but getting error invalid index name

DROP FULLTEXT INDEX "SAPD3D"."RSOS_RSLTIPT_DESCRIPTION"

Please tell me sql command which you use to drop index.

Regards,

Santosh

[former_member5192]

Hi Santosh,

I did it form HANA Studio: Catalog - Find Table - Indexes - Delete Index. Somewhere in between you have to change to "Edit Mode".

Kind Regards, Norbert