Showing posts with label planned. Show all posts
Showing posts with label planned. Show all posts

Monday, March 26, 2012

Microsoft reporting Services Support & Changes

Hi We are planning to install the Reporting Services, but have been given a very negative feedback by some companies which planned to move to this.

The type of uncertainities that are coming through are:
1) product may either undergo a signifcant change
2) lose support

Can anyone help me with these questions, as i myself believe that it is hard to imagine such a big change.

Let me know what you think about this?

Thanking you in anticipation,

Kind Regards,
NittoWhat information did those companies base their opinions on? It sounds very subjective to me. The ease of report design/deployment, and flexibility is enough for the two companies I do independant contracting for to proceed full steam with this.|||Hi,
They were not willing to give any concrete answers, but asked us to investiagate more into Microsoft's decisions on changing the product and Support.

Does anyone think that such a big change is possible?

Thanks, Nitto|||As part of the development team, I can assure you that we are moving forward with Reporting Services, as evidenced by our SQL 2005 release. While competitors might like to think otherwise, RS has a bright future.

Brian Welcker
Group Program Manager
Reporting Services

Wednesday, March 7, 2012

Meta Data Cleanup Error

Hi,
We are Merge replicating about 50 Production databases. We had planned to
monitor the meta deta clean up error during replication.
While we were monitoring the data to be updated during replication in one of
these databases, noticed 4 records to be merge replicated ( 3 insert and 1
update). At this moment we noticed the meta data clean up error. "The merge
process could not perform retention-based meta data cleanup in database
'database name'". The replication was in retrying mode and additionally the
following errors were reported
a) The subscription to publication 'XXXX' is invalid.
b) The process is running and is waiting for a response from one of the
backend connections'
During this process there we no issues in the remaining 49 databases,
replication was proceeding as usual.
In this database where we noticed the the above errors, the replication was
in sync in another 10 minutes, without any manual intervention.
What triggers to raise these error messages.
Please let us know what correction action we need to take for these error
messages
Thanks,
Soura.
Hi,
I got it from One article...
"The most common reason I can think of is that the query timed out. Sometime
retention based cleaup may need to cleanup a lot of rows and that can take
time. Rerunning the merge with a larger value for the querytimeout parameter
should fix this problem."
Hope this will help
Herbert
"SouRa" wrote:

> Hi,
> We are Merge replicating about 50 Production databases. We had planned to
> monitor the meta deta clean up error during replication.
> While we were monitoring the data to be updated during replication in one of
> these databases, noticed 4 records to be merge replicated ( 3 insert and 1
> update). At this moment we noticed the meta data clean up error. "The merge
> process could not perform retention-based meta data cleanup in database
> 'database name'". The replication was in retrying mode and additionally the
> following errors were reported
> a) The subscription to publication 'XXXX' is invalid.
> b) The process is running and is waiting for a response from one of the
> backend connections'
> During this process there we no issues in the remaining 49 databases,
> replication was proceeding as usual.
> In this database where we noticed the the above errors, the replication was
> in sync in another 10 minutes, without any manual intervention.
> What triggers to raise these error messages.
> Please let us know what correction action we need to take for these error
> messages
> Thanks,
> Soura.