"System.Exception: Security Error 2" when reschedule job for import external data from staging table

Technote (troubleshooting)


Problem(Abstract)

User clicks "Rransfer - External data - Import from staging table". User tries to reschedule a job. User receives an error.
Problems does not affect all users - it only affects users who have limitations on a menu group.

Symptom

Standard Error

Error Detail:
Source: ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Security Error 2 at
Cognos.Controller.Proxy.SoapExtension.ServerExtension.ProcessMessage(SoapMessage message) at ...

Cause

Code production problem (APAR PM76021) in early versions of Controller 10.1.1.

Resolving the problem

Fix:

Upgrade to Controller 10.1.2155 or later.

Workaround:
Use either of the following methods:

  • Method #1 - Remove the restrictions from the Users in Rights.
  • Method #2 - Modify the "WebServiceAccessControlList.acl" file on the Controller application server.

Steps for Method #2
  1. Logon to the Controller application server
  2. Open the "ControllerProxyServer" folder. TIP: By default this is located here: C:\Program Files (x86)\ibm\cognos\c10\ControllerProxyServer
  3. Open the file "WebServiceAccessControlList.acl" inside NOTEPAD.EXE
  4. Locate the following two lines, and modify them (to add the number 60338) so that they now look as follows:

clsBatchT_DeleteBatchJob =60313,60338 ;R
clsBatchT_RescheduleSpecificBatchJob =60313,60338 ;R

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Controller
Controller

Software version:

10.1.1

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1615568

Modified date:

2013-04-26

Translate my page

Machine Translation

Content navigation