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 for Me (Login required).

Search for additional results

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