MaxExchange Fails to Run After Restoring a Previous Copy of the Database

Solution

The MaxExchange SP_VERSION needs to be removed to allow MaxExchange to rebuild the Stored Procedures again.

• If you are using Maximizer CRM Enterprise Edition or Maximizer CRM Professional Edition, click here.
• If you are using Maximizer CRM Group Edition, or MaxExchange Remote, click here.
• If you are using MaxExchange Remote, click here.

For Maximizer CRM Professional Edition or Maximizer CRM Enterprise Edition users

The following instructions assume you have a fairly good understanding of SQL.

1. Close all Maximizer and MaxExchange applications and stop the MaxExchange Service if it is running.
2. Backup your MaConfig and Maximizer SQL databases.
3. Run the following SQL Query against the MaConfig database on your SQL Server.
   
   DELETE FROM MaConfig
   WHERE eSection = ‘[MaxExchange DB Name]’ and ekey = ‘SP_VERSION’
   
   Where [MaxExchange DB Name] should be replaced with the name of your MaxExchange Database Name on the SQL Server.
4. Start the MaxExchange Server again. This will rebuild the missing stored procedures.

For Maximizer CRM Group Edition users

1. Close all Maximizer and MaxExchange applications and stop the MaxExchange Service if it is running.
2. Backup your Maximizer Address Book.
3. Find and open the MxzDir.cfg file in Notepad.

On the MaxExchange Server, this is located at: "C:\Documents and Settings\All Users\Application Data\Maximizer\SvrShare”

4. Delete all lines beginning with ‘SP_VERSION’.
5. Start MaxExchange Server again. This will rebuild the missing stored procedures.

For MaxExchange Remote users

1. Close all Maximizer and MaxExchange applications.
2. Backup your Maximizer Address Book.
3. Find and open the MxzDir.cfg file in Notepad.

On a MaxExchange Remote, this is located at: "C:\Documents and Settings\[username]\Application Data\Maximizer”

4. Delete all lines beginning with ‘SP_VERSION’.
5. Start MaxExchange Remote again. This will rebuild the missing stored procedures.

Affected Versions

• MaxExchange 10
• MaxExchange 10.5
• MaxExchange 10.5 R2


• Maximizer CRM 10
• Maximizer CRM 10.5
• Maximizer CRM 10.5 R2