Issue
When using SQL 2008 or SQL 2008 R2, I/NET will crash randomly. Referring to the system Event Log, you can see a SQL error happened just before I/NET crashed, called "There is insufficient system memory in resource pool 'internal' to run this query."
Product Line
EcoStruxure Building Operation,TAC INET
Environment
- I/NET
- SmartStruxure
Cause
According to Microsoft Knowledge Base, this problem occurs for all the following reasons:
- There is a bug in the code that is used to evaluate how many rowsets are required to perform a sorting operation. Therefore, the code greatly overestimates the numbers of rowsets. The required grant estimate in full-text is 64 pages for each rowset that is required to sort.
- There is a large request that blocks the system from using the memory that is reserved for the full-text query.
Resolution
Install the newest SP to the SQL 2008 or SQL 2008 R2 being used. Download Microsoft SQL Server 2008 SP3 Express Edition or Microsoft SQL Server 2008 R2 SP2 Express Edition from the Microsoft website.
If this doesn't help, please follow Create Error Log for I/NET to turn on the error log for I/NET and then send the log in to your local country product support group for further troubleshooting.
