Home Discussions Questions & Answers ECC Data Load Request Ends with CANCELLED Status

ECC Data Load Request Ends with CANCELLED Status

Avatar photoCustomer January 9, 2024 at 9:51 pm

We are attempting to run the ‘Process Manufacturing Command Center Data Load’ concurrent program, but it fails and ends with the status CANCELLED. Data loads for other products (like Payables) completed successfully. What should be the primary focus for troubleshooting this specific failure?

Viewing 6 reply threads
  • Author
    Replies
    • Support January 10, 2024 at 12:15 pm  

      When an ECC Data Load concurrent request ends with a ‘CANCELLED’ status, it suggests an issue that prevents the load from finalizing, often deep within the ECC or database layers . You should refer to Oracle Support Document 2649008.1, which covers similar symptoms . The key action for troubleshooting is checking the database alert log immediately following the failure of the data load request . Errors in the database alert log often provide clues regarding resource contention, connection loss, or specific data handling failures.

    • Avatar photoCustomer January 11, 2024 at 7:29 am  

      If the database alert log provides no immediate clues, what logs on the ECC server itself should I investigate?

    • Support January 13, 2024 at 9:00 am  

      You should check the ECC managed server logs, typically the `ecc.log` file . While the concurrent request shows ‘CANCELLED’ in EBS, the ECC logs may contain detailed stack traces or error messages related to the Solr index update or data processing . If the error points to a ‘Read timed out’ (`java.lang.InterruptedException: Read timed out`), as seen in some logs, it suggests a connectivity or timing issue between ECC components during the heavy collection registration phase .

    • Avatar photoCustomer January 14, 2024 at 8:25 pm  

      If this is the initial load, should I run it in `FULL_LOAD` mode, and is there a log level parameter I should set?

    • Support January 15, 2024 at 7:48 am  

      Yes, for the initial data extraction, you should specify the Load Type as `FULL_LOAD` . While the default log level is typically acceptable, setting the Log Level parameter to ‘Error’ is usually standard for initial runs . Note that the concurrent program short code is `ECCRUNDL` (‘ECC Run Data Load’) .

    • Avatar photoCustomer January 16, 2024 at 10:51 am  

      If I am seeing a generic ‘No Data to display’ error on the dashboard, even after the load completes successfully, what configuration might be missing?

    • Support January 17, 2024 at 2:46 pm  

      The ‘No Data to display’ error can occur if the required security roles have not been properly assigned to the user’s responsibility . Even after a successful data load, users need product-specific roles (e.g., `UMX|FA_M_ECC_ACCESS_ROLE` for Fixed Assets) to access the Command Center functionality and view the data , . You must ensure the necessary UMX assignments were completed using the appropriate role assignment script or method , .

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: