CA Service Management

  • 1.  While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Posted Feb 08, 2018 04:44 AM

    While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Can some one help me to fix this issue.

    Regards,

    Kripesh



  • 2.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Posted Feb 08, 2018 08:05 AM

    Hi Kripesh,

    We generally dont recommend using pdm_restore as its a very time-consuming process.  Are you just attempting to backup and restore a database from one system to another?  If so, then you can simply use SQL backup and SQL restore (or oracle if you are using oracle).   If you must use pdm_restore and are not able to get past this issue, then I would recommend opening a support case for this one to have an engineer take a look at it on the affected system with you.

    Thanks,

    Jon I.



  • 3.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Broadcom Employee
    Posted Feb 08, 2018 10:42 AM

    Hi Kripesh,

    Did you pdm_restore on same SDM server with same DB server?  If pdm_restore on different SDM server or different DB, it won't work.

    Regards,

    Derek



  • 4.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Posted Feb 09, 2018 01:30 AM

    Hi Derek,

    SDM server and DB server is same.

    We are trying pdm_restore option because we are upgrading database from SQL to oracle.

    Regards,

    Kripesh



  • 5.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.
    Best Answer

    Broadcom Employee
    Posted Feb 09, 2018 12:45 PM

    Hi Kripesh,

     

    This is a very data records insertion intensive process and could take a very long time if you did a full backup/restore like you mentioned.

     

    To quickly check if any data is getting inserted - you could try below via a command prompt:

     

    pdm_logstat -f orclclass.c milestone

     

    Check the SDM sdtlogs to see if it shows if its inserting data records.

     

    To stop the tracing repeat the command without the milestone flag:

    pdm_logstat -f orclclass.c 

     

     

    _R



  • 6.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Broadcom Employee
    Posted Feb 12, 2018 02:02 PM

    Kripesh.............

     

    Did the information provided by Jon, Derek and Raghu address your question?

     

    If so, please mark one of their answers as correct so that this thread can be closed.



  • 7.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Broadcom Employee
    Posted Feb 21, 2018 02:24 PM

    Kripesh.............  

    Did the information provided by Jon, Derek and Raghu address your question?  

    If so, please mark one of their answers as correct so that this thread can be closed.



  • 8.  Re: While doing pdm_restore, slump_nxd  process got hanged and not moving further. Also in command prompt is showing "Validating database backup file" from past many hours in ca service desk 12.9.

    Posted Feb 27, 2018 12:24 AM

    Hi,

     

    Issue still the same.