CA Service Management

 View Only
  • 1.  Pdm_extract issue

    Posted Nov 25, 2014 04:31 PM

    Hi guys

    I’ve an issue with PDM_EXTRACT command, just don’t returns anything .


    By example:

    - executing in command promt:: pdm_extract –v –f “select * from Priority” follows ENTER

    - command prompt don’t control line return, then I need abort (Control+C)

     

    STDLOG capture these lines:

     

    11/25 17:23:25.94 asusis-ueitm   sql_agent            8604 SIGNIFICANT  sql_agent.c            235 STARTUP of sql_agent:mdb:rgen-#1012:

    11/25 17:23:26.58 asusis-ueitm   sql_agent            8604 SIGNIFICANT  sql_agent.c            275 SHUTDOWN of sql_agent:mdb:rgen-#1012:

     

    Some idea to solve?

    Thanks you in advanced



  • 2.  Re: Pdm_extract issue

    Broadcom Employee
    Posted Nov 25, 2014 04:51 PM

    What version of SDM are you using?

     

    Have you tried the command without the -v option?

     

    Do you see any extra pdm_extract processes running via Task Manager?



  • 3.  Re: Pdm_extract issue

    Broadcom Employee
    Posted Nov 25, 2014 05:16 PM

    In addition to Paul's suggestions, it would be interesting to try:

    Open Command prompt by running as Administrator and then run the command.

    Does this command work?

    pdm_extract Priority



  • 4.  Re: Pdm_extract issue

    Posted Nov 25, 2014 05:41 PM

    Hi Paul & Shawn!

     

    Paul:

    - i'm using SDM 12.5

    - without -v parameter is the same result, dont works

    - no other pdm_extract process running.

     

    Shawn:

    - yes, i was tried too but the same: dont work.

    - "pdm_extract Priority" dont works too

     

    Thanks!



  • 5.  Re: Pdm_extract issue

    Broadcom Employee
    Posted Nov 26, 2014 12:46 PM

    I do not remember this being an issue in 12.5.  Do other pdm_* commands work, like pdm_status?



  • 6.  Re: Pdm_extract issue

    Broadcom Employee
    Posted Nov 26, 2014 12:53 PM

    Are there any plans to upgrade to a current release?



  • 7.  Re: Pdm_extract issue

    Posted Nov 26, 2014 02:49 PM

    Other command pdm_* works fine, and currently we are doing migration test to 12.9,, regards



  • 8.  Re: Pdm_extract issue

    Posted Nov 27, 2014 01:17 AM

    I've seen this problem once...Turned out to be a problem with the path format in the paradigm.ini

     

    Also check if you do not have the paradigm.ini in two paths (~program files and ~program files (x86))



  • 9.  Re: Pdm_extract issue

    Posted Nov 27, 2014 06:38 AM

    Hi Brian,
    I’ve PARADIGM.INI file into C:\WINDOWS directory only. It’s content:

    [PARADIGM]
    NX_ROOT=C:/APPS/CA/SERVIC~1
    NX_LOCAL=C:/APPS/CA/SERVIC~1

    NX_OS_TYPE=WINNT
    [Product]
    type=CA Service Desk Manager
    version=12.5.0.572

     

    I verify that NX_ROOT and NX_LOCAL value are rights.


    Regards



  • 10.  Re: Pdm_extract issue

    Posted Nov 27, 2014 07:47 PM

    How about considering rgen command?

     

    C:\Users\Administrator>rgen -h

    Usage: rgen or pdm_extract

    [ -h (help) ]

    [ -f (format string) ]

    [ -c (CSV output) ]

    [ -e (CSV output with double double quotes) ]

    [ -r (informal report output) ]

    [ -v (verbose) ]

    [ -s (saved_script) ]

    [ -u (no headers) ]

    [ -d (use dataent.fmt) ]

    [ -x (locale sensitive numeric formats) ]

    [ -X (extract all tables except table list) ]

    [ -B (do not include UTF-8 Byte Order Mark (BOM) (set by NX_ADD_UTF8_BYTE_ORDER

    _MARK )) ]

    [ -C (convert output to named charset or 'DEFAULT' to use default charset) ]

    ALL | database table names ....

     

    Thanks,

    Naveen



  • 11.  Re: Pdm_extract issue
    Best Answer

    Posted Nov 28, 2014 01:36 PM

    This app comes from the **** definitely

     

    Try to execute rgen command but your behavior is the same that pdm_extract command, its mean still hangs and shows nothing.

     

    But, executing pdm_extract command again, works!

     

    It seems that rgen execution has exorcised to pdm_extract command.

     

    Thanks you a lot guys!