IQ connection remains in a DOWN state upon creation.

Symptom

RepServer log reports the following errors:

T. 2004/11/05 16:36:37. (36): 'execute rs_update_lastcommit @origin = 0, @origin_qid = 

0x000000000000000000000000000000000000000000000000000000000000000000000000, @secondary_qid = 

0x000000000000000000000000000000000000000000000000000000000000000000000000, @origin_time = '19000101 

00:00:00:000''

E. 2004/11/05 16:36:37. ERROR #1028 DSI(116 asiqdemo.asiqdemo) - \dsioqid.c(2028)

	Message from server: Message: 201, State 0, Severity 16 -- 'ASA Error -615: Parameter '' not found in procedure '???''.

E. 2004/11/05 16:36:37. ERROR #5046 DSI(116 asiqdemo.asiqdemo) - \dsioqid.c(2042)

	When executing the rs_get_lastcommit function in database 'asiqdemo.asiqdemo', received data server errors. See 

logged data server errors for more information.

I. 2004/11/05 16:36:37. The DSI thread for database 'asiqdemo.asiqdemo' is shutdown. 

Solution

The maintenance user (rsuser) must be a member of the rs_systabgroup group. To accomplish this, the IQ administrator must execute the following from an Interactive SQL or isql session:

grant membership in group rs_systabgroup to rsuser 

Or the IQ administrator may use IQ's Sybase Central Java Edition. Highlight the maintenance user (rsuser) and select File | New | Memberships from the menu. Then select the rs_systabgroup group for the rsuser to join.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF