Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP 2010 Upgra...
Microsoft Dynamics GP (Archived)

Dynamics GP 2010 Upgrade Issue 'seeCustomerYTDSalesByTerritoryDetail'

(0) ShareShare
ReportReport
Posted on by Christian Villeneuve 190

Hello everyone,

I wanted to see if anyone has seen or come across this issue when upgrading Dynamics GP 9.00.0371 to 11.00.1935 or Upgrading to GP2010 in general.

During the upgrade of a company, all of the sequence of the update completes, along with upgrading the data, but when it reaches 'Load Stored Procedures', it fails on seeZZZ_Dynamics_Create.

When looking at the DEXSQL.LOG and doing a little more research, it is actually failing on creating the following stored procedure 'seeCustomerYTDSalesByTerritoryDetail', along with 'seeTopCustomerBalancesDetail'.

The 'seeCustomerYTDSalesByTerritoryDetail' stored procedure comes back with

/*  Date: 03/26/2012  Time: 16:17:54
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Number'.*/
/*
/*  Date: 03/26/2012  Time: 16:17:54
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Number For Drillback'.*/
/*
/*  Date: 03/26/2012  Time: 16:17:54
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Salesperson ID For Drillback'.*/

/*  Date: 03/26/2012  Time: 16:17:54
SQLSTATE:(37000) Native Err:(15151) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'seeCustomerYTDSalesByTerritoryDetail', because it does not exist or you do not have permission.*/

and the 'seeTopCustomerBalancesDetail' stored procedure comes back with

*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Number'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Number'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Balance'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket2'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket3'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket4'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket5'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket6'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket7'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Name'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Address 1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Address 2'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'City'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'State'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Zip'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Phone 1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Number'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Balance'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket2'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket3'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket4'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket5'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket6'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket7'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Name'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Address 1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Address 2'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'City'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'State'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Zip'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Phone 1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Number'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Balance'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket2'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket3'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket4'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket5'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket6'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Aging Bucket7'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Customer Name'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Address 1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Address 2'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'City'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'State'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Zip'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(S0022) Native Err:(207) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Invalid column name 'Phone 1'.*/
/*
/*  Date: 03/26/2012  Time: 16:18:06
SQLSTATE:(37000) Native Err:(15151) stmt(42088384):*/
[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'seeTopCustomerBalancesDetail', because it does not exist or you do not have permission.*/

I then tried another database and that one completed fine with no issues on the Load Stored Procedures process, so i tried to script it and run it against the one that failed, but the same errors above occur.

Any input would be great, and thanks in advance.

Chris

*This post is locked for comments

  • Christian Villeneuve Profile Picture
    Christian Villeneuve 190 on at
    Re: Dynamics GP 2010 Upgrade Issue 'seeCustomerYTDSalesByTerritoryDetail'

    Andrew,

    In my case, a table existed with the name 'Customers', while it is suppose to be a View.

    You can run this script to see what it comes back as.

    SELECT * FROM SYSOBJECTS WHERE NAME = 'Customers'

    Against the database that you are having a problem with

    If the xtype column shows a 'U' it is a table, however it suppose to be 'V' (view).

    I simply scripted the table 'Customers' and saved it as a file, and deleted the table 'Customers' (also checked to see if there are any records in the table and in my case there were '0')

    Once you completed this, re-run GP Utilities and try to upgrade the company again.

  • Andrew Tims Profile Picture
    Andrew Tims 50 on at
    Re: Dynamics GP 2010 Upgrade Issue 'seeCustomerYTDSalesByTerritoryDetail'

    I am getting exactly the same issue. Did you ever get a resolution??

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans