Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2013 R2 - Professio...
Microsoft Dynamics GP (Archived)

GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

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

Hello,

We recently updated to GP 2013 R2 and are trying to utilize the Professional Services Tools Library's Item Combiner tool. The first error states: " [Microsoft][SQL Server Native Client 10.0][SQL Server} Violation of PRIMARY KEY constraint 'PKJSOP131'. Cannot insert duplicate key in object 'dbo.JSOP131'. The duplicate key value is (200125).

Item 200125 is the "surviving" item number we want when the combiner is complete.

The second error we get states "The stored procedure TACallItemCombine returned the following results: DBMS: 2627, Microsoft Dynamics GP: 0

I see the community has had other errors with Item Combiner but I can't find anything on this particular one. I would greatly appreciate any help.

*This post is locked for comments

  • Suggested answer
    iruser2 Profile Picture
    iruser2 2,046 on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    This is an older post, but in case you are still wondering what this table is for, I believe I have it identified.

    My client got the same error this past weekend.  They run an EDI addon from BlueMoon that uses JSOP tables.  I

    believe in the set file it is Dynamics Online Services, which I see original poster also has in their set file.

    My client has over 12,000 records in this JSOP table.  It looks like the inventory merge errored out on a duplicate.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    We think the JSOP131 table has something to do with payroll/commissions but still aren't quite sure. Running the script below in SQL resolves the problem for us, we use it every time we use the PSTL item combiner tool. Since we aren't 100% sure I would recommend running a back up before deleting the record and trying it in a test environment/company before running it in the live company. Hope this helps.

    DELETE FROM JSOP131 WHERE ITEMNMBR = 'XXXX' (replace ‘XXXX’ with the item number you want to keep in GP

  • Mark Colling Profile Picture
    Mark Colling 5 on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    We are experiencing the same issue when attempting to combine some item numbers.  Were you able to identify what the JSOP131 table is associated with?

    Thanks

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    I would suggest that the table is relating to one of the last three products on your list.  You could have a look in your Resource Descriptions to see if the table is listed - that would at least let you know which product it is conflicting with.

    To do that go to Microsoft Dynamics GP --> Tools --> Resource Descriptions --> Tables.

    Choose the product from the drop-down and check within each series to look for JSOP tables.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    Hi Leslie,

    There is a table named JSOP131 in our database but there is nothing in the table for any of the items in our system. Because of that we felt comfortable deleting the table for each item we combined. After we did that we are able to successfully combine the items and no problems - so far. :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    Here's a copy of my set file.

    16
    0
    Microsoft Dynamics GP
    949
    FieldService
    1042
    Interfund Management
    1493
    SmartList
    1632
    Cash Flow Management
    1878
    Excel-Based Budgeting
    2277
    Purchase Order Enhancements
    2416
    Control Account Management
    2547
    Enhanced Commitment Management
    2992
    CopierSeries
    3104
    Advanced Security
    3278
    Report Scheduler
    5597
    HITB Report
    6499
    Dynamics Online Services
    5986
    Menus for Visual Studio Tools
    4687
    Credit Card Extension
    Windows
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Dynamics.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/FORMS.DIC
    //I3SQL2012/MBS_Share/GP_Reports/Reports.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/SrvcAdv.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/FRMS949.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/RPTS949.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/IFund.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/1042FORM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/1042RPTS.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/EXP1493.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/EXP1493F.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/EXP1493R.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/CFM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CFMFORM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CFMRPTS.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/XLBudget.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/XL1878F.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/XL1878R.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/POE2277.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/POE2277F.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/POE2277R.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/CAM2416.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CAMFORM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/CAMRPTS.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/ECM2547.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ECM2547F.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ECM2547R.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/QK2992.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/QDF2992.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/QKR2992.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/AdvSecur.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ADVS_FRM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/ADVS_RPT.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/RPTSCHED.dic
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/F3278.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/R3278.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/HTB5597.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/HTBF5597.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/HTBR5597.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/DO6499.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/DO6499F.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/DO6499R.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/VSTMENUS.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/VSTM_FRM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/VSTM_RPT.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/4687ENH.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/4687FRM.DIC
    :C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/4687RPT.DIC

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    This sounds like it might be from a third party dictionary. Do you in fact have a table named JSOP131 in your database? The other thing you can do is search your database for the value '200125' and check out any tables it might show up in.

    Kind regards,

    Leslie

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    Can you post the details from your set file here?  We might be able to isolate it.  I don't have those tables in my database so they are probably related to third party product.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    Hi Heather. We aren't sure what the JSOP131 table is, it appears for each of our items in SQL but there is no data in any of those files. We are only combining 4 items so we removed those files for each item and the Item Combiner works great (we used our test database). This morning we went ahead and ran the Item Combiner in the live company using that same logic, no problems - so far! My inquiring mind would still really like to know what table JSOP131 is and what it's used for though.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: GP 2013 R2 - Professional Services Tools Library - Item Combiner Error

    What is table JSOP131 - I am not familiar with that table - do you have a third party product installed that links in with inventory?

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,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