We have discovered that some of our fields in content types in Rhythmyx 6.5.2 have gotten out-of-sync with the backend database somehow. For example, a sys_EditLive control that Rhythmyx thinks has a storage size of ‘max’ is mapped to a column in a database table with a data type, in Oracle, which is a 100 byte varchar. Creating items of this type passes the Rhythmyx validation, but then fails and dumbs SQL on to user’s screens, when it sends Oracle an INSERT statement that cannot be executed.
I was wondering if anyone has, or knows of, a tool that can check Rhythmyx field settings against database column data types automatically. Otherwise it is going to take us ages to check manually.