On SQL Server, Post stopped due to error “Poster: [SP-OPX01008] Unsupported ANYDATA data type” (4269785)

Open Post stopped with following error

“Error 2016-1-10 18:00:22.645000 5904 5588 Poster: [SP-OPX01008] Unsupported ANYDATA data type in COL_ANYDATA_CHAR2 table "XXX"."YYY". SharePlex does not support this data type in the ANYDATA type. To skip operations that include ANYDATA with this data type, add the error SP-OPX01008 to the sqlservermsglist file in the data sub-directory of the SharePlex variable data directory. See 'http://advice.shareplex.com/SP-OPX01008' for additional advice and support. (posting from w112a64f, queue qa_anydata_char, to sp_ss) [module opx]”

Skip the operation as below: 

Note: please replace <queue_name> below with problematic post queue name before executing the commands.

1. Sp_ctrl>set param SP_OPX_CONT_ON_ERR queue <queue_name> 1

2. Add SP-OPX01008 to the sqlservermsglist file in $sp_sys_vardir/data directory:

Add SP-OPX01008 to the file. 

3. Start the post queue

     sp_ctrl>start post queue <queue_name>

4. Once the post by passing the operation, you can reset the SP_OPX_CONT_ON_ERR

   

     sp_ctrl>reset param SP_OPX_CONT_ON_ERR queue <queue_name>