web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Issue creating custome...
Finance | Project Operations, Human Resources, ...
Unanswered

Issue creating customer record in Microsoft GP 2018

(0) ShareShare
ReportReport
Posted on by Dynamics Community 365 5

Recently upgraded to GP 2018 from 2013 and trying to create a customer through SSIS package.

Getting the below error:

[Dynamics GP Destination [259]] Error: An error occurred with the following error message: "System.Data.SqlClient.SqlException: Cannot find either column "DYNAMICS" or the user-defined function or aggregate "DYNAMICS.dbo.GetGPUserIDbyCurrentSPIDExt", or the name is ambiguous. (SSIS Integration Toolkit for Microsoft Dynamics GP, v4.1.0.766 - DtsDebugHost, v11.0.7001.0)".

What's changed in the new version of the GP Database that it's looking for the above function as this function doesnt exist in older version (2013)

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    Is your Dynamics database name is DYNAMICS or something else?

    By the way why you need GP User id to run your SSIS package , you are creating customer only?

  • Dynamics Community 365 Profile Picture
    Dynamics Community 365 5 on at

    Yes, our DB is called DYNAMICS.

    We are using SSIS package with KingswaySoft to connect to Dynamics GP via a SQL user that has admin permission.

    We can read data from GP Database but when trying to update /insert data into GP Database. It gives me that error.

    It all works fine with Dynamics GP 2013.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    I see this function in GP 18.2 DYNAMICS.dbo.GetGPUserIDbyCurrentSPID not DYNAMICS.dbo.GetGPUserIDbyCurrentSPIDExt. Is this a function added by Kingsway? Did you upgrade Kingsway? Is this a  custom function that needs to be recreated? If so, hopefully you have a copy of your Dynamics database prior to the upgrade and can extract it.

  • Dynamics Community 365 Profile Picture
    Dynamics Community 365 5 on at

    I see both DYNAMICS.dbo.GetUserIDbyCurrentSPID and DYNAMICS.dbo.GetGPUserIDbyCurrentSPIDExt user-defined function in the Dynamics GP 2018 DB.

    It's not a function added by Kingswaysoft. It's not a custom function. It came with the Dynamics upgrade.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    I am looking at GP 2018.00.0704 and I only see DYNAMICS.dbo.GetUserIDbyCurrentSPID. What is the datestamp on DYNAMICS.dbo.GetUserIDbyCurrentSPIDExt? I wonder if it may have something to do with Extender. Since it is there in your database perhaps it has something to do with the column issue. If you open your SSIS package and extract the sql script does it result in the same error message? Maybe an update to your SSIS package is needed.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans