Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Insufficient Log Data


The mirror database, "UOP_PIMB", has insufficient transaction log data to preserve the log backup chain of the principal database.  This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)

 

I've taken a backup while the database is online and applied it to my "other" server.  What do I need to do to have both in sync to get mirroring to work.  My way around this is to restore the backup to my primary.

 
thanks.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Help! What Is The Risk For Data On Insufficient Hardware?
I am sertainly no SQL expert so I am looking for a bit of help(actually quite desperate).The extra CPU and 1GB of RAM to be added to a server (Compaq DL380 G2:1.4 GHz PIII with a Gig of RAM) have not come in and we are scheduledto go live tomorrow with a MS SQL Server web app. Will potentiallyinsufficient hardware resources endanger the data of other appsrunning on the SQL Server or will the system simply be slow foreveryone?Basically, I need to know whether SQl Server bogs down gracefully(under 2x-3x an acceptable load) or will we be corrupting the databasewith a crash.Thanks a million,Bert

View Replies !   View Related
SSIS Execution Error: The Product Level Is Insufficient For Component &&"data Reader Source&&"
Hi all, while executing my ssis package Im getting this error

"  the product level is insufficient for component "data reader source"  "

 

but through the bussiness intelligence while debugging it was executing successfully,

 but only after deploying the package on to the IS server, while executing getting this error

I checked with the server version also, its was with service pack 2

 

can I get any help

 

thanks in advance

 

 

View Replies !   View Related
Insufficient Memory
Hi All,
Greetings,

Sql Server 7, SP 3
OS: Win NT

Every day i am facing problem with Memory.
I get the below in SQL server Logs

"Insufficient memory available..
Error: 17803, Severity: 17, State: 17"


Please suggest How to solve it.


Thanks in Advance
Adil

View Replies !   View Related
Insufficient Memory
I have a dedicated SQL 2000 on Windows 2K with over 7GB memory, SQL memory configuration is dynamic. This is a new server and doesn't have much processes yet. This morning, SQL logs recorded the error 'insufficient memory available, error 17803, severity 20, state 17'. Does anyone have any clue what could be the cause?
Thanks in advance.

View Replies !   View Related
Insufficient Memory
About once a week I'm receiving this message in the Sqlserver Log from ODS

Error 17803,Severity: 17, State: 14
Insufficient Memory Available

The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.

Chris

View Replies !   View Related
Insufficient Memory
Hi,
I get the following error Error: 17803, Severity: 17, State: 17
Insufficient memory available.Source ODS. When I have lot of scheduled jobs are running during the night. Does anyone know why this happens and how it can be fixed. Let me know.

Thanks

View Replies !   View Related
The Buffer Is Insufficient
Hi all,

I have a strange problem that I need to solve as soon as possible.
I have created two CLR UDTs called point and point_list. Each record of a point_list consists of a list of points. I created a CLR stored procedure which reads some raw data and updates the point_list records.
When I execute the stored procedure the following error appears :

System.Data.SqlTypes.SqlTypeException: The buffer is insufficient. Read or write operation failed.
System.Data.SqlTypes.SqlTypeException:
at System.Data.SqlTypes.SqlBytes.Write(Int64 offset, Byte[] buffer, Int32 offsetInBuffer, Int32 count)
at System.Data.SqlTypes.StreamOnSqlBytes.Write(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BinaryWriter.Write(Char ch) etc ...


Does anybody know what should I do ?
Thanks!

View Replies !   View Related
Insufficient Privileges
After installing Express, I tried running the QuickStart utility and received an error that I have insufficient privileges to create.  I am the administrative user on my laptop and don't understand why I am unable to run the utility.
 
I did have an instance previously and had no problems with it until it was corrupted somehow.
 
I am running on Vista.
 
Any help will be greatly appreciated.

View Replies !   View Related
Insufficient Memory To Run This Query
We seem to have developed a memory leak in our sql server applicationand are getting the above error on occasion. Also, over several hoursof hard usage the memory consumed by the sql server ramps up and isnever released. The only thing we have found to remedy the problem isto stop/start sql server.My question to the group is, how can I debug this problem? Are theresystem stored procedures that would be useful in indentifying any temptables, cursors, etc, not getting cleaned up?Thanks,John

View Replies !   View Related
Key Column Information Is Insufficient ....II
This is the case.... I would like to learn the statement that make therelation between these tables.Why? Cos these are separated in two different databases and if a usermake an update in a table from database X these changes must to beapplied in the other table in the another database:The tables are :Principal Database Name : Server Information 2004Table Name : ClientsFields : ID_Client, ClientSecondary Database Name : Index2003Table Name : ContratosFields : ID_Con, ID_Client, ClientI need to write a Trigger for Update the table Contratos everytime auser change the values in Clients.I´m using the follow Trigger :CREATE TRIGGER UPDate_Clients ON dbo.ClientsFOR UPDATEASupdate Contratosset Client = inserted.Clientfrom Clientsinner join inserted on Clients.Client = inserted.ClientWhen I update the register the follow message in the application raise :"Key column information is insufficient or incorrect. Too many rows wereaffected by update."If somebody can help me THANKS A LOT OF....Leonardo Almeida*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
Key Column Information Is Insufficient ....
This is the case.... I would like to learn the statement that make therelation between these tables.Why? Cos these are separated in two different databases and if a usermake an update in a table from database X these changes must to beapplied in the other table in the another database:The tables are :Principal Database Name : Server Information 2004Table Name : ClientsFields : ID_Client, ClientSecondary Database Name : Index2003Table Name : ContratosFields : ID_Con, ID_Client, ClientI need to write a Trigger for Update the table Contratos everytime auser change the values in Clients.I´m using the follow Trigger :CREATE TRIGGER UPDate_Clients ON dbo.ClientsFOR UPDATEASupdate Contratosset Client = inserted.Clientfrom Clientsinner join inserted on Clients.Client = inserted.ClientWhen I update the register the follow message in the application raise :"Key column information is insufficient or incorrect. Too many rows wereaffected by update."If somebody can help me THANKS A LOT OF....Leonardo Almeida*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
Insufficient Memory Error
My company has a database that is throwing a weird error. We've tried reinstalling both the OS and the SQL instance, and the error still persists. We think this error might have to do with some .NET code we've written to run on the box, but I cannot find anything out on the internet about it. Here is the Enterprise Manager Error Log:


Insufficient memory available..
Error: 17803, Severity: 20, State: 4
Query Memory Manager: Grants=0 Waiting=0 Maximum=97638 Available=97638
Global Memory Objects: Resource=912 Locks=42
SQLCache=67 Replication=2
LockBytes=2 ServerGlobal=20
Xact=12
Dynamic Memory Manager: Stolen=2138 OS Reserved=1048
OS Committed=1026
OS In Use=1022
Query Plan=1777 Optimizer=0
General=1066
Utilities=12 Connection=262
Procedure Cache: TotalProcs=488 TotalPages=1787 InUsePages=542
Buffer Counts: Commited=5168 Target=131072 Hashed=1917
InternalReservation=191 ExternalReservation=0 Min Free=128 Visible= 131072
Buffer Distribution: Stolen=351 Free=1113 Procedures=1787
Inram=0 Dirty=599 Kept=0
I/O=0, Latched=23, Other=1295
WARNING: Failed to reserve contiguous memory of Size= 65536.


I can find information if I do a Google search on "Error: 17803, Severity: 20" But as soon as I add "State: 4" to the query I get no results. Also, the articles that I have seen that give the same error messages (but different states) tend to deal with servers that have more than 4GB of memory. This server has ONLY 4GB of memory and in order to try and resolve this issue, we have limited the server to 1GB of physical memory to no avail.

Any help would be appreciated. Thanks!

View Replies !   View Related
Insufficient Memory Error
When I execute the very long query(in the attached), I got an insufficient memory error, Please help me check. Thanks in advance.

View Replies !   View Related
SQL Insufficient Memory Errors
Here's the deal.....

I was converting a lot of MS Access records to SQL Server (almost 500,000)
and about midway through I got the old MSACCESS.EXE Not Responding. A few
more times through this and SQL Server informed me that I was running out
of locks. I upped the locks from 5000 to 20000, and retried it. I am now
getting errors like "There is insufficient system memory to run this
query". I receive this when I attempt to look at tables, devices, etc. In
SQL Enterprise Manager. I am also not able to run the sp_configure command
or choose configure by right-clicking on the server in Ent. Mgr. I am
running SQL Server 6.5, SP4, on a dual P200 with 256MB RAM. Any help would be
incredibly great.

Rob

View Replies !   View Related
Insufficient OPEN OBJECTS With 6.5
Hi,

I have had the error message "Warning : OPEN OBJECTS
parameter may be too low" using 6.5.
We raised the value from 500 to 1000 a few months ago but
still get the error message.
One could just keep raising the value (it does not use
much memory) until the problem goes away?
The online help Error 603 states that it could be due to
running a complex SQL query, but it is vague.
Strangely, our sister hospital
with the same software/hardware/setup etc. does not get this
error.

We plan to move to SQL Server 7 in 4-6 weeks & I assume that
this will fix this issue as its auto-configurable.

I am responsible for 2 other SQL 7 applications & have not
had this problem with these applications.

Any ideas?
Andrew

View Replies !   View Related
Insufficient Memory To Continue
I am running a .sql file containing a large number of delete and insert statements, using isql from the command line. After 2 minutes I get a message "Insufficient memory to continue", same statements if I cut and paste in SQL server query analyzer I do not get this message. On looking at the
task manager, it shows a lot of available memory.

Any clues

Thanks in advance

View Replies !   View Related
Insufficient Disk Space
I'm trying to save a dts package and it keeps coming back with insufficient disk space. I noiticed that db MSDB was full so I manually increased the size. It was set to manually grow at 1 mb increments. But for some reason it didn't look like it was doing that so I manually increased it. Right now this is about 355 MB free so that should be plenty to save a package. But its still coming back with the same error insufficient disk space to complete operation. Any ideas on why or why it didn't grow on its own? Please help I can't seem to save any packages.

View Replies !   View Related
Insufficient Key Column...error. Why??
Hiya!
I have a static, optimistic ADO recordset in VB6 selecting rows from a view definition which selects fields (includes all primary keys!) from two tables using a right join on the table whose fields I absolutely need. My update affects only one table (the right one), yet I am getting an error "Insufficient key column info for updating or refreshing", NativeError is 1007, which does not match any SQL error in BOL, and source gives me Microsoft Cursor Engine, although my cursor type is fine for updating. Any clues?

Thanks,
Sarah

View Replies !   View Related
Insufficient Buffer Zone
hello again,

This is another pending issue.

It is another package accessing the same database of the same system ("Sage" for commercial and accounting operations).

When run, it gives an error message, as following (also translated from french):
Simba ODBC Driver[CBase]: Very Small/Insufficient Buffer Zone. Data is truncated.

it seems there is a bug in the database, as when we run the same package on another database, it runs successfully.

It may be possible that the database needs a maintenance. Is it possible to advise how to do it, if it is so?
May you help in helping resolve this issue?
thank you in advance.

LeĂŻla
P.S: How is it possible to attach a file?

View Replies !   View Related
SQL Error 701 Insufficient Memory
We have an application running on a SQL cluster (Win 2003) and SQL 2005 SP2 within it's own instance - 12 total databases and about 100G of data total. The node this instance is on has 64G of RAM with 16 allocated to this instance (only 8G allocated to other instances currently).

Now to the problem there is one process that when running we get the error below and we cannot figure how to correct this - the process runs 8 times a day and has been running great and then all of a sudden stopped running with the memory error. I am in search of any tips to diagnose or correct this issue

[298] SQLServer Error: 701, There is insufficient system memory to run this query. [SQLSTATE 42000]

Thanks in Advance

View Replies !   View Related
Insufficient System Memory
We are hitting a crippling 701 "insufficient System Memory" error intermittently in out production environment. I haven’t gotten anywhere with PSS in two weeks. The error has occurred 4 times over the past two weeks, crippling our SQL server and application each time. When the error occurs it lasts for 5 to 20 minutes, causing the app to time out, refusing new connections, and a massive slow-down of anything that is running. SQL has recovered on its own two of these times. It recovered following a Kill of hundreds of threads reporting “SEMAPHORE WAIT�. The most recent occurrence nailed all 16 processors at 100%. We were forced to issue shutdown with nowait. I have been monitoring Perfmon very closely; there are no symptoms that precede the error. Each occurrence captures a different query. Any of the queries, when run from Management Studio, complete in under a second. DBCC MEMORY STATUS reports all memory as being in an unstressed state. The first time the error occurred there were 10 GB still available on the server.

Has anyone else experienced this problem or anything similar? We don’t use linked servers or table valued functions (there are known memory bugs related to each of these items)

The following server and configuration has been running in production for 6 weeks with no issues:

.SQL 2005 EE SP1 Post SP1 Hotfix kb918222
.Win 2003 SP1 (dedicated box)
.Quad Dual Core 3GHz
.32 GB memory
.AWE enabled
.No memory related flags in boot.ini
."Lock Pages in memory" set for SQL Startup account
.1 Instance (default)
.1,994 OLTP databases avg less than 100MB each
.1,200 active user threads on average (from connection pool of avg 4,000 concurent users)

Any comments would be appraciated

View Replies !   View Related
Product Level Is Insufficient
I am receiving the following error when I try to execute an SSIS package that is saved to a structured file.  I am using DTExec to execute the package.

Description: The task "Initialize Variables" cannot run on this edition of Integration Services. It requires a higher level edition.

After some research, I was able to find a supporting article in SQL Server 2005 BOL at http://msdn2.microsoft.com/en-us/library/aa337371.aspx

The issue was resolved by installing the Enterprise Edition of SQL Server Integration Services (Windows Service) on the local server (server where the package is saved and executed from).  However, this goes against my original anticipation that the SSIS Windows Service would only need to be installed on a machine where I needed to store packages and/or monitor package execution.  Not if I wanted to execute packages. 

Unfortunately, my package is using advanced options (as identified in the BOL article previously referenced).

Am I missing something??

Sincerely,

Sean Fitzgerald

View Replies !   View Related
Product Level Insufficient
I am trying to run dtexec on some DTSC packages I created using SSIS.  I keep getting the error "The product level is insufficient for the component".  Anybody know what this means?

Thanks,

Michael D. Fox

View Replies !   View Related
Insufficient System Memory
Just wondering if anyone else has seen any memory issues with cross instance communication.  Just this last week we moved from single instance to cross instance communication.  I started up a process that will move 3,000,000 messages through service broker, but after a couple of hours the server tanks out and we get insufficient system memory errors in the sql error log.  If no one else has seen or experienced this then I'll probably get a ticket opened to see what it may be.  It's just that the change in our service broker network was the only change I was aware of on this instance.

Regards.

 

View Replies !   View Related
SPROC Won't Execute - Insufficient Permissions
I'm trying to use the SPROC below (courtesy of Erland!) to capture theerror message but it fails owing to insufficient permissions (I can'treproduce it just now, but I think it's because it can't get access tothe DBCC OUTPUTBUFFER).How do I give the SPROC permission to execute?Many thanksEdwardCREATE PROCEDURE stpShowErrorMessage @errmsg nvarchar(500) OUTPUT ASDECLARE @dbccrow nchar(77),@msglen int,@lenstr nchar(2),@sql nvarchar(2000),@s tinyint-- Catch the output buffer.CREATE TABLE #DBCCOUT (col1 nchar(77) NOT NULL)INSERT INTO #DBCCOUTEXEC ('DBCC OUTPUTBUFFER(@@spid)')-- Set up a cursor over the table. We skip the first-- row, because there is nothing of interest.DECLARE error_cursor CURSOR STATIC FORWARD_ONLY FORSELECT col1FROM #DBCCOUTWHERE left(col1, 8) <> replicate('0', 8)ORDER BY col1-- Init variable, and open cursor.SELECT @errmsg = ''OPEN error_cursorFETCH NEXT FROM error_cursor INTO @dbccrow-- On this first row we find the length.SELECT @lenstr = substring(@dbccrow, 15, 2)-- Convert hexstring to intSELECT @sql = 'SELECT @int = convert(int, 0x00' + @lenstr + ')'EXEC sp_executesql @sql, N'@int int OUTPUT', @msglen OUTPUT-- @s is where the text part of the buffer starts.SELECT @s = 62-- Now assemble rest of string.WHILE @@FETCH_STATUS = 0 AND datalength(@errmsg) - 1 < 2 * @msglenBEGINSELECT @errmsg = @errmsg + substring(@dbccrow, @s + 1, 1) +substring(@dbccrow, @s + 3, 1) +substring(@dbccrow, @s + 5, 1) +substring(@dbccrow, @s + 7, 1) +substring(@dbccrow, @s + 9, 1) +substring(@dbccrow, @s + 11, 1) +substring(@dbccrow, @s + 13, 1) +substring(@dbccrow, @s + 15, 1)FETCH NEXT FROM error_cursor INTO @dbccrowENDCLOSE error_cursorDEALLOCATE error_cursor-- Now chop first character which is the length, and cut after end.SELECT @errmsg = substring(@errmsg, 2, @msglen)GO

View Replies !   View Related
Key Column Information Is Insufficient Or Incorrect
Dear Friends,I have table contain 2000 out of those some areduplicate when i select duplicate records by using Enterprise Managerand make modification to one of those duplicate records the followingmessage flashes/display.key columen information is insufficient or incorrect.Too many rows wereaffected by updatepls suggest what is this and how to solve this problemThanks in advanceDinesh Patwal

View Replies !   View Related
There Is Insufficient System Memory To Run This Query
Help,

Getting this error msg when running a bulk insert.
Bulk insert was working fine before and all of a sudden getting this.

Any Ideas?

View Replies !   View Related
Insufficient Memory SQL Server 2000
Currently, I am experiencing memory problems with SQL Server 2000. Daily, I have many "Insufficient memory available" errors in my SQL logs, and "A time out occurred while waiting for memory resources to execute the query. Re-run the query." messages. I have already enabled Address Windowing Extensions. I do not have the /3GB in my boot.ini, but the /PAE is. Implemented is a startup option, -g256, which made no difference, but it is in place. Also, SQL Server is configured for thread mode processing. When I run the PerfMon, SQL Server: Memory Manager, and add up Maximum Workspace Memory, Connection Memory, Lock Memory, Optimizer Memory, and SQL Cache Memory I get around 1.2GB not anywhere near the 6.8GB that the SQL Server process has reserved.

System Summary: SQL Server 2000 Enterprise Edition; Windows 2000 Advanced Server; DELL PE8450 8-Way, 700 Mhz, 8GB RAM, MDAC 2.6.

Has anyone experienced memory problems with SQL Server 2000? The same code ran on 7.0 without this problem. Any help would be very appreciated.

Thank you.

View Replies !   View Related
Err -2147467259 Insufficient Key Column Information
I had an error -2147217887, with a server side cursor - MSDN says change to client side to get the error info i.e. server side cursor will not return error info
the code - which then returned -2147467259

Error: Insufficient key column information for updating or refreshing.
Error: -2147467259
Microsoft Cursor Engine

MSDN search gave no hits on this number
The cursor is updateable and dynamic - and rs.Supports give a recordset that supports addnew, update and delete

Any further suggestions would be much appreciated

View Replies !   View Related
Insufficient Memory To Continue The Execution
I have scheduled a SSIS package to run repeatedly by creating a scheduled SQL job that runs every minute . After every hour the packgae fails with the following error

Description: System.OutOfMemoryException: Insufficient memory to continue the execution of the program. at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSCustomProperty90.get_Value() at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent() End Erro

The strange thing is that if i right click on SQL JOb and run it...it works fine.


Did anyone encounter similar problem or know the solution of the above problem ?

Thanks....

View Replies !   View Related
The Product Level Is Insufficient For Component...
Hi. I'm using SQL Server 2005 Management Studio to try and run an SSIS package. One step blows up with this error: "The product level is insufficient for component "data conversion 1"". I checked out the thread here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1&PageID=0

However, after installing SP1, the program is still giving me the error. I'm running the package from my WinXP Pro SP2 workstation. What am I missing? Thanks.

View Replies !   View Related
The Product Level Is Insufficient For Component
hi,

I am very new to SSIS. I have created a small application in which the data flow task contains OLEDB source, derived column and datareaderdest.When i run dtexecui.exe and execute the package i am getting these errors

The product level is insufficient for component "Derived Column"

The product level is insufficient for component "DataReaderDest"

But i am not geeting any warning or error when i debug the solution.

Please help me on this.

Thanks in advance

 

 

View Replies !   View Related
The Product Level Is Insufficient For Component
We are trying to run SSIS DTSX packages from a VB.Net 2005 application and we get this error : The product level is insufficient for component.

The server is SQL 2005, the clients (for which the VB application is run from) have SQL 2005 Client tools (since there are running XP).

I know this is a known issue, as SP1 corrected the import/export problem in Management Studio, can we expect a similar fix when using SSIS locally on a client's machine via a VB.Net application and SQLServer 2005 assemblies ? 

We are currently in the process of migrating our VB.Net 2003/ SQL2000 applications to VB.Net 2005/ SQL2005 and do not want to change the way we process our data, as we expected 2005 version to have the same functionality as 2003.

Thanks,

Patrick

View Replies !   View Related
The Product Level Is Insufficient For Component
I´m having this trouble (The product level is insufficient for component "flat file.txt") executing a ssis package using dtexec from a store procedure.

The database is SQL Server 2005 Express Edition with Advanced Services SP1 and Microsoft SQL Server 2005 Express Edition Toolkit SP1.

If anyone knows how to solve this problem i would be very thankful

 

 

View Replies !   View Related
Product Level Is Insufficient Error
Configuration: Windows XP Pro with SQL 2005 Workgroup Sp2

Hi, we have a package that runs fine in BI Studio but fails with the following error when executing it using DTExec.


   Code: 0xC00470FE
   Source: Data Flow Task DTS.Pipeline
   Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW.  The product level is insufficient for component "Derived Column" (10660).

The package imports a CSV into a table mapping some columns. The MSDN article at http://msdn2.microsoft.com/en-us/library/ms143761.aspx describes features supported by different versions.

The article says OLE DB source/destination adapters are supported in WG edition but a couple of lines later seems to imply that all source/destination adapters are not supported in WG.

Could you clarify whether stuff like import of a csv into a table with some column mappings should work in WG edition? Also if we have a legacy SQL 2K package doing the same thing, will that work in WG edition? Thx.





Features/Integration Services Enhancements
EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)
SE (32-bit)
WG (32-bit)
SSE (32-bit) SSEA (32-bit)
SE (64-bit)



SQL Server Import and Export Wizard and supporting connections, source and destination adapters, and tasks


Yes


Yes


Yes


No


Yes



Execute SQL Task


Yes


Yes


Yes


No


Yes



OLE DB Source and Destination Adapters


Yes


Yes


Yes


No


Yes



SSIS command prompt tools


Yes


Yes


Yes


No


Yes



SSIS Package Designer


Yes


Yes


Yes


No


Yes



Legacy support for DTS packages


Yes


Yes


Yes


Yes


Yes



SSIS Service


Yes


Yes


No


No


Yes



All other source and destination adapters, tasks, and transformations, except for those listed below


Yes


Yes


No


No


Yes

View Replies !   View Related
Distribution Agent Insufficient Permissions
Hi,

I am trying implement replication and having problem when creating push subscription to an existing transactional replication publication.
The distribution agent is failing to run its job with the error:

Agent message code 14260. You do not have sufficient permission to run this command. Contact your system administrator.

I followed the http://msdn2.microsoft.com/en-us/library/ms151868.aspx article instructions when I set the distribution agent properties

What did I miss?

The following is the step error message:
Date        1/12/2007 2:30:01 PM
Log        Job History (105342-DB3PROD-MOMA-ArchivedTransactions-105337-DEV2-15)

Step ID        2
Server        105342-DB3PROD
Job Name        105342-DB3PROD-MOMA-ArchivedTransactions-105337-DEV2-15
Step Name        Run agent.
Duration        00:00:00
Sql Severity        0
Sql Message ID        0
Operator Emailed       
Operator Net sent       
Operator Paged       
Retries Attempted        0

Message
2007-01-12 19:30:01.258 Microsoft SQL Server Replication Agent: distrib
2007-01-12 19:30:01.258
2007-01-12 19:30:01.258 The timestamps prepended to the output lines are expressed in terms of UTC time.
2007-01-12 19:30:01.258 User-specified agent parameter values:
            -Subscriber 105337-DEV2
            -SubscriberDB MOMA
            -Publisher 105342-DB3PROD
            -Distributor 105342-DB3PROD
            -DistributorSecurityMode 1
            -Publication ArchivedTransactions
            -PublisherDB MOMA
            -XJOBID 0x65C41EBC553D96439BAF69E4DC3CC823
            -XJOBNAME 105342-DB3PROD-MOMA-ArchivedTransactions-105337-DEV2-15
            -XSTEPID 2
            -XSUBSYSTEM Distribution
            -XSERVER 105342-DB3PROD
            -XCMDLINE 0
            -XCancelEventHandle 00000000000006E8
2007-01-12 19:30:01.258 Startup Delay: 214 (msecs)
2007-01-12 19:30:01.477 Connecting to Distributor '105342-DB3PROD'
2007-01-12 19:30:01.618 Agent message code 14260. You do not have sufficient permission to run this command. Contact your system administrator.

View Replies !   View Related
CHECDB Failed - Insufficient Memory
 

Hi There
 
Ok i am a bit stumped by this one.
 
I have an instance of sql server 2005 Enterprise Edition 9.0.3152.
 
The server has 32 Gigs of RAM. Sql Server is AWE enabled and is configured to use 14Gigs MAX memory (it is in a cluster so it is configured so that way for fail over).
 
When i perform the following command on a 1.9 Gig database on the server:
 

dbcc checkdb('CLMS', NOINDEX)WITH NO_INFOMSGS

 
I get the following error message:
 

Msg 701, Level 17, State 123, Line 1

There is insufficient system memory to run this query.

 
I am stumped i can see the server has 17 Gigs of available memory.
 
After this i perform the folloing query :
 
dbcc checkdb('OLTP1PRO', NOINDEX)WITH NO_INFOMSGS
 
This database is 140 Gigs and checdb works no problem.
 
What the hell is going on ? I have never received this error before with CHECKDB, and it is ahppening on the smallest database on the instance while the exact same checdb works fine for all the other larger db's on the instance ?
 
Please help.
 
Thanx

View Replies !   View Related
17803 Insufficient Memory During Xp_sqlagent
HI,
 
We have got this error on a server after a reboot, now i can appreciate that the server went into recovery after a shutdown cos of services still doing stuff when the shutdown occured.. and this worked
 
the machine has 4 gig of mem and as you can see from log 4 cpu...we are running sql server 2000 sp4
 
log file from errorlog..any ideas
 2007-09-17 10:21:20.39 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
May  3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-09-17 10:21:20.39 server    Copyright (C) 1988-2002 Microsoft Corporation.
2007-09-17 10:21:20.39 server    All rights reserved.
2007-09-17 10:21:20.39 server    Server Process ID is 2036.
2007-09-17 10:21:20.39 server    Logging SQL Server messages in file 'D:Microsoft SQL ServerMSSQLlogERRORLOG'.
2007-09-17 10:21:20.45 server    SQL Server is starting at priority class 'normal'(4 CPUs detected).
2007-09-17 10:21:20.60 server    SQL Server configured for thread mode processing.
2007-09-17 10:21:20.64 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-09-17 10:21:21.01 server    Attempting to initialize Distributed Transaction Coordinator.
2007-09-17 10:21:23.18 spid3     Starting up database 'master'.
2007-09-17 10:21:23.73 spid3     0 transactions rolled back in database 'master' (1).
2007-09-17 10:21:23.73 spid3     Recovery is checkpointing database 'master' (1)
2007-09-17 10:21:23.81 server    Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-09-17 10:21:23.81 spid5     Starting up database 'model'.
2007-09-17 10:21:23.82 server    SQL server listening on 128.1.100.121: 1433.
2007-09-17 10:21:23.82 server    SQL server listening on 127.0.0.1: 1433.
2007-09-17 10:21:23.85 spid3     Server name is 'LDS-SSQL1'.
2007-09-17 10:21:23.85 spid8     Starting up database 'msdb'.
2007-09-17 10:21:23.85 spid10    Starting up database 'Sample_1'.
2007-09-17 10:21:23.85 spid9     Starting up database 'C8DM_Catalogs_RnD'.
2007-09-17 10:21:23.90 server    SQL server listening on TCP, Shared Memory, Named Pipes.
2007-09-17 10:21:23.90 server    SQL Server is ready for client connections
2007-09-17 10:21:23.90 spid11    Starting up database 'c8content'.
2007-09-17 10:21:23.90 spid12    Starting up database 'DataWarehouse'.
2007-09-17 10:21:23.90 spid13    Starting up database 'C8DM_Catalogs'.
2007-09-17 10:21:23.93 spid14    Starting up database 'DW_DS'.
2007-09-17 10:21:24.01 spid5     1 transactions rolled forward in database 'model' (3).
2007-09-17 10:21:24.04 spid5     0 transactions rolled back in database 'model' (3).
2007-09-17 10:21:24.04 spid5     Recovery is checkpointing database 'model' (3)
2007-09-17 10:21:24.18 spid5     Clearing tempdb database.
2007-09-17 10:21:24.28 spid13    113 transactions rolled forward in database 'C8DM_Catalogs' (9).
2007-09-17 10:21:24.37 spid8     199 transactions rolled forward in database 'msdb' (4).
2007-09-17 10:21:24.37 spid10    64 transactions rolled forward in database 'Sample_1' (6).
2007-09-17 10:21:24.39 spid10    0 transactions rolled back in database 'Sample_1' (6).
2007-09-17 10:21:24.42 spid13    0 transactions rolled back in database 'C8DM_Catalogs' (9).
2007-09-17 10:21:24.45 spid10    Recovery is checkpointing database 'Sample_1' (6)
2007-09-17 10:21:24.48 spid13    Recovery is checkpointing database 'C8DM_Catalogs' (9)
2007-09-17 10:21:24.49 spid9     49 transactions rolled forward in database 'C8DM_Catalogs_RnD' (5).
2007-09-17 10:21:24.51 spid9     0 transactions rolled back in database 'C8DM_Catalogs_RnD' (5).
2007-09-17 10:21:24.53 spid9     Recovery is checkpointing database 'C8DM_Catalogs_RnD' (5)
2007-09-17 10:21:24.59 spid5     Starting up database 'tempdb'.
2007-09-17 10:21:24.60 spid8     0 transactions rolled back in database 'msdb' (4).
2007-09-17 10:21:24.64 spid8     Recovery is checkpointing database 'msdb' (4)
2007-09-17 10:21:27.60 spid12    Analysis of database 'DataWarehouse' (8) is 8% complete (approximately 4 more seconds)
2007-09-17 10:21:28.12 spid14    Analysis of database 'DW_DS' (10) is 100% complete (approximately 0 more seconds)
2007-09-17 10:21:31.09 spid14    31 transactions rolled forward in database 'DW_DS' (10).
2007-09-17 10:21:31.10 spid14    0 transactions rolled back in database 'DW_DS' (10).
2007-09-17 10:21:31.14 spid14    Recovery is checkpointing database 'DW_DS' (10)
2007-09-17 10:21:36.00 spid12    Analysis of database 'DataWarehouse' (8) is 100% complete (approximately 0 more seconds)
2007-09-17 10:21:36.01 spid12    Recovery of database 'DataWarehouse' (8) is 0% complete (approximately 54 more seconds) (Phase 2 of 3).
2007-09-17 10:21:36.98 spid12    Recovery of database 'DataWarehouse' (8) is 9% complete (approximately 9 more seconds) (Phase 2 of 3).
2007-09-17 10:21:41.78 spid12    Recovery of database 'DataWarehouse' (8) is 56% complete (approximately 3 more seconds) (Phase 2 of 3).
2007-09-17 10:21:47.92 spid12    Recovery of database 'DataWarehouse' (8) is 100% complete (approximately 0 more seconds) (Phase 2 of 3).
2007-09-17 10:21:47.92 spid12    25 transactions rolled forward in database 'DataWarehouse' (8).
2007-09-17 10:21:48.10 spid12    0 transactions rolled back in database 'DataWarehouse' (8).
2007-09-17 10:21:48.20 spid12    Recovery is checkpointing database 'DataWarehouse' (8)
2007-09-17 10:21:48.37 spid3     Recovery complete.
2007-09-17 10:21:48.37 spid3     SQL global counter collection task is created.
2007-09-17 10:21:49.95 spid51    Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.
2007-09-17 10:22:33.24 spid53    Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_sqlagent_monitor'.
2007-09-17 10:23:55.17 spid58    Error: 17803, Severity: 20, State: 12
2007-09-17 10:23:55.17 spid58    Insufficient memory available..

View Replies !   View Related
Permissions Are Insufficient For Performing ListChildren()
I'm developing an asp.net app that will list the reports available on the report server.  The app works OK on my local machine but when I deploy it I run into a permissions problem:

 Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation.  at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow()  at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()  at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems)  --- End of inner exception stack trace ---  at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems)  at Microsoft.ReportingServices.WebServer.ReportingService2005.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems)

My code uses the DefaultCredentials:
ReportingService2005 rService = new ReportingService2005();rService.Credentials = System.Net.CredentialCache.DefaultCredentials;
CatalogItem[] catalogItems;
catalogItems = rService.ListChildren("/", true);
I can avoid the exception if I use the Administrator account:

System.Net.CredentialCache cache = new System.Net.CredentialCache();// Add a NetworkCredential instance to CredentialCache.// Negotiate for NTLM or Kerberos authentication.cache.Add(new Uri(ReportServer), "Negotiate", new System.Net.NetworkCredential("Administrator", "<password>", "<domain>")); //Assign CredentialCache to the Web service Client Proxy(myProxy) Credentials property.rService.Credentials = cache;

I'm pretty sure using the Administrator account here is not the best practice.  Any suggestions?

Thanks,
Al

View Replies !   View Related
An Insufficient Number Of Arguments To Function....
Hi all
 
I have select statement which is using Function and I am passing arguments to the query
 
 
select * from funactin_name(@a,@b,@c) 
 
It is giving an error saying is that "An insufficient number of arguments to function..."
 
some body help how to find out required arguments to the function by using QA.
 

View Replies !   View Related
ADO Error: An Insufficient Number Of Arguments....
 

Im currently using Access 2000 which is connected to a SQL database. I have a query (Or View) that runs every month. The problem i had was i had to manually make some changes every month to get to the data i needed so i changed this View into a Function with a parameter so i can input the detail(s) i need and it will run correctly - this works so far but the original View was also used within other queries that were created. Now the problem i have now is some of the other views that are now connected with the newly created Function comes up with the error:
 
ADO error: an insufficient number of arguments were supplied for the procedure or function Name_Of_Function.
 
I called the newly created function the exact name as the original view to ensure i had no problems. Any idea of whats happening here and how to resolve?
 
Thanks

View Replies !   View Related
Error - There Is Insufficient System Memory To Run This Query.
Hello,

We receive this error after running a complex query. Could someone please shed some light on what this means exactly?

One of our developer said we needed to purchase a server with more memory, but would SQL Server not simply just run slower by using virtual memory instead of physical RAM?

I know there is a limit and servers must be upgraded as the processing requirements increase, due to data set size increases for example, but we have just been told to "purchase more power because after a while as you process more rows, SQL Server will require more resources"

Any comments on this would be really appreciated.

View Replies !   View Related
Error: There Is Insufficient System Memory To Run This Query
We're experiencing the following problem on our servers:

Server: Msg 701, Level 17, State 1, Line 3
There is insufficient system memory to run this query.

I've been able to fix the problem by a)Lowering the Max Server Memory and b)Minimum Query Memory.

However, Microsoft state there is a hot fix available for this issue at in KB Article 817262 (
http://support.microsoft.com/default.aspx?scid=kb;en-us;817262&Product=sql2k).

Any idea how one is supposed to contact Microsoft to get this fix without paying?

Thanks,

Nick

View Replies !   View Related
Scheduled Job Fails With &#39;EXCEPTION - Insufficient Memory&#39;
A series of export/import jobs are scheduled on a dozen databases sitting on one of our servers, and are run at regular intervals through the day. Some of the jobs are failing with the following error recorded in the 'View Job History..':

EXCEPTION: Insufficient memory for this operation. Process Exit Code 2. The step failed.

Will this be cured by increasing the memory available to SQL Server (it has 512Mb already, 1/2 of the total physical RAM)? Also, why are only some jobs failing and others completing? Should I run performance monitor when the next schedule is?

Thanks

Derek

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved