IBM Support

'You do not have permission to use the bulk load statement' error when running Excel reports

Troubleshooting


Problem

User runs/refreshes an Excel report/spreadsheet (for example by clicking 'F9'). User receives error message.

Symptom

Screen:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: You do not have permission to use the bulk load statement.

Event Log on Application Server:
Event Type: Warning
Event Source: Cognos Controller
Event Category: None
Event ID: 0
Date: 09/11/2007
Time: 09:12:12
User: N/A
Computer: APPSERVER
Description:
Error occured at 11/9/2007 9:12:12 AM in Microsoft Office 2003, Error No=5, Source=FrangoDirect.ExcelLinkD.FetchValuesBulk#ControllerProxyClient, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x80040E14): You do not have permission to use the bulk load statement. Server: SQLSERVER Share: SHARENAME$ User: domain\controlleruser Psw: ***** Transfer: 0 Prefix: C3F3D4B13CD9451F8232730AA1FCD4EE Direct Caller: C3F3D4B13CD9451F8232730AA1FCD4EE
at Cognos.Controller.Proxy.CCRWS.ExcelLinkB_FetchValuesBulk(String sGuid, String sKeys, String sMcurr, Boolean bLocLang, String sUser, String sRep, Boolean bIsLnk, String sSortOrd, Int32 lOptBitSet)
--- End of inner exception stack trace ---, 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":"10.3;10.2.1;10.2.0;10.1.1;10.1","Edition":"","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

1037071

Document Information

Modified date:
08 May 2025

UID

swg21347471

Page Feedback