The information in this article applies to:
Product: Metastorm BPM
Version: 7.5.1.19
Discussion
This is by design. This hot fix is a workaround to an Oracle bug where the histogram considers only the first 32 bytes of a character string when generating statistics. This means the leading zeros in Metastorm's folder IDs are not used by Oracle when generating statistics. To work around this, the last 8 characters of the folder ID are copied to the beginning. This will ensure that these characters are used when statistics are generated. This change has been made to GET\_FOLDERID in eWorkPackage.sql.
A folder ID will now look like 0000001100000000000000000000011 instead of 0000000000000000000000000000011.
