Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Larger worksheets cras...

Larger worksheets crashing HQ Server V2.0

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I've had a problem with hq server closing unexpectedly while processing Worksheet 401's from multiple stores. The error is initiated from MSSQLSERVER and the error info is:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date:  1/6/2010
Time:  06:59:40
User:  N/A
Computer: SERVER
Description:
Error: 7105, Severity: 22, State: 6
Page (1:376428), slot 62 for text, ntext, or image node does not exist.

This typically happens when the data being uploaded is larger than normal (ie after physical inventory when there are many item counts updated, etc). Does anyone have any advice or know of a way to view the SQl information being sent from the store in the 401 Worksheet?

Thanks,

Tyler

*This post is locked for comments