"Unable to configure component: Unable to validate CSI_DATA SQL instance" when running maintenance in ConnectShip Progistics Management Console for SendSuite Live

Learn how to resolve the error "The following errors were encountered: ConnectShip UPS (Consolidated): Unable to configure component: Unable to validate CSI_DATA SQL instance" when running maintenance in ConnectShip Progistics Management Console for SendSuite Live.
Products affected: SendSuite® Live

Issue

When running maintenance in ConnectShip Progistics Management Console, the following error is displayed:

"The following errors were encountered:

ConnectShip UPS (Consolidated): Unable to configure component:

Unable to validate CSI_DATA SQL instance"

Cause

The "Transaction Data" and "Configuration Data" Connection Strings are improperly configured or are set to not be used.

Resolution

  1. Launch Progistics Management Console as Administrator.
  2. On the left side, navigate to Server Components.
  3. Double-click on ConnectShip UPS (Consolidated) to open the editor.
  4. Click on the Transaction Data tab.
  5. Ensure that the Location is set to SQL Server.
  6. Ensure the Database connection string matches the following format and contains valid values for all fields:
 server=[SERVER INSTANCE];database=[DATABASE NAME];user id=[SQL USERNAME];password=[SQL PASSWORD];
  1. Click on the Configuration Data tab.
  2. Ensure that the Location is set to SQL Server.
  3. Ensure that the Database connection string matches the following format and contains valid values for all fields:
 server=[SERVER INSTANCE];database=[DATABASE NAME];user id=[SQL USERNAME];password=[SQL PASSWORD];
  1. Save your changes in the lower right corner.

Test Criteria

Attempt to run maintenance again. If it succeeds, the resolution worked.

Permissions Required

Windows Administrator

UPDATED: August 14, 2021

Contact Us
Live Chat
Available • Closes at 8pm ET
Sales team hours are 8am-6pm ET
Live Chat
Live Chat is currently unavailable.
Chat is available Mon-Fri, 8am-8pm ET
Create a case
Submit support requests (Sign in required)