Migration Errors - CS 2002 FP1 to CS 2007

#1 01-31-2008, 06:00 PM

I keep getting this SqlException (from the upgrade log file) when I attempt
to migrate CS2K2 FP1 Marketing/Campaigns to CS2K7? I dont see this particular
stored procedure in the FP1 marketing resource. Any ideas on how to proceed
with the migration? Please help

<CS2007Upgrade>: Error: Exception when upgrading 'Marketing/Campaigns':
System.Data.SqlClient.SqlException: Invalid object name
'dbo.mktg_spGetIncrementalBatches'.

#2 02-08-2008, 04:17 PM

I figured this one out. My CS 2002 database connectionstrings had been
configured to use a SQL Login, say XYZ (dbowner), and when the Upgrade tool
runs the migration, it creates these new tables, procs with XYZ schema
instead of dbo schema.

I changed the connections in Commerce Server Manager to use sa and it worked
fine.

"TechMate" wrote:

> I keep getting this SqlException (from the upgrade log file) when I attempt
> to migrate CS2K2 FP1 Marketing/Campaigns to CS2K7? I dont see this particular
> stored procedure in the FP1 marketing resource. Any ideas on how to proceed
> with the migration? Please help
>
> <CS2007Upgrade>: Error: Exception when upgrading 'Marketing/Campaigns':
> System.Data.SqlClient.SqlException: Invalid object name
> 'dbo.mktg_spGetIncrementalBatches'.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode