CA Service Management

I have the CA Service Desk 12.6 installed on red hat linux server and the BOXI 12.3.0 installed on windows server. Constantly when we run a report the the ODBC driver died, then we need to restart ODBC to do that run again. The error are showed as followed:

"A error occurred on database. The error message is: [DataDirect]ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]socket() returns error code: -1. Unable to connect: Socket open error on /tmpl/.PDMWEB-unix/pdmweb.exe -0 (575). (WIS 10901)"

Anyone have any idea why this is happening? Thank you for any assistance!

Lucas.

Lucas,

There were some updated ODBC routines that we got from our ODBC vendor that might help in this scenario. Alongside, increasing resources (specifically File Handles) to the user who starts the oaserver/oaagent programs (mostly this is root account) might alleviate this as well. Example: ulimit -n 32768 if this entry exists in the users’ environment before the odbc routines are started, that helps.

The problem might also happen because the webengine crashed or something similar.

So may I recommend opening a CA Support ticket for this ?

Thx
-R



From: CA Service Management Global User CommunityMessage Boards [mailto:CommunityAdmin@communities-mail.ca.com]
Sent: Wednesday, January 08, 2014 11:36 AM
To: mb_message.98912195.107219071@myca-email.ca.com
Subject: [CABI for CA Service Desk] ODBC OpenAccess SDK driver error


I have the CA Service Desk 12.6 installed on red hat linux server and the BOXI 12.3.0 installed on windows server. Constantly when we run a report the the ODBC driver died, then we need to restart ODBC to do that run again. The error are showed as followed:

"A error occurred on database. The error message is: [DataDirect]ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]socket() returns error code: -1. Unable to connect: Socket open error on /tmpl/.PDMWEB-unix/pdmweb.exe -0 (575). (WIS 10901)"

Anyone have any idea why this is happening? Thank you for any assistance!

Lucas.
Posted by:daflon
--
CA Communities Message Boards
107221611
mb_message.98912195.107219071@myca-email.ca.com<mailto:mb_message.98912195.107219071@myca-email.ca.com>
https://communities.ca.com

Hi Raghu,

thanks for the quick answer. Our CA partner suggest us to installed a dedicated server only to ODBC, do you think it could help?

Thanks again.

Lucas.

Lucas,

Not sure if I understand the suggestion fully, but am guessing they’re talking about installing a SDM Secondary server, where in there are no other components but ODBC server on it.

ODBC server still needs a webengine/domsrvr and other components for authentication and data fetching. Maybe they’re referring to having an Offline reporting environment, where in the above components are not depending on the production MDB + SDM, but rather on an offline reporting MDB + small subset of SDM?

-R

From: CA Service Management Global User CommunityMessage Boards [mailto:CommunityAdmin@communities-mail.ca.com]
Sent: Wednesday, January 08, 2014 12:38 PM
To: mb_message.98912195.107222961@myca-email.ca.com
Subject: [CABI for CA Service Desk] RE: [CABI for CA Service Desk] ODBC OpenAccess SDK driver error


Hi Raghu,

thanks for the quick answer. Our CA partner suggest us to installed a dedicated server only to ODBC, do you think it could help?

Thanks again.

Lucas.
Posted by:daflon
--
CA Communities Message Boards
107225501
mb_message.98912195.107222961@myca-email.ca.com<mailto:mb_message.98912195.107222961@myca-email.ca.com>
https://communities.ca.com