We are upgrading one of our test environments from SM 9..34P2 to Sm 9..41P2. After the Application Upgrade process the exception log has several errors like this:
2016-02-01 15:33:28 No hay soporte del cambio de tipo SQL para incidents en svc.options dbdict de VARCHAR2(4000) a BLOB
2016-02-01 15:33:28 There is no support for the convertion of the SQL type for incidents in svcoptions dbdict from VARCHAR2(4000) to BLOB
So we need to know:
- Is svc.options stored as a BLOB (or CLOB) in SM 9.41? We have an SM that was first deployed with SM 9.20 and subsequently upgraded. Maybe at some point this changed but the upgrade process can't do this.
- If yes we need to know how to convert the field svc.options from VARCHAR2(4000) that we have now to BLOB or CLOB. We have oracle 11.2.0.
SM version information:
Application version: 9..34.0032
RTE Version: 9.34.2003
Compilation Date: 31/08/2012 08:00:00
DB: Oracle 11.2.0