Skip to Content
0
Former Member
Aug 21, 2017 at 01:15 PM

Adding index to a column defined at a variant Product level

87 Views

We have a setup of baseProducts, Stylevariants, SizeVariants. StyleVariant has a property(sku) on which i am trying to create index, but getting an error ,

CREATE INDEX idx$sku_1 ON PRODUCTS (P_SKU)]; nested exception is java.sql.BatchUpdateException: unexpected token: IDX$SKU_1] at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeBatch(DefaultDbScriptsExecutor.java:159) ~[ybootstrap.jar:?] at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeDDl(DefaultDbScriptsExecutor.java:70) ~[ybootstrap.jar:?] at de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor.executeDDl(DefaultDbScriptsExecutor.java:56) ~[ybootstrap.jar:?] at de.hybris.bootstrap.ddl.HybrisSchemaGenerator.executeUpdateStatements(HybrisSchemaGenerator.java:249) ~[ybootstrap.jar:?] at de.hybris.bootstrap.ddl.HybrisSchemaGenerator.update(HybrisSchemaGenerator.java:244) ~[ybootstrap.jar:?]

Can i define an index like this at a derived table?

 <index name="idx$sku" creationmode="all" replace="true">
     <key attribute="sku" />
 </index>


Thanks in advance.