Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ERROR [Microsoft][SQL ...
Finance | Project Operations, Human Resources, ...
Answered

ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

When Running GP Utilities we have encounter the following errors Against a single company database. Our current instance is comprised of a total of 16 companies.

Any thoughts on how to correct this? I have Checked the DUINSTALL log file and there are no error messages that I can see.

Thanks for any help provided.

The following SQL statement produced an error:
exec seeSVCOpenRMACountsDetail_Create 0
exec seeSVCRTVCountsDetail_Create 0
exec seeSVCServiceCallCountsDetail_Create 0

ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.  

The following SQL statement produced an error:
exec seeSVCOpenRMACountsDetail_Create 0
exec seeSVCRTVCountsDetail_Create 0
exec seeSVCServiceCallCountsDetail_Create 0   

ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Service Record Type'.

Categories:
Microsoft Dynamics GP
  • Erick_Correa Profile Picture
    Erick_Correa 92 on at
    RE: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.
    Thanks, I check it right now
  • Verified answer
    Fritz Camille Profile Picture
    Fritz Camille 580 on at
    RE: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.

    Hi Erick,

    If I'm not mistaking, I was able to solve this issue. Look at my forum post.

    community.dynamics.com/.../error-gp-upgrade-2016-to-18-2

  • Erick_Correa Profile Picture
    Erick_Correa 92 on at
    RE: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.

    I am having the same issue upgrading to GP2018,

    any idea what it is and how to solve it?
  • Fritz Camille Profile Picture
    Fritz Camille 580 on at
    RE: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.

    Hi, did you find a solution for this? I am having the same issue upgrading from GP 2016.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.

    Interestingly enough I have not. Of the 16 Companies we have in our Dynamics DB only a single company fails with this error. All others upgraded correctly. In addition, when I review the installed components, in the GP 2018 Install media, I dont see field service as an option. Any thoughts?

    Thanks

  • GMA Profile Picture
    GMA 1,072 on at
    RE: ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SVC Return Type'.

    It has been a while, but any chance you installed/selected modules (Field Service) that you don't actually use? I have gotten errors similar to this when upgrading and selecting modules that I did not have.

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

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans