IBM Support

After completing the initial installation of Case Foundation Case Analyzer, I see the following error when starting Case Analyzer:
You do not have permission to use the bulk load statement.

Troubleshooting


Problem

After completing the initial installation of Case Foundation Case Analyzer, the following error is displayed in a window when starting Case Analyzer: You do not have permission to use the bulk load statement.

Symptom

When you click the "Detail" button in the error window, the following stack trace is displayed.

Database error: com.microsoft.sqlserver.jdbc.SQLServerException: You do not have permission to use the bulk load statement.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
at filenet.pa.publisher.fact.FactDataEnvironment.bulkInsert(Unknown
at filenet.pa.publisher.fact.BulkFactTable.update(Unknown Source)
at filenet.pa.publisher.fact.FactManager.performBulkUpdate(Unknown Source)
at filenet.pa.publisher.Publisher.performBulkUpdate(Unknown Source)
at filenet.pa.publisher.Publisher.run(Unknown Source)


This error is caused because the database user does not have the proper
permissions to the temp directory where the Case Analyzer stores temporary files.

[{"Product":{"code":"SSTHRT","label":"IBM Case Foundation"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Case Analyzer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.0;5.1.0","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.

Document Information

Modified date:
17 June 2018

UID

swg21696382

Page Feedback