Microsoft SQL Server 2005 RTM merge replication issues

We are trying to implement merge replication between 2 servers. Database size is around 11GB.

When I tried to create publication, snaphot agent is failing with following errror.

Error: 14151, Severity: 18, State: 1.
Replication-Replication Snapshot Subsystem: agent NBTENTSQL1X-PayDirectWeb-PayDirectPub-2 failed. The
replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
Exception Message: String or binary data would be truncated.
Cannot find the object 'MSmerge_sel_4D388

The table where the snapshot is breaking contains around 169 columns. Can someone please help me get through this error ?

Are you using vertical partitioning to replicate subset of the columns of the table? You may be hitting an known issue in Microsoft SQL Server 2005 where the list of column names for the table is longer than 4K and hence gets truncated in an internal proc.

|||

Thanks Sudarshan, your reply is very helpful. No we are not using vertical partitioning.

If this is a known issue, did Microsoft have any immediate fix for it or we have wait for SQL2K5 SP2 ?

|||Please wait for SQL2K5 SP2. You can install the latest CTPs availalbe and test out that your scenarios works. If not, please reply back and we can take a look further.|||This is a known issue in SQL2K5 SP1 which is fixed in SP2.|||Does the same limitation apply to the complexity of joined tables in the filter? I'm getting an error in the snapshot agent, saying:

String or

binary data would be truncated.

Cannot find

the object 'MSmerge_ctsv_2C675AF5938E4EA1B7D0DCFF9ECAD9EB', because it does not

exist or you do not have permission.

sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_upd_2C675AF5938E4EA1B7

But this only happens when I add too many joined tables to the filter section of the publication.

Dan

Microsoft SQL Server 2005 RTM merge replication issues

We are trying to implement merge replication between 2 servers. Database size is around 11GB.

When I tried to create publication, snaphot agent is failing with following errror.

Error: 14151, Severity: 18, State: 1.
Replication-Replication Snapshot Subsystem: agent NBTENTSQL1X-PayDirectWeb-PayDirectPub-2 failed. The
replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
Exception Message: String or binary data would be truncated.
Cannot find the object 'MSmerge_sel_4D388

The table where the snapshot is breaking contains around 169 columns. Can someone please help me get through this error ?

Are you using vertical partitioning to replicate subset of the columns of the table? You may be hitting an known issue in Microsoft SQL Server 2005 where the list of column names for the table is longer than 4K and hence gets truncated in an internal proc.

|||

Thanks Sudarshan, your reply is very helpful. No we are not using vertical partitioning.

If this is a known issue, did Microsoft have any immediate fix for it or we have wait for SQL2K5 SP2 ?

|||Please wait for SQL2K5 SP2. You can install the latest CTPs availalbe and test out that your scenarios works. If not, please reply back and we can take a look further.|||This is a known issue in SQL2K5 SP1 which is fixed in SP2.|||Does the same limitation apply to the complexity of joined tables in the filter? I'm getting an error in the snapshot agent, saying:

String or

binary data would be truncated.

Cannot find

the object 'MSmerge_ctsv_2C675AF5938E4EA1B7D0DCFF9ECAD9EB', because it does not

exist or you do not have permission.

sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_upd_2C675AF5938E4EA1B7

But this only happens when I add too many joined tables to the filter section of the publication.

Dan

Microsoft SQL 2000 Reporting Services

Has anyone who is involved in testing the Beta 2 version of this SQL
add-on (reporting services) needed to implement a calendar control as
a means to obtain parameter criteria?
Is this possible to place and then fire the calendar control on a
report and then populate a field with the date that was selected on
the control.
Cheers
GrantHi
As this is a beta you are probably governed by an NDA, therefore a public
newsgroup is not the appropriate place for a question like this.
John
"GrantS" <sutcliffe_grant@.hotmail.com> wrote in message
news:6963940b.0312221250.5afb1f75@.posting.google.com...
> Has anyone who is involved in testing the Beta 2 version of this SQL
> add-on (reporting services) needed to implement a calendar control as
> a means to obtain parameter criteria?
> Is this possible to place and then fire the calendar control on a
> report and then populate a field with the date that was selected on
> the control.
> Cheers
> Grant|||Oops! OK - Thanks John.

Microsoft Analysis Services on the web problem

Hi All!

We are trying to implement a web solution which include some OLAP cubes. We are using the followings applications and components:

Server: Windows 2000 - Microsoft Internet Information Server - SQL Server 2000 - Microsoft Analysis Services

Client: Active X Cube Browser included with Office 2000 - Pivot Table Services

For access the cubes, we developed an ASP which includes the Active X, and connect to the Analysis Services server. If i access this web page from the server, i can view the cube, and use it without any problem, but if i try to access the cube accross internet, i am having the following problem:

"The operation requested failed due to security problems - the user could not be authenticated"

If you have any idea or suggestion about this problem, let me know.
Thanks!

IgnacioIt depends on the secuity mode you are using with SQL server most sane people wont let NT authentication through their firewall which leaves SQL logins only.

Try setting up the accounts to use SQL only authentication & see how you go.

Post back if probs

J.|||Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||HII
Can u tell me what was the permissions in the cube.

1) if the cube gave has access to everyone . How did u restrict people on the network to access the cube.
2) if it was specific domain users. How did u manage to propagate security of a user accessing from the page.

Regds
Ram

Originally posted by isbampato
Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||Ram,

we didn't configure a secure environment yet, because the cubes were prepared only for a demo in our intranet. We have created a test database, and a test set of cubes, and added a new user only for use in this test environment, and with full control over it.

Besides, we added basic web authentication to the web page with the online cubes.

We didn't analyze yet how to secure this because it's still at a test phase.

Best regards,

Ignacio