Clarity Service Management

Publish schema with replication without delete replication (READPAST error) 

06-06-2016 07:36 AM

Hello again guys,

 

I found a way to use pdm_publish with BD replication(boxi offline) without delete that replication, only stopping that.

With the replication online, you will recive the READPAST error during the pdm_publish.

 

Before PDM_PUBLISH, you need to stop the replication agent:

replication2.PNG

replication3.PNG

 

With the Agent stopped, insert the var SQL_NO_DIRTY_READS:

sql_dirty1.PNG

 

Now, you can use PDM_PUBLISH without recive the READPAST error.

 

After this, disable that variable:

sql_dirty2.PNG

 

And start the Agent.

 

 

 

Tks to EduardoDiersmann and Sandra_Antunes.

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

03-22-2018 08:34 AM

Hey Rianne,

 

Please ignore my previous comment. My apologies.

 

Though NO_DIRTY_READS was being referred to, it does look like  SQL_NO_DIRTY_READS  is still the correct one.  Meaning what you have in the document is correct, no changes needed.

 

Thank you !

_R

03-21-2018 09:23 AM

Rianne,

 

Based on the source code, the option seems to be:

 

NO_DIRTY_READS  and not  SQL_NO_DIRTY_READS.

 

Everything else should be correct otherwise though.  Would this be a change that you could make?


Thank you 
_R

 

Edited my comment above and put a strikethrough so please do not get misled by my previous wrong suggestion.  Its still readable, but makes it hard :-)

06-06-2016 02:28 PM

Thanks for sharing this with the community Rianne!

Publish schema with replication without delete replication (READPAST error)

06-06-2016 08:43 AM

Thanks for the feedback Rianne. I'll request the original tecdoc to be updated with this info!

Sandra

Related Entries and Links

No Related Resource entered.