[PierreParticipant November 3, 2015 at 6:55 am Post count: 1]

#6462 |

Hello everyone,

I currently have a problem with Integration Server when I use this with queues.

When I call an extension (950 in my case) which contact the Database with Integration Server, it works and then I am led to a queue with a low weight because I have called with an non-VIP extension according to the Database.

But when I call the same extension with an other phone, this time registered as VIP on the Database and yet I am led to the same low weight queue instaed of an other queue with higher weight.

I think, during the first call, we can contact but not on the second time unfortunately and I want to know why?

Here is the is.log:

The first call:

2015-11-03 14:22:05,154 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Processing Database Query script...
2015-11-03 14:22:05,154 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Argument asteriskServer is: 10.171.54.149
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Argument db is: Oracle database
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Argument query is: VIP
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Argument callback is: null
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Argument varNames is: name;first name;Statut
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Argument callbackApp is: null
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A.D - Get query for server: 10.171.54.149, DB: Oracle database and query: VIP
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A.D - Query ID is: Oracle database:VIP
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A.D - Returning query: com.apstel.is.B.B.A.A@41750ae1
2015-11-03 14:22:05,155 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Query object is: com.apstel.is.B.B.A.A@41750ae1
2015-11-03 14:22:05,156 [Asterisk-Java DaemonPool-1-thread-10] DEBUG apstel.is.com.apstel.is.B.B.A - [uniqueId: 1446556914.3887channelId: SIP/531007-00000259] Preparing SQL query: select CONTACT.STRATTRIBUTE1 as NOM, CONTACT.STRATTRIBUTE2 as PRENOM, sub_table.STRVALUE as VIP from CONTACT, CONTACTATTRIBUTE, ( select CONTACTID, ATTRIBUTENAME, STRVALUE from CONTACTATTRIBUTE) sub_table where CONTACT.ID=CONTACTATTRIBUTE.CONTACTID and sub_table.CONTACTID=CONTACT.ID and sub_table.ATTRIBUTENAME='Title' and CONTACTATTRIBUTE.ATTRIBUTENAME='PhoneNumber' and CONTACTATTRIBUTE.STRVALUE = '${PhoneNumber}'

The second call:

2015-11-03 14:24:03,147 [Asterisk-Java DaemonPool-1-thread-10] INFO apstel.is. - No available licenses for module: db

Thank you very much!

• This topic was modified 9 years, 7 months ago by  Pierre.

[adminKeymaster November 9, 2015 at 2:17 pm Post count: 7]

#6466 |

Hello,

Please note that IS comes with 1 free DB module license.
For the second call (second simultaneous call) DB module will run out of licenses.
> 2015-11-03 14:24:03,147 [Asterisk-Java DaemonPool-1-thread-10] INFO apstel.is. – No available licenses for module: db

Regards,
Daniel