Upgrading EmbeddedMIND from 3.5 To 3.6 Does Not Support Lengthy Database Column Names (Doc ID 1636971.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Goal

In EmbeddedMIND 3.5.1, the first column name is shown as "system_systemId" but in the 3.6, the first column name is shown as "VExecEnvId_siteMoid_subSlotMoid_siteMoid_slotMoid_shelfMoid_sys" even though the same mc2 file was used for code generation.

Also, in 3.6 the first column name "VExecEnvId_siteMoid_subSlotMoid_siteMoid_slotMoid_shelfMoid_systemMoid_systemId" is sent to the database for creation, but the database has truncated the column name to "VExecEnvId_siteMoid_subSlotMoid_siteMoid_slotMoid_shelfMoid_sys" as the maximum column name size is 64 bytes in the database.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.