Issues with the usage of sqlupper and allowunsupporteddbversion

  • Document ID:KM00783351
  • Creation Date:07-Mar-2014
  • Modified Date:25-Mar-2014
    • Micro Focus Products:
      service manager 9.33

Summary

When trying to setup an SM 9.33 system with the new oracle setting we are running into issues In the sm.ini we have the below settings: sqlupper:1 allowunsupporteddbversion:1 However the logs still show the below messages: RTE E An unsupported version of Oracle cannot be used even when starting Service Manager with the parameter allowunsupporteddbversion:1 in conjunction with sqlupper:1

Error

When trying to setup an SM 9.33 system with the new oracle setting we are running into issues.

In the sm.ini we have the below settings:

sqlupper:1
allowunsupporteddbversion:1

However the logs still show the below messages:

RTE E An unsupported version of Oracle cannot be used even when starting Service Manager with the parameter allowunsupporteddbversion:1 in conjunction with sqlupper:1

Cause

When checking the logs the below was showing:

9524(  9557) 02/28/2014 14:51:29  RTE I Connected to Oracle Version 11.2.0.3.0

9524(  9557) 02/28/2014 14:51:29  RTE I Oracle Client version: 11.2.0.1.0

The oracle client is cause of the message since this oracle client is not allowed anymore from 9.30 P5 onwards because of issues that this client does not read CLOB correctly.


Fix

Upgrade oracle client to the same level as server 11.2.0.3.0 and problem is fixed