IBM Support

Error 'ORA-01031 : Insufficient privileges' when click 'save' in Controller Configuration

Troubleshooting


Problem

Administrator logs onto the Controller application server, and launches 'Controller Configuration'. Administrator opens section 'Database connections for publish to datamart' and fills in the connection details. Administrator clicks 'save' and then receives error message #1. After acknowledging the error message, user attempts to perform a Data Mart publish (to the target 'Cognos BI'). User receives error message #2

Symptom

Error #1 (screen)

IBM Cognos 8 Controller Configuration
A unknown error has occured: System.Data.OleDb.OleDbException: ORA-01031: insufficient privileges
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBacks, BindingFlags Flags)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Cognos.Controller.Configuration.ControllerConfiguration.toolbar_ButtonClick(Object sender, ToolbarButtonClickEventArgs e)
ORA-01031 : Insufficient privileges
OK

Error #2 (screen)

<template ID> Overflow

Error #2 (Event Log)

Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 9/25/2008
Time: 11:26:49 AM
User: N/A
Computer: SERVERNAME
Description:
Error occured at 9/25/2008 11:26:49 AM in Cognos Controller, Error No=6, Source=DMPublishD.PublishTemplate, Description=Overflow, HelpFile= HelpContext=0

Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 9/25/2008
Time: 11:26:49 AM
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 3920 ,Logged: Error occured at 9/25/2008 11:26:49 AM in FrSrvFunc, Error No=-2147217900, Source=Server Sub:Db_ExecuteSql(..) , Description=ORA-06550: line 1, column 254:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 254:
PL/SQL: SQL Statement ignored, HelpFile= HelpContext=0

Event Type: Warning
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 9/25/2008
Time: 11:26:49 AM
User: N/A
Computer: SERVERNAME
Description:
The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 3920 ,Logged: Error occured at 9/25/2008 11:26:49 AM in FrSrvFunc, Error No=-2147217900, Source=Server function:Dbp_ExecuteImmediate(..) , Description=ORA-06550: line 1, column 254:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 254:
PL/SQL: SQL Statement ignored, HelpFile= HelpContext=0

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5;8.4;8.3","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1041375

Document Information

Modified date:
08 May 2025

UID

swg21367322

Page Feedback