Clients disconnect from CXMD, Cognos Express 10.2.1

[jolteon]

Hi,
We have a problem that randomly clients (while working in Excel 2010) are disconnected from TM1 server with the following error message:
"Error -2 occurred pinging your cognos passport. You will now be disconnected from cxmd"

We have modified the setting for ClientPingCAMPassport in the tm1s.cfg file from 21600 to 3600, restarted the services but this seems to have no effect on the problem.

http://www-01.ibm.com/support/docview.w ... wg21637849

Installed version: Cognos Express 10.2.1

Any help or assistance with the problem will be appreciated.


Regards

[jolteon]

Excuse me, Don't exist any resolution for this Issue??

Regards.

[Edward Stuart]

Do you get the disconnection errors when working directly on the server? How are the clients connecting to the server?

Are there issues with network stability? What security are you using? Do you have a Dev server? Are the same issues occurring on the Dev server?

[jolteon]

Do you get the disconnection errors when working directly on the server? How are the clients connecting to the server?

Are there issues with network stability? What security are you using? Do you have a Dev server? Are the same issues occurring on the Dev server?

Hi Edward

Yes, All the users working directly on the server, the user use Xceletaror and the server randomly disconnect any hour, working or not, I made a testing on the network and have it a little inestability. about the security only have trend micro antivirus. and yes the disconnection errors when working directly on the server.

Regards.

[Edward Stuart]

How much memory do you have on the server and how much is available, ditto for hard disk space?

Do you have any other issues with stability on the server aside from the CAMPassport? Have you tried changing the value to 1800 as per the Support note?

[jolteon]

How much memory do you have on the server and how much is available, ditto for hard disk space?

Do you have any other issues with stability on the server aside from the CAMPassport? Have you tried changing the value to 1800 as per the Support note?

Hi Edward

This is the Server's characteristics :

-Windows Server 2008 R2 Standard SP 1 de 64 bits
-Ram Memory 16 GB
-Hard Disk 99.8 GB Free space 19.1. GB


in the CAMPassaport we have it originally 1800, I found in another forum from IBM change this parameter 300 or 110 but don't work anything.

route: c:/program files/ibm/cognos express/xcelerator/custom/tm1data/cxmd archive tm1s.cfg
-
AllowSeparateNandCRules = T
CAMPortalVariableFile = portal/variables_TM1.xml
ServerCAMURI = http://192.168.6.52:19300/p2pd/servlet/dispatch
Language = ESP
# IntegratedSecurityMode = 1
IntegratedSecurityMode = 5
ClientMessagePortNumber = 19307
DataBaseDirectory = C:/Program Files/IBM/Cognos Express/Xcelerator/Custom/TM1Data/CXMD
UseSSL = T
ClientCAMURI = http://192.168.6.52:19300/p2pd/servlet/dispatch
DistributedPlanningOutputDir = ./tunit
PortNumber = 19306
ClientPingCAMPassport = 1800
IdleConnectionTimeOutSeconds = 3600
LoggingDirectory = C:\Program Files\IBM\Cognos Express\logs\express
ServerName = CXMD
# Lineas incluidas:
#AdminHost=TM1-SERVER


Regards

[lotsaram]

I have found this to occasionally be a problem with Enterprise BI & TM1 where the BI server is elsewhere on the network and/or there is a client version misalignment. With the symptom that the TM1 Perspectives users are disconnected from the server with the cognos passport ping error message. This happens at exactly the interval of whatever the ClientPingCAMPassport setting is timed from the moment the user logged on. I have never seen this though on CX where the install is on the same machine and versions are all aligned.

As a workaround you can just increase the ClientPingCAMPassport value to something very large like 43200 (12 hours) such that this won't happen to a user during a normal working day. (that is do the opposite of what you have done so far and INCREASE the value not decrease it.)

[jolteon]

I have found this to occasionally be a problem with Enterprise BI & TM1 where the BI server is elsewhere on the network and/or there is a client version misalignment. With the symptom that the TM1 Perspectives users are disconnected from the server with the cognos passport ping error message. This happens at exactly the interval of whatever the ClientPingCAMPassport setting is timed from the moment the user logged on. I have never seen this though on CX where the install is on the same machine and versions are all aligned.

As a workaround you can just increase the ClientPingCAMPassport value to something very large like 43200 (12 hours) such that this won't happen to a user during a normal working day. (that is do the opposite of what you have done so far and INCREASE the value not decrease it.)

Hi lotsaram

Thank you, I have a question about the ClientPingCamPassaport number, Is 43200 in minutes?. I can maximize the parameter for 16 hours for example ??

Regards.

[jolteon]

I have found this to occasionally be a problem with Enterprise BI & TM1 where the BI server is elsewhere on the network and/or there is a client version misalignment. With the symptom that the TM1 Perspectives users are disconnected from the server with the cognos passport ping error message. This happens at exactly the interval of whatever the ClientPingCAMPassport setting is timed from the moment the user logged on. I have never seen this though on CX where the install is on the same machine and versions are all aligned.

As a workaround you can just increase the ClientPingCAMPassport value to something very large like 43200 (12 hours) such that this won't happen to a user during a normal working day. (that is do the opposite of what you have done so far and INCREASE the value not decrease it.)

Hi lotsaram

Thank you, i change the number and apears an other error System Server Client not found




I have a question about the ClientPingCamPassaport number, Is 43200 in minutes?. I can maximize the parameter for 16 hours for example ??

Regards.

[qml]

This parameter is in seconds.

Check out this IBM Technote and especially the following bit:

You will need your Cognos BI Administrator to check the Cognos Configuration for this BI server, and verify the ‘Ping timeout in seconds’ and 'Inactivity timeout in seconds' settings - these two should be set about the same (default is 3600).

Back in your tm1s.cfg file, configure the ClientPingCAMPassport to be at least half of what is listed as the Ping timeout in seconds/Inactivity timeout in seconds on your BI Dispatcher, or lower. For example, assuming the dispatcher timeouts are set to 3600, then the tm1s.cfg ClientPingCAMPassport parameter should be set to 1800 or lower (default is 900).