Second index on the same same column is not created

[former_member1185084]

Hi,

I'm trying to create additional function based index on few tables:

-CSTICKETS

-MEDIAS

-ORDERS

-USERGROUPS

but indexes are not created. No errors in logs. Is any "optimization" which blocking creation of index with different name on the same column? For example for CSTICKETS I am trying create TICKETIDIDX_LOWER index on P_TICKETID attribute (default index on this attribute is created in ext-commerce/ticketsystem/resources/ticketsystem-items.xml). After system update index is not created and I cannot find any errors or warns in logs. Others indexes are created without any porblems.

I am using hybris 1811.

[janos_mucsi-besze]

Hi Mikolaj,

This 'Oracle Database' Tag is usually takes reference to SAP NW based Oracle issues.

Our position with Function-Based indexes in a SAP NW System is that our customer can use this but no support provided. This is documented in below SAP note:

105047 - Support for Oracle functions in the SAP environment

But, besides this you can maybe try to create the index as 'invisible'.

However, since you are using Hybris, I recommend to use some additional tags like "SAP Commerce Cloud".