Resolving Reports Failing with "Task error: IBFSException 6000: local error" after WebFOCUS Upgrade

Resolving Reports Failing with "Task error: IBFSException 6000: local error" after WebFOCUS Upgrade

book

Article ID: KB0070125

calendar_today

Updated On:

Products Versions
ibi WebFOCUS WebFOCUS Version 9 and above

Description

During the upgrade process from WebFOCUS old version to new version (for example: 8.2.06 to 9.2.2), users have reported issues where reports, especially those in Excel format, fail to execute successfully. The error message "Task error: IBFSException 6000: local error" is displayed, without providing comprehensive error details. It's important to note that no code changes were implemented from old to new version, and the same files were copied for testing purposes in both Development (Dev) and User Acceptance Testing (UAT) environments.

Issue/Introduction

This article provides steps to resolve issues encountered with reports failing in Excel format with the error message "Task error: IBFSException 6000: local error" following an upgrade from WebFOCUS old to new versions.

Environment

Windows, Linux and Unix

Resolution

To resolve this issue, follow these steps:

  1. Configuration Update:

    • Edit the edasprof.prf file and add the following configuration:
      SET EXCELSERVURL = LOCAL
      This configuration directs the system to use the tscom-based zip process instead of the jscom process, aiming to improve performance and scalability.
  2. Restart Agents:

    • Kill the stuck tscom3 agents to release any in-use resources.
    • Restart the jscom3 agent to ensure a fresh start and free up any locked resources.
  3. Verify and Test:

    • After making these changes, verify that the issue with reports failing due to IBFSException 6000: local error is resolved.
    • Test the affected reports, particularly those in Excel format, to ensure they execute successfully without errors.

By following these steps, users can effectively address the reported errors and ensure smooth functionality of reports in the upgraded WebFOCUS environment.

This approach optimizes the utilization of processing agents and addresses potential bottlenecks that may occur during report execution, enhancing overall performance and reliability.