Problem with PC /CPMB/LOAD_DS_TD_FULL_NEW

[guillermo_castaeda2]

     Hi all,

     I'm having a problem with the process chain /CPMB/LOAD_DS_TD_FULL_NEW,

     which consists to run the package by data manager not asked to enter the datasource.

     I followed the steps indicated by the 1850323 note.

     Also check that the UJD_DEF_INSTRUCT table is keeping the full text as indicated in a previous post.

     But nevertheless when the package runs prompted to enter the transformation file but not the datasource.

     Someone can tell me you may be doing missing.

     Best Regards,

     Guillermo,

[former_member186338 · Accepted solution]

Please show the advanced script for this package

[guillermo_castaeda2 · Accepted solution]

   Hi Vadim,

  This is the sequence

PROMPT(LOGSYSDTSRCSEL,%LOGSYS%,%DATASOURCE%,%SELECTION%,"PLEASE SELECT SOURCE SYSTEM AND DATASOURCE")

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"TRANSFORMATION FILE:",,,IMPORT.XLS)

PROMPT(RADIOBUTTON,%TARGETMODE%,"SELECT HOW TO HANDLING OF RECORDS IN TARGET",0,{"APPEND","OVERWRITE RECORDS WITH MATCH KEY","REPLACE DATA IN SAME DATA REGION OF ENTITY, CATEGORY, TIME AND AUDIT ID"},{"0","1","2"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"SELECT WHETHER TO RUN DEFAULT LOGIC FOR STORED VALUES AFTER IMPORTING",1,{"YES","NO"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"SELECT WHETHER TO CHECK WORK STATUS SETTINGS WHEN IMPORTING DATA.",1,{"YES, CHECK FOR WORK STATUS SETTINGS BEFORE IMPORTING","NO, DO NOT CHECK WORK STATUS SETTINGS"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"KEY DATE",0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

TASK(/CPMB/PSA_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/PSA_SOURCE,SELECTION,%SELECTION%)

TASK(/CPMB/PSA_SOURCE,LOGSYS,%LOGSYS%)

TASK(/CPMB/PSA_SOURCE,DATASOURCE,%DATASOURCE%)

TASK(/CPMB/PSA_CONVERT,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/PSA_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/PSA_CONVERT,SUSER,%USER%)

TASK(/CPMB/PSA_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/PSA_CONVERT,SAPP,%APP%)

TASK(/CPMB/PSA_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/PSA_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_PSA,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_PSA,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/LOAD_PSA,INPUTNO,%TEMPNO2%)

TASK(/CPMB/LOAD_PSA,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_PSA,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD_PSA,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/LOAD_PSA,KEYDATE,%KEYDATE%)

   Thanks,

[former_member186338 · Accepted solution]

Please read:

[former_member186338 · Accepted solution]

P.S. I suspect that this chain is still not supported...