CA Service Management

Hello,

It was by mistake a change order was directly created in the offline/replication application and once the subscription runs, now we end up with two change orders with the same number in the offline reporting which is hampering our reporting.

could you please help how to delete the ticket from offline

regards

sharath

Hi Sharath,

Have you not tried pdm_extract command to remove the specific duplicate change order?

Note : Ensure that the relevant table data has to be removed not to have and dangling references.

Archive / Purge (Change Order) will help what are the related tables which need to be considered.

Hope this helps.

Hello Mahesh,

I have tried to user the pdm_userload -r which worked in test but when I try in offline it just hang at Loadind data and when I see the logs it says  below..

10/01 10:45:15.81 corpappl9198   dbload              11568 SIGNIFICANT  dbload.c               647 Dbload Started - Parms: -r -v "ch243020.txt"
10/01 10:45:15.99 corpappl9198   sql_agent            9468 SIGNIFICANT  sql_agent.c            245 STARTUP of sql_agent:mdb:dbload-#511568:

Is it because its offline server and we set it has Default_Set

BR

sharath

process set as Offline_reporting

Have tried pdm_load -r instead of pdm_userload?

Considering this is the offline DB used only for reporting, you can use a straight forward SQL means to delete the record

sharamateti 

With the Offline_Reporting PROCSET, SDM is started with a minimal number of processes/modules activated.

Therefore, not all SDM functions will work with this limited PROCSET.

I have changed the startup to MAIN_PROCSET and used the pdm_userload -r and it worked well

I was more worried if the removal cause more issue since I have read an other thread that any record should not be deleted.

so far it went well and reports are working fine