2433297 - rs_subcmp with -h Message: 189 Function 'HASHBYTES' requires 2 to 32768 arguments - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2433297 - rs_subcmp with -h Message: 189 Function 'HASHBYTES' requires 2 to 32768 arguments - SRS

Symptom

  • When all columns of a table are included in the unique index (as specified to rs_subcmp with -k), and the "hash" option is used, the following error is raised:
    Command 'select ColA,ColB,hashbytes('md5')from dbo.table1  order by ColB,ColA' sent to data server failed in select_data(). [c/subcmp.c(3080)]
    Message from server: Message: 189, State 13, Severity 15 -- 'Function 'HASHBYTES' requires 2 to 32768 arguments.' [c/subcmp.c(3080)]
  • rs_subcmp command
    rs_subcmp -SPDS -sRDS -dRDB -tdbo.table1 -V -h -p"..." -c"select ColA,ColB from dbo.table1  order by ColB,ColA" -kColA -kColB
  • dbo.table1 contains two columns ColB and ColA

 


Read more...

Environment

SAP Replication Server (SRS) 15.7.1 SP110 or higher

Product

SAP Replication Server 15.7

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.