17122 Initdata: Warning: Could Not Set Working Set
Oct 9, 2007
Running SQL 2000 Standard w/SP4 on a Windows Server 2003 Enterprise w/SP2 for about a year and I just recently started getting this error.
The server has 2GB of RAM and was dynamically set and no problems then within the past couple days I've started getting this error.
So far I've tried all the "fixes" found by searching Google but none of them fix the problem. After restarting SQL or the Server the same error shows up in the Event Viewer
17122 initdata: Warning: Could not set working set size to
Have set and reset the memory options and awe, no awe, etc but still get the error.
Hello Is there anyone who can help me? I saw the fallowing error message in the SQL SERVER error log. "initdata: warning: could not set working set size"
Set Working set size to 0(zero)* in my SQL SERVER What should I do? Should I Set working set size set to 1(one)?
EVENT ID: 17055 SOURCE: MSSQLServer CATEGORY: Kernel DESCRIPTION: 17122 : initdata: Warning: Could not set working set size to 519104 KB.
I have 1gb of memory. In the SQL server properties, I configure my memory with 512Kb not in dynamic but with determinated memory ! I reserve 1024 for SQL request physical memory.
Do you have any suggestions to resolve it ? My server reboot 3 times per day !!!!
I had a view in which I did something like this isnull(fld,val) as 'alias'
when I assign a value to this in the client (vb 6.0) it works ok in sql2000 but fails in 2005. When I change the query to fld as 'alias' then it works ok in sql 2005 . why ?? I still have sql 2000 (8.0) compatability.
Also some queries which are pretty badly written run on sql 2000 but dont run at all in sql 2005 ???
any clues or answers ?? it is some configuration issue ?
I am getting the following warning message in the event viewer. I have only one schedule in sql. there is no other schedules in task scheduler or database management.
Event Type:Warning Event Source:SQLSERVERAGENT Event Category:Job Engine Event ID:208 Description: SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0xD25A4CDDD1C59E48B4D28F61F0A411B8) - Status: Failed - Invoked on: 2004-08-16 02:30:00 - Message: The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last step to run was step 1 (Step 1).
Hey guys....I have a quick question. I am having a problem with a certain app which connects to my SQL 2000 SP3a Database. It only occurs when I have a ^ in the password, both using SQL and NT authentication.
I have checked on MSDN and they do not list that character as one to avoid. I did find in the books online documentation that the ^ performs a bitwise exclusive OR operation....has anyone tested using ^ as part of a password to authenticate to a SQL db?
ALTER TABLE [konnik].[PORTAL_CONFIG] ADD CONSTRAINT [DF_PORTAL_CONFIG_AUTOPM_ON] DEFAULT (1) FOR [AUTOPM_ON]
and i received the following warning
Warning: The table 'PORTAL_CONFIG' has been created but its maximum row size (12068) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Bear in mind that this table come from Access through the Dts. Could anyone translate this for me? How can i overcome this???
i have this error and fail to resolve it :- Warning: Null value is eliminated by an aggregate or other SET operation. what does that means? my code :-
SELECT @BookQtyIN = ISNULL(SUM(x.pickqty), 0), @PickQtyIN = CASE WHEN ISNULL(SUM(x.pickqty), 0) >0 THEN ISNULL(SUM(d.PickQty), 0) - ISNULL(SUM(x.pickqty), 0) ELSE ISNULL(SUM(d.PickQty), 0)END,
FROMtblItemDetail d
LEFT JOIN (SELECT p.PickQty AS PickQty, j.PickComplete AS PickComplete, p.ItemStorageID AS ItemStorageID FROM tblItempicked p LEFT JOIn tblJobDocuments j ON j.Docrefid=p.Docrefid AND j.JobID=p.JobID WHERE j.PickComplete='N' )AS x ON x.ItemStorageID=d.ItemStorageID
WHERE d.ItemID = @ItemID AND d.Ownership = @ClientID AND d.CustomLotNo = @CustomLotNo
If you have a package that uses an environment variable for an indirect configuration and the environment variable is not present when the package runs you get the following warning:
The configuration environment variable was not found. The environment variable was: "Seer.ConnectionManager.CUECommonReference". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid.
IMO, if the package is expecting to find something and cannot find it then it should cause an error, not a warning. I'm happy for people to disagree tho :)
I'm having a problem with one of my packages due to a truncation warning that I can't get rid of. It's not the end of the world, because the package still works. It's just extremely frustrating.
The problem arises in a derived column item in a data flow task. There is a postcode field in the data flow which has space for 20 characters. I create a derived column from this which simply removes any spaces:
Derived Column Name: Postcode
Derived Column: Replace 'Postcode'
Expression: REPLACE(" ",Postcode,"")
Data Type: string [DT_STR]
Length: 20
Code Page: 1252 (ANSI - Latin I)
However when I use this expression, or anything else which uses the replace function, I end up with the warning message:
Warning 1 Validation warning. Create Staging Tables: Derived Column [20555]: The result string for expression "REPLACE(" ",Postcode,"")" may be truncated if it exceeds the maximum length of 4000 characters. The expression could have a result value that exceeds the maximum size of a DT_WSTR.
I have tried everything I can think of to get rid of the warning. Is there some way I can use the replace function, but not have the system convinced that I'm about to go over the maximum size limit?
Can some one please help. Lately I am getting an error: LAZY WRITER WARNING: LRU List is Empty
Than the system locks! can anyone help. This is driving us crazy. There is no reference in the KB. We are trying to insert records into a table by a SP.
I'm running SQL Server 6.5, with the latest Service pack on NT 4.0 with SP4. A couple of days ago I started getting a warning message in my event log right after a scheduled task ran. The scheduled task calls three stored procedures (data dumps for master, msdb, and a production database) it also runs a consistency check on each before dumping them. I can interactively run each stored procedure and get NO error messages. Prior to getting the warning message (which occurs after the scheduled task runs) I get normal informational entries that the dumps occurred without a problem and the files are written to the proper area. The error is in the Task Engine category and are Warning type messages. Here is the text:
SQL Server Scheduled Task: 27, 'Proddata Dump' -- Status: Failed -- Task Invoked on: 5/20/99 5:00:00 AM -- Message: Database 'ASSMTCTRPROD' (116647 pages) dumped to file <1> on device 'D:DATDUMPASSMTCTRPROD_990520_DATA.DMP'. (Message 4035)
Any help that anyone could give would be greatly appreciated. Thanks
I'm getting a strange sql server agent warning in my server's event log (not in the sql server log). Its occurring after each agent job runs and says:
"Unable to determine if the owner (sa) of job Trans Backup has server access (reason: Unable to connect to server - check SQL Server and SQL Agent errorlogs)."
I have checked the errorlogs - nothing. My job completes OK, but I get this warning.
I'm running SQL Server 2000 SP2. I'm running in a cluster. The problem has only occurred since a reboot yesterday.
I've recently restored one of my development databases from it's production backup. The restore completed successfully, users were able to connect to the database without any problems. However, when I checked the error log I found the following message:
Bypassing recovery for database 'Test' because it is marked IN LOAD.
I could not find anything on the web or in BOL. Any ideas?
Under event viewer->application log i am getting the below error continously. Pls help
Regards,Event Type: Warning Event Source: SQLServerAgent$abc Event Category: Printers Event ID: 208 Date: 2/9/2004 Time: 9:23:03 PM User: N/A Computer: abc1 Description: The description for Event ID ( 208 ) in Source ( SQLServerAgent$abc ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: SQL Check, 0xAF04DFE7917DEA489F33D8A38E8A0793, Failed, 2/9/2004 9:23:00 PM, The job failed. The Job was invoked by Schedule 31 (6.x schedule). The last step to run was step 1 (Step 1)..
I use VB 6.0 with ADO 2.6 to access an SQL-server. I know that the table I wish to create generates this warning.
But from today ( without any changes to the SQL-server ) , this warning is reported as an error to the client instead of continuing. So my error trap routine traps this as an error now.
I have a workaround that I would to avoid and that's reinstalling the SQL-server ( Only the MSSQL ).
Does anybody know a better solution.
PS : Changing the table structure is not possible in this case.
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
how do i get hold of Internet Information Services I installed it on vista premium.
While intalling SQL 2005 on an x64 machine, I got an error message that warned that some functions of SQL would not install unless IIS was installed (and enabled) on the machine. It did not say what would not install, but I gather it is Reporting Services. I don't recall getting these warnings in previous (32 bit) installations of SQL 2005.
On the other hand, when I go into the BI Intelligence Studio on a (32 bit) server that does not have IIS, I seem to be able to create a report anyway (Not really my area of expertise ). Does that mean that Report Services is working without IIS?
Hi,I have a few create table statements which create temporary tablesthat has row definitions which exceeds the 8060 size limit, this causesa warning message being generated (Message 1708).Is there a way I can disable/avoid the warning message from beingprinted ?Thanks,joe
Awhile back there was some discussion about ways of sending multiplerows of data to SQL Server. The ADO .UpdateBatch method was one ofthe possibilities mentioned, and Erland said he thought that probablyonce the data get to SQL Server they are probably actually insertedone row at a time. I just want to say that based on an experience Ihad a couple of days ago I am now sure that is the case. I was using..UpdateBatch for something quick and dirty I had to do just once andwas too lazy to use XML for. An error was generated during the..UpdateBatch process because of invalid data in one row. However, alarge number of the rows in the batch WERE written to the database.Until now I haven't used .UpdateBatch in a production environment onlybecause this implies granting INSERT or UPDATE privileges to the user.But based on this experience I would NEVER use .UpdateBatch in aproduction environment, even for a user like a batch job where thepermissions would not be an issue.FWIW.
I have an SSIS package which uses a third party RMS driver. It is not licensed and so it throws a warning messagebox when the package is run and every time the connection is used. Is there a way to suppress these messages so that the package can be scheduled and run without user interaction?
I don€™t know if this is the case but I need some help. We have itanium server with Microsoft SQL Server 2005 - 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).
We has had lot of problem with that the sqlserver.exe process hangs 100% cpu. It€™s totally non responsive I€™m not even able to contact the server with DAC. The general solution has been just kill the process. Not nice.
I am able to "CREATE ASSEMBLY" for the stdole.dll without issue, however, I receive the warning:
Warning: Assembly "stdole" was built using version v1.0.3705 of the .NET Framework. SQL Server currently uses version v2.0.50727. (Microsoft SQL Server, Error: 6215)
I am unable to find a PIA for stdole that is .NET 2.0. Has anyone resolved this warning? Can I create a 2.0 PIA myself without causing other problems?
when using lookup i am geting the following warning.our OLEDB connection is Oracle.how to resolve this will this have any performance impact.
[Lookup [14342]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
I'm running dtexec with the /WarnAsErrors flag, to be sure to detect any configuration warning (configuration errors are actually throwed as warning, which is not sufficient) or any other important warning.
I only get one warning (0x80047076, optimisation warning). Is there a way to disable this specific warning ?
I have insured that I have the x86 version downloaded of both the ver. 2.0 .net foundation. I have insured that I meet the min. requirements of all software requirements. For the Std. edition my hardware reports I exceed the minimum requirements. For the Adv. edition my hardware meets the min. mem. requirements.
I proceed with the Adv. installation, I find a warning during the preamable or the installation support tools regarding insufficient hardware. I then back out of installation, I remove the /program files/ms sql folder and verify registry is cleared.
I proceed to install the std. edition, I find the same warning as above. I suspect I have an error in the hardware profile reporting tool. I then search for a ms analysis tool equivalent to the one used by SQL 2k5 express to no avail.
As this installation is a requirement for classes I find myself a little frustrated; however, expert assistance would be most welcome. Note: In either case of the above installations I can proceed with the installation; however, the client fails. This issue does not appear resolveable with normal user access tools, suggestions for a Remedy in the next few hours will be most welcome. Class starts tomorrow.
Document contains one or more extremely long lines of text. These lines will cause the editor to respond slowly when you open the file. Do you still want to open the file? on every file containing a Script Component? I've got a project with about 21 packages, ~ 3/4 of them having multiple Script Components and every single one of them makes me click through the warning dialouge to open the file. That means simply opening the project takes about three minutes and almost complete attention through the entire process. Builds offer the same headache since the creation of a Deployment utility inexplicably requires every file in the project be open. As far as I can tell, the warning is a result of Script Components being included in the .dtsx file as a pre-compiled binary. I didn't specifically ask for the binary to be included in the file, so why would the standard behaviour raise a warning dialouge by default? Please tell me I'm doing something wrong.
