Hi ,
Webfocus procedure is failing with some kind of system error, please let us know if any one has faced simalar issue . I am using webfocus 767 on windows 2003 nt server.

%connect
%begin
ex turnover_smalltab_monthly_first
%end
SYSPRINT.SCR
-* file turnover_smalltab_monthly_first.fex
APP HOLD HRIS
-SET ASNAMES = ON
APP DELETEF HRIS FOC$HOLD MASTER
APP DELETEF HRIS FOC$HOLD FOCTEMP
-RUN

(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.mas
(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.ftm
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-* RUN TURNOVER_SMALLTAB_RUNFIRST.FEX BEFORE RUNNING MONTHLY
FILES
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-INCLUDE DEF_TIME_BEGIN
-SET &ECHO = ALL;
-* File DEF_TIME_BEGIN.fex
DEFINE FUNCTION TIME(HOUR1/A8, HOUR2/A8)
HRS1/I2 = EDIT(EDIT(HOUR1, '99'));
MIN1/I2 = EDIT(EDIT(HOUR1, '$$$99'));
SEC1/I4 = EDIT(EDIT(HOUR1, '$$$$$$99'));
HRS2/I2 = EDIT(EDIT(HOUR2, '99'));
MIN2/I2 = EDIT(EDIT(HOUR2, '$$$99'));
SEC2/I4 = EDIT(EDIT(HOUR2, '$$$$$$99'));
TIM1/I9 = HRS1 * 60 * 60 + MIN1 * 60 + SEC1 ;
TIM2/I9 = HRS2 * 60 * 60 + MIN2 * 60 + SEC2 ;
TIME/I9 = TIM2 - TIM1 ;
END
-RUN

-*
-SET &STARTCPU=421 ;
-TYPE 421
421
-*
-SET &TIME1 = HHMMSS('A08');
-TYPE .
.
-TYPE THE BEGINNING TIME IS 13.43.15
THE BEGINNING TIME IS 13.43.15
-TYPE .
.
-*SET &ECHO = &&SEE;
-SET &ECHO = ALL ;
-SET &ECHO = ALL;
-RUN

-INCLUDE CHECKREC
-*SET &ECHO = &&SEE;
-SET &ECHO = ALL;
-*
-* *** checkrec.fex
-*
-DEFAULT &SARCNT = '0';

WINNT ERASE D:\HRIS\SAR_CNT.TXT
-RUN

FILEDEF SAR_CNT DISK D:\HRIS\SAR_CNT.TXT
-RUN

TABLE FILE SAP_ASSOCIATE_REP
COUNT PERSNUM/I6
IF EMP_STATUS NE 'Withdrawn'
ON TABLE SAVE AS SAR_CNT FORMAT ALPHA
END
-RUN

0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1


ALPHANUMERIC RECORD NAMED SAR_CNT
0 FIELDNAME ALIAS FORMAT LENGTH

PERSNUM PERSNUM I6 6

TOTAL 6
-READ SAR_CNT &SARCNT.A6.

-SET &SAPASSOCIATE = IF 131392 LT 120000 THEN 'SAP_ASSOCIATE' ELSE 'SAP_ASSOCIA
TE_REP';
-RUN

-SET &ECHO = ALL;
-SET &CURRMM = 20110105 /100;
-SET &START_DATE = AYM( 201101, -1, 'I6YYM');
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-*-SET &START_DATE = 200906;
-SET &CNTR = 0;
-SET &PREVMM = AYM( 201101, -1, 'I6YYM');
-CALCDATE

-*
-SET &DT1= AYM( 201012, 0, 'I6YYM');
-SET &DT2 = 201012|'01' ;
-*
-SET &BEG_MTH_DAY = DATECVT((DATEMOV((DATECVT(20101201,'I8YYMD','YYMD')),'BOM')
),'YYMD','A8MDYY');
-SET &END_MTH_DAY = DATECVT((DATEMOV((DATECVT(20101201,'I8YYMD','YYMD')),'EOM')
),'YYMD','A8MDYY');
-*
DEFINE FILE SAP_ORG_ASSIGNMENT_PRD
CORPLOC/A2 = EDIT(PERSONNEL_SUB_AREA, '99');
CORPLOCTEXT/A25 = DECODE CORPLOC('WP' 'White Plains' 'AS' 'Asia'
'AI' 'EAME'
'EU' 'EAME' 'BL' 'Bliss' 'RE' 'Bliss' 'NB' 'New Builds'
'NE' 'New Builds' 'HB' 'Home Based'
'HI' 'Hawaii' 'AT' 'Atlanta' 'AU' 'Austin' 'BO' 'Boston'
'BR' 'Braintree' 'CH' 'Chicago'
'DA' 'Dallas' 'DC' 'Washington DC' 'DE' 'Denver' 'FB' 'Field Based'
'FR' 'Fall River' 'GU' 'Guam'
'HO' 'Hotel' 'LA' 'Los Angeles' 'LC' 'Lancaster' 'LT' 'Latin America
' 'NA' 'North America' 'NY' 'New York'
'OM' 'Omaha' 'OR' 'Orlando' 'PH' 'Phoenix' 'RA' 'Raleigh'
'SF' 'San Francisco' 'SL' 'Salt Lake City'
'ST' 'St. Louis' 'SV' 'SVO' 'TU' 'Tustin' 'UB' 'Bliss'
'AE' 'Allocated'
'EX' 'Executives' 'MC' 'Marketing Comm' 'MG' 'Management Cmte' 'MM' 'Manage
ment Mrkt'
'MN' 'Marketing Non-Comm' 'MS' 'Management Sales' 'MT' 'Management Telemarket
ing'
'NM' 'Non-Management' 'SC' 'Sales Comm' 'SN' 'Sales Non Comm' 'TE' 'Telema
rketing' 'ZC' 'Conversion'
ELSE ' ' ) ;
END
-******************************************************************************
*****************
-* CALCULATE TABLE FOR BEGINNING OF THE MONTH
-******************************************************************************
*****************
APP DELETEF HRIS FOC$HOLD MASTER
APP DELETEF HRIS FOC$HOLD FOCTEMP
-RUN

(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.mas
(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.ftm
TABLE FILE SAP_ACTIONS
SUM EMP_STATUS_CODE EMP_STATUS
BY PERSNUM
WHERE (BEGIN_DATE LE '12012010') AND (END_DATE GE '12012010')
IF EMP_STATUS EQ 'Active'
IF PERSNUM NE '899$*'
ON TABLE HOLD AS SAFIRSTM FORMAT FOCUS INDEX PERSNUM
END
-RUN

0 NUMBER OF RECORDS IN TABLE= 129962 LINES= 129955

-NEXT1

APP DELETEF HRIS FOC$HOLD MASTER
APP DELETEF HRIS FOC$HOLD FOCTEMP
-RUN

(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.mas
(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.ftm
MATCH FILE SAP_ORG_ASSIGNMENT_PRD
SUM CORPLOC CORPLOCTEXT
PERSONNEL_SUB_AREA AS 'SOA_P_PERS_SUB_AREA'
PERSONNEL_SUB_AREA_TEXT AS 'SOA_P_PERS_SUB_AREA_TEXT'
BY PERSNUM
BY BEGIN_DATE
BY END_DATE
RUN
FILE SAP_ORG_ASSIGNMENT
SUM
LST.BEGIN_DATE AS SOA_BEGIN_DATE
LST.END_DATE AS SOA_END_DATE
LST.COMPANY_CODE AS SOA_COMPANY_CODE
LST.COMPANY_CODE_TEXT AS SOA_COMPANY_CODE_TEXT
LST.PERSONNEL_AREA AS SOA_PERSONNEL_AREA
LST.PERSONNEL_AREA_TEXT AS SOA_PERSONNEL_AREA_TEXT
LST.PERSONNEL_GROUP AS SOA_PERSONNEL_GROUP
LST.PERSONNEL_GROUP_TEXT AS SOA_PERSONNEL_GROUP_TEXT
LST.PERSONNEL_SUB_GROUP AS SOA_PERSONNEL_SUB_GROUP
LST.PERSONNEL_SUB_GROUP_TEXT AS SOA_PERSONNEL_SUB_GROUP_TEXT
LST.PERSONNEL_SUB_AREA AS SOA_PERSONNEL_SUB_AREA
LST.PERSONNEL_SUB_AREA_TEXT AS SOA_PERSONNEL_SUB_AREA_TEXT
LST.PAYROLL_AREA AS SOA_PAYROLL_AREA
LST.PAYROLL_AREA_TEXT AS SOA_PAYROLL_AREA_TEXT
LST.WORK_CONTRACT AS SOA_WORK_CONTRACT
LST.WORK_CONTRACT_TEXT AS SOA_WORK_CONTRACT_TEXT
LST.COST_CENTER AS SOA_COST_CENTER
LST.COST_CENTER_TEXT AS SOA_COST_CENTER_TEXT
LST.ORG_UNIT AS SOA_ORG_UNIT
LST.ORG_UNIT_TEXT AS SOA_ORG_UNIT_TEXT
LST.POSITION_CODE AS SOA_POSITION_CODE
LST.POSITION_TEXT AS SOA_POSITION_TEXT
LST.JOB_CODE AS SOA_JOB_CODE
LST.JOB_TEXT AS SOA_JOB_TEXT
BY PERSNUM
BY BEGIN_DATE
BY END_DATE
WHERE (BEGIN_DATE LE '12012010') AND (END_DATE GE '12012010')
IF PERSNUM NE '899$*'
AFTER MATCH HOLD AS 'SOA_COM1' NEW
END
-RUN

0 NUMBER OF RECORDS SELECTED= 757979 LINES= 757979
0 NUMBER OF RECORDS SELECTED= 476228 LINES= 476228
*** ibisnap.log from D:\starwood\batchjobs, exec=D:\ibi\srv76\home\bin\tscom3.exe
tktrap 5468 1700
01/05/2011 13:55

Loading psapi.dll
module name=d:\ibi\srv76\home\bin\tscom3.exe
checking module path against EDAHOME=d:\ibi\srv76\home
this is an EDA module
debugging prog=d:\ibi\srv76\home\bin\tscom3.exe pid=5468 arg=1700
p01 pid=5468
t01 tid=4504
Initializing Symbol Handler with path: d:\ibi\srv76\home\dbg;d:\ibi\srv76\home\bin
p01 t01 0ms 0ms pcreate 00400000 tscom3.exe
t02 tid=4140
p01 t02 31ms 0ms tcreate 77e617ec ?/?/?/?
p01 t01 31ms 31ms load 7c800000 ntdll.dll
p01 t01 47ms 47ms load 77e40000 kernel32.dll
p01 t01 62ms 62ms load 47a50000 ntdump.dll
p01 t01 78ms 78ms load 488f0000 utlh.dll
p01 t01 94ms 94ms load 48140000 r1fns.dll
p01 t01 109ms 109ms load 76c10000 imagehlp.dll
p01 t01 125ms 125ms load 77ba0000 msvcrt.dll
p01 t01 156ms 156ms load 7d1e0000 advapi32.dll
p01 t01 172ms 172ms load 77c50000 rpcrt4.dll
p01 t01 187ms 187ms load 76f50000 secur32.dll
p01 t01 219ms 219ms load 77380000 user32.dll
p01 t01 234ms 234ms load 77c00000 gdi32.dll
p01 t01 250ms 250ms load 7d180000 shlwapi.dll
p01 t01 266ms 266ms load 76df0000 activeds.dll
p01 t01 266ms 266ms load 76dc0000 adsldpc.dll
p01 t01 281ms 281ms load 71c40000 netapi32.dll
p01 t01 297ms 297ms load 76f10000 wldap32.dll
p01 t01 312ms 312ms load 76b80000 credui.dll
p01 t01 328ms 328ms load 7c8d0000 shell32.dll
p01 t01 344ms 344ms load 76a80000 atl.dll
p01 t01 359ms 359ms load 77670000 ole32.dll
p01 t01 375ms 375ms load 77d00000 oleaut32.dll
p01 t01 391ms 391ms load 46c20000 futlh.dll
p01 t01 406ms 406ms load 472f0000 mbx.dll
p01 t01 422ms 422ms load 463b0000 emgsrv.dll
p01 t01 437ms 437ms load 47fe0000 qopsys.dll
p01 t01 453ms 453ms load 451c0000 cbh.dll
p01 t01 484ms 484ms load 46bd0000 focutl.dll
p01 t01 500ms 500ms load 47930000 nlsp.dll
p01 t01 516ms 516ms load 471f0000 kkdo.dll
p01 t01 531ms 531ms load 47980000 nlssys.dll
p01 t01 547ms 547ms load 479b0000 ntctx.dll
p01 t01 562ms 562ms load 76290000 imm32.dll
p01 t01 578ms 578ms load 77420000 comctl32.dll
p01 t01 594ms 594ms load 76b70000 psapi.dll
p01 t01 609ms 609ms load 46fd0000 ioh.dll
p01 t01 625ms 625ms load 47c50000 nwh.dll
p01 t01 656ms 656ms load 47e40000 pth.dll
p01 t01 672ms 672ms load 48200000 r1sec.dll
p01 t01 687ms 687ms load 47830000 ngfl.dll
p01 t01 703ms 703ms load 48250000 rth.dll
p01 t01 734ms 734ms load 47ac0000 nthr.dll
p01 t01 766ms 766ms load 472c0000 maspar.dll
p01 t01 781ms 781ms load 47590000 mfp.dll
p01 t01 812ms 812ms load 48820000 tabutl.dll
p01 t01 828ms 828ms load 48880000 tokh.dll
p01 t01 859ms 859ms load 456c0000 corfoc.dll
p01 t01 875ms 875ms load 45650000 comph.dll
p01 t01 906ms 906ms load 46ef0000 ibiuth.dll
p01 t01 937ms 937ms load 47e60000 ptree.dll
p01 t01 953ms 953ms load 456b0000 complt.dll
p01 t01 984ms 984ms load 46b80000 focini.dll
p01 t01 1000ms 1000ms load 46bb0000 focscr.dll
p01 t01 1016ms 1016ms load 46d30000 gntint.dll
p01 t01 1047ms 1047ms load 47ec0000 qcvtin.dll
p01 t01 1062ms 1062ms load 46e10000 hffunc.dll
p01 t01 1078ms 1078ms load 46fc0000 io3270.dll
p01 t01 1109ms 1109ms load 47800000 ncache.dll
p01 t01 1125ms 1125ms load 47a10000 ntdm.dll
p01 t01 1156ms 1156ms load 47fc0000 qmfint.dll
p01 t01 1172ms 1172ms load 488d0000 utl.dll
p01 t01 1219ms 1219ms load 488c0000 ufaapi.dll
p01 t01 1234ms 1234ms load 48b30000 xfcode.dll
p01 t01 1281ms 1281ms load 48b60000 xfutil.dll
p01 t01 1297ms 1297ms load 47270000 lwidxf.dll
p01 t01 1328ms 1328ms load 48bd0000 xsrb.dll
p01 t01 1359ms 1359ms load 47260000 lwapi.dll
p01 t01 1406ms 1406ms load 47e20000 parser.dll
p01 t01 1437ms 1437ms load 463a0000 emglt.dll
p01 t01 1453ms 1453ms load 46fa0000 intcbs.dll
p01 t01 1500ms 1500ms load 47ad0000 ntmas.dll
p01 t01 1531ms 1531ms load 47c00000 ntsn.dll
p01 t01 1547ms 1547ms load 45600000 cmh.dll
p01 t01 1578ms 1578ms load 47000000 iregexp.dll
p01 t01 1609ms 1609ms load 47560000 mfdp.dll
p01 t01 1672ms 1672ms load 479d0000 ntdb.dll
p01 t01 1703ms 1703ms load 46f30000 imgdir.dll
p01 t01 1734ms 1734ms load 45960000 dmh.dll
p01 t01 1766ms 1766ms load 45a50000 dqsqlf.dll
p01 t01 1797ms 1797ms load 480b0000 qstrac.dll
p01 t01 1828ms 1828ms load 47da0000 or8foc.dll
p01 t01 1859ms 1859ms load 47dc0000 or8ps10.dll
p01 t01 1891ms 1891ms load 10000000 oci.dll
p01 t01 1953ms 1953ms load 7c340000 msvcr71.dll
p01 t01 1984ms 1984ms load 61c20000 oraclient10.dll
p01 t01 2031ms 2031ms load 60870000 oracore10.dll
p01 t01 2094ms 2094ms load 60a80000 oranls10.dll
p01 t01 2187ms 2187ms load 63690000 oraunls10.dll
p01 t01 2234ms 2234ms load 60eb0000 orauts.dll
p01 t01 2281ms 2281ms load 71c00000 ws2_32.dll
p01 t01 2312ms 2312ms load 71bf0000 ws2help.dll
p01 t01 2359ms 2359ms load 76aa0000 winmm.dll
p01 t01 2406ms 2406ms load 636b0000 oravsn10.dll
p01 t01 2437ms 2437ms load 60fa0000 oracommon10.dll
p01 t01 2500ms 2500ms load 60300000 orageneric10.dll
p01 t01 2578ms 2578ms load 63430000 orasnls10.dll
p01 t01 2625ms 2625ms load 00ff0000 oraxml10.dll
p01 t01 2703ms 2703ms load 60020000 msvcirt.dll
p01 t01 2766ms 2766ms load 60960000 oran10.dll
p01 t01 2828ms 2828ms load 62740000 oranl10.dll
p01 t01 2859ms 2859ms load 62790000 oranldap10.dll
p01 t01 2922ms 2922ms load 627f0000 orannzsbb10.dll
p01 t01 2984ms 2984ms load 62530000 oraldapclnt10.dll
p01 t01 3016ms 3016ms load 62670000 orancrypt10.dll
p01 t01 3062ms 3062ms load 71bb0000 wsock32.dll
p01 t01 3125ms 3125ms load 62920000 oranro10.dll
p01 t01 3187ms 3187ms load 626b0000 oranhost10.dll
p01 t01 3234ms 3234ms load 62660000 orancds10.dll
p01 t01 3281ms 3281ms load 629c0000 orantns10.dll
p01 t01 3328ms 3328ms load 60b50000 orapls10.dll
p01 t01 3391ms 3391ms load 003b0000 ORASLAX10.DLL
p01 t01 3453ms 3453ms load 63080000 oraplp10.dll
p01 t01 3531ms 3531ms load 61ed0000 orahasgen10.dll
p01 t01 3594ms 3594ms load 62ab0000 oraocr10.dll
p01 t01 3672ms 3672ms load 62b20000 oraocrb10.dll
p01 t01 3734ms 3734ms load 62980000 orantcp10.dll
p01 t01 3781ms 3781ms load 01150000 orasql10.dll
p01 t01 3844ms 3844ms load 47c90000 odbfoc.dll
p01 t01 3922ms 3922ms load 47cf0000 odbpwin.dll
p01 t01 3969ms 3969ms load 01460000 odbc32.dll
p01 t01 4031ms 4031ms load 77530000 comctl32.dll
p01 t01 4109ms 4109ms load 762b0000 comdlg32.dll
p01 t01 4172ms 4172ms load 015f0000 odbcint.dll
p01 t01 4234ms 4234ms load 482b0000 sapfoc.dll
p01 t01 4297ms 4297ms load 48300000 sappas.dll
p01 t01 4359ms 4359ms load 59460000 librfc32.dll
p01 t01 4437ms 4437ms load 77b90000 version.dll
p01 t01 4500ms 4500ms load 01620000 msvcp60.dll
p01 t01 4672ms 4672ms load 48810000 tabp.dll
p01 t01 4750ms 4750ms load 46b60000 focapi.dll
p01 t01 4812ms 4812ms load 48430000 sndh.dll
p01 t01 4891ms 4891ms load 48190000 r1ine2.dll
p01 t01 4969ms 4969ms load 47b90000 ntmsrv.dll
p01 t01 5031ms 5031ms load 47b80000 ntmspr.dll
p01 t01 5109ms 5109ms load 485c0000 sqlds.dll
p01 t01 5187ms 5187ms load 451f0000 cdtab.dll
p01 t01 5266ms 5266ms load 71b20000 mswsock.dll
p01 t01 5344ms 5344ms load 5f270000 hnetcfg.dll
p01 t01 5422ms 5422ms load 71ae0000 wshtcpip.dll
p01 t01 5500ms 5500ms load 4b3c0000 msctf.dll
t03 tid=964
p01 t03 5562ms 0ms tcreate 7c83fde4 ntdll.dll/?/?/DbgUiRemoteBreakin+0x0
p01 t03 5562ms 0ms texit 0
--------------------------------------------------------------------------
p01 t01 5562ms 5562ms error c0000005 access violation

1] pc=77BD7E23,sp=0012F01C,fp=0012F024,ra=4577B761
msvcrt.dll/?/?/memcpy+0x33
2] pc=4577B761,sp=0012F01C,fp=0012F074,ra=4581BADC
corfoc.dll/?/?/rdtext+0x1059
3] pc=4581BADC,sp=0012F01C,fp=0012F268,ra=456FBA2E
corfoc.dll/?/?/dmlset+0x9ff
4] pc=456FBA2E,sp=0012F01C,fp=0012F8CC,ra=456FAC9A
corfoc.dll/?/?/tabctl+0xdca
5] pc=456FAC9A,sp=0012F01C,fp=00D3C5C0,ra=00D20768
corfoc.dll/?/?/tabctl+0x36
6] pc=00D20768,sp=0012F01C,fp=00D3C898,ra=00000010
?/?/?/?

%connect
%begin
ex turnover_smalltab_monthly_first
%end
SYSPRINT.SCR
-* file turnover_smalltab_monthly_first.fex
APP HOLD HRIS
-SET ASNAMES = ON
APP DELETEF HRIS FOC$HOLD MASTER
APP DELETEF HRIS FOC$HOLD FOCTEMP
-RUN

(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.mas
(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.ftm
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-* RUN TURNOVER_SMALLTAB_RUNFIRST.FEX BEFORE RUNNING MONTHLY
FILES
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-INCLUDE DEF_TIME_BEGIN
-SET &ECHO = ALL;
-* File DEF_TIME_BEGIN.fex
DEFINE FUNCTION TIME(HOUR1/A8, HOUR2/A8)
HRS1/I2 = EDIT(EDIT(HOUR1, '99'));
MIN1/I2 = EDIT(EDIT(HOUR1, '$$$99'));
SEC1/I4 = EDIT(EDIT(HOUR1, '$$$$$$99'));
HRS2/I2 = EDIT(EDIT(HOUR2, '99'));
MIN2/I2 = EDIT(EDIT(HOUR2, '$$$99'));
SEC2/I4 = EDIT(EDIT(HOUR2, '$$$$$$99'));
TIM1/I9 = HRS1 * 60 * 60 + MIN1 * 60 + SEC1 ;
TIM2/I9 = HRS2 * 60 * 60 + MIN2 * 60 + SEC2 ;
TIME/I9 = TIM2 - TIM1 ;
END
-RUN

-*
-SET &STARTCPU=187 ;
-TYPE 187
187
-*
-SET &TIME1 = HHMMSS('A08');
-TYPE .
.
-TYPE THE BEGINNING TIME IS 01.30.00
THE BEGINNING TIME IS 01.30.00
-TYPE .
.
-*SET &ECHO = &&SEE;
-SET &ECHO = ALL ;
-SET &ECHO = ALL;
-RUN

-INCLUDE CHECKREC
-*SET &ECHO = &&SEE;
-SET &ECHO = ALL;
-*
-* *** checkrec.fex
-*
-DEFAULT &SARCNT = '0';

WINNT ERASE D:\HRIS\SAR_CNT.TXT
-RUN

FILEDEF SAR_CNT DISK D:\HRIS\SAR_CNT.TXT
-RUN

TABLE FILE SAP_ASSOCIATE_REP
COUNT PERSNUM/I6
IF EMP_STATUS NE 'Withdrawn'
ON TABLE SAVE AS SAR_CNT FORMAT ALPHA
END
-RUN

0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1


ALPHANUMERIC RECORD NAMED SAR_CNT
0 FIELDNAME ALIAS FORMAT LENGTH

PERSNUM PERSNUM I6 6

TOTAL 6
-READ SAR_CNT &SARCNT.A6.

-SET &SAPASSOCIATE = IF 131562 LT 120000 THEN 'SAP_ASSOCIATE' ELSE 'SAP_ASSOCIA
TE_REP';
-RUN

-SET &ECHO = ALL;
-SET &CURRMM = 20110205 /100;
-SET &START_DATE = AYM( 201102, -1, 'I6YYM');
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-* ** ** ** ** ** ** ** ** ** ** ** ** ** ** **
** ** ** ** **
-*-SET &START_DATE = 200906;
-SET &CNTR = 0;
-SET &PREVMM = AYM( 201102, -1, 'I6YYM');
-CALCDATE

-*
-SET &DT1= AYM( 201101, 0, 'I6YYM');
-SET &DT2 = 201101|'01' ;
-*
-SET &BEG_MTH_DAY = DATECVT((DATEMOV((DATECVT(20110101,'I8YYMD','YYMD')),'BOM')
),'YYMD','A8MDYY');
-SET &END_MTH_DAY = DATECVT((DATEMOV((DATECVT(20110101,'I8YYMD','YYMD')),'EOM')
),'YYMD','A8MDYY');
-*
DEFINE FILE SAP_ORG_ASSIGNMENT_PRD
CORPLOC/A2 = EDIT(PERSONNEL_SUB_AREA, '99');
CORPLOCTEXT/A25 = DECODE CORPLOC('WP' 'White Plains' 'AS' 'Asia'
'AI' 'EAME'
'EU' 'EAME' 'BL' 'Bliss' 'RE' 'Bliss' 'NB' 'New Builds'
'NE' 'New Builds' 'HB' 'Home Based'
'HI' 'Hawaii' 'AT' 'Atlanta' 'AU' 'Austin' 'BO' 'Boston'
'BR' 'Braintree' 'CH' 'Chicago'
'DA' 'Dallas' 'DC' 'Washington DC' 'DE' 'Denver' 'FB' 'Field Based'
'FR' 'Fall River' 'GU' 'Guam'
'HO' 'Hotel' 'LA' 'Los Angeles' 'LC' 'Lancaster' 'LT' 'Latin America
' 'NA' 'North America' 'NY' 'New York'
'OM' 'Omaha' 'OR' 'Orlando' 'PH' 'Phoenix' 'RA' 'Raleigh'
'SF' 'San Francisco' 'SL' 'Salt Lake City'
'ST' 'St. Louis' 'SV' 'SVO' 'TU' 'Tustin' 'UB' 'Bliss'
'AE' 'Allocated'
'EX' 'Executives' 'MC' 'Marketing Comm' 'MG' 'Management Cmte' 'MM' 'Manage
ment Mrkt'
'MN' 'Marketing Non-Comm' 'MS' 'Management Sales' 'MT' 'Management Telemarket
ing'
'NM' 'Non-Management' 'SC' 'Sales Comm' 'SN' 'Sales Non Comm' 'TE' 'Telema
rketing' 'ZC' 'Conversion'
ELSE ' ' ) ;
END
-******************************************************************************
*****************
-* CALCULATE TABLE FOR BEGINNING OF THE MONTH
-******************************************************************************
*****************
APP DELETEF HRIS FOC$HOLD MASTER
APP DELETEF HRIS FOC$HOLD FOCTEMP
-RUN

(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.mas
(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.ftm
TABLE FILE SAP_ACTIONS
SUM EMP_STATUS_CODE EMP_STATUS
BY PERSNUM
WHERE (BEGIN_DATE LE '01012011') AND (END_DATE GE '01012011')
IF EMP_STATUS EQ 'Active'
IF PERSNUM NE '899$*'
ON TABLE HOLD AS SAFIRSTM FORMAT FOCUS INDEX PERSNUM
END
-RUN

0 NUMBER OF RECORDS IN TABLE= 129639 LINES= 129589

-NEXT1

APP DELETEF HRIS FOC$HOLD MASTER
APP DELETEF HRIS FOC$HOLD FOCTEMP
-RUN

(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.mas
(FOC36331) CANNOT DELETE FILE d:\hris\foc$hold.ftm
MATCH FILE SAP_ORG_ASSIGNMENT_PRD
SUM CORPLOC CORPLOCTEXT
PERSONNEL_SUB_AREA AS 'SOA_P_PERS_SUB_AREA'
PERSONNEL_SUB_AREA_TEXT AS 'SOA_P_PERS_SUB_AREA_TEXT'
BY PERSNUM
BY BEGIN_DATE
BY END_DATE
RUN
FILE SAP_ORG_ASSIGNMENT
SUM
LST.BEGIN_DATE AS SOA_BEGIN_DATE
LST.END_DATE AS SOA_END_DATE
LST.COMPANY_CODE AS SOA_COMPANY_CODE
LST.COMPANY_CODE_TEXT AS SOA_COMPANY_CODE_TEXT
LST.PERSONNEL_AREA AS SOA_PERSONNEL_AREA
LST.PERSONNEL_AREA_TEXT AS SOA_PERSONNEL_AREA_TEXT
LST.PERSONNEL_GROUP AS SOA_PERSONNEL_GROUP
LST.PERSONNEL_GROUP_TEXT AS SOA_PERSONNEL_GROUP_TEXT
LST.PERSONNEL_SUB_GROUP AS SOA_PERSONNEL_SUB_GROUP
LST.PERSONNEL_SUB_GROUP_TEXT AS SOA_PERSONNEL_SUB_GROUP_TEXT
LST.PERSONNEL_SUB_AREA AS SOA_PERSONNEL_SUB_AREA
LST.PERSONNEL_SUB_AREA_TEXT AS SOA_PERSONNEL_SUB_AREA_TEXT
LST.PAYROLL_AREA AS SOA_PAYROLL_AREA
LST.PAYROLL_AREA_TEXT AS SOA_PAYROLL_AREA_TEXT
LST.WORK_CONTRACT AS SOA_WORK_CONTRACT
LST.WORK_CONTRACT_TEXT AS SOA_WORK_CONTRACT_TEXT
LST.COST_CENTER AS SOA_COST_CENTER
LST.COST_CENTER_TEXT AS SOA_COST_CENTER_TEXT
LST.ORG_UNIT AS SOA_ORG_UNIT
LST.ORG_UNIT_TEXT AS SOA_ORG_UNIT_TEXT
LST.POSITION_CODE AS SOA_POSITION_CODE
LST.POSITION_TEXT AS SOA_POSITION_TEXT
LST.JOB_CODE AS SOA_JOB_CODE
LST.JOB_TEXT AS SOA_JOB_TEXT
BY PERSNUM
BY BEGIN_DATE
BY END_DATE
WHERE (BEGIN_DATE LE '01012011') AND (END_DATE GE '01012011')
IF PERSNUM NE '899$*'
AFTER MATCH HOLD AS 'SOA_COM1' NEW
END
-RUN

0 NUMBER OF RECORDS SELECTED= 762468 LINES= 762468
0 NUMBER OF RECORDS SELECTED= 478761 LINES= 478761
0 LINES OF MATCH OUTPUT = 478761
-*-*-*-*
JOIN CLEAR *
JOIN PERSNUM IN SOA_COM1 TO PERSNUM IN SOA_P_ENDDT AS J1
DEFINE FILE SOA_COM1
CORPLOC/A2 = IF (CORPLOC EQ ' ') AND (SOA_END_DATE EQ '12/31/9999') THEN CL9999
ELSE CORPLOC ;
END
TABLE FILE SOA_COM1
SUM
SOA_BEGIN_DATE
SOA_END_DATE
SOA_COMPANY_CODE
SOA_COMPANY_CODE_TEXT
SOA_PERSONNEL_AREA
SOA_PERSONNEL_AREA_TEXT
SOA_PERSONNEL_GROUP
SOA_PERSONNEL_GROUP_TEXT
SOA_PERSONNEL_SUB_GROUP
SOA_PERSONNEL_SUB_GROUP_TEXT
SOA_PERSONNEL_SUB_AREA
SOA_PERSONNEL_SUB_AREA_TEXT
SOA_PAYROLL_AREA
SOA_PAYROLL_AREA_TEXT
SOA_WORK_CONTRACT
SOA_WORK_CONTRACT_TEXT
SOA_COST_CENTER
SOA_COST_CENTER_TEXT
SOA_ORG_UNIT
SOA_ORG_UNIT_TEXT
SOA_POSITION_CODE
SOA_POSITION_TEXT
SOA_JOB_CODE
SOA_JOB_TEXT
CORPLOC CORPLOCTEXT
SOA_P_PERS_SUB_AREA
SOA_P_PERS_SUB_AREA_TEXT
BY PERSNUM
BY BEGIN_DATE
BY END_DATE
ON TABLE HOLD AS 'SOA_COM2' FORMAT FOCUS
END
-RUN

0 NUMBER OF RECORDS IN TABLE= 478761 LINES= 478761

-NEXT77

-*-*-*-*
JOIN CLEAR *
JOIN SOA_POSITION_CODE IN SOA_COM2 TO POS_CODE IN TO_LEVEL AS J1
TABLE FILE SOA_COM2
SUM
SOA_BEGIN_DATE
SOA_END_DATE
SOA_COMPANY_CODE
SOA_COMPANY_CODE_TEXT
SOA_PERSONNEL_AREA
SOA_PERSONNEL_AREA_TEXT
SOA_PERSONNEL_GROUP
SOA_PERSONNEL_GROUP_TEXT
SOA_PERSONNEL_SUB_GROUP
SOA_PERSONNEL_SUB_GROUP_TEXT
SOA_PERSONNEL_SUB_AREA
SOA_PERSONNEL_SUB_AREA_TEXT
SOA_PAYROLL_AREA
SOA_PAYROLL_AREA_TEXT
SOA_WORK_CONTRACT
SOA_WORK_CONTRACT_TEXT
SOA_COST_CENTER
SOA_COST_CENTER_TEXT
SOA_ORG_UNIT
SOA_ORG_UNIT_TEXT
SOA_POSITION_CODE
SOA_POSITION_TEXT
SOA_JOB_CODE
SOA_JOB_TEXT
CORPLOC CORPLOCTEXT
SOA_P_PERS_SUB_AREA
SOA_P_PERS_SUB_AREA_TEXT
LEVEL_CODE LEVEL_TEXT
BY PERSNUM
ON TABLE HOLD AS SOA1M FORMAT FOCUS INDEX PERSNUM
END
-RUN

*** ibisnap.log from D:\starwood\batchjobs, exec=D:\ibi\srv76\home\bin\tscom3.exe
tktrap 1228 1700
02/05/2011 01:40

Loading psapi.dll
module name=d:\ibi\srv76\home\bin\tscom3.exe
checking module path against EDAHOME=d:\ibi\srv76\home
this is an EDA module
debugging prog=d:\ibi\srv76\home\bin\tscom3.exe pid=1228 arg=1700
p01 pid=1228
t01 tid=5856
Initializing Symbol Handler with path: d:\ibi\srv76\home\dbg;d:\ibi\srv76\home\bin
p01 t01 0ms 0ms pcreate 00400000 tscom3.exe
t02 tid=6024
p01 t02 0ms 0ms tcreate 77e617ec ?/?/?/?
p01 t01 0ms 0ms load 7c800000 ntdll.dll
p01 t01 0ms 0ms load 77e40000 kernel32.dll
p01 t01 15ms 15ms load 47a50000 ntdump.dll
p01 t01 15ms 15ms load 488f0000 utlh.dll
p01 t01 15ms 15ms load 48140000 r1fns.dll
p01 t01 15ms 15ms load 76c10000 imagehlp.dll
p01 t01 15ms 15ms load 77ba0000 msvcrt.dll
p01 t01 15ms 15ms load 7d1e0000 advapi32.dll
p01 t01 31ms 31ms load 77c50000 rpcrt4.dll
p01 t01 31ms 31ms load 76f50000 secur32.dll
p01 t01 31ms 31ms load 77380000 user32.dll
p01 t01 31ms 31ms load 77c00000 gdi32.dll
p01 t01 31ms 31ms load 7d180000 shlwapi.dll
p01 t01 46ms 46ms load 76df0000 activeds.dll
p01 t01 46ms 46ms load 76dc0000 adsldpc.dll
p01 t01 46ms 46ms load 71c40000 netapi32.dll
p01 t01 46ms 46ms load 76f10000 wldap32.dll
p01 t01 62ms 62ms load 76b80000 credui.dll
p01 t01 62ms 62ms load 7c8d0000 shell32.dll
p01 t01 62ms 62ms load 76a80000 atl.dll
p01 t01 78ms 78ms load 77670000 ole32.dll
p01 t01 78ms 78ms load 77d00000 oleaut32.dll
p01 t01 78ms 78ms load 46c20000 futlh.dll
p01 t01 93ms 93ms load 472f0000 mbx.dll
p01 t01 93ms 93ms load 463b0000 emgsrv.dll
p01 t01 93ms 93ms load 47fe0000 qopsys.dll
p01 t01 93ms 93ms load 451c0000 cbh.dll
p01 t01 109ms 109ms load 46bd0000 focutl.dll
p01 t01 109ms 109ms load 47930000 nlsp.dll
p01 t01 125ms 125ms load 471f0000 kkdo.dll
p01 t01 125ms 125ms load 47980000 nlssys.dll
p01 t01 140ms 140ms load 479b0000 ntctx.dll
p01 t01 140ms 140ms load 76290000 imm32.dll
p01 t01 156ms 156ms load 77420000 comctl32.dll
p01 t01 156ms 156ms load 76b70000 psapi.dll
p01 t01 171ms 171ms load 46fd0000 ioh.dll
p01 t01 187ms 187ms load 47c50000 nwh.dll
p01 t01 187ms 187ms load 47e40000 pth.dll
p01 t01 187ms 187ms load 48200000 r1sec.dll
p01 t01 203ms 203ms load 47830000 ngfl.dll
p01 t01 203ms 203ms load 48250000 rth.dll
p01 t01 203ms 203ms load 47ac0000 nthr.dll
p01 t01 218ms 218ms load 472c0000 maspar.dll
p01 t01 218ms 218ms load 47590000 mfp.dll
p01 t01 234ms 234ms load 48820000 tabutl.dll
p01 t01 234ms 234ms load 48880000 tokh.dll
p01 t01 250ms 250ms load 456c0000 corfoc.dll
p01 t01 250ms 250ms load 45650000 comph.dll
p01 t01 265ms 265ms load 46ef0000 ibiuth.dll
p01 t01 265ms 265ms load 47e60000 ptree.dll
p01 t01 281ms 281ms load 456b0000 complt.dll
p01 t01 281ms 281ms load 46b80000 focini.dll
p01 t01 296ms 296ms load 46bb0000 focscr.dll
p01 t01 296ms 296ms load 46d30000 gntint.dll
p01 t01 312ms 312ms load 47ec0000 qcvtin.dll
p01 t01 328ms 328ms load 46e10000 hffunc.dll
p01 t01 328ms 328ms load 46fc0000 io3270.dll
p01 t01 343ms 343ms load 47800000 ncache.dll
p01 t01 343ms 343ms load 47a10000 ntdm.dll
p01 t01 359ms 359ms load 47fc0000 qmfint.dll
p01 t01 375ms 375ms load 488d0000 utl.dll
p01 t01 375ms 375ms load 488c0000 ufaapi.dll
p01 t01 390ms 390ms load 48b30000 xfcode.dll
p01 t01 406ms 406ms load 48b60000 xfutil.dll
p01 t01 421ms 421ms load 47270000 lwidxf.dll
p01 t01 421ms 421ms load 48bd0000 xsrb.dll
p01 t01 437ms 437ms load 47260000 lwapi.dll
p01 t01 484ms 484ms load 47e20000 parser.dll
p01 t01 500ms 500ms load 463a0000 emglt.dll
p01 t01 515ms 515ms load 46fa0000 intcbs.dll
p01 t01 531ms 531ms load 47ad0000 ntmas.dll
p01 t01 546ms 546ms load 47c00000 ntsn.dll
p01 t01 562ms 562ms load 45600000 cmh.dll
p01 t01 578ms 578ms load 47000000 iregexp.dll
p01 t01 578ms 578ms load 47560000 mfdp.dll
p01 t01 593ms 593ms load 479d0000 ntdb.dll
p01 t01 609ms 609ms load 46f30000 imgdir.dll
p01 t01 625ms 625ms load 45960000 dmh.dll
p01 t01 640ms 640ms load 45a50000 dqsqlf.dll
p01 t01 656ms 656ms load 480b0000 qstrac.dll
p01 t01 671ms 671ms load 47da0000 or8foc.dll
p01 t01 687ms 687ms load 47dc0000 or8ps10.dll
p01 t01 703ms 703ms load 10000000 oci.dll
p01 t01 734ms 734ms load 7c340000 msvcr71.dll
p01 t01 750ms 750ms load 61c20000 oraclient10.dll
p01 t01 765ms 765ms load 60870000 oracore10.dll
p01 t01 796ms 796ms load 60a80000 oranls10.dll
p01 t01 812ms 812ms load 63690000 oraunls10.dll
p01 t01 828ms 828ms load 60eb0000 orauts.dll
p01 t01 859ms 859ms load 71c00000 ws2_32.dll
p01 t01 875ms 875ms load 71bf0000 ws2help.dll
p01 t01 890ms 890ms load 76aa0000 winmm.dll
p01 t01 906ms 906ms load 636b0000 oravsn10.dll
p01 t01 937ms 937ms load 60fa0000 oracommon10.dll
p01 t01 953ms 953ms load 60300000 orageneric10.dll
p01 t01 984ms 984ms load 63430000 orasnls10.dll
p01 t01 1000ms 1000ms load 00ff0000 oraxml10.dll
p01 t01 1046ms 1046ms load 60020000 msvcirt.dll
p01 t01 1078ms 1078ms load 60960000 oran10.dll
p01 t01 1109ms 1109ms load 62740000 oranl10.dll
p01 t01 1125ms 1125ms load 62790000 oranldap10.dll
p01 t01 1140ms 1140ms load 627f0000 orannzsbb10.dll
p01 t01 1171ms 1171ms load 62530000 oraldapclnt10.dll
p01 t01 1203ms 1203ms load 62670000 orancrypt10.dll
p01 t01 1234ms 1234ms load 71bb0000 wsock32.dll
p01 t01 1250ms 1250ms load 62920000 oranro10.dll
p01 t01 1281ms 1281ms load 626b0000 oranhost10.dll
p01 t01 1296ms 1296ms load 62660000 orancds10.dll
p01 t01 1328ms 1328ms load 629c0000 orantns10.dll
p01 t01 1359ms 1359ms load 60b50000 orapls10.dll
p01 t01 1390ms 1390ms load 003b0000 ORASLAX10.DLL
p01 t01 1406ms 1406ms load 63080000 oraplp10.dll
p01 t01 1437ms 1437ms load 61ed0000 orahasgen10.dll
p01 t01 1468ms 1468ms load 62ab0000 oraocr10.dll
p01 t01 1500ms 1500ms load 62b20000 oraocrb10.dll
p01 t01 1531ms 1531ms load 62980000 orantcp10.dll
p01 t01 1562ms 1562ms load 01150000 orasql10.dll
p01 t01 1593ms 1593ms load 47c90000 odbfoc.dll
p01 t01 1625ms 1625ms load 47cf0000 odbpwin.dll
p01 t01 1656ms 1656ms load 4bf70000 odbc32.dll
p01 t01 1687ms 1687ms load 77530000 comctl32.dll
p01 t01 1718ms 1718ms load 762b0000 comdlg32.dll
p01 t01 1750ms 1750ms load 015b0000 odbcint.dll
p01 t01 1781ms 1781ms load 482b0000 sapfoc.dll
p01 t01 1828ms 1828ms load 48300000 sappas.dll
p01 t01 1859ms 1859ms load 59460000 librfc32.dll
p01 t01 1890ms 1890ms load 77b90000 version.dll
p01 t01 1921ms 1921ms load 015d0000 msvcp60.dll
p01 t01 2046ms 2046ms load 48810000 tabp.dll
p01 t01 2078ms 2078ms load 46b60000 focapi.dll
p01 t01 2125ms 2125ms load 48430000 sndh.dll
p01 t01 2156ms 2156ms load 48190000 r1ine2.dll
p01 t01 2203ms 2203ms load 47b90000 ntmsrv.dll
p01 t01 2234ms 2234ms load 47b80000 ntmspr.dll
p01 t01 2281ms 2281ms load 485c0000 sqlds.dll
p01 t01 2312ms 2312ms load 451f0000 cdtab.dll
p01 t01 2375ms 2375ms load 71b20000 mswsock.dll
p01 t01 2421ms 2421ms load 5f270000 hnetcfg.dll
p01 t01 2500ms 2500ms load 71ae0000 wshtcpip.dll
p01 t01 2578ms 2578ms load 4b3c0000 msctf.dll
p01 t01 2625ms 2625ms load 48920000 vsamx.dll
p01 t01 2687ms 2687ms load 48960000 vvset.dll
p01 t01 2734ms 2734ms load 46b50000 foc.dll
t03 tid=4140
p01 t03 2796ms 0ms tcreate 7c83fde4 ntdll.dll/?/?/DbgUiRemoteBreakin+0x0
p01 t03 2796ms 0ms texit 0
--------------------------------------------------------------------------
p01 t01 2796ms 2796ms error c0000005 access violation

1] pc=47AFDF87,sp=0012F754,fp=77BBCE33,ra=E877BA20
ntmas.dll/?/?/?
2] pc=E877BA20,sp=0012F754,fp=E868186A,ra=00000000
?/?/?/?

This message has been edited. Last edited by: Kerry,

This seems to be rather specific, and therefore I'd advise you to open a case with IB tech support. They can support you far better.