In this blog post, let’s learn about the error message “4320 Stream access not allowed on multi-partitioned table, when flag ATTEMPT_ASYNCHRONOUS_ACCESS is set to OFF. Table in scope: table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4320 Stream access not allowed on multi-partitioned table, when flag ATTEMPT_ASYNCHRONOUS_ACCESS is set to OFF. Table in scope: table-name.
Reason for the Error
You attempted a stream access on a multi-partitioned table when the flag ATTEMPT_ASYNCHRONOUS_ACCESS was set to OFF.
Solution
Set the ATTEMPT_ASYNCHRONOUS_ACCESS flag to ON and resubmit
