February 7, 2014 at 12:46 am
ENVIRONMENT :SQL 2008 R2 (STANDARD EDTION 64 BIT)
ERROR DESC
===========
Executed as user: XXX\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:30:00 AM Error: 2014-02-07 06:55:52.98 Code: 0x00000000 Source: create_index_cc_XXX_ Description: Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. End Error Error: 2014-02-07 06:55:55.98 Code: 0xC002F210 Source: create_index_cc_XXX Execute SQL Task Description: Executing the query " /****** Object: Index [IDX_XXX] Scrip..." failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:30:00 AM Finished: 6:56:11 AM Elapsed: 1570.75 seconds. The package execution failed. The step failed.
IN AGENT LOG IS SEE THE ERROR LIKE
1.The error is printed in terse mode because there was error during formatting
2.INTERNAL MEMORY ERROR LIKE THAT
PLEASE HELP OUT ON THIS ISSUE
February 7, 2014 at 1:07 am
Is your caps lock broken?
This error is mostly due to memory pressure.
Make sure SQL Server has enough memory to finish the operations.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 7, 2014 at 2:03 am
how to handle the memory pressure in sql
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply