If a database move is needed for SendSuite® Live, please contact software support for assistance. The complete installation will be reviewed for complexity and depending on the results, the work may be performed by the software support desk or a Change Request may be submitted.
Environment Details
Products affected: SendSuite® Live
Internal Notes
STEP 1
Run the below SQL script against the SendSuite live database once it has been successfully restored.
SQL SCRIPT # 1: UPDATE DATASOURCE
USE [SendSuite Live]
DECLARE @NEWServer AS VARCHAR(50)
DECLARE @OLDServer AS VARCHAR(50)
SET @NewServer = ‘SendSuiteLive-qa’
SET @OLDServer = ‘SendSuiteLive-test’
UPDATE DataSources SET DBLinkedServerName = @NEWServer, DBServerName = @NEWServer WHERE DBLinkedServerName = @OLDServer
NOTE: ‘NewServerName’ should be replaced with the name of the new SQL server and ‘OldServerName’ should be replaced with the name of the old SQL server.
STEP 2
After restoring ConnectShip database, launch Progistics Management Console.
a. Under the Enterprise section, Update the Controller Configuration Data to reflect the new database server and credentials, then click on the Test button to verify connectivity can be establish with the database on the new SQL server. Save the changes by clicking on the “Save” button.
b. Under the Server Component section, click on one of the Server Components, then click on the Transaction Data tab, select the newly created Database connection string from the pull-down, then click on the Test button to verify connectivity can be establish with the database on the new SQL server. Save the changes by clicking on the “Save” button.
NOTE: These steps must be performed on both the Transaction Data tab and the Configuration Data tab for each Server Component.
STEP 3 – Update Server Configuration Utility
Launch Server Configuration Utility
If the “Server Setting” section is not expanded, click on the “+” sign next to it and expand the “Server Settings” section.
Expand the SQL Section by clicking on the “+” sign
Update the below fields with the new SQL Server information
. SQL Password
. SQL Server
. SQL User
Click on the “Apply Clear” button.
Click on the “Close” button
STEP 4 – Only needs to be done if the country codes are not loading for the Projects
Open Internet Explorer and launch SendSuite Live Projects Administration
Click on the Project Administration tab
Highlight the project missing the country codes
Click on the Project Design tab
Once the Project Datasources have finish loading, click on the Ship link in the bottom left hand pane
Once the Page Design View has loaded, left click on the ShipToCountry list box and go to Data properties
Note: The following error message might appear “An error has occured in the VDPEClient component: Subscript out of range – From_load”, if it does just click the “OK” button.
Click on the List Options tab. Click on the “Configure New” button
Select Microsoft SQL Server and click the “Next” button
Select the new SQL Server and enter credentials
Select SendSuite Live Database
Highlight the “Address Codes” table from Available Tables and Views window then click on the Limit Tables and Views button
Highlight the “Address Codes” table and click on the “OK” button.
Click on the “Next” button
Click on the “Finish” button
Configure the below option in the bottom window.
a. Check the “Text” box for the field Name
b. Check the “Order by” box for the field Name
c. Check the “Value” box for the field Code
d. Type 1 in the “Where the field equals” box for the field Type ID
Click on the “OK” button
Click on the “Save Changes” button
Once the changes have been saved, perform an iisreset
Close browser
Launch Internet Explorer load the Project