Extraction of users using DW.EXPORT

Hi,

We're having an issue with User extraction from DW.EXPORT. Currently, only few of the records are being extracted from DW.EXPORT but not all the records. Could you please suggest if any changes need to be done for this in DW.EXPORT setup?

DW.EXPORT record for USER:
GB Description USER EXTRACTION FOR DW.EXPORT
Sel Company.1 NP0010001
Process Rtn DW.USER.PROCESS.API
Field Name.1 @ID
Field Name.2 USER.NAME
Field Name.3 SIGN.ON.NAME
Field Name.4 CLASSIFICATION
Field Name.5 LANGUAGE
Field Name.6 COMPANY.CODE
Field Name.7 DEPARTMENT.CODE
Field Name.8 PASSWORD.VALIDITY
Field Name.9 START.DATE.PROFILE
Field Name.10 END.DATE.PROFILE
Field Name.11 START.TIME
Field Name.12 END.TIME
Field Name.13 TIME.OUT.MINUTES
Field Name.14 ATTEMPTS
Field Name.15 INIT.APPLICATION
Field Name.16 CUSTOMER
Field Name.17 ACCOUNT
Field Name.18 COMPANY.RESTR
Field Name.19 APPLICATION
Field Name.20 VERSION
Field Name.21 FUNCTION
Field Name.22 FIELD.NO
Field Name.23 DATA.COMPARISON
Field Name.24 DATA.FROM
Field Name.25 DATA.TO
Field Name.26 SIGN.ON.OFF.LOG
Field Name.27 SECURITY.MGMT.L
Field Name.28 APPLICATION.LOG
Field Name.29 FUNCTION.ID.LOG
Field Name.30 INPUT.DAY.MONTH
Field Name.31 ATTEMPTS.SINCE
Field Name.32 DATE.LAST.SIGN.ON
Field Name.33 TIME.LAST.SIGN.ON
Field Name.34 PASSWORD
Field Name.35 PASSW.CHANGE.DATE
Field Name.36 PASSW.END.DATE
Field Name.37 DEACTIVATION.DATE
Field Name.38 REACTIVATION.DATE
Field Name.39 CLEAR.SCREEN
Field Name.40 OVERRIDE.CLASS
Field Name.41 LOCAL.REF
Field Name.42 DEALER.DESK
Field Name.43 PRINTER.FOR.RPTS
Field Name.44 PRINTER.FOR.P.FUNC
Field Name.45 USER.ADDR
Field Name.46 RPT.TO.RECEIVE
Field Name.47 RPT.COPIES
Field Name.48 LAST.SPOOL.DATE
Field Name.49 LAST.SPOOL.TIME
Field Name.50 AMOUNT.FORMAT
Field Name.51 RESERVED.11
Field Name.52 RESERVED2
Field Name.53 RESERVED1
Field Name.54 MAX.SESSIONS
Field Name.55 ATTRIBUTES
Field Name.56 DISPO.OFFICER
Field Name.57 DISPO.RIGHTS
Field Name.58 SIGN.ON.ITEM
Field Name.59 SIGN.OFF.ITEM
Field Name.60 PROCESS.DEPT
Field Name.61 OTH.BOOK.ACCESS
Field Name.62 OTH.BOOK.BLOCK
Field Name.63 ALLOWED.DAYS
Field Name.64 DAY.ST.TIME
Field Name.65 DAY.END.TIME
Field Name.66 LDAP.ID
Field Name.67 LDAP.DN
Field Name.68 LEAD.PREF
Field Name.69 DATE.FORMAT
Field Name.70 OFFLINE.SMS.PROFILE
Field Name.71 SIGN.ON.RTN
Field Name.72 LOGIN.STATUS
Field Name.73 CHANNEL
Field Name.74 RESERVED.8
Field Name.75 RESERVED.7
Field Name.76 RESERVED.6
Field Name.77 RESERVED.5
Field Name.78 RESERVED.4
Field Name.79 RESERVED.3
Field Name.80 RESERVED.2
Field Name.81 RESERVED.1
Field Name.82 OVERRIDE
Field Name.83 RECORD.STATUS
Field Name.84 CURR.NO
Field Name.85 INPUTTER
Field Name.86 DATE.TIME
Field Name.87 AUTHORISER
Field Name.88 CO.CODE
Field Name.89 DEPT.CODE
Field Name.90 AUDITOR.CODE
Field Name.91 AUDIT.DATE.TIME
Takeover Y
Hash Tot Fld LANGUAGE
Date Time.1 29 MAR 11 09:13

We are using R10 version of T24.

Thanks in advance,
Sailen

I suggest you write a select routine and place in SELECTION.RTN field.
You should also analyze what the Process Routine is doing.