Adding New fields to inv. Posting Buffer primary Key

sunnyk
sunnyk Member Posts: 280
edited 2011-05-19 in NAV/Navision Classic Client
Hi All,
I have added 2 Fields to Table 49 and added them to primary key so the total no of fields are now become 16 in the primary key. but when i tried to add another field to primary key and try to save it it throws me the error,

The Invoice Posting buffer table primary key exceeds the maximum of 16 coloumn in SQl server index.

Any suggestions on this. How can i avaoid to maintain SQLindex for this.

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    If I remember correctly, we can have 20 fields in primary key in native database and 16 fields in primary key in SQL database..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • sunnyk
    sunnyk Member Posts: 280
    Hi Mohan,
    Yes. But is there any way to overcome this.
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    I think NO

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • rmv_RU
    rmv_RU Member Posts: 119
    sunnyk wrote:
    Hi All,
    I have added 2 Fields to Table 49 and added them to primary key so the total no of fields are now become 16 in the primary key. but when i tried to add another field to primary key and try to save it it throws me the error,
    The Invoice Posting buffer table primary key exceeds the maximum of 16 coloumn in SQl server index.
    Any suggestions on this. How can i avaoid to maintain SQLindex for this.
    You could increase size of some fields and concatenate values in one, but maximum size of any key is 256 bytes (both key fields and sumindex fields in key).
    Trick only for temporary tables: You able to calculate calcsums of any field with any filters, it doesn't matter if this field and filter fields included in key or not. May be it help you.
    Looking for part-time work.
    Nav, T-SQL.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

    In the primary key are both the "VAT xxx Posting Group" fields as "Tax *" fields. You do not need both. You can remove the ones you don't need to make place. But you also have to change some code to fix the posting.
    And you will have to redo that when you upgrade your version.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • jglathe
    jglathe Member Posts: 639
    Hello,

    we have built a solution for this problem. It is part of our BuildingBlocks add-on, soon to be released.

    with best regards

    Jens

Categories