Error From Maintenance Plan

I am getting the following error in my Maintenance Plan. It looks as
if it is just one table (according to the Object id). My question is
how do I determine which table this is when all I have is this Object
ID?
Mark
[7] Database pcms: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2576:
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:28607) object ID
507864876 index ID 2 but was not detected in the scan.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:28607) object ID
507864876 index ID 2 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:96558) object ID
507864876 index ID 9 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:97687) object ID
507864876 index ID 10 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:111104) object ID
507864876 index ID 11 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:117681) object ID
507864876 index ID 12 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:117690) object ID
507864876 index ID 13 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
allocation errors and 0 consistency errors in table '(Object ID
507864876)' (object ID 507864876).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
allocation errors and 0 consistency errors in database 'pcms'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss
is the minimum repair level for the errors found by DBCC CHECKDB (pcms
repair_fast).
** Execution Time: 0 hrs, 2 mins, 22 secs **Hi Mark,
As all the indexes are non clustered (their indid is greater than 1) you
should be able to solve this issue by rebuilding the indexes on your table.
You can find the name of the table that is affected with
OBJECT_NAME(507864876), and you can then rebuild the indexes with DBCC
DBREINDEX(<table name>). Make a backup of your database first though.
--
Jacco Schalkwijk
SQL Server MVP
"Mark" <markcash@.Hotmail.com> wrote in message
news:57bdc737.0402160616.508ce27f@.posting.google.com...
> I am getting the following error in my Maintenance Plan. It looks as
> if it is just one table (according to the Object id). My question is
> how do I determine which table this is when all I have is this Object
> ID?
> Mark
>
> [7] Database pcms: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2576:
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:28607) object ID
> 507864876 index ID 2 but was not detected in the scan.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:28607) object ID
> 507864876 index ID 2 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:96558) object ID
> 507864876 index ID 9 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:97687) object ID
> 507864876 index ID 10 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:111104) object ID
> 507864876 index ID 11 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:117681) object ID
> 507864876 index ID 12 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:117690) object ID
> 507864876 index ID 13 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
> allocation errors and 0 consistency errors in table '(Object ID
> 507864876)' (object ID 507864876).
> [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
> allocation errors and 0 consistency errors in database 'pcms'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss
> is the minimum repair level for the errors found by DBCC CHECKDB (pcms
> repair_fast).
> ** Execution Time: 0 hrs, 2 mins, 22 secs **

Error From Maintenance Plan

I am getting the following error in my Maintenance Plan. It looks as
if it is just one table (according to the Object id). My question is
how do I determine which table this is when all I have is this Object
ID?
Mark
[7] Database pcms: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2576:
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:28607) object ID
507864876 index ID 2 but was not detected in the scan.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:28607) object ID
507864876 index ID 2 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:96558) object ID
507864876 index ID 9 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:97687) object ID
507864876 index ID 10 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:111104) object ID
507864876 index ID 11 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:117681) object ID
507864876 index ID 12 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
pointed to by the previous pointer of IAM page (1:117690) object ID
507864876 index ID 13 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The repair
level on the DBCC statement caused this repair to be bypassed.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
allocation errors and 0 consistency errors in table '(Object ID
507864876)' (object ID 507864876).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
allocation errors and 0 consistency errors in database 'pcms'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss
is the minimum repair level for the errors found by DBCC CHECKDB (pcms
repair_fast).
** Execution Time: 0 hrs, 2 mins, 22 secs **Hi Mark,
As all the indexes are non clustered (their indid is greater than 1) you
should be able to solve this issue by rebuilding the indexes on your table.
You can find the name of the table that is affected with
OBJECT_NAME(507864876), and you can then rebuild the indexes with DBCC
DBREINDEX(<table name> ). Make a backup of your database first though.
Jacco Schalkwijk
SQL Server MVP
"Mark" <markcash@.Hotmail.com> wrote in message
news:57bdc737.0402160616.508ce27f@.posting.google.com...
> I am getting the following error in my Maintenance Plan. It looks as
> if it is just one table (according to the Object id). My question is
> how do I determine which table this is when all I have is this Object
> ID?
> Mark
>
> [7] Database pcms: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2576:
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:28607) object ID
> 507864876 index ID 2 but was not detected in the scan.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:28607) object ID
> 507864876 index ID 2 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:96558) object ID
> 507864876 index ID 9 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:97687) object ID
> 507864876 index ID 10 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:111104) object ID
> 507864876 index ID 11 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:117681) object ID
> 507864876 index ID 12 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is
> pointed to by the previous pointer of IAM page (1:117690) object ID
> 507864876 index ID 13 but was not detected in the scan.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server] The repair
> level on the DBCC statement caused this repair to be bypassed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
> allocation errors and 0 consistency errors in table '(Object ID
> 507864876)' (object ID 507864876).
> [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 12
> allocation errors and 0 consistency errors in database 'pcms'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss
> is the minimum repair level for the errors found by DBCC CHECKDB (pcms
> repair_fast).
> ** Execution Time: 0 hrs, 2 mins, 22 secs **

error executing query

I have a database running on MSDE it was working fine. Recently when I try to select from the database I am getting the following error after a few records have been returned. All of the tables are giving this problem. Not sure what to do.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Connection Broken
These are network problems - update your drivers for network card, check
cables and so on.
You can try also to run from command prompt "ping -t yourserver" and see if
there are lost packets.
Just in case do a db check from query analyzer - "DBCC checkdb"
Bojidar Alexandrov

error executing query

I have a database running on MSDE it was working fine. Recently when I try t
o select from the database I am getting the following error after a few reco
rds have been returned. All of the tables are giving this problem. Not sure
what to do.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForD
ata (CheckforData()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network err
or. Check your network documentation.
Connection Broken"Warren" <anonymous@.discussions.microsoft.com> wrote in message
news:E77B88A4-C231-4C30-B2D2-C4282A43A32F@.microsoft.com...
> I have a database running on MSDE it was working fine. Recently when I try
to select from the database I am getting the following error after a few
records have been returned. All of the tables are giving this problem. Not
sure what to do.
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData[/c
olor]
(CheckforData()).
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Ch
eck
your network documentation.
> Connection Broken
>
It could be several things... first a question: were any changes made or
different software installed on the computer running MSDE?
If not, databases like MSDE and SQL Server can expose network issues such as
packet drops or interruptions. Also, rule out name resolution problems like
DNS or WINS.
Another angle, consider installing the latest version of MDAC on the client
computer and enabling both SQL Server utilities TCP/IP and Named Pipes.
Steve

error executing query

I have a database running on MSDE it was working fine. Recently when I try to select from the database I am getting the following error after a few records have been returned. All of the tables are giving this problem. Not sure what to do.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Connection Broken
"Warren" <anonymous@.discussions.microsoft.com> wrote in message
news:E77B88A4-C231-4C30-B2D2-C4282A43A32F@.microsoft.com...
> I have a database running on MSDE it was working fine. Recently when I try
to select from the database I am getting the following error after a few
records have been returned. All of the tables are giving this problem. Not
sure what to do.
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check
your network documentation.
> Connection Broken
>
It could be several things... first a question: were any changes made or
different software installed on the computer running MSDE?
If not, databases like MSDE and SQL Server can expose network issues such as
packet drops or interruptions. Also, rule out name resolution problems like
DNS or WINS.
Another angle, consider installing the latest version of MDAC on the client
computer and enabling both SQL Server utilities TCP/IP and Named Pipes.
Steve
sql

Error evaluating expression

Greetings my SQL friends.

Why do I get an error message saying that the following expression won't evaluate?

"Select * from Price_grp where price_grp_id >= " + (dt_str, 10, 1252) @.[User::MIN_PRICE_GRP_ID] +
" and " + (dt_str, 10, 1252) @.[User::MIN_PRICE_GRP_ID] + " > 0"

Thanks for your help in advance.

Hi friends,

I have solved the problem now. I didn't change the code but I got it to evaluate in the end. I don't know what I did to fix it but perhaps there was some issue with the spaces. I don't know...

|||

Do you still have a note of the error message you had when it would not evaluate?

Donald

|||

Afraid not. Like I said, not quite sure how I sorted it out but I reckon there was some issue with white spaces or something because the same expression worked without any changes!

Thanks.

Error establishing socket

Our applications (day-end jobs) sporadically get the following errors
(usually between midnight and 1 AM):
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
[Microsoft][SQLServer 2000 Driver for JDBC]Address in use: connect
If the job is restarted, it then works without error. Any ideas what may be
causing the error?
Thanks in advance for any assistance you can offer,
-Chris
Chris:
It's suspicious that these errors appear time-related, esp. during a
*mainentance* time of day when servers may be getting backed up or traffic
on the network may spike w/ data replication, etc. Have you done a good
check for possible environment issues?
-shelby
Shelby Goerlitz
Microsoft SQL Server
"Chris Rowan" <ChrisRowan@.discussions.microsoft.com> wrote in message
news:770F1B8E-5740-4DA5-8053-8B88DA922C2A@.microsoft.com...
> Our applications (day-end jobs) sporadically get the following errors
> (usually between midnight and 1 AM):
> [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
> [Microsoft][SQLServer 2000 Driver for JDBC]Address in use: connect
> If the job is restarted, it then works without error. Any ideas what may
be
> causing the error?
> Thanks in advance for any assistance you can offer,
> -Chris
sql

Error encountered while executing a UDF

Hi,

I get the following error while trying to execute a UDF.

Msg 6522, Level 16, State 1, Line 1

A .NET Framework error occurred during execution of user defined routine or aggregate 'test':

System.NullReferenceException: Object reference not set to an instance of an object.

System.NullReferenceException:

at SalesCentral_Database.UserDefinedFunctions.udfTest()

My function is defined as follows:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction(DataAccess:=DataAccessKind.Read)> _

Public Shared Function udfTest() As SqlString

SqlContext.Pipe.Send(System.DateTime.Now().ToString())

Dim conn As New SqlConnection("context connection=true")

conn.Open()

Dim cmd As New SqlCommand("SELECT MAX(ACCTPERIOD) FROM TBL_OPPORTUNITY_HIS", conn)

Return New SqlString(cmd.ExecuteScalar().ToString())

End Function

End Class

SQL Server

CREATE ASSEMBLY SalesCentral_Database from '\\isew5l6c\tranf\SFS_Sales\SalesCentral_Database.dll' WITH PERMISSION_SET = SAFE

CREATE FUNCTION test() RETURNS NVARCHAR(10) AS EXTERNAL NAME [SalesCentral_Database].[SalesCentral_Database.UserDefinedFunctions].[udfTest]

SELECT dbo.test()

- Here I get the error mentioned above. Can anyone please tell me what am I missing.

Thanks.

Hi,

This is the same error as in this thread. You should remove the "SqlContext.Pipe.Send..." line from your code. I'm curious what you intent is with that linethe pipe is really to return results from within a stored procedure.

Cheers,
-Isaac

|||Thanks for bringing that to my notice. Sorry it has slipped out of my mind :)

Error encountered when creating a new datasource

Hello:
I am new with the Reporting services.
When I tried creating a data source with the following connection string
with the following options:
Conenction Type: SQLServer or OLE DB
Connect using: credentials supplied by the user running the report)
Connection String:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
Catalog=Northwind;Data Source=venkat-wxp2;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=VENKAT-WXP2;Use Encryption for
Data=False;Tag with column collation when possible=False
I get the following error:
The underlying connection was closed: Could not establish trust relationship
with remote server.
I am on a standalone Windows 2003 Server named venkat-wxp2.
Any help will be appreciated. Thanks in advance.
VenkiTry a simple connection string first and see if it works.
Initial Catalog=Northwind;Data Source=venkat-wxp2;
--
| Thread-Topic: Error encountered when creating a new datasource
| thread-index: AcVrkf5jtPegPMTmTqyEkHE51Kcf9A==| X-WBNR-Posting-Host: 24.56.142.17
| From: "=?Utf-8?B?dnZlbms=?=" <vvenk@.discussions.microsoft.com>
| Subject: Error encountered when creating a new datasource
| Date: Tue, 7 Jun 2005 11:52:03 -0700
| Lines: 28
| Message-ID: <577C1F19-4A5B-4E75-B15D-C81CFDD9BD9D@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45474
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello:
|
| I am new with the Reporting services.
|
| When I tried creating a data source with the following connection string
| with the following options:
| Conenction Type: SQLServer or OLE DB
| Connect using: credentials supplied by the user running the report)
| Connection String:
|
| Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
| Catalog=Northwind;Data Source=venkat-wxp2;Use Procedure for
Prepare=1;Auto
| Translate=True;Packet Size=4096;Workstation ID=VENKAT-WXP2;Use Encryption
for
| Data=False;Tag with column collation when possible=False
|
| I get the following error:
|
| The underlying connection was closed: Could not establish trust
relationship
| with remote server.
|
| I am on a standalone Windows 2003 Server named venkat-wxp2.
|
| Any help will be appreciated. Thanks in advance.
|
| Venki
|
|
|
||||Brad:
Yes, I did try the simpler connection string. I encounter the same issue.
Thanks.
venki
""Brad Syputa - MS"" wrote:
> Try a simple connection string first and see if it works.
> Initial Catalog=Northwind;Data Source=venkat-wxp2;
> --
> | Thread-Topic: Error encountered when creating a new datasource
> | thread-index: AcVrkf5jtPegPMTmTqyEkHE51Kcf9A==> | X-WBNR-Posting-Host: 24.56.142.17
> | From: "=?Utf-8?B?dnZlbms=?=" <vvenk@.discussions.microsoft.com>
> | Subject: Error encountered when creating a new datasource
> | Date: Tue, 7 Jun 2005 11:52:03 -0700
> | Lines: 28
> | Message-ID: <577C1F19-4A5B-4E75-B15D-C81CFDD9BD9D@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45474
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hello:
> |
> | I am new with the Reporting services.
> |
> | When I tried creating a data source with the following connection string
> | with the following options:
> | Conenction Type: SQLServer or OLE DB
> | Connect using: credentials supplied by the user running the report)
> | Connection String:
> |
> | Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
> | Catalog=Northwind;Data Source=venkat-wxp2;Use Procedure for
> Prepare=1;Auto
> | Translate=True;Packet Size=4096;Workstation ID=VENKAT-WXP2;Use Encryption
> for
> | Data=False;Tag with column collation when possible=False
> |
> | I get the following error:
> |
> | The underlying connection was closed: Could not establish trust
> relationship
> | with remote server.
> |
> | I am on a standalone Windows 2003 Server named venkat-wxp2.
> |
> | Any help will be appreciated. Thanks in advance.
> |
> | Venki
> |
> |
> |
> |
>|||While I do not know the cause of your error, a good article to read is at :
http://www.awprofessional.com/articles/article.asp?p=357694&rl=1
--
| Thread-Topic: Error encountered when creating a new datasource
| thread-index: AcVrvSNw13tsTe+nTPeEUMl0Hpblcw==| X-WBNR-Posting-Host: 24.56.142.17
| From: "=?Utf-8?B?dnZlbms=?=" <vvenk@.discussions.microsoft.com>
| References: <577C1F19-4A5B-4E75-B15D-C81CFDD9BD9D@.microsoft.com>
<btNl$X6aFHA.2476@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Error encountered when creating a new datasource
| Date: Tue, 7 Jun 2005 17:00:53 -0700
| Lines: 71
| Message-ID: <12ECD0E6-E614-4932-96D5-1AEF2B80B125@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45502
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Brad:
|
| Yes, I did try the simpler connection string. I encounter the same issue.
|
| Thanks.
|
| venki
|
| ""Brad Syputa - MS"" wrote:
|
| > Try a simple connection string first and see if it works.
| >
| > Initial Catalog=Northwind;Data Source=venkat-wxp2;
| > --
| > | Thread-Topic: Error encountered when creating a new datasource
| > | thread-index: AcVrkf5jtPegPMTmTqyEkHE51Kcf9A==| > | X-WBNR-Posting-Host: 24.56.142.17
| > | From: "=?Utf-8?B?dnZlbms=?=" <vvenk@.discussions.microsoft.com>
| > | Subject: Error encountered when creating a new datasource
| > | Date: Tue, 7 Jun 2005 11:52:03 -0700
| > | Lines: 28
| > | Message-ID: <577C1F19-4A5B-4E75-B15D-C81CFDD9BD9D@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:45474
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Hello:
| > |
| > | I am new with the Reporting services.
| > |
| > | When I tried creating a data source with the following connection
string
| > | with the following options:
| > | Conenction Type: SQLServer or OLE DB
| > | Connect using: credentials supplied by the user running the report)
| > | Connection String:
| > |
| > | Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
| > | Catalog=Northwind;Data Source=venkat-wxp2;Use Procedure for
| > Prepare=1;Auto
| > | Translate=True;Packet Size=4096;Workstation ID=VENKAT-WXP2;Use
Encryption
| > for
| > | Data=False;Tag with column collation when possible=False
| > |
| > | I get the following error:
| > |
| > | The underlying connection was closed: Could not establish trust
| > relationship
| > | with remote server.
| > |
| > | I am on a standalone Windows 2003 Server named venkat-wxp2.
| > |
| > | Any help will be appreciated. Thanks in advance.
| > |
| > | Venki
| > |
| > |
| > |
| > |
| >
| >
||||Brad:
I just de-installed SQL Server 2000 and installed SQL Server 2005 instead
and I was able to create a datasource.
Thanks.
""Brad Syputa - MS"" wrote:
> While I do not know the cause of your error, a good article to read is at :
> http://www.awprofessional.com/articles/article.asp?p=357694&rl=1
> --
> | Thread-Topic: Error encountered when creating a new datasource
> | thread-index: AcVrvSNw13tsTe+nTPeEUMl0Hpblcw==> | X-WBNR-Posting-Host: 24.56.142.17
> | From: "=?Utf-8?B?dnZlbms=?=" <vvenk@.discussions.microsoft.com>
> | References: <577C1F19-4A5B-4E75-B15D-C81CFDD9BD9D@.microsoft.com>
> <btNl$X6aFHA.2476@.TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: Error encountered when creating a new datasource
> | Date: Tue, 7 Jun 2005 17:00:53 -0700
> | Lines: 71
> | Message-ID: <12ECD0E6-E614-4932-96D5-1AEF2B80B125@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45502
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Brad:
> |
> | Yes, I did try the simpler connection string. I encounter the same issue.
> |
> | Thanks.
> |
> | venki
> |
> | ""Brad Syputa - MS"" wrote:
> |
> | > Try a simple connection string first and see if it works.
> | >
> | > Initial Catalog=Northwind;Data Source=venkat-wxp2;
> | > --
> | > | Thread-Topic: Error encountered when creating a new datasource
> | > | thread-index: AcVrkf5jtPegPMTmTqyEkHE51Kcf9A==> | > | X-WBNR-Posting-Host: 24.56.142.17
> | > | From: "=?Utf-8?B?dnZlbms=?=" <vvenk@.discussions.microsoft.com>
> | > | Subject: Error encountered when creating a new datasource
> | > | Date: Tue, 7 Jun 2005 11:52:03 -0700
> | > | Lines: 28
> | > | Message-ID: <577C1F19-4A5B-4E75-B15D-C81CFDD9BD9D@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:45474
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | Hello:
> | > |
> | > | I am new with the Reporting services.
> | > |
> | > | When I tried creating a data source with the following connection
> string
> | > | with the following options:
> | > | Conenction Type: SQLServer or OLE DB
> | > | Connect using: credentials supplied by the user running the report)
> | > | Connection String:
> | > |
> | > | Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial
> | > | Catalog=Northwind;Data Source=venkat-wxp2;Use Procedure for
> | > Prepare=1;Auto
> | > | Translate=True;Packet Size=4096;Workstation ID=VENKAT-WXP2;Use
> Encryption
> | > for
> | > | Data=False;Tag with column collation when possible=False
> | > |
> | > | I get the following error:
> | > |
> | > | The underlying connection was closed: Could not establish trust
> | > relationship
> | > | with remote server.
> | > |
> | > | I am on a standalone Windows 2003 Server named venkat-wxp2.
> | > |
> | > | Any help will be appreciated. Thanks in advance.
> | > |
> | > | Venki
> | > |
> | > |
> | > |
> | > |
> | >
> | >
> |
>

Error during upgrade of SQL Server 7.0 to 2000

Hello!
I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
2000 on Windows 2000 server, during the upgrade
I received the following error message " Error running
script:messages.sql(1)".
I found Microsoft article 300676 how to fix this problem.
In this article they provide link to the new setup.ins file
you have to download in order to fix your installation.
Here's the link and it doesn't work:
ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
Does anybody know the correct link? Or where I can download this file from?
Thank you,
LenaArticle says:
To use the fix, use these steps:
1.. Download s80305i.exe
from:ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
The password is: 8.00.305
2.. To install SQL Server 2000 using the new Setup.ins file, copy all of
the files on the SQL Server 2000 CD to a directory on your drive.
3.. Replace the existing Setup.ins in the \x86\Setup\ folder with the
Setup.ins file that you downloaded in the fix.
4.. Rerun the SQL Server 2000 setup.
It is working fine. I just cheked this out. If you will not able to download
it let me know your EMail I'll send it to you.
Regards
---
All information provided above AS IS.
"Lena" <lenaglozman@.yahoo.com> wrote in message
news:fc1e8071.0310310848.12b948d5@.posting.google.com...
> Hello!
> I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
> 2000 on Windows 2000 server, during the upgrade
> I received the following error message " Error running
> script:messages.sql(1)".
> I found Microsoft article 300676 how to fix this problem.
> In this article they provide link to the new setup.ins file
> you have to download in order to fix your installation.
> Here's the link and it doesn't work:
> ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
> Does anybody know the correct link? Or where I can download this file
from?
> Thank you,
> Lena|||I could download the file from
ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/s80
305i.exe and then ran winzip to extract the setup.ins
file, the password to unzip this file is 8.00.305.
Let me know if you still having problem downloading this
file, i can email the setup.ins file to you.
>--Original Message--
>Hello!
>I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
>2000 on Windows 2000 server, during the upgrade
> I received the following error message " Error running
>script:messages.sql(1)".
>I found Microsoft article 300676 how to fix this problem.
>In this article they provide link to the new setup.ins
file
>you have to download in order to fix your installation.
>Here's the link and it doesn't work:
>ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
>Does anybody know the correct link? Or where I can
download this file from?
>Thank you,
>Lena
>.
>

Error during SQL 2000 SP3a upgrade

I received the following error while executing the
REPLCOM.SQL script during the upgrade.
[DBNETLIB]General network error. Check your network
documentation.
[DBNETLIB]ConnectionRead (recv()).
This was the only output in REPLCOM.OUT.
Any ideas, I upgraded other servers and this did not
happen. I was upgrading from SQL 2000 SP2.
Mark,
Is the SQL Server service pack directory you are installing from on the
network or on your local machine? Perhaps there was a network outage
whilst the upgrade was running?
Can you copy the install directory locally and run it again?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Gozick wrote:
> I received the following error while executing the
> REPLCOM.SQL script during the upgrade.
> [DBNETLIB]General network error. Check your network
> documentation.
> [DBNETLIB]ConnectionRead (recv()).
> This was the only output in REPLCOM.OUT.
> Any ideas, I upgraded other servers and this did not
> happen. I was upgrading from SQL 2000 SP2.
sql

Error during SQL 2000 SP3a upgrade

I received the following error while executing the
REPLCOM.SQL script during the upgrade.
[DBNETLIB]General network error. Check your network
documentation.
[DBNETLIB]ConnectionRead (recv()).
This was the only output in REPLCOM.OUT.
Any ideas, I upgraded other servers and this did not
happen. I was upgrading from SQL 2000 SP2.Mark,
Is the SQL Server service pack directory you are installing from on the
network or on your local machine? Perhaps there was a network outage
whilst the upgrade was running?
Can you copy the install directory locally and run it again?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Gozick wrote:
> I received the following error while executing the
> REPLCOM.SQL script during the upgrade.
> [DBNETLIB]General network error. Check your network
> documentation.
> [DBNETLIB]ConnectionRead (recv()).
> This was the only output in REPLCOM.OUT.
> Any ideas, I upgraded other servers and this did not
> happen. I was upgrading from SQL 2000 SP2.

Error during SQL 2000 SP3a upgrade

I received the following error while executing the
REPLCOM.SQL script during the upgrade.
[DBNETLIB]General network error. Check your network
documentation.
[DBNETLIB]ConnectionRead (recv()).
This was the only output in REPLCOM.OUT.
Any ideas, I upgraded other servers and this did not
happen. I was upgrading from SQL 2000 SP2.Mark,
Is the SQL Server service pack directory you are installing from on the
network or on your local machine? Perhaps there was a network outage
whilst the upgrade was running?
Can you copy the install directory locally and run it again?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Gozick wrote:
> I received the following error while executing the
> REPLCOM.SQL script during the upgrade.
> [DBNETLIB]General network error. Check your network
> documentation.
> [DBNETLIB]ConnectionRead (recv()).
> This was the only output in REPLCOM.OUT.
> Any ideas, I upgraded other servers and this did not
> happen. I was upgrading from SQL 2000 SP2.

Error during set partner statement (SP1)

Hi!

I have the following error during setting partner on mirror server
Msg 1431, Level 16, State 4, Line 1
Neither the partner nor the witness server instance for database "masterserver" is available. Reissue the command when at least one of the instances becomes available.

The partner is available through telnet. I've also checked ports vai netstat and have no found errors.

There are two noteworthy erros in the error log at mirror server
Error: 9642, Severity: 16, State: 3.
and
An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')

Security settings it seems are set accurately.

Ok, find out the problem.
I leave database yesterday in restoring state and today morning it has recovering state.

When I synchronize logs again mirroring has worked fine. I think during server startup (I restarted server today morning) it tries to recover mirror database. It leads database status changing and impossibility to set up partner.

Error during query execution

Hi,
Does anyone know how to solve the following error during
query execution?
Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to e:\sql_data\Microsoft SQL
Server\MSSQL$DEVA_AP04_SQL\log\SQL00048.dmp
*
****************************************
*******************
********************
*
* BEGIN STACK DUMP:
* 03/11/04 16:40:34 spid 57
*
* Exception Address = 00418209 (FastDBCSToUnicode +
000000B6 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000015
* Input Buffer 2824 bytes -
* SELECT event_time as [Alert Time],
combo_orders.firm_name AS [Firm], dbo
* .GetTradingSymbol(underlying_id) AS [Underlying],
combo_orders.order_pri
* ce AS [Price], combo_orders.original_quantity AS
[Original Quantity], tr
* aded_quantity AS [Traded Quantity],
combo_orders.current_quantity AS [Cu
* rrrent Quantity], order_begin_time as [Time of Entry],
dbo.GetOrderStatu
* sText(combo_orders.current_order_status) AS [Current
Status], dbo.GetCom
* bexAlertText(reason_code) as [Alert Type],
dbo.GetCombexAlertAcknowledge
* dText(acknowledged) as [Acknowledged], login_id as [ISE
Analyst], combex
* _alerts.logb_order_number as [LogB Order Number],
item_id as [Item ID],
* combex_alert_id as [Combex Alert ID] FROM combex_alerts
WITH (NOLOCK), c
* ombo_orders WITH (NOLOCK) WHERE
combex_alerts.logb_order_number = combo_
* orders.logb_order_number AND reason_code IN
(13,7,2,3,9,11,12,10,8,4,6,1
* ,14,5,15,22,20,18,21,19,16,17) AND display_on_off = 1
AND combex_alerts.
* market_date ='3/11/2004 12:00:00 AM' AND
combo_orders.logb_order_number
* <> 999 AND (combo_orders.sequence_number = (SELECT MAX
(sequence_number)
* FROM combo_orders co2 WITH (NOLOCK) WHERE
co2.logb_order_number = combo
* _orders.logb_order_number AND co2.logb_order_number <>
999 AND co2.mar
* ket_date = combo_orders.market_date AND
co2.market_date = '3/11/2004 12
* :00:00 AM' AND co2.underlying_id =
combo_orders.underlying_id)) ORDER B
* Y [Acknowledged], [Combex Alert ID] DESC
.
.
.
Error: 0, Severity: 19, State: 0
language_exec: Process 57 generated an access violation.
SQL Server is terminating this process..
Regards,
JennyJenny,
Access violations are more often than not SQL Server bugs. The first
thing to do is make sure you are up-to-date on service packs. What is
the result you get when you run select @.@.version? The one solution I
can find in newsgroups to an access violation referring to
FastDBCSToUnicode was solved by the installation of SQL Server 2000
service pack 3.
SK
Jenny wrote:

>Hi,
>Does anyone know how to solve the following error during
>query execution?
>Using 'dbghelp.dll' version '4.0.5'
>*Stack Dump being sent to e:\sql_data\Microsoft SQL
>Server\MSSQL$DEVA_AP04_SQL\log\SQL00048.dmp
>*
> ****************************************
*******************
>********************
>*
>* BEGIN STACK DUMP:
>* 03/11/04 16:40:34 spid 57
>*
>* Exception Address = 00418209 (FastDBCSToUnicode +
>000000B6 Line 0+00000000)
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000015
>* Input Buffer 2824 bytes -
>* SELECT event_time as [Alert Time],
>combo_orders.firm_name AS [Firm], dbo
>* .GetTradingSymbol(underlying_id) AS [Underlying],
>combo_orders.order_pri
>* ce AS [Price], combo_orders.original_quantity AS
>[Original Quantity], tr
>* aded_quantity AS [Traded Quantity],
>combo_orders.current_quantity AS [Cu
>* rrrent Quantity], order_begin_time as [Time of Entry],
>dbo.GetOrderStatu
>* sText(combo_orders.current_order_status) AS [Current
>Status], dbo.GetCom
>* bexAlertText(reason_code) as [Alert Type],
>dbo.GetCombexAlertAcknowledge
>* dText(acknowledged) as [Acknowledged], login_id as [ISE
>Analyst], combex
>* _alerts.logb_order_number as [LogB Order Number],
>item_id as [Item ID],
>* combex_alert_id as [Combex Alert ID] FROM combex_alerts
>WITH (NOLOCK), c
>* ombo_orders WITH (NOLOCK) WHERE
>combex_alerts.logb_order_number = combo_
>* orders.logb_order_number AND reason_code IN
>(13,7,2,3,9,11,12,10,8,4,6,1
>* ,14,5,15,22,20,18,21,19,16,17) AND display_on_off = 1
>AND combex_alerts.
>* market_date ='3/11/2004 12:00:00 AM' AND
>combo_orders.logb_order_number
>* <> 999 AND (combo_orders.sequence_number = (SELECT MAX
>(sequence_number)
>* FROM combo_orders co2 WITH (NOLOCK) WHERE
>co2.logb_order_number = combo
>* _orders.logb_order_number AND co2.logb_order_number <>
>999 AND co2.mar
>* ket_date = combo_orders.market_date AND
>co2.market_date = '3/11/2004 12
>* :00:00 AM' AND co2.underlying_id =
>combo_orders.underlying_id)) ORDER B
>* Y [Acknowledged], [Combex Alert ID] DESC
>.
>.
>.
>Error: 0, Severity: 19, State: 0
>language_exec: Process 57 generated an access violation.
>SQL Server is terminating this process..
>
>Regards,
>Jenny
>
>

Error during merge web sync

Hello,

We have 5 subscribers trying to replicate via web synchronization. Two of the subscribers get the following message and the other three are fine. Any ideas on what the problem is or where to troubleshoot? Thanks in advance.

John

Error on client output:

The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.

Are you using a mix of .NET 1.1 and .NET 2.0 in your applications? If so, that can cause this error to happen. Try migrating your application to .NET 2.0 completely and see if that fixes your problem.|||

Mahesh,

Our app does uses a class that was developed using 1.1. However this class has nothing to do with replication. Could this still cause this error?

John

|||

On the IIS machine if there is an app that uses .NET 1.1, it could cause this to happen.

Another way to troubleshoot is to run https://Machine.domain/virtualDir/replisapi.dll?diag and you should see SUCCESS in all the class instantiation on that page. If not, then that is the cause of the problem.

|||

Mahesh,

This is a web server box that only has two virtual directories. Both are used for replication. One for sqlexpress replication and the other for WM 5.0 devices. We get successes from both sqlexpressurl/replisapi.dll?diag and wm50url/sqlcesa30.dll?diag, with the exception of the reconciler for the wm50url/sqlcesa30.dll?diag for version 8.0 which we are not using. This sites are all running asp 2.0

John

|||I have seen typically that once is 3 times you can get successes. Other times it could fail to load the dll and hance cause the sync to fail. Can you try on a different IIS box that doesnt have anything except the virtual directory to rule out this possibility?|||Hi John,

I have had this exact same message. Basically this occured because changes to the publisher database meant the subscribers required a new data partition snapshot. I pre-generated the snapshot and I have the option to allow subscribers to auto generate snapshots switched off. When the subscriber connects it does not recognise and hence does not download the pre-generated snapshot file and there for began the process of enumerating all the data that is needed for the subscriber. Immediately after downloading x number of chunks it then pops the same messaqge you receive.

If I was to switch auto generate snapshots option on then the subscriber happily runs the snapshot agent then downloads and applies it as expected. This was not ideal as we did not want auto-snapshot on for server load reasons.

We were at this timeusing FTP not UNC for delivery of snapshots. We had trouble with UNC shares between the servers which forced our hand on this. I spent two weeks in conversation with Microft Tech Support, until I tried finally to solve the UNC issue. I managed to get the UNC share visible from our webserver and hey presto it sorted our problem out and the subscribers happily retrieve pre-generated snapshots.

Not sure if this is anyway similar situation but might be useful

Cheers
Rab|||

Rab,

I'll give that a try thanks for the input I appreciate it.

John

|||

Mahesh,

We are having the same problem. The client application is solely 2.0 framework, but the client unit also has framework 1.1 for some other applications not related to the replication process. The webserver is solely 2.0 framework and doesn't even have 1.1 installed on the machine. Is there another reason for these errors? It looks like we get the 14151 error first the the web synchronization right after it. SQL 2k5 SP1.

Server logs:

Date 3/27/2007 10:14:47 PM
Log SQL Server (Current - 3/28/2007 6:00:00 AM)

Source spid102

Message
Replication-Replication Merge Subsystem: agent INSTANCE_NAME failed. The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.

Date 3/27/2007 10:14:47 PM
Log SQL Server (Current - 3/28/2007 6:00:00 AM)

Source spid102

Message
Error: 14151, Severity: 18, State: 1.

Error during merge web sync

Hello,

We have 5 subscribers trying to replicate via web synchronization. Two of the subscribers get the following message and the other three are fine. Any ideas on what the problem is or where to troubleshoot? Thanks in advance.

John

Error on client output:

The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.

Are you using a mix of .NET 1.1 and .NET 2.0 in your applications? If so, that can cause this error to happen. Try migrating your application to .NET 2.0 completely and see if that fixes your problem.|||

Mahesh,

Our app does uses a class that was developed using 1.1. However this class has nothing to do with replication. Could this still cause this error?

John

|||

On the IIS machine if there is an app that uses .NET 1.1, it could cause this to happen.

Another way to troubleshoot is to run https://Machine.domain/virtualDir/replisapi.dll?diag and you should see SUCCESS in all the class instantiation on that page. If not, then that is the cause of the problem.

|||

Mahesh,

This is a web server box that only has two virtual directories. Both are used for replication. One for sqlexpress replication and the other for WM 5.0 devices. We get successes from both sqlexpressurl/replisapi.dll?diag and wm50url/sqlcesa30.dll?diag, with the exception of the reconciler for the wm50url/sqlcesa30.dll?diag for version 8.0 which we are not using. This sites are all running asp 2.0

John

|||I have seen typically that once is 3 times you can get successes. Other times it could fail to load the dll and hance cause the sync to fail. Can you try on a different IIS box that doesnt have anything except the virtual directory to rule out this possibility?|||Hi John,

I have had this exact same message. Basically this occured because changes to the publisher database meant the subscribers required a new data partition snapshot. I pre-generated the snapshot and I have the option to allow subscribers to auto generate snapshots switched off. When the subscriber connects it does not recognise and hence does not download the pre-generated snapshot file and there for began the process of enumerating all the data that is needed for the subscriber. Immediately after downloading x number of chunks it then pops the same messaqge you receive.

If I was to switch auto generate snapshots option on then the subscriber happily runs the snapshot agent then downloads and applies it as expected. This was not ideal as we did not want auto-snapshot on for server load reasons.

We were at this timeusing FTP not UNC for delivery of snapshots. We had trouble with UNC shares between the servers which forced our hand on this. I spent two weeks in conversation with Microft Tech Support, until I tried finally to solve the UNC issue. I managed to get the UNC share visible from our webserver and hey presto it sorted our problem out and the subscribers happily retrieve pre-generated snapshots.

Not sure if this is anyway similar situation but might be useful

Cheers
Rab
|||

Rab,

I'll give that a try thanks for the input I appreciate it.

John

|||

Mahesh,

We are having the same problem. The client application is solely 2.0 framework, but the client unit also has framework 1.1 for some other applications not related to the replication process. The webserver is solely 2.0 framework and doesn't even have 1.1 installed on the machine. Is there another reason for these errors? It looks like we get the 14151 error first the the web synchronization right after it. SQL 2k5 SP1.

Server logs:

Date 3/27/2007 10:14:47 PM
Log SQL Server (Current - 3/28/2007 6:00:00 AM)

Source spid102

Message
Replication-Replication Merge Subsystem: agent INSTANCE_NAME failed. The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.

Date 3/27/2007 10:14:47 PM
Log SQL Server (Current - 3/28/2007 6:00:00 AM)

Source spid102

Message
Error: 14151, Severity: 18, State: 1.

error during installing SP3

Hi
I've got following error during installing SP3
by running this file Sql2kasp3.exe after successfully
installation sql 2ksp3.exe,
(SQL server 2000,server station)
"an error occurred during move data process : -145"
Thanks for any reply
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Are you running analysis services?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1kakxwshqligo@.msnews.microsoft.com...
> Hi
> I've got following error during installing SP3
> by running this file Sql2kasp3.exe after successfully
> installation sql 2ksp3.exe,
> (SQL server 2000,server station)
> "an error occurred during move data process : -145"
> Thanks for any reply
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/sql

error during installing SP3

Hi
I've got following error during installing SP3
by running this file Sql2kasp3.exe after successfully
installation sql 2ksp3.exe,
(SQL server 2000,server station)
"an error occurred during move data process : -145"
Thanks for any reply
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Are you running analysis services?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1kakxwshqligo@.msnews.microsoft.com...

quote:

---

> Hi
> I've got following error during installing SP3
> by running this file Sql2kasp3.exe after successfully
> installation sql 2ksp3.exe,
> (SQL server 2000,server station)
> "an error occurred during move data process : -145"
> Thanks for any reply
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

---

error during installation of sql server 2005

I have sql server 2000 installed on my PC. Now it is giving following error during installation of sql server 2005.

"The procedure entry point _vswprintf_c_l could not be located in the dynamic link
library MSVCR80.dll."

What can be wrong?I would suggest posting this to SQL Server Setup & Upgrade forum for faster response.

Thanks,
-Vineet Rao