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.

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.