Changing Read-Only Attribute of Warehouse

[joschong]

We currently have 2 warehouses set to default by accident, which is causing some problems in our warehouse selection logic upon placing an order. We're unable to change this attribute except on item creation, but do not want to delete and recreate the problematic warehouse as this would remove all references to the current warehouse and we're not sure where all those references may be used. Is there a way to override the attribute restriction and update the value directly in the database (using HANA database)? Would this cause any issues in Commerce?

Alternatively, is there a way to get all rows in the database where a certain PK is referenced? Thanks in advance.

[christoph_probst · Accepted solution]

You can by pass the attribute restriction by directly writting to database and not using backoffice/impex. To do that either connect to DB with a tool of your choice or go to hac -> Console -> FlexibleSearch -> SQL Query there you can issue an direct SQL query which also supports UPDATE.

Be aware after doing that you need to clear the query cache on each node or restart each node.

[joschong · Accepted solution]

Thanks Christoph, this worked wonderfully.