Unable to Add or Edit MRA's in Event Management When TLS 1.0 is Disabled in MS SQL.

Document ID:  TEC1067656
Last Modified Date:  06/15/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Workload Automation AE

Releases

  • CA Workload Automation AE:Release:11.3.6
  • CA Workload Automation AE:Release:11.3

Components

  • CA Workload Automation AE (AutoSys):ATSYS
Issue:

When TLS 1.0 is disabled in the MS SQL server hosting the Event Management database, EM can no longer connect to the database. This prevents adding or editing Message Record Actions from the EM Console.

The SQL Server client and ODBC driver has been installed at the level that supports TLS 1.2. However, “%CAOP_F_414, Database OPEN CURSOR failure on DB_OPEN” error appears in an odbc trace when trying to open or create a Message Record in EM.

 

Resolution:

The first step is to ensure that updated MS SQL odbc and native client drivers that support TLS 1.2 are installed on the EM Manager machine. These can be obtained from Microsoft...

ODBC Driver 11 for SQL Server
SQL Server Native Client 10

After the updated drivers are in place, the odbc configuration for EM must be modified to use the updated drivers.

Edit C:\Program Files (x86)\CA\CA_APPSW\cauodbc.ini

Modify the following lines to...

[SQL Server]
DefaultDatabase=master
ConnectionString="DRIVER=ODBC Driver 11 for SQL Server;SERVER=%CADB_SERVER%;DATABASE=%CADB_DATABASE%;UID=%CADB_UID%;PWD=%CADB_PWD%;Trusted_Connection=%CADB_TRUSTED%;"

[SQL Native Client]
DefaultDatabase=master
ConnectionString="DRIVER=SQL Server Native Client 10;SERVER=%CADB_SERVER%;DATABASE=%CADB_DATABASE%;UID=%CADB_UID%;PWD=%CADB_PWD%;Trusted_Connection=%CADB_TRUSTED%;"


The change will be in the "DRIVER=" portion for both lines.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing