IQ connection remains in a DOWN state upon creation

Symptom

RepServer log reports the following errors:

T. 2006/09/18 16:36:37. (36): 'execute
rs_update_lastcommit @origin = 0, @origin_qid =

0x000000000000000000000000000000000000000000000000000000000000000000000000,
@secondary_qid =

0x000000000000000000000000000000000000000000000000000000000000000000000000,
@origin_time = '19000101

00:00:00:000''

E. 2006/09/18 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. 2006/09/18 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. 2006/09/18 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

Alternatively, the IQ administrator can use Sybase Central Java Edition of IQ to add the rsuser to the rs_systabgroup group. Highlight the maintenance user (rsuser) and select File | New | Memberships from the menu, then select the rs_systabgroup group for the rsuser to join.