Interaction Server could not get datastream from Stat Server

[hieutx]

Hello you guys  ,

Recently, I have installed stat server and interaction server on the same host. When I start application via GA, it seems ok.
However, when I check stat server log and interaction log, I see ixn server could not get datastream from stat server.
More detail logs:
D:\gcti\Stat Server\e_rout_start_srv\java
[ixn log]
2017-06-13T22:42:35.203 Std 04525 Port 4420 opened for listening
2017-06-13T22:42:35.203 Dbg 25020 Queuing dbmanager request: request id: '1', request:[Sql:Select statistic; select queue, tenant_id, media_type, type, count(*) as counter from interactions group by queue, tenant_id, media_type, type], stack:'default:standard', stack size: '1', interaction id:''
2017-06-13T22:42:35.203 Dbg 25021 Getting ready to send dbmanager request: request id: '1', request:[select queue, tenant_id, media_type, type, count(*) as counter from interactions group by queue, tenant_id, media_type, type], stack size: '1', interaction id:''
2017-06-13T22:42:35.203 Dbg 25030 Database request sent: DAP:'e_ixn_dap'(0), request id: '22', dbchannel stack id: '1', interaction id:'', sql statement: [Begin Transaction]
2017-06-13T22:42:35.203 Dbg 25032 Database request executed: DAP:'e_ixn_dap'(0), request id: '21', dbchannel stack id: '0', interaction id:'', sql statement: [commit off]
2017-06-13T22:42:35.203 Dbg 25032 Database request executed: DAP:'e_ixn_dap'(0), request id: '22', dbchannel stack id: '1', interaction id:'', sql statement: [Begin Transaction]
2017-06-13T22:42:35.203 Dbg 25030 Database request sent: DAP:'e_ixn_dap'(0), request id: '23', dbchannel stack id: '2', interaction id:'', sql statement: [select queue, tenant_id, media_type, type, count(*) as counter from interactions group by queue, tenant_id, media_type, type]
2017-06-13T22:42:35.203 Dbg 25032 Database request executed: DAP:'e_ixn_dap'(0), request id: '23', dbchannel stack id: '2', interaction id:'', sql statement: [select queue, tenant_id, media_type, type, count(*) as counter from interactions group by queue, tenant_id, media_type, type]
2017-06-13T22:42:35.203 Dbg 25030 Database request sent: DAP:'e_ixn_dap'(0), request id: '24', dbchannel stack id: '3', interaction id:'', 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]
2017-06-13T22:42:35.203 Dbg 25032 Database request executed: DAP:'e_ixn_dap'(0), request id: '24', dbchannel stack id: '3', interaction id:'', 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]
2017-06-13T22:42:35.203 Dbg 25030 Database request sent: DAP:'e_ixn_dap'(0), request id: '25', dbchannel stack id: '4', interaction id:'', sql statement: [Commit Transaction]
2017-06-13T22:42:35.203 Dbg 25032 Database request executed: DAP:'e_ixn_dap'(0), request id: '25', dbchannel stack id: '4', interaction id:'', sql statement: [Commit Transaction]
2017-06-13T22:42:36.201 Std 04502 Cannot connect to Datastream consumer (Stat Server) 'e_rout_start_srv' at host 'hcmors01', port 7006, reason '[connect failed]'
2017-06-13T22:42:36.217 Std 04502 Cannot connect to Datastream consumer (Stat Server) 'e_rout_start_srv' at host 'hcmors01', port 7006, reason '[connect failed]'
2017-06-13T22:42:46.291 Dbg 30300 DEBUG: Connecting to server with the following parameters:
'name' [str] = "e_rout_start_srv"
'host' [str] = "hcmors01"
'is-server' [str] = "1"
'client-type' [str] = "111"
'server-type' [str] = "2"
'port' [str] = "7006"
'protocol' [str] = "addp"
'addp-timeout' [str] = "0"
'addp-remote-timeout' [str] = "0"
'addp-trace' [str] = "off"
2017-06-13T22:42:46.291 Trc 04500 Connecting to Datastream consumer (Stat Server) 'e_rout_start_srv' at host 'hcmors01', port 7006
addp-trace off
(addp_xconfig) local OFF, remote OFF, trace off
2017-06-13T22:42:46.307 Dbg 30300 DEBUG: Connecting to server with the following parameters:
'name' [str] = "e_rout_start_srv"
'host' [str] = "hcmors01"
'is-server' [str] = "1"
'client-type' [str] = "111"
'server-type' [str] = "2"
'port' [str] = "7006"
'protocol' [str] = "addp"
'addp-timeout' [str] = "0"
'addp-remote-timeout' [str] = "0"
'addp-trace' [str] = "off"
2017-06-13T22:42:46.307 Trc 04500 Connecting to Datastream consumer (Stat Server) 'e_rout_start_srv' at host 'hcmors01', port 7006
addp-trace off
(addp_xconfig) local OFF, remote OFF, trace off
2017-06-13T22:42:46.354 Std 04502 Cannot connect to Datastream consumer (Stat Server) 'e_rout_start_srv' at host 'hcmors01', port 7006, reason '[connect failed]'
2017-06-13T22:42:46.385 Std 04503 Connected to Datastream consumer (Stat Server) 'e_rout_start_srv' at host 'hcmors01', port 7006

[rout_stat_log]
22:45:17.268 Trc 04541 Message OpenDataStream received from 352 ( 'e_ixn')
22:45:17.268> Client: Message from e_ixn(352) received
22:45:17.268> Client: Message 'OpenDataStream'
'REQ_ID' 1
'USER_REQ_ID' 0
'PROTOCOL_NAME' 'Data Stream Wraper protocol'
'PROTOCOL_DATASOURCE_TYPE' 'Interaction Server 7.6'
'PROTOCOL_VERSION_MAJOR' 1
'PROTOCOL_VERSION_MINOR' 0
'DATASTREAM_TYPE' 1
'DATASTREAM_DATASOURCE_NAME' 'e_ixn'
'DATASTREAM_DATACONSUMER_URL' 'eServiceSystemStat.jar'
22:45:17.268> Client: Extension loading on demand is not allowed -- cannot create datastream.
22:45:17.268> Client: Sending message to e_ixn(352)
22:45:17.268> Client: Message 'DataStreamOpeningFailure'
'STRING_VALUE' 'Could not load data consumer'
'LONG_VALUE' 13
'TM_LENGTH' 0
'TM_SERVER' 1497419117
'USER_REQ_ID' 0
'REQ_ID' 1
22:45:17.284> Client: Client 352 Disconnected
22:45:17.284 Trc 04524 Client 'e_ixn' disconnected
22:45:17.284> Client: Removing Client e_ixn


Environment configuration:
+ Java JDK: 1.7
+ Connection protocol between ixn and stat server: addp

Moreover, I have followed suggestion on knowledge center:
https://genesyspartner.force.com/customercare/pkb_Home?id=kA4U00000008bwGKAQ&l=en_US&fs=Search&pn=1

Enable at [stat server], add java-config, java-config-XXX, java-extentions at tab statserver - [option]. But, the problems is still not dealed with. Please give me some advices. Thanks so much! 

[Kubig]

Check whether JVM is loaded properly on statserver level and also check the configuration for java-extension, they must be enabled and of course JAR files added.

[hieutx]

Hi Kubig,

Thanks for suggestion, I have checked you requirements.
Java Directory:
C:\Program Files\Java\jre1.8.0_111
I checked Extentions at D:\gcti\Stat Server\e_rout_start_srv\java\ext also:

eServiceContactStat.jar
eServiceInteractionStat.jar
eServiceSystemStat
OCCStatExtension.jar
ORSStatExtension

At tab [option] of stat server, I add options below:

[java-config]
java-extensions-dir=D:\gcti\Stat Server\e_rout_start_srv\java\ext
java-libraries-dir=D:\gcti\Stat Server\e_rout_start_srv\java\lib
jvm-path=C:\Program Files\Java\jre1.8.0_111\bin\server\jvm.dll
jvm-path-old=C:\Program Files\Java\jdk1.8.0_111\jre\bin\server\jvm.dll

[java-config-XXX]
java-extensions-dir=D:\gcti\Stat Server\e_rout_start_srv\java\ext
java-libraries-dir=D:\gcti\Stat Server\e_rout_start_srv\java\lib
jvm-path=C:\Program Files\Java\jre1.8.0_111\bin\server\jvm.dll

[java-extensions]
eServiceContactStat.jar=true
eServiceInteractionStat.jar=true
eServiceSystemStat=true
OCCStatExtension.jar=true
ORSStatExtension=true
print-level=debug

I don't know exactly problem where however I doub the issue come from java-extention

[Kubig]

And what say logs about the loading of JVM environment on StatServer level?

[hieutx]

I see in stat log JVM is loaded successfully. However Extentions can not be loaded!

Starting Java...

java version "1.8.0_111"
Java HotSpot(TM) 64-Bit Server VM (build 25.111-b14)

00:13:37.591 Std 10008 Loaded Java Virtual Machine from 'C:\Program Files\Java\jre1.8.0_111\bin\server\jvm.dll'
cannot find file 'D:\gcti\Stat Server\e_rout_start_srv\java\ext\eServiceSystemStat'
00:13:37.638> Init: Extension 'eServiceSystemStat' cannot be loaded
cannot find file 'D:\gcti\Stat Server\e_rout_start_srv\java\ext\ORSStatExtension'
00:13:37.638> Init: Extension 'ORSStatExtension' cannot be loaded
00:13:37.638> Init: Opening Interaction Server 'e_ixn'
00:13:37.638> Server: Connecting to Ixn Server [hcmors01:4420:e_ixn]
00:13:37.638 Trc 04500 Connecting to Ixn Server 'e_ixn' at host 'hcmors01', port 4420
00:13:37.638> Init: Creating Management Port '3031'

Initialization Successful

[Kubig]

Incorrect configuration. It must be like following

[java-extensions]
eServiceContactStat.jar=true
eServiceInteractionStat.jar=true
eServiceSystemStat.jar=true
OCCStatExtension.jar=true
ORSStatExtension.jar=true
print-level=debug

[hieutx]

YEAH! It 's dealed with now thank you so so much