CA Service Management

Publish schema with replication without delete replication (READPAST error) 

Jun 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
5 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.