-
Title
When discarding messages through qview, it errors out with "Cannot set message, user is not the w -
Description
When running qview to discard a message, you come across the following type of errors:
arbhvp02 /u21/splex/var/arrm1o/log [arrm1o] > prod
arbhvp02 /apps/opt/Shareplex/prod/bin [arrm1o] > ./qview -i
qview> qsetup 2100
qview> open p r
Queue CCEncrypt+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue Mdr+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue CMF_BAL_DET+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue ArborAll+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue ArborImage+P+o.arpm1o-o.arrm1o (y/n) <n>? y
Current queue ArborImage+P+o.arpm1o-o.arrm1o user +PP+ArborImage+sp_opst+o.arpm1o-o.arrm1o
qview> discard 21 13961709042
Cannot set message, user is not the writer
writecommit failed: que_NOPRIV: User is wrong type
qview> -
Cause
Queue has been opened in the wrong mode.
-
Resolution
The error was due to the opening of qview in read mode as follows:
qview>open p r
When discarding a message from the queue, one needs to open it in write mode as follows:
qview>open p w
So to get past the error, one can get into qview by opening it in the write mode and the message will be discarded as the following session shows:
arbhvp02 /apps/opt/Shareplex/prod/bin [arrm1o] > ./qview -i
qview> qsetup 2100
qview> open p w
Queue CCEncrypt+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue Mdr+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue CMF_BAL_DET+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue ArborAll+P+o.arpm1o-o.arrm1o (y/n) <n>?
Queue ArborImage+P+o.arpm1o-o.arrm1o (y/n) <n>? y
Current queue ArborImage+P+o.arpm1o-o.arrm1o user +PP+ArborImage+sp_opst+o.arpm1o-o.arrm1o
qview> discard 21 13961709042
qview>message now set for discard