Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Tuesday, February 23, 2016

Professional Services Tools Library PSTL - Item Number Combiner Error


When using the item number combiner feature of the PSTL, you might encounter an error indicating that there is an invalid object name which is DYNAMICS..syscolumns . As a result, the process is interrupted and will fail to deliver the required results. The encountered errors are included below:

Dynamics..syscolumns

Procedure TACallItemCombine
 
The stored procedure that is designed to manage the whole combine task is "TACallItemCombine", it is encrypted and can not be checked. The error is primarily due to having a static "SQL statement" within the code checking DYNAMICS..Syscolumns. Although, in certain environment the DYNAMICS db itself could have a different name due to the new feature of changing its name. As a result, this process will break up in the middle achieving no results at all.

Item Number Combiner

In my environment, I had Dynamics GP 2015 and the database names are as follows:
  • GP Company : GP15R
  • Dynamics Company: DYN15
Therefore, the procedure failed to find an object in a database which name is DYNAMICS, and eventually fail. 
In order to work this out, I have created a dummy database with the name 'DYNAMICS', just to force the procedure to proceed since it is encrypted and can not be altered.



Best Regards,
Mahmoud M. AlSaadi

5 comments:

  1. Thanks Mahmoud,
    This shows once more that sometimes Microsoft itself shoots in the stars when adding new functions to GP (i.e. named system databases other than DYNAMICS) and doesn't back-test properly all their tools :-)

    ReplyDelete
    Replies
    1. Hello Beat
      Unfortunately, sometimes yes :)

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  2. Mahmoud
    Thank you for the explanation it was driving me crazy. Have you determined any other way to run the function other than create a dummy database?

    ReplyDelete
    Replies
    1. Helly Gary
      Unfortunately, no. This needs to be reported to Microsoft Support team in order to sort it out. Meanwhile, creating a dummy database seems the most effective solution.

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  3. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete