Hello all,
I faced the following error during the deploying interaction server 8.5.1 with ODBC(without db server).
ODBC error: (connection ID: 1, RC:-1, CODE:0, SQLSTATE:'HY104') '[Microsoft][ODBC SQL Server Driver]Invalid precision value'
I will try to explain step by step what I did;
For interaction server application:
I didn't made specific configuration. just default installation.
ODBC Configuration:
The server is 2012R2.
I used default ODBC driver and added 2 DSN:
One for dap_ixn, one for dap_ixn_log
DB Connection test was successfull.
dap for interaction server:
DB Info Connection Type: default
I filled out also DBMS Name, Type, DB Name, user etc.
I added 2 option into the dap_ixn.
settings --> dbprotocol --> odbc(value)
settings --> connection-string --> DSN=dap_ixn(name of dsn for dap_ixn)
dap for interaction log server:
same configuration with dap_interaction server.
I also added 2 option to the this app.
logger-settings --> delivery-protocol --> odbc
logger-settings --> connection-string --> DSN=dap_ixn_log(name of dsn for interaction log server)
At the end of this, the interaction server service is started but I see the following errors in the end of log files:
Thank you all from now,
14:26:14.146 Std 05060 Application started
14:26:14.458 Std 27013 ODBC error: (connection ID: 1, RC:-1, CODE:0, SQLSTATE:'HY104') '[Microsoft][ODBC SQL Server Driver]Invalid precision value'
14:26:14.458 Std 27013 ODBC error: (connection ID: 1, RC:-1, CODE:0, SQLSTATE:'HY104') '[Microsoft][ODBC SQL Server Driver]Invalid precision value'
14:26:14.458 Std 27126 New database connection opened (connection ID: 1)
14:26:14.458 Std 27113 Checking database integrity (connection ID: 1)
14:26:14.458 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '0', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select top 1 * from interactions]
14:26:14.458 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '0', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select top 1 * from interactions]
14:26:14.489 Trc 27116 Database integrity check complete (connection ID: 1, table name: 'interactions')
14:26:14.489 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '0', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select top 1 * from parameters]
14:26:14.489 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '0', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select top 1 * from parameters]
14:26:14.489 Trc 27116 Database integrity check complete (connection ID: 1, table name: 'parameters')
14:26:14.489 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select value from parameters where name='EventSequence']
14:26:14.489 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select value from parameters where name='EventSequence']
14:26:14.489 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [update interactions set server_id=0,is_locked=case when snapshot_place_id is not null and snapshot_place_id<>'' then 0 else is_locked end,state=0,cache=0]
14:26:14.489 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [update interactions set server_id=0,is_locked=case when snapshot_place_id is not null and snapshot_place_id<>'' then 0 else is_locked end,state=0,cache=0]
14:26:14.489 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue,workbin from interactions group by tenant_id,queue,workbin]
14:26:14.505 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue,workbin from interactions group by tenant_id,queue,workbin]
14:26:14.505 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (agent_id is not null) and (agent_id<>'') group by tenant_id,queue]
14:26:14.505 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (agent_id is not null) and (agent_id<>'') group by tenant_id,queue]
14:26:14.505 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (place_id is not null) and (place_id<>'') group by tenant_id,queue]
14:26:14.505 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (place_id is not null) and (place_id<>'') group by tenant_id,queue]
14:26:14.505 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (place_group_id is not null) and (place_group_id<>'') group by tenant_id,queue]
14:26:14.505 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (place_group_id is not null) and (place_group_id<>'') group by tenant_id,queue]
14:26:14.505 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (agent_group_id is not null) and (agent_group_id<>'') group by tenant_id,queue]
14:26:14.521 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select tenant_id,queue from interactions where (workbin is null) and (agent_group_id is not null) and (agent_group_id<>'') group by tenant_id,queue]
14:26:14.521 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select queue,tenant_id,media_type,type,count(*) as counter from interactions group by queue,tenant_id,media_type,type]
14:26:14.521 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select queue,tenant_id,media_type,type,count(*) as counter from interactions group by queue,tenant_id,media_type,type]
14:26:14.521 Dbg 25030 Database request sent: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select queue,tenant_id,media_type,count(*) as counter from interactions where type='Inbound' and delivered_at is null group by queue,tenant_id,media_type]
14:26:14.521 Dbg 25032 Database request executed: DAP:'dap_ixn'(1), request id: '1', dbchannel stack id: '0', interaction id:'(null)', sql statement: [select queue,tenant_id,media_type,count(*) as counter from interactions where type='Inbound' and delivered_at is null group by queue,tenant_id,media_type]
14:26:14.521 Std 27115 Initialization successful (connection ID: 1, request ID: 1)
14:26:14.521 Dbg 30300 DEBUG: Opening port with the following parameters:
'protocol' [str] = "addp"
'addp-timeout' [str] = "0"
'addp-remote-timeout' [str] = "0"
'addp-trace' [str] = "off"
'name' [str] = "ixnserver_p"
'server-type' [str] = "111"
'backlog' [str] = "1000"
'port' [str] = "5000"
WARNING: Unable to bind server to 5000, rebind scheduled in 10 seconds
14:26:14.521 Std 04525 Port 5000 opened for listening
WARNING: Unable to bind server to 5000, rebind scheduled in 10 seconds
Note: I also try to download the latest version of odbc driver and I used that instead of default driver. However, the error was the same.
