Error 0xC020209C in Flat File Connection Manager in SSIS

Hi,
I got this error in a Flat File connection manager, it was saying that the last column caused the disk I/O Buffer overflow, whereas the last column contains 188 characters at max.

Any Idea how to deal with it ?

Thanks,
FahadI set the type of Flat File Source object to Unicode and problem was no more. But I still wonder whats the reason of this error ?

error 0xC0202092 - what is it?

Pardon, can someone tell me how to resolve and "error 0xC0202092" ?
I am trying to import a text file, with "" as the field text qualifier.
Thanks,
`LeAlright, I have narrowed the error, but not the solution.

The problem occurs when importing a text file using TEXT DELIMITERS.

Specifically, imagine these two records (Text qualifier of "" and field delimeter of "|"):

"Row 1"|"Hello Nurse"|"Goodbye"
"Row 2"|"Hello Jenna"|"Goodbye"

In the 2nd row, there are several spaces after the word "Goodbye". These spaces are causing the import problem!

This error does not appear in SQl Server 2000!

Anyone have a solution?

`Le

error 0xc0202055...while import data from csv file

I receiveed the error:

Error 0xc0202055: Data Flow Task: The column delimiter for column "Column x" was not found.

I would like to have the import continue., even the error occur. I have the error output to ignore, but doesn't seem to be working. Any suggestion on what to do next, or how to skip the row that create the problem.

thanks

We'll need a little more information - is the .csv file in a valid format? Does it have an inconsistent number of columns? If so, you should check out these posts - one for a workaround, the other for another workaround and some background info.

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/07/handling-flat-files-with-varying-numbers-of-columns.aspx

http://blogs.conchango.com/jamiethomson/archive/2007/05/15/SSIS_3A00_--Flat-File-Connection-Manager-issues.aspx

Error 0xC0047012 trying to import flat file in SSIS

I'm trying to do a simple flat file import of a .csv file. The task keeps failing on me and I get the following error

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039

I looked up the error codes and the only information I can find is that a thread is failing. What would cause this and how can I fix it? I can open the same file in Excel without any problems. I'd really appreciate any insight that anyone has to offer.

Does your package do anything else than importing the flat file?

Could you try nail down a piece of data in your file that is causing this? You can do it by splitting the file in two and keeping the failing part until you get the minimal amount of data causing this failure.

If your data is not sensitive I would like to do some testing with your file as well.

Thanks.

|||

Bob,

Thank you for the tip. I've been working on it all day and finally started coming to the same place you mentioned. I was finally able to get rid of the error by modifying the column data types in the Flat File connection.

Error 0x80070003 while loading package file

Hello,
I deployed an SSIS project to my SQL Server. The project I deployed contained two packages. One called the other. After deployment I notice that both packages are indeed in the SQL Server. However when I try to run it I get the error below. This error happens during the "Execute Package Task" and the path the error is pointing at is my local development path, not the one it was deployed to. Is there any way to fix the path? And how can I get it to deploy both packages so it knows where they are when I run it from the server?

Error 0x80070003 while loading package file "C:\VS Projects\Testing\Run Codes to DB\Run Codes to DB\SofAid_DBRefresh.dtsx". The system cannot find the path specified.

Thank You
Jaime
You should use a Package Configuration to populate a variable that specifies where the child package is located. Then use an expression on the connection manager to set the appropriate property from this variable.

You could have a configuration file on your workstation and one on the server, each specifying the appropriate path for that environment. Unless you want to hard-code the location of the file, you might want to specify it's location with an environment variable. Or you could just use an environment variable to hold to package location directly if that's the only configuration information you have.
|||That seems pretty round-about. Is there a way of telling it that the package is in the same folder, or a relative path?
|||No, there's no concept of relative paths in SSIS. Remember that a package may never even exist as a file.
|||You need to use package configuration to set the path and any other property value, dinamically at run time. Serach by package configurations in BOL and this forum.|||Thank you, that was very helpful

Error 0x80070002 while preparing to load the package. The system cannot find the file specified

Hi,

I have a package which calls another package. It had been working fine for a while. Recently I changed the connection managers' names. Everything in the parent package works fine. Database has been updated correctly. But when it comes to calling the child package it generates :

OnError,CRPRCHMSQCZ,,Execute AMSClientAgentMaintenance,,,3/8/2007 5:49:38 PM,3/8/2007 5:49:38 PM,-1073602332,0x,Error 0x80070002 while preparing to load the package. The system cannot find the file specified.
. (there is a period here instead of a file name)

I tested the child package on the server. It works fine. I connected the child package to the Execute Package Task by selecting from the packages on the server. So it is there for sure. Connection manager's name is read from the .dtsConfig. Child package is executed from my development machine but not on the server. I made a small test package just to call this child package, it generates the same error...

Any help is appreciated

Gulden

Renaming the connection managers must have corrupted the package.

I restored from the backup and left the connection manager's names as they are.

Error 0x80070002 while preparing to load the package. The system cannot find the file specified

Hi,

I have a package which calls another package. It had been working fine for a while. Recently I changed the connection managers' names. Everything in the parent package works fine. Database has been updated correctly. But when it comes to calling the child package it generates :

OnError,CRPRCHMSQCZ,,Execute AMSClientAgentMaintenance,,,3/8/2007 5:49:38 PM,3/8/2007 5:49:38 PM,-1073602332,0x,Error 0x80070002 while preparing to load the package. The system cannot find the file specified.
. (there is a period here instead of a file name)

I tested the child package on the server. It works fine. I connected the child package to the Execute Package Task by selecting from the packages on the server. So it is there for sure. Connection manager's name is read from the .dtsConfig. Child package is executed from my development machine but not on the server. I made a small test package just to call this child package, it generates the same error...

Any help is appreciated

Gulden

Renaming the connection managers must have corrupted the package.

I restored from the backup and left the connection manager's names as they are.

error 0x80040155 not interface

Hi

I got the following error message when I make a new integration service project

Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered".
Can someone help

MeHi there,

This looks like a setup issue. Did you have a prior build of SQL/VS 2005 on the machine? If so, likely the machine wasn't cleaned up prior to setting up.

regards,
ash|||I also am getting this error.
I upgraded from VS 2005 Beta 2 to VS 2005 RC, but I followed all recommended uninstallation steps prior to installing VS 2005 RC.
So what can I do about this?
Will it help at all to completely uninstall VS 2005 RC and then reinstall it?
I've already tried repairing VS 2005 RC, but it didn't make any difference.
Thanks,
Dyvim|||Try registering MSXML:

regsvr32 msxml3.dll
regsvr32 msxml6.dll|||Thanks, this worked also for me|||Thanks but how do I do this, how do I register MSXML?|||

Just run these two commands from the command prompt:

regsvr32 msxml3.dll
regsvr32 msxml6.dll

|||yes it works for me too. Thanks.|||

I got the same issue, it also works for me.

Thank you so much!

|||

Hi-Thank you for the info. When I ran the 1st command regsvr32 msxml3.dll, it went fine. The 2nd command regsvr32 msxml6.dll told me "The specific module could not be found" I am getting errors like: Interface not registered (when I try to print), No such interface supported (when I tried to contact NoAdware for online support). Also, get same message when I try to go into a game room on Yahoo games. Please note: I just did a scan to remove adware and spyware.

Thanks in advance for any help you can give me,

Corinne

|||

It looks like the software you used to "remove adware and spyware" removed much more - apparently it deleted msxml6.dll (which is installed with SQL Server 2005) and probably some interface registrations.

I would recommend reformatting and reinstalling this machine and avoiding this antispyware program in the future.

|||

Hi, I have the exact same problem but it is when I try to burn a cd using Win Media Player 10. I tried registering the .dll's, but since I don't have the SQL 2005 installed in my machine, the regsvr32 msxml6.dll gives me the same error message. I see that this forum is mainly for SQL but if anybody knows what I can do, it would be appreciated.

Thanks,

Jason

|||

Hi there, di you get a reply to your query as I am experiencing the same problem. Please e-mail me & let me know. Many thanks

|||

Guys, there are thousands of interfaces registered on a typical Windows box. The error can be caused by missing registration of any of them.

We've found that particular problem ("Interface not registered" error when creating new SSIS project) is usually caused by incorrectly registered msxml dlls - my reply above describes how to fix it.

Regarding other applications - like media player, etc - there is no common answer, and you should be looking at the support forums for particular application.

|||

Quote 'I would recommend reformatting and reinstalling this machine and avoiding this antispyware program in the future.'

If I had to re-format every time something is not registering in Windows - that would be all I would be doing -Re-formatting...

Would re-installing SQL fix the problem.

Dan.

ERROR : Host-file columns may be skipped only when copying into the Server

Hi All,

I need to make a query from the SQL Server 2K and save this data as an XML file. What i am trying to do is to execute a bcp utility as follows:

EXEC master..xp_cmdshell 'bcp "SELECT CustID,CustName,CustSurname,CustEmail FROM myOwenDB..T_Customers FOR XML RAW" queryout "c:\customers.xml" -fc:\bcp.fmt -Sservername -Usa -Ppwd -C RAW -r -t'

with bcp.fmt file formatted as

8.0
4
1 SQLCHAR 0 9 "\t" 1 CustID Turkish_CI_AS
2 SQLCHAR 0 100 "\t" 2 CustName Turkish_CI_AS
3 SQLCHAR 0 100 "\t" 3 CustSurname Turkish_CI_AS
4 SQLCHAR 0 100 "\t" 4 CustEmail Turkish_CI_AS

The error is as follows:

Error = [Microsoft][ODBC SQL Server Driver]Host-file columns may be skipped only when copying into the Server

Does anyone have an idea about the problem? Also other techniques to generate XML file are also welcomed:)

Thanks in advance,

Bahtiyar KARANLIKYour select statment only returns one column and you are using a format file that says bcp will be receiving four columns from the select statment.|||Hi,
How can my SQL statement can return only one column? When i execute the statement via Query Analyzer it displays the correct information?

Am i missing a point??

Bahtiyar KARANLIK|||If you execute
SELECT CustID,CustName,CustSurname,CustEmail FROM myOwenDB..T_Customers
In QA you will get four columns, CustID, CustName,CustSurname and CustEmail.

If you execute
SELECT CustID,CustName,CustSurname,CustEmail FROM myOwenDB..T_Customers FOR XML RAW
In QA you will have a resultset with one column. Within the one column you will have an XML string that contains the four above mentioned columns, but they will be contained in one column!

If you execute
select au_id,au_lname,phone,contract from pubs.dbo.authors

you should get something like:

au_id au_lname phone contract
---- ------------ ---- ---
172-32-1176 White 408 496-7223 1

If you execute
select au_id,au_lname,phone,contract from pubsdbo.authors for xml raw

you should get something like:

XML_F52E2B61-18A1-11d1-B105-00805F49916B
------------------------
<row au_id="172-32-1176" au_lname="White" phone="408 496-7223" contract="1"/>

The first has four colums in the result set the second has only one.

Error "Line too long" - Report too large?

I'm working with a report which is being generated dynamically through
an XML and XSLT transform which generates the .rdl file which is then
pasted in to the code view of a report file in Visual Studio. This
process has worked so far for various reports until we came to this
latest report.
This report is a bit larger in scale, all together the final file size
of the .rdl file is just about 2MB. Of course it's a bit slow to work
with in Visual Studio, but the goal again was to generate the .rdl
dynamically so that editing the file(s) in Visual Studio would not be
necessary.
The report loads fine into Visual Studio and the layout view of the
report looks fine as well, but when we attempt to preview the report,
we get a build error which states:
[rsUnexpectedCompilerError] An unexpected error occurred while
compiling expressions. Native compiler return value: '[BC30494] Line
is too long.'.
I've attempted to locate information on the error message or the error
code itself but can't find any references anywhere. The error is
occurring on compilation of the report - because the same error occurs
when we select 'Build' from the context menu of the report.
So since it's a compilation error and the message seems to indicate
that the error occured while compiling expressions (and expressions use
VB.NET syntax) my assumption is that the source of the report is
somehow being passed in as a parameter to a version of the VB.NET
compiler and then spit back out for further processing.
If you follow that logic, my first thought was that perhaps one of the
expressions was literally too long and perhaps needed to be broken up
into smaller lines. But this was not the case. As the longest 'line' in
the report is 384 characters. Not long enough to cause any problems.
And we have other reports with lines just as long which do compile.
My next thought was that the entire source of the .rdl file was being
passed in to the compiler as a single string for parsing and execution
(e.g. turning the expressions into actual values or something similar).
If this is the case, then perhaps it's the actual size (in characters
or bytes) of the .rdl file that was the problem.
That's currently where I am now. I've narrowed it down to a theoretical
file size limit.
While trimming the report down piece by piece, I've discovered that the
same report works when it is in the area of 1.63 MB in size. However,
as soon as the report reaches 1.79 MB in size, this error returns and
the report fails to build.
I've seen other posts and documentation regarding the theoretical or
imposed limits of IIS and other platforms for uploading reports to
report server, but we are still below the 4MB limit.
I've also seen other posts by users who have asked about reports in the
range of <1MB, but ours is clearly outside that range.
So, does anyone have any information related to this error message, any
limits on .rdl file size, or suggestions for getting this to work?In case anyone is interested about this later on, I haven't found a
solution to the problem yet, but have found a workaround.
I was able to break the report up into smaller, more manageable chunks
(each one around 1MB in size) and create a master report and include
each chunk in a subreport.
So that's how I'm dealing with the problem for now, but I'm still
wondering if the errors I've encountered are really related to the size
of the report or something else.|||will.s.smith@.gmail.com wrote:
> In case anyone is interested about this later on, I haven't found a
> solution to the problem yet, but have found a workaround.
> I was able to break the report up into smaller, more manageable chunks
> (each one around 1MB in size) and create a master report and include
> each chunk in a subreport.
> So that's how I'm dealing with the problem for now, but I'm still
> wondering if the errors I've encountered are really related to the size
> of the report or something else.
Hi,
Iam have a RDL file where the file size is over 4MB
I have been workiing with it and deploying various versions of this
file size for the past couple of weeks ,without any errors and now
unexpectedly when iam to go live tomm Iam getting this error ,
I really don;t have any clue on how to handle this
Any help would really be appreciated
this is the compiler error iam having
[rsUnexpectedCompilerError] An unexpected error occurred while
compiling expressions. Native compiler return value: '[BC30494] Line
is too long.'.
Basically iam having 24 table data regions each pulling data from the
same dataset with different filtering options
only when i add the last 4 table regions iam gettign this error
Keep in mind that i was not getting this error last week with the same
24 data regions

Error - log file for tempdb is full

Hi,
I'm using SQL Server 2000.
I often get this message on my server saying "the log file for database
'tempdb' is full. Back up the transaction log for the database to free up
some log space..". But it does not allow me to backup and truncate the
transaction log file for the tempdb, maunally from the Enterpirse manager.
The only way is to re-start the server which often is not a preferred way
becuase there are more than 300 users connected to the server and its
difficult and bad for the buisness.
Also, sometime ago I tried the following DBCC command:
DBCC SHRINKFILE(tempdb_log, 1)
But unfortunately after that whenever I re-start the server, the Autogrow
option for the tempdb is only "1 KB", which is very very low in our company's
buisness, which is a real time scenario with people working 24/7 and doing
heavy transactions.
So I have to remember alwyas , to manually change the autogrow option to 10%
or more.
Can someone please help. Its being a nuisance now specially with me only as
the database support person in the company and with me on leave sometimes
causes problems.
Thanks,
Somi
Hi,
Have a look into the below URL:-
http://www.aspfaq.com/show.asp?id=2446
Thanks
Hari
SQL Server MVP
"Somi" <Somi@.discussions.microsoft.com> wrote in message
news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> Hi,
> I'm using SQL Server 2000.
> I often get this message on my server saying "the log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space..". But it does not allow me to backup and truncate the
> transaction log file for the tempdb, maunally from the Enterpirse manager.
> The only way is to re-start the server which often is not a preferred way
> becuase there are more than 300 users connected to the server and its
> difficult and bad for the buisness.
> Also, sometime ago I tried the following DBCC command:
> DBCC SHRINKFILE(tempdb_log, 1)
> But unfortunately after that whenever I re-start the server, the Autogrow
> option for the tempdb is only "1 KB", which is very very low in our
> company's
> buisness, which is a real time scenario with people working 24/7 and doing
> heavy transactions.
> So I have to remember alwyas , to manually change the autogrow option to
> 10%
> or more.
> Can someone please help. Its being a nuisance now specially with me only
> as
> the database support person in the company and with me on leave sometimes
> causes problems.
> Thanks,
> Somi
>
|||Hi,
try out this and schedule it in a job it will not effect ur ERP
database.
backup log tempdb with truncate_only
dbcc shrinkfile(templog,1)
select * from sysfiles
u can also create a stored procedure and schedule it that will check
the logfile size and if it reached to a certain size u can execute the
code(shrink) the shrinkfile will free the space on logfile but it will
not shrink the space on disk.
u have to backup the logfirst and then execute shrink file then it will
free the space on disk.
hope this help u
from
Doller
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> Have a look into the below URL:-
> http://www.aspfaq.com/show.asp?id=2446
> Thanks
> Hari
> SQL Server MVP
> "Somi" <Somi@.discussions.microsoft.com> wrote in message
> news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
|||Thanks Hari and Doller,
I am going through all the options provided by you both.
But I still have a doubt in my mind,
when I use "dbcc shrinkfile(templog,1)" command, will it restrict the auto
grow option of the tempdb log file to only 1 MB ? and this definitely is not
what i want in our scenario of heavy and continuous transactions & constant
use of #temp tables, cursors etc.
As I mentioned in my main issue that I've already tried this option and that
seems to have cause this problem that now the auto grow option for the tempdb
sits at 1 MB only, unitl i manually change it everytime the server re-starts.
Thanks,
Somi.
"doller" wrote:

> Hi,
> try out this and schedule it in a job it will not effect ur ERP
> database.
> backup log tempdb with truncate_only
> dbcc shrinkfile(templog,1)
> select * from sysfiles
> u can also create a stored procedure and schedule it that will check
> the logfile size and if it reached to a certain size u can execute the
> code(shrink) the shrinkfile will free the space on logfile but it will
> not shrink the space on disk.
> u have to backup the logfirst and then execute shrink file then it will
> free the space on disk.
> hope this help u
> from
> Doller
>
> Hari Prasad wrote:
>
|||1. Set the autogrow option on Model to 10%, tempdb is created from model.
2. Ensure there is enough disk space for the tempdb log - it will always
truncate automatically, you must be sure there is enough space for the log
on the hard drive... If not, add a second log on another drive - or move the
log to another drive..
that should take care of you...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Somi" <Somi@.discussions.microsoft.com> wrote in message
news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> Hi,
> I'm using SQL Server 2000.
> I often get this message on my server saying "the log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space..". But it does not allow me to backup and truncate the
> transaction log file for the tempdb, maunally from the Enterpirse manager.
> The only way is to re-start the server which often is not a preferred way
> becuase there are more than 300 users connected to the server and its
> difficult and bad for the buisness.
> Also, sometime ago I tried the following DBCC command:
> DBCC SHRINKFILE(tempdb_log, 1)
> But unfortunately after that whenever I re-start the server, the Autogrow
> option for the tempdb is only "1 KB", which is very very low in our
> company's
> buisness, which is a real time scenario with people working 24/7 and doing
> heavy transactions.
> So I have to remember alwyas , to manually change the autogrow option to
> 10%
> or more.
> Can someone please help. Its being a nuisance now specially with me only
> as
> the database support person in the company and with me on leave sometimes
> causes problems.
> Thanks,
> Somi
>

Error - log file for tempdb is full

Hi,
I'm using SQL Server 2000.
I often get this message on my server saying "the log file for database
'tempdb' is full. Back up the transaction log for the database to free up
some log space..". But it does not allow me to backup and truncate the
transaction log file for the tempdb, maunally from the Enterpirse manager.
The only way is to re-start the server which often is not a preferred way
becuase there are more than 300 users connected to the server and its
difficult and bad for the buisness.
Also, sometime ago I tried the following DBCC command:
DBCC SHRINKFILE(tempdb_log, 1)
But unfortunately after that whenever I re-start the server, the Autogrow
option for the tempdb is only "1 KB", which is very very low in our company's
buisness, which is a real time scenario with people working 24/7 and doing
heavy transactions.
So I have to remember alwyas , to manually change the autogrow option to 10%
or more.
Can someone please help. Its being a nuisance now specially with me only as
the database support person in the company and with me on leave sometimes
causes problems.
Thanks,
SomiHi,
Have a look into the below URL:-
http://www.aspfaq.com/show.asp?id=2446
Thanks
Hari
SQL Server MVP
"Somi" <Somi@.discussions.microsoft.com> wrote in message
news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> Hi,
> I'm using SQL Server 2000.
> I often get this message on my server saying "the log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space..". But it does not allow me to backup and truncate the
> transaction log file for the tempdb, maunally from the Enterpirse manager.
> The only way is to re-start the server which often is not a preferred way
> becuase there are more than 300 users connected to the server and its
> difficult and bad for the buisness.
> Also, sometime ago I tried the following DBCC command:
> DBCC SHRINKFILE(tempdb_log, 1)
> But unfortunately after that whenever I re-start the server, the Autogrow
> option for the tempdb is only "1 KB", which is very very low in our
> company's
> buisness, which is a real time scenario with people working 24/7 and doing
> heavy transactions.
> So I have to remember alwyas , to manually change the autogrow option to
> 10%
> or more.
> Can someone please help. Its being a nuisance now specially with me only
> as
> the database support person in the company and with me on leave sometimes
> causes problems.
> Thanks,
> Somi
>|||Hi,
try out this and schedule it in a job it will not effect ur ERP
database.
backup log tempdb with truncate_only
dbcc shrinkfile(templog,1)
select * from sysfiles
u can also create a stored procedure and schedule it that will check
the logfile size and if it reached to a certain size u can execute the
code(shrink) the shrinkfile will free the space on logfile but it will
not shrink the space on disk.
u have to backup the logfirst and then execute shrink file then it will
free the space on disk.
hope this help u
from
Doller
Hari Prasad wrote:
> Hi,
> Have a look into the below URL:-
> http://www.aspfaq.com/show.asp?id=2446
> Thanks
> Hari
> SQL Server MVP
> "Somi" <Somi@.discussions.microsoft.com> wrote in message
> news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> > Hi,
> > I'm using SQL Server 2000.
> > I often get this message on my server saying "the log file for database
> > 'tempdb' is full. Back up the transaction log for the database to free up
> > some log space..". But it does not allow me to backup and truncate the
> > transaction log file for the tempdb, maunally from the Enterpirse manager.
> > The only way is to re-start the server which often is not a preferred way
> > becuase there are more than 300 users connected to the server and its
> > difficult and bad for the buisness.
> >
> > Also, sometime ago I tried the following DBCC command:
> > DBCC SHRINKFILE(tempdb_log, 1)
> >
> > But unfortunately after that whenever I re-start the server, the Autogrow
> > option for the tempdb is only "1 KB", which is very very low in our
> > company's
> > buisness, which is a real time scenario with people working 24/7 and doing
> > heavy transactions.
> >
> > So I have to remember alwyas , to manually change the autogrow option to
> > 10%
> > or more.
> >
> > Can someone please help. Its being a nuisance now specially with me only
> > as
> > the database support person in the company and with me on leave sometimes
> > causes problems.
> >
> > Thanks,
> > Somi
> >|||Thanks Hari and Doller,
I am going through all the options provided by you both.
But I still have a doubt in my mind,
when I use "dbcc shrinkfile(templog,1)" command, will it restrict the auto
grow option of the tempdb log file to only 1 MB ' and this definitely is not
what i want in our scenario of heavy and continuous transactions & constant
use of #temp tables, cursors etc.
As I mentioned in my main issue that I've already tried this option and that
seems to have cause this problem that now the auto grow option for the tempdb
sits at 1 MB only, unitl i manually change it everytime the server re-starts.
Thanks,
Somi.
"doller" wrote:
> Hi,
> try out this and schedule it in a job it will not effect ur ERP
> database.
> backup log tempdb with truncate_only
> dbcc shrinkfile(templog,1)
> select * from sysfiles
> u can also create a stored procedure and schedule it that will check
> the logfile size and if it reached to a certain size u can execute the
> code(shrink) the shrinkfile will free the space on logfile but it will
> not shrink the space on disk.
> u have to backup the logfirst and then execute shrink file then it will
> free the space on disk.
> hope this help u
> from
> Doller
>
> Hari Prasad wrote:
> > Hi,
> >
> > Have a look into the below URL:-
> >
> > http://www.aspfaq.com/show.asp?id=2446
> >
> > Thanks
> > Hari
> > SQL Server MVP
> >
> > "Somi" <Somi@.discussions.microsoft.com> wrote in message
> > news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> > > Hi,
> > > I'm using SQL Server 2000.
> > > I often get this message on my server saying "the log file for database
> > > 'tempdb' is full. Back up the transaction log for the database to free up
> > > some log space..". But it does not allow me to backup and truncate the
> > > transaction log file for the tempdb, maunally from the Enterpirse manager.
> > > The only way is to re-start the server which often is not a preferred way
> > > becuase there are more than 300 users connected to the server and its
> > > difficult and bad for the buisness.
> > >
> > > Also, sometime ago I tried the following DBCC command:
> > > DBCC SHRINKFILE(tempdb_log, 1)
> > >
> > > But unfortunately after that whenever I re-start the server, the Autogrow
> > > option for the tempdb is only "1 KB", which is very very low in our
> > > company's
> > > buisness, which is a real time scenario with people working 24/7 and doing
> > > heavy transactions.
> > >
> > > So I have to remember alwyas , to manually change the autogrow option to
> > > 10%
> > > or more.
> > >
> > > Can someone please help. Its being a nuisance now specially with me only
> > > as
> > > the database support person in the company and with me on leave sometimes
> > > causes problems.
> > >
> > > Thanks,
> > > Somi
> > >
>|||1. Set the autogrow option on Model to 10%, tempdb is created from model.
2. Ensure there is enough disk space for the tempdb log - it will always
truncate automatically, you must be sure there is enough space for the log
on the hard drive... If not, add a second log on another drive - or move the
log to another drive..
that should take care of you...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Somi" <Somi@.discussions.microsoft.com> wrote in message
news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> Hi,
> I'm using SQL Server 2000.
> I often get this message on my server saying "the log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space..". But it does not allow me to backup and truncate the
> transaction log file for the tempdb, maunally from the Enterpirse manager.
> The only way is to re-start the server which often is not a preferred way
> becuase there are more than 300 users connected to the server and its
> difficult and bad for the buisness.
> Also, sometime ago I tried the following DBCC command:
> DBCC SHRINKFILE(tempdb_log, 1)
> But unfortunately after that whenever I re-start the server, the Autogrow
> option for the tempdb is only "1 KB", which is very very low in our
> company's
> buisness, which is a real time scenario with people working 24/7 and doing
> heavy transactions.
> So I have to remember alwyas , to manually change the autogrow option to
> 10%
> or more.
> Can someone please help. Its being a nuisance now specially with me only
> as
> the database support person in the company and with me on leave sometimes
> causes problems.
> Thanks,
> Somi
>

Error - log file for tempdb is full

Hi,
I'm using SQL Server 2000.
I often get this message on my server saying "the log file for database
'tempdb' is full. Back up the transaction log for the database to free up
some log space..". But it does not allow me to backup and truncate the
transaction log file for the tempdb, maunally from the Enterpirse manager.
The only way is to re-start the server which often is not a preferred way
becuase there are more than 300 users connected to the server and its
difficult and bad for the buisness.
Also, sometime ago I tried the following DBCC command:
DBCC SHRINKFILE(tempdb_log, 1)
But unfortunately after that whenever I re-start the server, the Autogrow
option for the tempdb is only "1 KB", which is very very low in our company'
s
buisness, which is a real time scenario with people working 24/7 and doing
heavy transactions.
So I have to remember alwyas , to manually change the autogrow option to 10%
or more.
Can someone please help. Its being a nuisance now specially with me only as
the database support person in the company and with me on leave sometimes
causes problems.
Thanks,
SomiHi,
Have a look into the below URL:-
http://www.aspfaq.com/show.asp?id=2446
Thanks
Hari
SQL Server MVP
"Somi" <Somi@.discussions.microsoft.com> wrote in message
news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> Hi,
> I'm using SQL Server 2000.
> I often get this message on my server saying "the log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space..". But it does not allow me to backup and truncate the
> transaction log file for the tempdb, maunally from the Enterpirse manager.
> The only way is to re-start the server which often is not a preferred way
> becuase there are more than 300 users connected to the server and its
> difficult and bad for the buisness.
> Also, sometime ago I tried the following DBCC command:
> DBCC SHRINKFILE(tempdb_log, 1)
> But unfortunately after that whenever I re-start the server, the Autogrow
> option for the tempdb is only "1 KB", which is very very low in our
> company's
> buisness, which is a real time scenario with people working 24/7 and doing
> heavy transactions.
> So I have to remember alwyas , to manually change the autogrow option to
> 10%
> or more.
> Can someone please help. Its being a nuisance now specially with me only
> as
> the database support person in the company and with me on leave sometimes
> causes problems.
> Thanks,
> Somi
>|||Hi,
try out this and schedule it in a job it will not effect ur ERP
database.
backup log tempdb with truncate_only
dbcc shrinkfile(templog,1)
select * from sysfiles
u can also create a stored procedure and schedule it that will check
the logfile size and if it reached to a certain size u can execute the
code(shrink) the shrinkfile will free the space on logfile but it will
not shrink the space on disk.
u have to backup the logfirst and then execute shrink file then it will
free the space on disk.
hope this help u
from
Doller
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> Have a look into the below URL:-
> http://www.aspfaq.com/show.asp?id=2446
> Thanks
> Hari
> SQL Server MVP
> "Somi" <Somi@.discussions.microsoft.com> wrote in message
> news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...|||Thanks Hari and Doller,
I am going through all the options provided by you both.
But I still have a doubt in my mind,
when I use "dbcc shrinkfile(templog,1)" command, will it restrict the auto
grow option of the tempdb log file to only 1 MB ' and this definitely is no
t
what i want in our scenario of heavy and continuous transactions & constant
use of #temp tables, cursors etc.
As I mentioned in my main issue that I've already tried this option and that
seems to have cause this problem that now the auto grow option for the tempd
b
sits at 1 MB only, unitl i manually change it everytime the server re-starts
.
Thanks,
Somi.
"doller" wrote:

> Hi,
> try out this and schedule it in a job it will not effect ur ERP
> database.
> backup log tempdb with truncate_only
> dbcc shrinkfile(templog,1)
> select * from sysfiles
> u can also create a stored procedure and schedule it that will check
> the logfile size and if it reached to a certain size u can execute the
> code(shrink) the shrinkfile will free the space on logfile but it will
> not shrink the space on disk.
> u have to backup the logfirst and then execute shrink file then it will
> free the space on disk.
> hope this help u
> from
> Doller
>
> Hari Prasad wrote:
>|||1. Set the autogrow option on Model to 10%, tempdb is created from model.
2. Ensure there is enough disk space for the tempdb log - it will always
truncate automatically, you must be sure there is enough space for the log
on the hard drive... If not, add a second log on another drive - or move the
log to another drive..
that should take care of you...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Somi" <Somi@.discussions.microsoft.com> wrote in message
news:94F948DC-0A8C-40B4-A125-FFE8FB0E25A4@.microsoft.com...
> Hi,
> I'm using SQL Server 2000.
> I often get this message on my server saying "the log file for database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space..". But it does not allow me to backup and truncate the
> transaction log file for the tempdb, maunally from the Enterpirse manager.
> The only way is to re-start the server which often is not a preferred way
> becuase there are more than 300 users connected to the server and its
> difficult and bad for the buisness.
> Also, sometime ago I tried the following DBCC command:
> DBCC SHRINKFILE(tempdb_log, 1)
> But unfortunately after that whenever I re-start the server, the Autogrow
> option for the tempdb is only "1 KB", which is very very low in our
> company's
> buisness, which is a real time scenario with people working 24/7 and doing
> heavy transactions.
> So I have to remember alwyas , to manually change the autogrow option to
> 10%
> or more.
> Can someone please help. Its being a nuisance now specially with me only
> as
> the database support person in the company and with me on leave sometimes
> causes problems.
> Thanks,
> Somi
>

Error - Event ID 3633

Hi,
My server is currently installed with SQL Server 2005. I checked in the
Event Viewer log file I noticed that I get the error message which the
source is MSSQL$SQLEXPRESS, following is the detail of the error message:
Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 3633
Date: 09-Aug-2006
Time: 1:47:34 PM
User: TEKKLSVR\IWAM_TEKLANG4
Computer: TEKLANG4
Description:
The operating system returned the error '997(Overlapped I/O operation is in
progress.)' while attempting 'OpenService' on 'SQLWRITER' at
'secexpr.cpp'(1352).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 31 0e 00 00 10 00 00 00 1......
0008: 14 00 00 00 54 00 45 00 ...T.E.
0010: 4b 00 4c 00 41 00 4e 00 K.L.A.N.
0018: 47 00 34 00 5c 00 53 00 G.4.\.S.
0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0028: 50 00 52 00 45 00 53 00 P.R.E.S.
0030: 53 00 00 00 07 00 00 00 S......
0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
0040: 65 00 72 00 00 00 e.r...
Can some one please assist me on solving this problem, because it is
affecting our daily operation. Many thanks in advance.
Regards,
RachaelAny luck finding a solutions for this issue. I am experiencing the samethin
g
and having a difficult time finding information.
"Seok Bee" wrote:

> Hi,
> My server is currently installed with SQL Server 2005. I checked in the
> Event Viewer log file I noticed that I get the error message which the
> source is MSSQL$SQLEXPRESS, following is the detail of the error message:
> Event Type: Error
> Event Source: MSSQL$SQLEXPRESS
> Event Category: (2)
> Event ID: 3633
> Date: 09-Aug-2006
> Time: 1:47:34 PM
> User: TEKKLSVR\IWAM_TEKLANG4
> Computer: TEKLANG4
> Description:
> The operating system returned the error '997(Overlapped I/O operation is i
n
> progress.)' while attempting 'OpenService' on 'SQLWRITER' at
> 'secexpr.cpp'(1352).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 31 0e 00 00 10 00 00 00 1......
> 0008: 14 00 00 00 54 00 45 00 ...T.E.
> 0010: 4b 00 4c 00 41 00 4e 00 K.L.A.N.
> 0018: 47 00 34 00 5c 00 53 00 G.4.\.S.
> 0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
> 0028: 50 00 52 00 45 00 53 00 P.R.E.S.
> 0030: 53 00 00 00 07 00 00 00 S......
> 0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0040: 65 00 72 00 00 00 e.r...
>
> Can some one please assist me on solving this problem, because it is
> affecting our daily operation. Many thanks in advance.
> Regards,
> Rachael
>
>|||Hi
There are a couple of other posts matching your error but without replies
http://tinyurl.com/yb8bmb Have you checked the SQL Server error log? Have yo
u
made sure that you have the latest drivers? Do you use any filter software
(such as Anti-virus or Disc compression)? What O/S and service pack level
are you on? Have you upgraded to SQL Server 2005 Service pack 1?
John
"Seok Bee" wrote:

> Hi,
> My server is currently installed with SQL Server 2005. I checked in the
> Event Viewer log file I noticed that I get the error message which the
> source is MSSQL$SQLEXPRESS, following is the detail of the error message:
> Event Type: Error
> Event Source: MSSQL$SQLEXPRESS
> Event Category: (2)
> Event ID: 3633
> Date: 09-Aug-2006
> Time: 1:47:34 PM
> User: TEKKLSVR\IWAM_TEKLANG4
> Computer: TEKLANG4
> Description:
> The operating system returned the error '997(Overlapped I/O operation is i
n
> progress.)' while attempting 'OpenService' on 'SQLWRITER' at
> 'secexpr.cpp'(1352).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 31 0e 00 00 10 00 00 00 1......
> 0008: 14 00 00 00 54 00 45 00 ...T.E.
> 0010: 4b 00 4c 00 41 00 4e 00 K.L.A.N.
> 0018: 47 00 34 00 5c 00 53 00 G.4.\.S.
> 0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
> 0028: 50 00 52 00 45 00 53 00 P.R.E.S.
> 0030: 53 00 00 00 07 00 00 00 S......
> 0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0040: 65 00 72 00 00 00 e.r...
>
> Can some one please assist me on solving this problem, because it is
> affecting our daily operation. Many thanks in advance.
> Regards,
> Rachael
>
>

Error - Event ID 3633

Hi,
My server is currently installed with SQL Server 2005. I checked in the
Event Viewer log file I noticed that I get the error message which the
source is MSSQL$SQLEXPRESS, following is the detail of the error message:
Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 3633
Date: 09-Aug-2006
Time: 1:47:34 PM
User: TEKKLSVR\IWAM_TEKLANG4
Computer: TEKLANG4
Description:
The operating system returned the error '997(Overlapped I/O operation is in
progress.)' while attempting 'OpenService' on 'SQLWRITER' at
'secexpr.cpp'(1352).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 31 0e 00 00 10 00 00 00 1......
0008: 14 00 00 00 54 00 45 00 ...T.E.
0010: 4b 00 4c 00 41 00 4e 00 K.L.A.N.
0018: 47 00 34 00 5c 00 53 00 G.4.\.S.
0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0028: 50 00 52 00 45 00 53 00 P.R.E.S.
0030: 53 00 00 00 07 00 00 00 S......
0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
0040: 65 00 72 00 00 00 e.r...
Can some one please assist me on solving this problem, because it is
affecting our daily operation. Many thanks in advance.
Regards,
RachaelAny luck finding a solutions for this issue. I am experiencing the samething
and having a difficult time finding information.
"Seok Bee" wrote:
> Hi,
> My server is currently installed with SQL Server 2005. I checked in the
> Event Viewer log file I noticed that I get the error message which the
> source is MSSQL$SQLEXPRESS, following is the detail of the error message:
> Event Type: Error
> Event Source: MSSQL$SQLEXPRESS
> Event Category: (2)
> Event ID: 3633
> Date: 09-Aug-2006
> Time: 1:47:34 PM
> User: TEKKLSVR\IWAM_TEKLANG4
> Computer: TEKLANG4
> Description:
> The operating system returned the error '997(Overlapped I/O operation is in
> progress.)' while attempting 'OpenService' on 'SQLWRITER' at
> 'secexpr.cpp'(1352).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 31 0e 00 00 10 00 00 00 1......
> 0008: 14 00 00 00 54 00 45 00 ...T.E.
> 0010: 4b 00 4c 00 41 00 4e 00 K.L.A.N.
> 0018: 47 00 34 00 5c 00 53 00 G.4.\.S.
> 0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
> 0028: 50 00 52 00 45 00 53 00 P.R.E.S.
> 0030: 53 00 00 00 07 00 00 00 S......
> 0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0040: 65 00 72 00 00 00 e.r...
>
> Can some one please assist me on solving this problem, because it is
> affecting our daily operation. Many thanks in advance.
> Regards,
> Rachael
>
>|||Hi
There are a couple of other posts matching your error but without replies
http://tinyurl.com/yb8bmb Have you checked the SQL Server error log? Have you
made sure that you have the latest drivers? Do you use any filter software
(such as Anti-virus or Disc compression)? What O/S and service pack level
are you on? Have you upgraded to SQL Server 2005 Service pack 1?
John
"Seok Bee" wrote:
> Hi,
> My server is currently installed with SQL Server 2005. I checked in the
> Event Viewer log file I noticed that I get the error message which the
> source is MSSQL$SQLEXPRESS, following is the detail of the error message:
> Event Type: Error
> Event Source: MSSQL$SQLEXPRESS
> Event Category: (2)
> Event ID: 3633
> Date: 09-Aug-2006
> Time: 1:47:34 PM
> User: TEKKLSVR\IWAM_TEKLANG4
> Computer: TEKLANG4
> Description:
> The operating system returned the error '997(Overlapped I/O operation is in
> progress.)' while attempting 'OpenService' on 'SQLWRITER' at
> 'secexpr.cpp'(1352).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 31 0e 00 00 10 00 00 00 1......
> 0008: 14 00 00 00 54 00 45 00 ...T.E.
> 0010: 4b 00 4c 00 41 00 4e 00 K.L.A.N.
> 0018: 47 00 34 00 5c 00 53 00 G.4.\.S.
> 0020: 51 00 4c 00 45 00 58 00 Q.L.E.X.
> 0028: 50 00 52 00 45 00 53 00 P.R.E.S.
> 0030: 53 00 00 00 07 00 00 00 S......
> 0038: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0040: 65 00 72 00 00 00 e.r...
>
> Can some one please assist me on solving this problem, because it is
> affecting our daily operation. Many thanks in advance.
> Regards,
> Rachael
>
>

Error - could not initialize the Publisher - LOG FILE

The log file for the above message is as follows
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: ECOSYSTEM-MLEcosystem-Production_MLEcosystem-ML-US-MLEcosystem- 0
Percent Complete: 0
Connecting to Subscriber 'ML-US'
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:48:45 AM]ML-US.MLEcosystem: {call sp_MSgetversion }
[3/31/2004 9:48:45 AM]ML-US.MLEcosystem: {?=call sp_helpsubscription_properties (N'ECOSYSTEM', N'MLEcosystem', N'Production_MLEcosystem')}
Distributor security mode: 0, login name: sa, password: ********.
[3/31/2004 9:48:45 AM]ML-US.MLEcosystem: {?=call sp_helpsubscription_properties (N'ECOSYSTEM', N'MLEcosystem', N'Production_MLEcosystem')}
Publisher security mode: 0, login name: sa, password: *********.
Percent Complete: 0
Connecting to Distributor 'ECOSYSTEM'
Connecting to Distributor 'ECOSYSTEM.'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:48:49 AM]ECOSYSTEM.: {call sp_MSgetversion }
[3/31/2004 9:48:50 AM]ECOSYSTEM.: {call sp_helpdistpublisher (N'ECOSYSTEM') }
[3/31/2004 9:48:50 AM]ECOSYSTEM.distribution: select datasource, srvid from master..sysservers where upper(srvname) = upper(N'ECOSYSTEM')
[3/31/2004 9:48:51 AM]ECOSYSTEM.distribution: {call sp_MSadd_merge_anonymous_agent(N'0', N'MLEcosystem', N'Production_MLEcosystem', N'MLEcosystem', N'ML-US',?, 1369)}
[3/31/2004 9:48:53 AM]ECOSYSTEM.distribution: {call sp_MShelp_profile (10, 4, N'')}
Percent Complete: 0
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Initializing
Percent Complete: 1
Connecting to Publisher 'ECOSYSTEM'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:48:58 AM]ECOSYSTEM.MLEcosystem: set nocount on declare @.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255) select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname, N'COLLATION')) select collationproperty(
@.collation, N'CODEPAGE') as 'CodePage', collationproperty(@.collation, N'LCID') as 'LCID', collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
The merge process could not initialize the Publisher 'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
The merge process could not initialize the Publisher 'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147198719
Message: The merge process could not initialize the Publisher 'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call master..sp_MScheck_agent_instance (N'9F48C1F5-1D8E-4886-864D-12230193FC4E', 4)}
Percent Complete: 0
Category:SQLSERVER
Source: ECOSYSTEM
Number: 21036
Message: Another merge agent for the subscription(s) is running.
Disconnecting from Subscriber 'ML-US'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Distributor 'ECOSYSTEM'
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: ECOSYSTEM-MLEcosystem-Production_MLEcosystem-ML-US-MLEcosystem- 0
Percent Complete: 0
Connecting to Subscriber 'ML-US'
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:01 AM]ML-US.MLEcosystem: {call sp_MSgetversion }
[3/31/2004 9:50:01 AM]ML-US.MLEcosystem: {?=call sp_helpsubscription_properties (N'ECOSYSTEM', N'MLEcosystem', N'Production_MLEcosystem')}
Distributor security mode: 0, login name: sa, password: ********.
[3/31/2004 9:50:01 AM]ML-US.MLEcosystem: {?=call sp_helpsubscription_properties (N'ECOSYSTEM', N'MLEcosystem', N'Production_MLEcosystem')}
Publisher security mode: 0, login name: sa, password: *********.
Percent Complete: 0
Connecting to Distributor 'ECOSYSTEM'
Connecting to Distributor 'ECOSYSTEM.'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:04 AM]ECOSYSTEM.: {call sp_MSgetversion }
[3/31/2004 9:50:04 AM]ECOSYSTEM.: {call sp_helpdistpublisher (N'ECOSYSTEM') }
[3/31/2004 9:50:05 AM]ECOSYSTEM.distribution: select datasource, srvid from master..sysservers where upper(srvname) = upper(N'ECOSYSTEM')
[3/31/2004 9:50:06 AM]ECOSYSTEM.distribution: {call sp_MSadd_merge_anonymous_agent(N'0', N'MLEcosystem', N'Production_MLEcosystem', N'MLEcosystem', N'ML-US',?, 1369)}
[3/31/2004 9:50:06 AM]ECOSYSTEM.distribution: {call sp_MShelp_profile (10, 4, N'')}
Percent Complete: 0
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Initializing
Percent Complete: 1
Connecting to Publisher 'ECOSYSTEM'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:10 AM]ECOSYSTEM.MLEcosystem: set nocount on declare @.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255) select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname, N'COLLATION')) select collationproperty(
@.collation, N'CODEPAGE') as 'CodePage', collationproperty(@.collation, N'LCID') as 'LCID', collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:15 AM]ECOSYSTEM.MLEcosystem: {call sp_MSgetversion }
Percent Complete: 3
Retrieving publication information
Percent Complete: 4
Retrieving subscription information
Percent Complete: 4
The merge process is cleaning up meta data in database 'MLEcosystem'.
Percent Complete: 4
The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
Percent Complete: 4
The merge process is cleaning up meta data in database 'MLEcosystem'.
Percent Complete: 4
The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
Percent Complete: 4
Uploading data changes to the Publisher
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:40 AM]ML-US.MLEcosystem: {call sp_MSgetversion }
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:43 AM]ECOSYSTEM.MLEcosystem: {call sp_MSgetversion }
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:44 AM]ML-US.MLEcosystem: {call sp_MSgetversion }
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:49 AM]ECOSYSTEM.MLEcosystem: {call sp_MSgetversion }
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:50 AM]ML-US.MLEcosystem: {call sp_MSgetversion }
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:53 AM]ECOSYSTEM.MLEcosystem: {call sp_MSgetversion }
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:53 AM]ML-US.MLEcosystem: {call sp_MSgetversion }
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 9:50:57 AM]ECOSYSTEM.MLEcosystem: {call sp_MSgetversion }
Percent Complete: 5
Processing article 'Analysis'
Percent Complete: 5
Processing article 'UserTaskTimeSplit'
Percent Complete: 5
Processing article 'Users'
Percent Complete: 5
Processing article 'TblMessage'
Percent Complete: 5
Processing article 'TblAttachment'
Percent Complete: 5
Processing article 'TaskDetailComment'
Percent Complete: 5
Processing article 'Risk'
Percent Complete: 5
Processing article 'PeerReviewTimeSplit'
Percent Complete: 5
Processing article 'MessageMaster'
Percent Complete: 5
Processing article 'MessageDetail'
Percent Complete: 5
Processing article 'ManagerTimeSheet'
Percent Complete: 5
Processing article 'GanttMaster'
Percent Complete: 5
Processing article 'BugMaster'
Percent Complete: 5
Processing article 'BugCategory'
Percent Complete: 5
Processing article 'Requirement'
Percent Complete: 5
Processing article 'Design'
Percent Complete: 5
Processing article 'MktgSitutationCompetitorTemp'
Percent Complete: 5
Processing article 'MktgSituationCustomerCompetitorsTemp'
Percent Complete: 5
Processing article 'MktgProgramQuarterDetails'
Percent Complete: 5
Processing article 'MktgProfitLoss'
Percent Complete: 5
Processing article 'MktgLearningToolsTemp'
Percent Complete: 5
Processing article 'MktgGoalQuarter'
Percent Complete: 5
Processing article 'MktgGoalDetails'
Percent Complete: 5
Processing article 'MktgGoalAccQualMaster'
Percent Complete: 5
Processing article 'MktgGoalAccQualDetails'
Percent Complete: 5
Processing article 'MktgCompanyTrainingTemp'
Percent Complete: 5
Processing article 'MktgCompanyProductsTemp'
Percent Complete: 5
Processing article 'MktgCompanyMaster'
Percent Complete: 5
Processing article 'MktgCompanyFinancialsTemp'
Percent Complete: 5
Processing article 'MktgAcQualificationTemp'
Percent Complete: 5
Processing article 'MktgAcQualification'
Percent Complete: 5
Processing article 'RADFolder'
Percent Complete: 5
Processing article 'FTPFile'
Percent Complete: 5
Processing article 'MktgProjectedPayment'
Percent Complete: 5
Processing article 'MktgProject'
Percent Complete: 5
Processing article 'MktgNewExpenseArchive'
Percent Complete: 5
Processing article 'LoginHistory'
Percent Complete: 5
Processing article 'HRDSwipeData'
Percent Complete: 5
Processing article 'HRDEmployeeResumeInformation'
Percent Complete: 5
Processing article 'HRDEmployeeQualificationDetails'
Percent Complete: 5
Processing article 'HRDEmployeeLeaveCount'
Percent Complete: 5
Processing article 'HRDPastSalaryPaidDetail'
Percent Complete: 5
Processing article 'GanttRelationship'
Percent Complete: 5
Processing article 'BugType'
Percent Complete: 5
Processing article 'BugMasterDetail'
Percent Complete: 5
Processing article 'BugAuthor'
Percent Complete: 5
Processing article 'Analysis'
Percent Complete: 5
Processing article 'MktgTimeInvest'
Percent Complete: 5
Processing article 'MktgSummaryDetails'
Percent Complete: 5
Processing article 'MktgSituationCompetitor'
Percent Complete: 5
Processing article 'MktgPossibleGoalDetails'
Percent Complete: 5
Processing article 'MktgObjectiveMaster'
Percent Complete: 5
Processing article 'MktgGoals'
Percent Complete: 5
Processing article 'MktgEventMaster'
Percent Complete: 5
Processing article 'MktgDraftStrategy'
Percent Complete: 5
Processing article 'MktgCompanyOffices'
Percent Complete: 5
Processing article 'MktgCompanyGeneralInfo'
Percent Complete: 5
Processing article 'MktgCompanyFinancials'
Percent Complete: 5
Processing article 'MktgGSSTimeSheet'
Percent Complete: 5
Processing article 'HRDTDSEmployeeDeclaration'
Percent Complete: 5
Processing article 'Project'
Percent Complete: 5
Processing article 'MktgSituationCustomerCompetitors'
Percent Complete: 5
Processing article 'BugTypeDetail'
Percent Complete: 5
Processing article 'BugPeer'
Percent Complete: 5
Processing article 'MktgProgramMaster'
Percent Complete: 5
Processing article 'MktgEventPhoneCall'
Percent Complete: 5
Processing article 'MktgCompanyOfficeContacts'
Percent Complete: 5
Processing article 'MktgNewExpenses'
Percent Complete: 5
Processing article 'MessagePerUser'
Percent Complete: 5
Processing article 'HRDEmployeeMaster'
Percent Complete: 5
Processing article 'Task'
Percent Complete: 5
Processing article 'ProjectDetails'
Percent Complete: 5
Processing article 'Process'
Percent Complete: 5
Processing article 'AssignedProject'
Percent Complete: 5
Processing article 'RADImplementerChecklistRecordsForPeer'
Percent Complete: 5
Processing article 'RADImplementerChecklistRecordsForAuthor'
Percent Complete: 5
Processing article 'HRDAttendanceMaster'
Percent Complete: 5
Processing article 'HRDEmployeeSalaryMaster'
Percent Complete: 5
Processing article 'HRDEmployeeLeaveMaster'
Percent Complete: 5
Processing article 'TaskDetail'
Percent Complete: 5
Processing article 'ProcessSkill'
Percent Complete: 5
Processing article 'ProjectFtpQueueUser'
Percent Complete: 5
Processing article 'HRDAttendanceDetails'
Percent Complete: 5
Processing article 'HRDEmployeeStatus'
Percent Complete: 5
Processing article 'HRDEmployeeLeaveDetails'
Percent Complete: 5
Processing article 'HRDLeaveUtilization'
Percent Complete: 5
Processing article 'UserTask'
Percent Complete: 5
Processing article 'ClientApprovalWorkDetail'
Percent Complete: 5
Processing article 'HRDEmployeeSalaryDetail'
Percent Complete: 5
Processing article 'PeerReview'
The merge process could not retrieve column information for table 'dbo.PeerReview'.
The merge process encountered an unexpected network error. The connection to Publisher 'ECOSYSTEM' is no longer available.
Percent Complete: 0
The merge process could not retrieve column information for table 'dbo.PeerReview'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201016
Message: The merge process could not retrieve column information for table 'dbo.PeerReview'.
Percent Complete: 0
{call sp_MSenumcolumns (?,?)}
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSenumcolumns (?,?)}
Percent Complete: 0
General network error. Check your network documentation.
Percent Complete: 0
Category:SQLSERVER
Source: ECOSYSTEM
Number: 11
Message: General network error. Check your network documentation.
Percent Complete: 0
The merge process encountered an unexpected network error. The connection to Publisher 'ECOSYSTEM' is no longer available.
Percent Complete: 0
Category:NULL
Source: Merge Process
Number: -2147199469
Message: The merge process encountered an unexpected network error. The connection to Publisher 'ECOSYSTEM' is no longer available.
Disconnecting from Subscriber 'ML-US'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Subscriber 'ML-US'
Disconnecting from Subscriber 'ML-US'
Disconnecting from Subscriber 'ML-US'
Disconnecting from Subscriber 'ML-US'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Distributor 'ECOSYSTEM'
Manish,
the only time I've seen the error above was when the system was so corrupted
that I installed the latest sp once again then everything was OK. In the log
file there are a variety of errors including "Another merge agent for the
subscription(s) is running" which can be to do with activeX controls running
or hung processes but let's wait and see if anyone else has more specific
information on the main error, and if not then I'd apply the service pack.
Regards,
Paul Ibison
|||Hi Manish,
I learned when I synchronize the servers you got the following error:
"The merge process could not initialize the Publisher
'ECOSYSTEM:MLEcosystem'."
After reviewing the log file, I noticed the following error message.
[3/31/2004 9:48:58 AM]ECOSYSTEM.MLEcosystem: set nocount on declare @.dbname
sysname select @.dbname = db_name() declare @.collation nvarchar(255) select
@.collation = convert(nvarchar(255), databasepropertyex(@.dbname,
N'COLLATION')) select collationproperty(@.collation, N'CODEPAGE') as
'CodePage', collationproperty(@.collation, N'LCID') as 'LCID',
collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
The merge process could not initialize the Publisher
'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
The merge process could not initialize the Publisher
'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147198719
Message: The merge process could not initialize the Publisher
'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call master..sp_MScheck_agent_instance
(N'9F48C1F5-1D8E-4886-864D-12230193FC4E', 4)}
Percent Complete: 0
Category:SQLSERVER
Source: ECOSYSTEM
Number: 21036
Message: Another merge agent for the subscription(s) is running.
Disconnecting from Subscriber 'ML-US'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Distributor 'ECOSYSTEM'
It is suspected that this problem is caused by the orphaned process. Please
try the following steps and check to see if it able to fix your problem.
1. In Enterprise Manager, under "Replication Monitor", Go to "Agents"
folder, Look for your failing Agent there. Right Click and Stop the agent
if it is in a retrying status.
2. Under Enterprise Manager, under "Replication Monitor", Go to "Agents"
folder, right click on the failing agent, choose Agent, properties. From
the Agent properties dialog box, copy the name of the agent.
3. In the Query Analyzer, modify Your_Agent_Name with the name from the
previous step in the following command and execute:
Select spid from sysprocesses where program_name = 'Your_Agent_Name'
4. Obtain the spid from the output, and use the Kill command to kill that
orphan process:
Kill spid
5. Restart the applicable agent.
What's the result?
Also, such issues tend to be complex and take up extensive research time.
I'd like to set your expectations that it may take a while for us to help
you narrow down the problem and we may eventually redirect you to PSS to
continue working with a dedicated Support Professional. If this is
critical, I'd recommend contacting PSS and opening a Support incident
troubleshoot this further. If you need any help in this regard, please let
me know.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
|||Hi Paul,
Thank you for the message.
I have been trying to sync these desperately for the last few hours. What I did was I was clicking on the Start Synchronizing at the subscriber in EM, and kept on querying my publisher database from the subscriber. At times my queries used to take around
30 seconds to return 5 rows (3 columns) while under normal circumstances it would take less than a second. And whenever this problem used to happen the sync used to give some error or the other.
Below are some more entries from my log file
__________________________________________________ ______________
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: ECOSYSTEM-MLEcosystem-Production_MLEcosystem-ML-US-MLEcosystem- 0
Percent Complete: 0
Connecting to Subscriber 'ML-US'
Connecting to Subscriber 'ML-US.MLEcosystem'
Server: ML-US
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 3:59:10 PM]ML-US.MLEcosystem: {call sp_MSgetversion }
[3/31/2004 3:59:10 PM]ML-US.MLEcosystem: {?=call sp_helpsubscription_properties (N'ECOSYSTEM', N'MLEcosystem', N'Production_MLEcosystem')}
Distributor security mode: 0, login name: sa, password: ********.
[3/31/2004 3:59:10 PM]ML-US.MLEcosystem: {?=call sp_helpsubscription_properties (N'ECOSYSTEM', N'MLEcosystem', N'Production_MLEcosystem')}
Publisher security mode: 0, login name: sa, password: *********.
Percent Complete: 0
Connecting to Distributor 'ECOSYSTEM'
Connecting to Distributor 'ECOSYSTEM.'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 3:59:14 PM]ECOSYSTEM.: {call sp_MSgetversion }
[3/31/2004 3:59:14 PM]ECOSYSTEM.: {call sp_helpdistpublisher (N'ECOSYSTEM') }
[3/31/2004 3:59:17 PM]ECOSYSTEM.distribution: select datasource, srvid from master..sysservers where upper(srvname) = upper(N'ECOSYSTEM')
[3/31/2004 3:59:17 PM]ECOSYSTEM.distribution: {call sp_MSadd_merge_anonymous_agent(N'0', N'MLEcosystem', N'Production_MLEcosystem', N'MLEcosystem', N'ML-US',?, 1369)}
[3/31/2004 3:59:17 PM]ECOSYSTEM.distribution: {call sp_MShelp_profile (10, 4, N'')}
Percent Complete: 0
Connecting to Publisher 'ECOSYSTEM.MLEcosystem'
Initializing
Percent Complete: 1
Connecting to Publisher 'ECOSYSTEM'
Server: ECOSYSTEM
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[3/31/2004 3:59:23 PM]ECOSYSTEM.MLEcosystem: set nocount on declare @.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255) select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname, N'COLLATION')) select collationproperty(
@.collation, N'CODEPAGE') as 'CodePage', collationproperty(@.collation, N'LCID') as 'LCID', collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
The merge process could not initialize the Publisher 'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
The merge process could not initialize the Publisher 'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147198719
Message: The merge process could not initialize the Publisher 'ECOSYSTEM:MLEcosystem'.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call master..sp_MScheck_agent_instance (N'9F48C1F5-1D8E-4886-864D-12230193FC4E', 4)}
Percent Complete: 0
Category:SQLSERVER
Source: ECOSYSTEM
Number: 21036
Message: Another merge agent for the subscription(s) is running.
Disconnecting from Subscriber 'ML-US'
Disconnecting from Publisher 'ECOSYSTEM'
Disconnecting from Distributor 'ECOSYSTEM'
I have specified the value for LoginTime to 3000 and QueryTimeOut to 3000. Also I have changed the DownloadGenerationsPerBatch, UploadGenerationsPerBatch and releated parameters to 5.
Do you think I should try a reinstall of SP3 on the subscriber?
Please advise. Thank you.
Regards,
Manish
|||Yuan's reply (below) makes sense to me. I mentioned ActiveX controls because this is one circumstance where an agent can be started programmatically, preventing your agent from working. If you can get hold of the erroring agent's process this could be kil
led like Yuan says. My suggestion is a bit of a sledgehammer and is one I have seen used before for this error, but in this circumstance it shouldn't be necessary to go this far, and I am not convinced that there is an actual corruption that is fixed, rat
her the reinstallation of the service pack simply removes problematic hung processes as a side-effect. From your explanation it sounds like this is a sporadic error, which is worrying. Anyway, I'd apply Yuan's reasoning and make sure that you don't have a
ny merge agent being started programmatically form legacy code.
Regards,
Paul Ibison
|||Hi Paul,
I am trying to implement Yuan's suggestion also.
But the thing is my servers synchronize based on synronichation scheduled via SQL Server. There is no possibility of any legacy code calling the merge agent.
Also, I did try a reinstall of SP3 on my subscriber. It didn't solve the problem though.
I am at present trying to implement Yuan's suggestion. I will post an update on the same later.
I would be highly obliged if you have any other suggestion though.
Thank you.
Regards,
Manish

Error

Hey,
Did anyone ever get this error:
Could not open FCB for invalid file ID 14646 in
database 'Database_Name'..'
If so.. know where is the problem?
Thanxs!If I remember correctly FCB is (File Control Block) and it sounds like you
have a corrupted Primary Data file... It is probably time to either restore
the database from a know good backup ( or open a support call to MS - maybe
they can help you get around the problem.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cs" <anonymous@.discussions.microsoft.com> wrote in message
news:1279201c41189$6034a0b0$a401280a@.phx
.gbl...
> Hey,
> Did anyone ever get this error:
> Could not open FCB for invalid file ID 14646 in
> database 'Database_Name'..'
> If so.. know where is the problem?
> Thanxs!

error

need help with this error message

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

hi,

try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124335&SiteID=1

regards

Erro trapping question

I have a batch file that runs SQL Server scripts using commands like:

OSQL -Umyname -Pmypassword -iScript_01.sql -w200 -e -n
>>Consolidation.log

Script_01.sql will contain statements like:
Update SASI.AACT set schoolnum='071' where schoolnum in ('000',' ')
update SASI.AATD set schoolnum='071' where schoolnum in ('000',' ')
update SASI.AATP set schoolnum='071' where schoolnum in ('000',' ')
update SASI.ACHS set schoolnum='071' where schoolnum in ('000',' ')
update SASI.ACLS set schoolnum='071' where schoolnum in ('000',' ')

If one of those tables should not exist, how could I have it continue,
but hopefully the log would have a reference to the error?

I am experimenting, but I am unsuccessfull with something like:
BEGIN TRAN
select count(*) from sasi.aact --this could be an update
statement
if @.@.ERROR =208 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
err_handle:
return
commit Tran<OakRogbak_erPine@.yahoo.com> wrote in message
news:13fdc9b4.0410140645.305d53d3@.posting.google.c om...
>I have a batch file that runs SQL Server scripts using commands like:
> OSQL -Umyname -Pmypassword -iScript_01.sql -w200 -e -n
>>>Consolidation.log
> Script_01.sql will contain statements like:
> Update SASI.AACT set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.AATD set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.AATP set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.ACHS set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.ACLS set schoolnum='071' where schoolnum in ('000',' ')
> If one of those tables should not exist, how could I have it continue,
> but hopefully the log would have a reference to the error?
> I am experimenting, but I am unsuccessfull with something like:
> BEGIN TRAN
> select count(*) from sasi.aact --this could be an update
> statement
> if @.@.ERROR =208 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> err_handle:
> return
> commit Tran

Error handling is rather awkward in MSSQL:

http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html

In your case, the easiest thing is probably to avoid the error by checking
if the table exists before trying to query it:

if object_id('sasi.aact') is not null and
objectproperty(object_id('sasi.aact'), 'IsTable') = 1
begin
... -- do something here
end
else
begin
... -- log to an error table
end

Simon

Erro install Reportig Service

> Hello,
>
> I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> Standard, but appers error message no log file rsstp.log
>
> InstallBootstrapPackage' Return='2' GetLastError='183
>
> anyone can help me?
> Clayton Cardozo.hi i am having trouble opening my emails it just goes in to error
"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
>
>|||"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
> i need help opening my email it has been ok upto now not sure whats happened it just goes in to error everytime i try.
>