Expired subscription clean up - Failed

Hi,
I have a merge replicate setup and is working fine.
Suddenly since last 4-5 days my "Expired subscription clean up" stored
procedure started failing.
The error message in the job history is
Unable to connect to SQL Server '(local)'. The step failed.
Can somebody help me to resolve this issue.
Thank you
Sam
Hi guys,
I found the solution for this problem so posting it here for otheres.
http://support.microsoft.com/kb/q296792/
thanks you
Sam
"sam" wrote:

> Hi,
> I have a merge replicate setup and is working fine.
> Suddenly since last 4-5 days my "Expired subscription clean up" stored
> procedure started failing.
> The error message in the job history is
> Unable to connect to SQL Server '(local)'. The step failed.
> Can somebody help me to resolve this issue.
> Thank you
> Sam

Expired Subscription Agent is failing

I have recently setup a Merge Publication with two other servers subscribing
to it. While I was checking the progress of the sync I have noticed that
Expired Subscription Agent is failing. The error it is giving is:
Invalid object name 'sysarticleupdates'. [SQLSTATE 42S02] (Error 208).
Has anyone got any suggestions?
This is probably symptomatic of much larger problems.
I would find a SQL Server with the same version and sp, locate
sysarticleupdates, right click on it in EM, select copy and then paste it
into your subscription database on your subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Russell" <Russell@.discussions.microsoft.com> wrote in message
news:7B52FB71-6159-4818-85EC-7216AB277473@.microsoft.com...
> I have recently setup a Merge Publication with two other servers
subscribing
> to it. While I was checking the progress of the sync I have noticed that
> Expired Subscription Agent is failing. The error it is giving is:
> Invalid object name 'sysarticleupdates'. [SQLSTATE 42S02] (Error 208).
> Has anyone got any suggestions?

expanding databases in SQL 6.5

I have a SQL 6.5 database that we parse some data into everyday using
an access program. All this was devises and setup by a programmer that
I can't get in contact with anymore and it has actually run for about
five years without a hickup! But just a few days ago our parsing
program just stops dead before completing and I did get this error
message.

"exportaLLdataToSQLifnoerror(): number 3146 Description- odbd- call
failed. [Micorsoft][odbc SQL Server Driver] [sql server] Can't
allocate space for object 'syslogs' in database 'newpdatasql' because
the 'logsegment' segment is full. If you ran out of space in Syslogs,
dump the transaction log. Otherwise, use ALTER DATABASE or
sp_extendsegment to increase the size of the segment. (#1105)"

I have looked at the database in SQL referred to and I notice that it
says there is 200 MEg allocated for the log size and 250 meg for the
data size and that in both categories there is "0" space available.
When I select "EXPAND" on this page it takes me to a screen which has
a graphical presentation with a bar chart showing the available space
in red and the used space in blue on each of what it refers to as
'database devices". There are 10 items shown--
Temp_DB available space 30 used 30, Newplog 200 available 200 used,
NewpDev 250 available 250 used, MSDBlog available 2.00 used 2.00,
MSDBData 6 available 6 used, Master 50 available 50 used, Data_log
2.00 available 2.00 used, Dale_data 12 available 12 "free space" (
this one says free space instead of used?), Contact_log 25 available
15 used, Contact_dev 100 available 75 used.

So I can see on the first screen that there was 450 meg allocated to
this database called newpdatasql and that all 450 is being used. And
when I go to the next screen that shows the devices in this database
that many of them show that their available space is completely used.

The fix is probably to expand the available space for the database. On
the second graphical screen that shows the bar chart there is an
button called "expand now" that is greyed out except when you select
the different devices in a drop-down box at the top of the screen.
There are two drop down boxes -- one titled "data devices and one
titled log devices. THe only time the Expand now button is not greyed
out is when I select "Dale_Data, "Contact_log", or "Contact_dev". I
did select the "contact_Dev" device clicked on expand and it seemed to
I guess expand this device to a fully used level as after I did this
it says that the space available is still 100 meg ( see comments
above) but now instead of 75 used it says 100 used! Progress or what?
I guess I could do this for the other devices as well. One issue for
me is whether when the space available for a device is the same as the
space used does this mean that it is at maximum capacity in terms of
data or only that the space available on the disk for this device is
completely being made available as potential storage space?

Interestingly the original error message mentions "syslogs" and
"logsegment" neither are available as devices or are named in the
screens relating to database expansion.

Any help would be greatly appreciated.

My tollfree number is 866-957 1081.

Jeffrey Kilpatrick[posted and mailed, please reply in news]

Jeffrey Kilpatrick (jeff@.newportsecurities.com) writes:
> "exportaLLdataToSQLifnoerror(): number 3146 Description- odbd- call
> failed. [Micorsoft][odbc SQL Server Driver] [sql server] Can't
> allocate space for object 'syslogs' in database 'newpdatasql' because
> the 'logsegment' segment is full. If you ran out of space in Syslogs,
> dump the transaction log. Otherwise, use ALTER DATABASE or
> sp_extendsegment to increase the size of the segment. (#1105)"

On SQL 6.5 the transaction is a table, syslogs. So what happened is
that you run out of log space.

This could happen because the data import actually needs 200 MB of
log space, so your regular dumping of the transaction log does not
help.

But it could also you have never taken any transaction log backups,
and the database is not set to "truncate log on checkpoint". If the
case is that you don't care about T-log backups on this database, just
issue "DUMP TRANSACTION db WITH NO_LOG". And then execute:

sp_dboption db, "trunc", true

which sets on "truncate log on checkpoint" which is the same as simple
recovery in SQL2000.

Assuming now that you actually have to make the log space larger (which
my guess is that you don't), then I'll try to explain the oddities of 6.5.

> When I select "EXPAND" on this page it takes me to a screen which has
> a graphical presentation with a bar chart showing the available space
> in red and the used space in blue on each of what it refers to as
> 'database devices". There are 10 items shown--

In 6.5 all databases are on devices. A device may host a single database,
or it may host many. And a database can be spread out on several devices.
It is a confusing scheme in the NT world, but when Sybase devised this
they had Unix boxes in mind, where the devices typically would reside on
raw disk.

To expand your log, you first need to find some available space on
a device or create some new device space. While you add 25 MB to
that contact_dev, space, expanding the existing device or adding a
new device is a better way to go.

Whether you actually can extend a device I don't remember off-hand. But
as long as you have the disk space, you can always add a new device and
expand the log onto that one.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Exit codes for successful install?

Hello everyone,
I'm calling MSDE setup from my installation program with:
setup.exe SecurityMode=sql REBOOT=ReallySuppress instancename="QSA"
sapwd=********** /l*v "C:\Program Files\SGM\MSDE.LOG"
I have seen this call return value 3010 (GetExitCodeProcess) on a W98SE and
a W2000 machine.
1) What does this return value mean (anything specific other than
'success')?
2) Are there more return values that indicate success?
(so that I can distinguish them from failure)
Thanks in advance
Jan
Jan Doggen, QSA Landsmeer, The Netherlands
Please remove the spam blocker from my email address when replying directly
Found the answer myself a few days later
http://msdn.microsoft.com/archive/de...us/dnarsql7/ht
ml/deploybus_depdbsol.asp
Exit Code Description
0 Successful installation (no reboot required)
3010 Successful installation (reboot required)
-1 Failed installation (logic or configuration error)
Other Failed installation (Win32 error code-see Endnote 6)
Jan
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> schreef in bericht
news:OLNf#weMEHA.1348@.TK2MSFTNGP10.phx.gbl...
> Hello everyone,
> I'm calling MSDE setup from my installation program with:
> setup.exe SecurityMode=sql REBOOT=ReallySuppress instancename="QSA"
> sapwd=********** /l*v "C:\Program Files\SGM\MSDE.LOG"
> I have seen this call return value 3010 (GetExitCodeProcess) on a W98SE
and
> a W2000 machine.
> 1) What does this return value mean (anything specific other than
> 'success')?
> 2) Are there more return values that indicate success?
> (so that I can distinguish them from failure)
> Thanks in advance
> Jan
>
> --
> ----
-
> Jan Doggen, QSA Landsmeer, The Netherlands
> Please remove the spam blocker from my email address when replying
directly
>

Execution snapshots not being added to report history

Hello,
I'm trying to generate a snapshot everytime a report is viewed. I've setup
the properties of the report to "Store all report execution snapshots in
history" but no report is being created under the History tab.
The datasource uses hardcoded credentials.
The only thing I have found in the log file that may relate to this is the
following (but it does not consistently occur every time):
INFO: LoadSnapshot: Item with session: [session id], reportPath: [report
path], userName: [my username] not found in the database
Can anyone help?
ThanksDo you have the report set up to run on an Execution snapshot? That setting
is on the Execution subtab (Under the properties tab). If not then no
execution snapshots are being created, so none are being stored.
There is no setting to create a report execution snapshot on each viewing.
Execution snapshots can only be created manually (via the SOAP Api or
checking the check box in Report Manager) or on a schedule.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ian F" <IanF@.discussions.microsoft.com> wrote in message
news:CF1B4CBA-B0B1-4A6B-9433-DE65CB817749@.microsoft.com...
> Hello,
> I'm trying to generate a snapshot everytime a report is viewed. I've
setup
> the properties of the report to "Store all report execution snapshots in
> history" but no report is being created under the History tab.
> The datasource uses hardcoded credentials.
> The only thing I have found in the log file that may relate to this is the
> following (but it does not consistently occur every time):
> INFO: LoadSnapshot: Item with session: [session id], reportPath: [report
> path], userName: [my username] not found in the database
> Can anyone help?
> Thanks