My Oracle Support Banner

IBM DB2 IP2016 IRM Error Message (SQL0440N No authorized routine named "SUBSTRING") (Doc ID 2210233.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Siebel CRM - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.9 [23016] version, Upgrade

When running IRM (upgrep) upgrade from 8.1.1.9 to 16.0
the following error occurs.

ERROR
-----------------------
DBCLog DBCLogError 1 00000002582d017c:0 2016-11-17 13:45:57 SQL Warning, SQL State 42884, -440, [IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named "SUBSTRING" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

DBCLog DBCLogError 1 00000002582d017c:0 2016-11-17 13:45:57 [IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named "SUBSTRING" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

UpgradeLog UpgradeError 1 00000002582d017c:0 2016-11-17 13:45:57 [IBM][CLI Driver][DB2/AIX64] SQL0440N No authorized routine named "SUBSTRING" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

UpgradeLog UpgradeError 1 00000002582d017c:0 2016-11-17 13:45:57 Error in function UTLOdbcExecDirect



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a command window (Shell)
2. Stop all Siebel Servers.
3. Stop the Siebel Gateway Name Server.
4. Change directory to $SIEBEL_ROOT
5. Source the environment variables from the siebsrvr root directory: install_location/
siebsrvr:
Korn shell: . siebenv.sh
C shell: source siebenv.csh

6. Start the Database Configuration Wizard:
install_location/config/config -mode dbsrvr
7. Select upgrep

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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