IBM Support

Error 'Exception has been thrown by the target of an invocation' and 'identifier 'USP_PUSHXKONFIG' must be declared ' when launching Controller after Oracle restore

Troubleshooting


Problem

Oracle schema has been restored as a new 'database connection'. Afterwards, user launches Controller. User receives error message.

Symptom

Screen:
--Exception has been thrown by the target of an invocation.
[OK]

Event Viewer (Application Log):
Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 09/02/2010
Time: 13:10:54
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrMiscST: Thread ID: 4880 ,Logged: Error occured at 09/02/2010 13:10:54 in FrMiscST, Error No=-2147217900, Source=Server Sub:Db_PushStruc(..) , Description=ORA-06550: line 1, column 7:
PLS-00201: identifier 'USP_PUSHXKONFIG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored, HelpFile= HelpContext=0

Cause

Oracle schema sxport (DMP file) did not contain all the required information. Specifically, it did not contain the stored procedures(s) (for example 'USP_PUSHXKONFIG') that are required for Controller to run. Therefore, when it was imported, there was missing required information.

Resolving The Problem

Perform a new Oracle schema export to create a valid DMP file. Afterwards, import this valid DMP file.

Steps:

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21420562

Page Feedback