Pdm_extract issue

[Legacy User]

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

[Paul Coccimiglio]

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?

[Shawn Walsh]

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

[Legacy User]

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!

[Shawn Walsh]

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

[Shawn Walsh]

Are there any plans to upgrade to a current release?

[Legacy User]

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

[Legacy User]

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))

[Legacy User]

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

[Anon Anon]

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

[Legacy User]

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!