Error in interaction server 7.6.1.xxx

[bounty]

Hello,
Since Migration from interaction server 7.6.0 to 7.6.1 (7.6.101.27), we got the following error in the logs :

I can't find why it's not working anymore. The fonction is used in our business process on workbins views.

Any ideas ?


10:38:28.055 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 7200' at position 0
10:38:28.055 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 259200' at position 0
10:38:28.055 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 259201' at position 0
10:38:28.055 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 300' at position 0
10:38:28.055 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 604800' at position 0
10:38:28.055 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 14400' at position 0
10:38:28.336 Trc 23074 Database type is unknown, can't translate statement '_time_in_queue() > 86400' at position 0

[tester]

we see in this LogMessages,
that the type of database is not known to the application.
For some reason the application had lost or never obtained info from DAP or DBServer what kind of RDBMS it is working with.
So it cannot apply rules to form proper SQL condition clause.

Need more log, preferably from start of InteractionServer.

(commonly it helps and saves time if in initial question there is info about actual environment, SQL-server type in this particular case)

[catanirex]

Hi,

Interaction Server 7.6.1 has a completely different db structure. Please read the chapter Interaction Properties in Multimedia Users Guide.
Read the document for full description, and how to customize it to solve your problem.

[bounty]

7.6.1 does not have a completly different DB structure; We migrate a few months ago from the 7.2 architecture and we had only problems with the new Interaction Server.
First, it was not compatible anymore with our DB Structure : we use SQL Server 2000, and all Genesys databases belong to the sql user "genesys". It was impossible to start  correctly InteractionServer because it was trying to use dbo ! This was a bug that RD has fixed, but now others problems appear !
I have checked everything : the DAP is OK !

Here is the start of the Ixn : (without all objects load)

[code]
Application name: ixnSrv
Application type: InteractionServer (111)
Command line:    interaction_server.exe -service GenesysInteractionServer -app ixnSrv -host INCTIR01 -port 2020 -sstart
Host name:        inactr01
DST:              TZ = 1, timeb = 1
Time zone:        -3600, Romance Standard Time, Romance Daylight Time
UTC time:        2010-06-18T15:10:54.513
Local time:      2010-06-18T17:10:54.513
Start time (UTC): 2010-06-18T15:10:53
Running time:    0:00:00:01
Host info:        Windows 5.2.3790, 2, Service Pack 2, 2.0, 0110, 3
File:            (1) d:\Logs\ixnSrv\ixnSrv.20100618_171054_514.log

17:10:54.513 Trc 04112 The Log Output of type 'd:\Logs\ixnSrv\ixnSrv' has been created and opened
17:10:54.513 Trc 55007 Using primary message server at host INCTIR01, port 4000
17:10:54.513 Trc 55009 No backup message server configured
Open LCALayer on port=4999
LCA Library version 7.5.000.06
17:10:54.966 Trc 55011 Server is starting up...
17:10:54.966 Std 05200 Genesys Interaction Server. Version 7.6.101.27
17:10:54.966 Std 05201 Copyright (c) 2003-2010 Genesys Telecommunications Laboratories, Inc.
17:10:54.966 Trc 30001 Starting in PRIMARY mode, using dbid 140 for database operations
17:10:54.997 Trc 30101 Starting license manager using group id '140'
17:10:55.388 Std 07101 Feature 'ics_multi_media_agent_seat': 50 licenses checked out
17:10:55.607 Std 07101 Feature 'ics_email_webform_channel': 50 licenses checked out
************************************
LCALayer: REventRegistered on LCA...
************************************
17:10:55.607 Trc 06084 Configuration option set: 'settings':'registration-timeout' = '30'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'max-interactions-per-pull' = '100'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'max-interactions-per-snapshot' = '500'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'handling-timeout' = '60'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'routing-timeout' = '720'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'delivering-timeout' = '30'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'statistic-interval' = '5'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'max-number-of-snapshots' = '2000'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'default-max-submitted-per-router' = '1000'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'default-max-submitted-per-strategy' = '200'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'default-max-submission-rate' = '10.00000000 interactions per second'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'hide-attached-data' = 'true'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'third-party-server-timeout' = '30'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'allow-duplicates-in-submit' = 'true'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'allow-duplicates-in-change' = 'true'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'not-ready-on-invitation-timeout' = 'true'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'ignore-read-only-on-submit' = 'true'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'ignore-read-only-on-change' = 'false'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'delay-updates' = 'true'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'third-party-server-window-size' = '10'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'third-party-server-queue-size' = '200'
17:10:55.607 Trc 06085 Configuration option set to default value: 'settings':'reroute-abandoned-interactions' = 'false'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'default-view-freeze-interval' = '300'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'submit-timer-interval' = '2000'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'max-workbin-interactions' = '500'
17:10:55.607 Trc 06085 Configuration option set to default value: 'settings':'max-output-timeout' = '15'
17:10:55.607 Trc 06085 Configuration option set to default value: 'settings':'no-userdata-changed-response-to-urs' = 'false'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'low-pull-threshold' = '50'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'high-pull-threshold' = '200'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'schema-name' = 'genesys'
17:10:55.607 Trc 06085 Configuration option set to default value: 'reporting-extensions':'system' = 'disable'
17:10:55.607 Trc 06084 Configuration option set: 'reporting-extensions':'interactions' = 'enable:all'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'allow-multiple-agent-connections' = 'false'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'honor-segmentation-generations' = 'false'
17:10:55.607 Trc 06084 Configuration option set: 'agent-reservation':'request-collection-time' = '100'
17:10:55.607 Trc 06084 Configuration option set: 'agent-reservation':'reservation-time' = '10000'
17:10:55.607 Trc 06084 Configuration option set: 'settings':'reject-subsequent-request' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'configuration' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'agent-configuration' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'database' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'protocol' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'routing' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'task-processing' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'workflow-configuration' = 'true'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'submitters-operation' = 'false'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'views-operation' = 'false'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'datastream' = 'false'
17:10:55.607 Trc 06084 Configuration option set: 'log-control':'max-protocol-message-size' = '8192'
17:10:55.607 Trc 06084 Configuration option set: 'log-control':'max-protocol-attribute-size' = '1024'
17:10:55.607 Trc 06084 Configuration option set: 'log-control':'max-key-value-list-size' = '16384'
17:10:55.607 Trc 06085 Configuration option set to default value: 'log-control':'mandatory-keys-to-log' = '[predefined set of keys]'
...
17:10:59.576 Std 25000 There are no connections to Database Access Points
17:11:00.592 Trc 25076 Checking configuration for event logger DAP:'DAP_ixn':
17:11:00.592 Trc 06084 Configuration option set: 'logger-settings':'batch-size' = '500'
17:11:00.592 Trc 06084 Configuration option set: 'logger-settings':'max-queue-size' = '20000'
17:11:00.592 Trc 06084 Configuration option set: 'logger-settings':'storing-timeout' = '1000'
17:11:00.592 Trc 06084 Configuration option set: 'logger-settings':'mandatory-logging' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'log-agent-state' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'log-agent-activity' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'log-esp-service' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'log-queue' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'log-strategy' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'log-userdata' = 'true'
17:11:00.592 Trc 06084 Configuration option set: 'event-filtering':'event-filter-by-id' = 'no event filtering by id'
17:11:00.592 Trc 04500 Connecting to primary DBServer 'ixn_dbserver' at host 'INCTIR02', port 6110
17:11:00.623 Trc 04500 Connecting to primary DBServer 'ixn_dbserver' at host 'INCTIR02', port 6110
17:11:00.623 Trc 04500 Connecting to primary DBServer 'ixn_dbserver' at host 'INCTIR02', port 6110
17:11:00.654 Std 04503 Connected to primary DBServer 'ixn_dbserver' at host 'INCTIR02', port 6110
17:11:00.654 Std 04503 Connected to primary DBServer 'ixn_dbserver' at host 'INCTIR02', port 6110
17:11:00.685 Std 04503 Connected to primary DBServer 'ixn_dbserver' at host 'INCTIR02', port 6110
17:11:00.701 Std 25002 Trying to open database:'Genesys_IXN', DBServer:'ixn_dbserver', DAP:'DAP_ixn'
17:11:00.701 Std 25002 Trying to open database:'Genesys_IXN', DBServer:'ixn_dbserver', DAP:'DAP_ixn'
17:11:00.732 Std 25002 Trying to open database:'Genesys_IXN', DBServer:'ixn_dbserver', DAP:'DAP_ixn'
17:11:03.670 Std 25004 Database:'Genesys_IXN', DBServer:'ixn_dbserver', DAP:'DAP_ixn' is opened
17:11:03.670 Std 25009 DAP:'DAP_ixn', DBServer version:'7.6.000.11' ('7.5.000.02' or greater required) [/code]

[cavagnaro]

Well if the main issue was solved by Genesys support team I have no idea what can we do...have you escalated the issue with them?

[Steve]

This could be a good place to start looking.

[code]17:10:59.576 Std 25000 There are no connections to Database Access Points[/code]

[YevgeniyP]

Looks like the only DAP configured is configured as logging DAP, the one that used for logging of reporting events. First of all you need  the primary DAP for operational DB. Probably wrong part of documentation was used.

YP

[bounty]

Thank you Guys !

That was it : the wrong configuration of the DAP.