AnsweredAssumed Answered

Help with pdm_extract and spel macro

Question asked by TheKatherine on Aug 30, 2017
Latest reply on Aug 30, 2017 by SHAWN WALSH

I have a custom SPEL code (macro) that was created and copied from an older version of SDM to our current environment (v14.1.3) which I need to change due to it causing errors and not being correct anymore. I am unable to modify the code via the application. 

 

I want to use the command (pdm_extract) to extract the code to a file, make my code changes and then upload the information back into the system, however when I try this the file is empty. I know the data exists as I can see it in the db (see image below)

 

run the query against my db to be sure the macro exists

 

 

text file created from pdm_extract command is empty (0 KB)

 

 

 

Current Macro:

zgroup_manager = (uuid)expand(format("&{%s=cnt.persistent_id->id}",misc::find_mang(group)));

 

Change Macro to this:

zgroup_manager = group.supervisor_contact_uuid;

 

Command I am using (running as administrator on my background and application servers):

pdm_extract -f "SELECT id, persid, del, sym, ob_type, type, fragment, lock_object FROM splmac WHERE id=500216" > c:\shzmgr.txt

 

 

 

 

Any help would be appreciated.

thanks

Katherine

 

Outcomes