Why do users encounter the warning message "does not allow partitioned requests" in the TIBCO Data Virtualization logs?
Article ID: KB0070235
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.5.5, 8.6, 8.7 |
Description
Users have noticed that the following warning message occurs frequently in the environment:
WARN [DBChannel] 2023-04-17 00:18:13.376 +0200 QueryEngine - Parallelization for ... failed. Will execute in CIS. Cause: com.compositesw.server.resource.ResourceAllocationFatalException: Data source /shared/PHYSICAL/Metadata/SS does not allow partitioned requests
Environment
Resolution
This warning indicates that a data source doesn't support partitioning of requests. This usually occurs when users have the Massively Parallel Processing (MPP) option enabled but aren't actually utilizing Parallel Processing.
To resolve this, disable MPP by navigating to:
TDV Studio -> Administration -> Configuration -> Server > SQL Engine > Parallel Processing
If "Enabled" is set to True, change it to False.
It's important to note that this warning doesn't impact queries or the overall functionality of the TIBCO Data Virtualization environment. However, it might clutter the log files unnecessarily. Therefore, it is recommended to turn off the MPP option if not actively utilizing parallel processing.
Issue/Introduction
Feedback
