Automation Process failed to complete with an error message "Could not connect to database; -url=Process.CommonDS.SCDBConnectionString_MDB - No suitable driver found for Process.CommonDS.SCDBConnectionString_MDB"

Document ID:  TEC1463814
Last Modified Date:  01/01/2018
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Service Catalog

Releases

  • CA Service Catalog:Release:14.1
  • CA Service Catalog:Release:12.9

Components

  • CA SERVICE CATALOG:USVCT
Issue:

Troubleshooting failed process instance using the global data-set connections

Environment:
CA Service catalog 14.1 CA Process Automation 4.2 CA Service Desk Manager 14.1
Cause:

Connection string URL is not captured even after saving the new URL information in the process design

Workaround:

Validate that the process is capturing the right information from the connection string URL by following the below steps

1. Login to Process Automation (CA ITPAM) with admin rights

2. open the troubled process and checkout to edit

3. Copy the ConnectionString value for future use

4. Clear the contents in the ConnecitonString and Save the process by Checkin button to save the updates

Note: Run the process manually to confirm that that ConnectionString values are blank in the process instance. The process instance should fail complaining that the URL is empty.

5. Checkout the process again and update the ConnecitonString value with the contents that were removed from Step 3

6. Click on checkin button to save the process with the new updates

7. Run the process manually to check if the process is completed in this case with a successful Database connection.

Additional Information:

Note: The above simple example is specific to a database connection issue using PAM process

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 >