April 23, 2013 at 6:01 pm
Hi Experts
I am getting this error when Running SSID job please help
Hi,
We are trying to run an SSIS job by pointing to "APPLICATION". It is failing because of insufficient system memory (please see below for additional details). This appears to be a problem on DATABASE.
Time: Tue, Apr 23, 2013 01:44:35 PM
Job: jbSpecCapMMCalcEarnings
Step: FACETS - Generate MM
Status: failed
Server: CDDEVDBV001
Message: Executed as user: Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:44:35 PM Error: 2013-04-23 13:45:43.38 Code: 0xC0202009 Source: Load ods_PCPNeighborhood FACETS_SUPP_vwPRK_PROVIDER_NEIGHBORHOOD_MAPPING [5886] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "There is insufficient system memory in resource pool 'internal' to run this query.". End Error Error: 2013-04-23 13:45:43.39 Code: 0xC004701A Source: Load ods_PCPNeighborhood SSIS.Pipeline Description: component "FACETS_SUPP_vwPRK_PROVIDER_NEIGHBORHOOD_MAPPING" (5886) failed the pre-execute phase and returned error code 0xC0202009. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:44:35 PM Finished: 1:45:43 PM Elapsed: 68.344 seconds. The package execution failed. The step failed.
Time: Tue, Apr 23, 2013 01:44:34 PM
Job: jbSpecCapMMCalcEarnings
Step: (Job outcome)
Status: failed
Server: CDDEVDBV001
Message: The job failed. The Job was invoked by User TIDALUSER. The last step to run was step 1 (FACETS - Generate MM).
Completed at 04/23/2013 01:45 PM
April 23, 2013 at 9:21 pm
What is the job trying to do? I've seen this error when I am trying to select too many records.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 24, 2013 at 7:04 am
This error is indicating that there isn't enough memory for the SSIS process to handle the number of rows that are being returned. If the SSIS package is being run on the same server as the SQL Server it could be that the Max Memory setting for SQL Server is not leaving enough memory available for the SSIS process.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply