RE: Error 24988 - sql error [util_connect ...]; 1,task limit - an other session already connected in UTL mode.

Hello Declan,
 
please open an OSS message. The bug you encountered is already fixed, but no 
version containing the fix is available yet.
 
Best Regards,
Tilo Heinrich
SAP Labs Berlin
 
 
-----Original Message-----
From: McArdle, Declan [mailto:Declan.McArdle@xxxxxxxxxxxxxx]
Sent: Thursday, September 25, 2003 4:07 PM
To: Heinrich, Tilo
Cc: maxdb@xxxxxxxxxxxxxxx
Subject: RE: Error 24988 - sql error [util_connect ...]; 1,task limit - an 
other session already connected in UTL mode.



7.4.2 

Kernel build 020-123-045-993 
Runtime Environment X64/AIX - same build number. 

Regards, 
Declan. 

-----Original Message----- 
From: Heinrich, Tilo [ mailto:tilo.heinrich@xxxxxxx 
<mailto:tilo.heinrich@xxxxxxx> ] 
Sent: 25 September 2003 16:01 
To: McArdle, Declan 
Cc: maxdb@xxxxxxxxxxxxxxx 
Subject: RE: Error 24988 - sql error [util_connect ...]; 1,task limit - 
an other session already connected in UTL mode. 


Hello Declan, 

what version are you using? 

Best Regards, 
Tilo Heinrich 
SAP Labs Berlin 

-----Original Message----- 
From: McArdle, Declan [ mailto:Declan.McArdle@xxxxxxxxxxxxxx 
<mailto:Declan.McArdle@xxxxxxxxxxxxxx> ] 
Sent: Thursday, September 25, 2003 3:42 PM 
To: Heinrich, Tilo 
Cc: maxdb@xxxxxxxxxxxxxxx 
Subject: RE: Error 24988 - sql error [util_connect ...]; 1,task limit - 
an other session already connected in UTL mode. 


Tilo, 

ID UKT  UNIX  TASK       APPL  Current       Timeout   Region   Wait 
Dispatch 
         tid  type        pid  state        priority  cnt try   time count 
T4   3     12 Utility  754482  AsynOpen       !    0    0   0      0 53(s) 

This looks like it. 

PID 754482 does not exist (any more?). 

It looks like it's stuck waiting for I/O or something? 

Should I be killing 4 or T4, by the way, I've tried cancelling and killing 
both, but it's still there in a 'sh ta'. 

Any other suggestions? 

Thanks, 
Declan McArdle. 

-----Original Message----- 
From: Heinrich, Tilo [ mailto:tilo.heinrich@xxxxxxx 
<mailto:tilo.heinrich@xxxxxxx> ] 
Sent: 25 September 2003 15:16 
To: McArdle, Declan; maxdb@xxxxxxxxxxxxxxx 
Subject: RE: Error 24988 - sql error [util_connect ...]; 1,task limit - 
an othe r session already connected in UTL mode. 


Hello Declan, 

your Utility Task is already in use by a DBM client. "dbmcli -d ... -u 
...,... db_cons sh ta" gives you a list of the database tasks, one is marked 
as Utility. Find out which DBM client is using it and end that client or the 
connection of that client to the database ("dbmcli ... db_cons cancel 
<task_index>"). 

Best Regards, 
Tilo Heinrich 
SAP Labs Berlin