SAP Commerce Update System does not create column in Database

[gguidastri]

Hello,

I'm facing an issue related to Hybris Update System. I'm trying to create some new property inside "B2BUnit" type. However, this property is not being created in the "usergroups" table.

When I run the "SQL Scripts" generator on HAC, this property does not appear in any ALTER TABLE. However, if I generate the Initialization script, the column is there.

It's happening to any column type, even if I declare this column as String. Any thoughts about this issue? I'm using SAP Commerce 1905 with MySQL 5.7.

Thanks!

[Former Member]

Hi Guilherme, could you please post the items.xml code fragment, so I can test this issue on my machine? Thanks! Antonio

[gguidastri]

Hi Antonio, thanks for your time!

Sure, this is the attribute that I'm trying to extend into B2BUnit:

<attribute qualifier="blockReason" type="CustomBlockReason">
    <modifiers optional="true" write="true" read="true" unique="false"/>
    <persistence type="property"/>
</attribute>

This is my "CustomBlockReason" model:

 <itemtype code="CustomBlockReason" autocreate="true" generate="true">
    <deployment table="CustomBlockReason" typecode="11167"/>
    <attributes>
        <attribute qualifier="code" type="java.lang.Integer">
            <modifiers optional="false" unique="true"/>
            <persistence type="property"/>
        </attribute>
        <attribute qualifier="description" type="java.lang.String">
            <modifiers/>
            <persistence type="property"/>
        </attribute>
    </attributes>
    <indexes>
        <index name="blockReasonCodeIDX" unique="true">
            <key attribute="code"/>
        </index>
    </indexes>
</itemtype>

[krolzik]

Something new for this issue?
We have the same problem and would be interested in a solution!