Return
-
Title
Open post poster fails with SP-OPX01011 error -
Description
Following warning showed up in the event_log when running open target:
"Wanring : [SP-OPX01011] The transaction exceeded the maximum number of active statements. User action is required.< CAUSE> The maximum active statements configured for the Post process is greater than allowed by the database.< ADVICE> Do one of the following:(A) Disable the re-use of active statements by setting SP_OPX_SQL_CACHE_DISABLE to 1 or(B) run the following SharePlex command to reduce the number of active statements: sp_ctrl> target r.{target_DB} [queue {post_queue}] set resources max_active_statements={maximum number of active statements}. See the SharePlex Reference Guide for full syntax details.".
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.