Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home

Symptoms

When users go to Project management and accounting > Projects > Project contracts, and then in the Action pane click on Maintain > Bill > Project invoice proposals, they receive the error message: Stack trace: Binding operation failed to allocate buffer space. Object Server Azure:

↑ Back to the top

Resolution

When coming from Project contract and opening the invoice proposal list page, the current code will get all Projects related to the contract and will use a concatenated comma delimted Project Ids that will be used later for the query. When Project contract has hundreds or more Projects, this will cause a SQL error because of the huge SQL "where clause" that is generated.

 

Fix is to remove that concatenation and use a direct relation to the Project table added to the query that is used in the invoice proposal list page.

↑ Back to the top

More information

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top

Article Info
Article ID : 4074904
Revision : 1
Created on : 1/11/2018
Published on : 1/11/2018
Exists online : False
Views : 201