Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2015 R2 update installed ....

Posted on 1 Jun 2015 19:15:38 by Microsoft Employee

After installing R2 .725 on top of .661 I was running utilities then an error popped up -- thoughts?

*This post is locked for comments

  • iruser2 Profile Picture
    iruser2 2,046 on 11 Jun 2015 at 13:43:46
    RE: GP 2015 R2 update installed ....

    to the posters wondering what this table is and if it is important to the users it holds data about the command bar.

    DictID ResType ResID TechnicalName PhysicalName Sequence FieldID FieldName PhysicalName2 DataType ControlType Length Keyable
    0 1 1237 syListViewCmdBar SY07240 1 7937 ListDictID ListDictID ID_INT Integer 2 4
    0 1 1237 syListViewCmdBar SY07240 2 7938 ListID ListID ID_INT Integer 2 4
    0 1 1237 syListViewCmdBar SY07240 3 7939 ViewID ViewID LI_MasterNumber Long Integer 4 9
    0 1 1237 syListViewCmdBar SY07240 4 7727 CmdParentDictID CmdParentDictID ID_INT Integer 2 4
    0 1 1237 syListViewCmdBar SY07240 5 7728 CmdParentFormID CmdParentFormID INT5_RU0 Integer 2 5
    0 1 1237 syListViewCmdBar SY07240 6 7726 CmdParentCmdID CmdParentCmdID INT5_RU0 Integer 2 5
    0 1 1237 syListViewCmdBar SY07240 7 7729 CmdSequence CmdSequence INT5_RU0 Integer 2 5
    0 1 1237 syListViewCmdBar SY07240 8 7719 CmdDictID CmdDictID ID_INT Integer 2 4
    0 1 1237 syListViewCmdBar SY07240 9 7720 CmdFormID CmdFormID INT5_RU0 Integer 2 5
    0 1 1237 syListViewCmdBar SY07240 10 7721 CmdID CmdID INT5_RU0 Integer 2 5
    0 1 1237 syListViewCmdBar SY07240 11 4594 Priority Priority INT5 Integer 2 4
    0 1 1237 syListViewCmdBar SY07240 12 7998 ButtonSize ButtonSize INT5 Integer 2 4
    0 1 1237 syListViewCmdBar SY07240 13 7715 CmdCaption CmdCaption STR79 String 80 79
    0 1 1237 syListViewCmdBar SY07240 14 7736 Visible Visible CB_Visible Boolean 2 0
  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on 11 Jun 2015 at 12:02:15
    RE: GP 2015 R2 update installed ....

    Hello everyone!

    I do see most of everyone that has posted is having issues with the error in regards to the SY07240 table.

    "Cannot insert the value NULL into column 'CmdSequence', table 'DYNAMICS.dbo.SY07240'; column does not allow nulls. INSERT fails.*/"

    I was sent an email today which directs to the a Known upgrade issue blog.

    [View:~/gp/b/dynamicsgp/archive/2015/06/10/draft-known-upgrade-issues-when-upgrading-to-microsoft-dynamics-gp-2015-r2:550:50]

    As a few people have mentioned Development is working hard at getting these issues resolved. It appears that we have a workaround for this issue however, a support incident would need to be entered in which when it is closed it will be set as non-chargeable.

    If you have any questions please let me know!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Redbeard Profile Picture
    Redbeard 12,931 on 04 Jun 2015 at 20:44:59
    RE: GP 2015 R2 update installed ....

    Tim,

    BTW, awesome work on the fix, thanks for sharing!

  • Redbeard Profile Picture
    Redbeard 12,931 on 04 Jun 2015 at 20:42:49
    RE: GP 2015 R2 update installed ....

    We recently faced a similar upgrade situation... we went GP 2010 SP3 to GP2013 SP2 to GP 2015 RTM.  I wonder if this is how we dodged this particular bullet?

  • Community Member Profile Picture
    Community Member Microsoft Employee on 04 Jun 2015 at 18:06:00
    RE: GP 2015 R2 update installed ....

    We are having the same issue with the SY07240 table.  As others are mentioning, the script is looking for (CmdParentFormID = 1576).  That CmdParentFormID is not in the table nor is a reference to that CmdParentFormID or FormId of any kind in any supporting table.

    We could probably come up with a clever workaround for now; however, the logic tells us that we may just need this new form and related command to actually work.

    Hopefully a hotfix resolution is available soon.

  • Community Member Profile Picture
    Community Member Microsoft Employee on 04 Jun 2015 at 15:10:16
    RE: GP 2015 R2 update installed ....

    I heard from Terry Healy that the development team is hard at work to get a fix together for us!

  • john doel Profile Picture
    john doel 335 on 03 Jun 2015 at 02:46:55
    RE: GP 2015 R2 update installed ....

    I had this exact same issue when upgrading from 11.00.2248 (GP 2010 SP4) to 14.00.0725 (GP 2015 R2).  Just like Tim mentioned, the insert statement it was dying on was using a subquery to get max+1 on a sequence number, but no records existed for the where clause, which gives us the NULL and obviously inserting a NULL value into any column in a GP table will fail since all columns are defined with NOT NULL.  I inserted a copy of the records in SY07240 I had in a test GP environment that had just Fabrikam in it, and the upgrade completed without any issues.  Like you mention, Tim, I'm not entirely sure what this table is used for beyond what its description is, which is "List View Action Pane" (perhaps something to do with Navigation Lists).  In any case, I'm definitely not proposing this as a solution, but I can confirm that the upgrade is expecting data in this table that's not there.  I'm not too concerned with moving forward with my solution for my specific purpose since this is just a test upgrade, but I'll be keeping tabs on this thread to see if someone from Microsoft responds with a detailed technical explanation or if Michael Sampson responds after he hears from Terry Heley.  In any case, the good news is that many of us are running into this so we're all in the same boat.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on 03 Jun 2015 at 00:26:18
    RE: GP 2015 R2 update installed ....

    Harry,

    I was going from GP2010 SP2 -> GP2010 SP5 -> GP2015 RTM -> Patch (x3) -> GP2015 R2

    I had no issues until GP 2015 R2.  I suppose it could be a result of the "hops" version to version (me skipping 2013)

    It looks like the GP team assumed there would be certain records populated in the table.

    SET @Count = 0

    SELECT @Count=COUNT(1)

    from SY07240

    WHERE ListDictID=0 and ListID=300 and ViewID=2 AND CmdParentDictID = 0 AND CmdParentFormID = 1576 AND CmdID = 41  

    If I run the SQL above against my SY07240 in my production GP 2010 environment I get 0 records returned.

    The next statement (Without my ISNULL stuff)

    if @Count = 0

    INSERT INTO SY07240 (ListDictID , ListID , ViewID , CmdParentDictID, CmdParentFormID,

                                         CmdParentCmdID, CmdSequence, CmdDictID, CmdFormID,

                                         CmdID, Priority, ButtonSize, CmdCaption, Visible)  

    SELECT 0, 300, 2, 0, 1576, 38,

               (SELECT max(CmdSequence) from SY07240

                WHERE ListDictID=0 and ListID=300 and ViewID=2 AND CmdParentDictID = 0

                             AND CmdParentFormID = 1576)+1 as NewSequence,

               0, 1576, 41, 0, 0, '',1  

    The query in the above select returns <NULL> and <NULL>+1 still is <NULL>

    Boom!

    I imagine I should go to my Production environment (prior to Upgrade) and follow your good advice and DELETE the records in SY07240 and let GP rebuild.  My issue is: I don't know a lot about this table and worry that I may be deleting something one of my users needs or cares about.  

    Tim

  • Redbeard Profile Picture
    Redbeard 12,931 on 03 Jun 2015 at 00:04:12
    RE: GP 2015 R2 update installed ....

    does it have to do with a combination of install package to upgrade path?

  • Community Member Profile Picture
    Community Member Microsoft Employee on 02 Jun 2015 at 16:07:48
    RE: GP 2015 R2 update installed ....

    I just heard from Terry Healy - the Microsoft team is looking into this. Only some people are experiencing this....

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans