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)?
Thanks in advance...
bim@sifas.com.tr
mikiz@turk.net
I get the following warning message logged when starting up SQL:
initdata: Warning: Could not set working set size to 519104 KB.
What it mean ?
I have got 1x400 MHz serevr with 512 MB RAM and MS SQL server parameters are following :
max_memory = min_memory = 250 MB
set working set size = 1.
Thanks for your help.
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.
Hi,
Can anyone assist me, whenever SQL server reboots the following message appears in the event log:
initdata: Warning: Could not set working set size to 1558528 KB.
so far I cannot find a way to cure this problem, does anyone know a solution.
Thanks
Hi All
I am running a script which has a table creation. The table gets created, but with the below warning.
Warning: The table 'PropertyInstancesAudits' has been created but its maximum row size (8190) 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.
Structure is as under:
Code SnippetCREATE TABLE [dbo].[PropertyInstancesAudits] (
[PIA_ClassID] [uniqueidentifier] NOT NULL ,
[PIA_ClassPropertyID] [uniqueidentifier] NOT NULL ,
[PIA_InstanceID] [uniqueidentifier] NOT NULL ,
[PIA_Value] [sql_variant] NOT NULL ,
[PIA_StartModID] [bigint] NOT NULL ,
[PIA_EndModID] [bigint] NOT NULL ,
[PIA_SuserSid] [varbinary] (85) NULL
) ON [PRIMARY]
GO
How should I get rid of this?
In my SQL 7 log, I get the following message at startup - initdata: Warning: Could not set working set size to 519104 KB.
I have actually constrained the memory settings to be a fixed memory size of 250 MB.
While I have not noticed any problems, does anyone know why the warning message?
Can anyone tell me when I would want to configure 'set working set size'
to 1 on an SQL Server 6.5? I realize that this option tells SQL Server
to request an initial physical memory range equal to the memory
configuration option or equal to memory and tempdb in RAM if that option
is activated.
Please let me know when this would be useful to implement.
Thank you!
Toni Eibner
Hi friends,
I have three servers on two servers I have configured
Server A B C
Total Memory 1024mb 1024 mb 1024 mb
Min Server Memory :200Mb 196mb 196 mb
Max Server Memory 955 mb 980 mb 955 mb
Set working Set size 1 1 1
Priority Boost 1 1 1
All servers using dynamic memory option.
Server A and B are fine but When I reboot or stop and start Sql services on Server C it is recording the following error in NT Application log:
17122: Initdata:Warning:Could not set working set size to 1038848 KB.
Please help me how to overcome this problem.
Thank you very much.
MHUDDIN
Someone asked about this and I was wondering if anyone has any idea.
Thanks in advance.
>>Yesterday in my Windows NT 4.0 Event Viewer I got a message and then I went to the the SQL Server logs and did not find and errors. Microsoft's web site did not have any insite on this issue so I need your help.
>>
>>
>>Category: Kernel
>>17122:
>>initdata: Warning: could not set working size to 259200KB.
>>
>>Please help this seems to be causing some ODBC connection problems to the databases.
Hello,
i am using sql server ce 2.0 for my device application.but this database sometimes gets corrupt,and i am not working with big size datas,if sdf file's size grow up,sdf file's performance gets knock out. for example: work with 50 mb data..what can i do?please somebody help me ?
Hi,
I wrote this sql function which takes a comma seperated string of numbers, splits the numbers seperately and stores it in a table. I have specified the input parameter type as text instead of varchar, the size of the string can get more than 8000.
But the function is not working properly if the input size is more than 8000. For example if the input string is of length 8005 and this is the input string from 7995 to 8005 - '123,124,125'. It works fine till 123 and after that it throws an error, Syntax error converting the varchar value '124,125' to a column of data type int. Can anyone tell me what is wrong with this. I am using string functions like charindex, substring. I can post the full function if you want.
Thanks.
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
Any help with this process?
I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message
native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.
I'll try to post the full log in a new post.
Hi folks,Can anyone enlighten me here? I'm trying to use a SPROC which, when supplied with an int, looks up the table and returns certain columns from it. I'm using a SqlCommand, here's my codebehind: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SqlCommand dataSource = new SqlCommand("retrieveData", new SqlConnection(dbConnString)); dataSource .CommandType = CommandType.StoredProcedure; dataSource .Parameters.AddWithValue("id", poid); dataSource .Parameters.AddWithValue("title", title).Direction = ParameterDirection.Output; dataSource .Parameters.AddWithValue("creator", creator).Direction = ParameterDirection.Output; dataSource .Parameters.AddWithValue("assignee", assignee).Direction = ParameterDirection.Output; etc, etc... And the SPROC:------------------------------------------------------------------------------------------------------------------set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[retrieveData] @id int, @title varchar(50) OUTPUT, @creator varchar(50) OUTPUT, @assignee varchar(50) OUTPUT, @contact varchar(50) OUTPUT, @deliveryCost numeric(18,2) OUTPUT, @totalCost numeric(18,2) OUTPUT, @status tinyint OUTPUT, @project smallint OUTPUT, @supplier smallint OUTPUT, @creationDateTime datetime OUTPUT, @amendedDateTime datetime OUTPUT, @locked bit OUTPUT AS /**SET NOCOUNT ON; **/ SELECT [title] AS [@title], [datetime] AS [@creationDateTime], [creator] AS [@creator], [assignee] as [@assignee], [supplier] as [@supplier], [contact] AS [@contact], [delivery_cost] AS [@deliveryCost], [total_cost] AS [@totalCost], [amended_timestamp] AS [@amendedDateTime], [locked] AS [@locked] FROM purchase_orders WHERE [id] = @id; ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ The id being passed in is definately not null, and is set to a value of an item I know exists. The resulting error is:
Exception Details: System.InvalidOperationException: String[1]: the Size property has an invalid size of 0.Line 63: retrievePODetails.Connection.Open();Line 64: retrievePODetails.ExecuteNonQuery();[InvalidOperationException: String[1]: the Size property has an invalid size of 0.] System.Data.SqlClient.SqlParameter.Validate(Int32 index) +717091... ... Can anyone see anything I'm missing? Thanks,Ally
Using C#, SQL Server 2005, ASP.NET 2, in a web app, I've tried removing the size from parameters of type NCHAR, NVARCHAR, and VARCHAR. I'd rather just send a string and let the size of the parameter in the SP truncate any extra chars if need be. I began getting the error below, and eventually realized it happened only with output parameters, as in the code snippet below.String[3]: the Size property has an invalid size of 0. par = new SqlParameter("@BusinessEntity", SqlDbType.NVarChar); par.Direction = ParameterDirection.Output; cmd.Parameters.Add(par); cmd.ExecuteNonQuery();What's the logic behind this? Is there any way around it other than either finding out what the size should be, or assigning a size larger than would ever be needed? ThanksMike Thomas
View 6 Replies View RelatedI have one db test with one .mdf and .ldf file...mdf file size is 100mb and for some reson i removed all the tablesfrom that .mdf file and transfer it into new secondary file so all thetables moved into secondary file now i want to reduce the first .mdffile from 100 mb to 50mb is that possible,it's showing 90mb is free.Please reply
View 1 Replies View RelatedI want to know encrypted data's size for designing database field size.
For example, cardnumber varchar(20) Encrypted by Triple_DES and PassPhrase, How match size does need to encrypted data store field.
I think the size does not depend to PassPhrase char length.
Regards,
Yoshihiro Kawabata
hi
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 ?
Thanks in advance.
I am getting error to run stored procedure using executenonquery method. The Stored Procedure is having OUTPUT parameter.
ExecuteNonQuery statement is called using SqlHelper.
Error : String[18]: the Size property has an invalid size of 0
Just wanted to know what is a general rule of thumb when determining log file space against a database's data file.We allow our data file for our database to grow 10%, unlimited. We do not allow our log file to autogrow due to a specific and poorly written process (which we are in a three month process of remove) that can balloon the log file size.Should it be 10% of the Data file, i.e. if the Date file size is 800MB the log file should be 8MB?I realize there are a myraid of factors that go against file size but a general starting point would be nice.ThanksJeff--Message posted via http://www.sqlmonster.com
View 4 Replies View RelatedThe Tabular model is showing 19 GB on disk, but it is acquiring around 40 GB in memory.
View 3 Replies View RelatedWhats the cause for this warning, after I query a sqlserver 7 table,
'warning: Null value eliminated from aggregate' ?
Thanks,
Scott
I keep getting this warning, any ideas on how to fix this? Thank you.
View 1 Replies View RelatedHello,
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).
Kindly give the suggestions at earliest.
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?
I typed the following query
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???
hi all..
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 :)
Any comments???
-Jamie
Install on 2003 Server R2 x64 I get this warning and need to now how to fix this:
- ASP.Net Version Registration Requirement (Warning)
Messages
ASP.Net Version Registration Requirement
64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).
Can the 32-bit version co-exist with the 64-bit version APS.Net?
Hello,
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?
Many thanks
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.
Thanks,
John
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
Hi
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.
Any Ideas?
Thanks in advance.
Andy