Hi all,

Does anyone know what the edapgwy.exe application does or is in charge of? We've got 2 8201M environment servers that seem to be crashing of late due to this process taking up excessive amounts of VRAM.

Any information on this process would be greatly appreciated.

Thanks in advance!

I would suggest talking to Techsupport about what edapgwy is expected to do and user

According to tech support edapgwy.exe corresponds to the following daemon processes:

1) The Deferred Requests Special Services Daemon. The DFM daemon is used for deferred requests. There is one process per server.

2) The HTTP Listener Daemon. The HTTP daemon is used for requests using the HTTP protocol. There is one process per server.

3) The TCP Listener Daemon. The TCP daemon is used for requests using the TCP protocol. There is one process per server.

What gen are you running? Have you reviewed edaprint.log file to see what errors are being logged? Also, check the min and max heap sizes on Tomcat.

Could be someone launch huge process deferred and taking all the memory
You can go into properties on DFM_default and limit memory_limit and/or cpu_limit to see if that helps

Thanks all for chiming in. I appreciate your time and the insights you've each provided.

BabakNYC, the Gen # for the server that's crashed twice thus far: 1060; the other that's crashed once thus far: 1086. Will be looking at all the logs from the last 2 days shortly, and will update this thread after I find anything. Where can I go to find the heap sizes for Tomcat?

I've reviewed various Tech Support Case entries that were searchable via the Tech Support site, and learned a few things. Not sure whether helpful or not as of yet.

So, in the Adapter settings for our Hyperstage server install, we have the ability to change the FETCHSIZE from the default 100 record value to something higher if needed. My colleague found by changing this setting it would speed up the data retrieval from Hyperstage (or other types of DBMSs via differing adapter types) I think he was saying. Would him setting this to 5000 (both servers for various adapter types) be a possible cause to our server crashes?

** The setting can be found by going to the Reporting Server Console > Adapters > Hyperstage (PG) JDBC & right-clicking the folder and going to Change Settings > Read/Write Optimization section > FETCHSIZE. **

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

So, in the archived edaprint.log, that was logging right before the crash from the first day, I have a loooooong string of blocks of info like this where TSCOM agents are ready to be ran but something isn't able to find an OCI.dll file? And some values are saying they aren't set after which, probably due to being gathered from the missing dll?

Here's a section of the log that details out what I'm describing below. Any ideas?

07/25/2017 12:31:51.113 I request by t3rp2420 to notify agent is ready (tscomid=8)
07/25/2017 12:31:51.114 I request by t3rp2468 to notify agent is ready (tscomid=14)
07/25/2017 12:31:51.269 I request by t3rp2452 to notify agent is ready (tscomid=12)
07/25/2017 12:31:50.268 E OCI.dll not found
07/25/2017 12:31:50.269 - OCI.dll not found
07/25/2017 12:31:50.276 -  (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS11 
07/25/2017 12:31:50.276 -  (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED : 
07/25/2017 12:31:50.276 -  (FOC1260) Loading D:\ibi\srv82\home\bin\or8ps11.dll: SearchPath: failed to find OCI.dll
07/25/2017 12:31:50.277 -  (FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE :
07/25/2017 12:31:50.277 -  (FOC1260) NLS_LANG : NOT SET
07/25/2017 12:31:50.277 -  (FOC1260) ORA_NCHAR_LITERAL_REPLACE : NOT SET
07/25/2017 12:31:50.277 -  (FOC1260) PATH : C:\Program Files\Java\jdk1.8.0_111\jre\bin
07/25/2017 12:31:50.277 -  (FOC1260)   C:\Program Files\Java\jdk1.8.0_111\jre\bin\server
07/25/2017 12:31:50.277 -  (FOC1260)   D:\ibi\srv82\home\bin
07/25/2017 12:31:50.277 -  (FOC1260)   C:\ProgramData\Oracle\Java\javapath
07/25/2017 12:31:50.277 -  (FOC1260)   C:\Windows\system32
07/25/2017 12:31:50.277 -  (FOC1260)   C:\Windows
07/25/2017 12:31:50.277 -  (FOC1260)   C:\Windows\System32\Wbem
07/25/2017 12:31:50.277 -  (FOC1260)   C:\Windows\System32\WindowsPowerShell\v1.0\
07/25/2017 12:31:50.282 -  (FOC1676) UNRECOGNIZED SET COMMAND FOR ORACLE INTERFACE
07/25/2017 12:31:50.282 -  (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS11 
07/25/2017 12:31:50.282 -  (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED : 
07/25/2017 12:31:50.282 -  (FOC1260) Loading D:\ibi\srv82\home\bin\or8ps11.dll: SearchPath: failed to find OCI.dll
07/25/2017 12:31:50.283 -  (FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE :
07/25/2017 12:31:50.283 -  (FOC1260) NLS_LANG : NOT SET
07/25/2017 12:31:50.283 -  (FOC1260) ORA_NCHAR_LITERAL_REPLACE : NOT SET
07/25/2017 12:31:50.283 -  (FOC1260) PATH : C:\Program Files\Java\jdk1.8.0_111\jre\bin
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Program Files\Java\jdk1.8.0_111\jre\bin\server
07/25/2017 12:31:50.283 -  (FOC1260)   D:\ibi\srv82\home\bin
07/25/2017 12:31:50.283 -  (FOC1260)   C:\ProgramData\Oracle\Java\javapath
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows\system32
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows\System32\Wbem
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows\System32\WindowsPowerShell\v1.0\
07/25/2017 12:31:50.283 -  (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLORA. MODULE NAME : OR8PS11 
07/25/2017 12:31:50.283 -  (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED : 
07/25/2017 12:31:50.283 -  (FOC1260) Loading D:\ibi\srv82\home\bin\or8ps11.dll: SearchPath: failed to find OCI.dll
07/25/2017 12:31:50.283 -  (FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLORA ARE :
07/25/2017 12:31:50.283 -  (FOC1260) NLS_LANG : NOT SET
07/25/2017 12:31:50.283 -  (FOC1260) ORA_NCHAR_LITERAL_REPLACE : NOT SET
07/25/2017 12:31:50.283 -  (FOC1260) PATH : C:\Program Files\Java\jdk1.8.0_111\jre\bin
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Program Files\Java\jdk1.8.0_111\jre\bin\server
07/25/2017 12:31:50.283 -  (FOC1260)   D:\ibi\srv82\home\bin
07/25/2017 12:31:50.283 -  (FOC1260)   C:\ProgramData\Oracle\Java\javapath
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows\system32
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows\System32\Wbem
07/25/2017 12:31:50.283 -  (FOC1260)   C:\Windows\System32\WindowsPowerShell\v1.0\
07/25/2017 12:31:50.283 -  (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) 
07/25/2017 12:31:50.283 -  (FOC1479) ERROR CONNECTING TO SQL DATABASE 

Hi Coolguy

Is the oracle client installed on this machine? If so in what directory. Can you search for the oci.dll on the actual machine?

Hi Chuck,

I'm not sure on this one with the logs saying things are missing. HD did the install for this one. I'll look around and see if I can find it though.

Thanks for chiming in! Will keep you and all posted on anything I find.

The latest 8201M should say:

Configuration Date 12/08/2016 10:53:07
Build Date 05/11/2017 14:56:36
Gen Number 1086 Release 82
Source Date 05/01/2017 14:53:13

Your edasprof is trying to execute commands that don't relate to the adapters you've configured. What commands (SET, DEFAULT SQLORA type stuff) do you have in edasprof?

BabakNYC,

Here's what's in our edasprof config file for this environment. I've replaced all the unneeded/sensitive information with "..." within the code below:

-*********************************************************
-* Profile generated on 08 December 2016 at 09:31:07
-*********************************************************
-*
-*
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES ...
ENGINE SQLORA SET CONNECTION_ATTRIBUTES ...
ENGINE SQLORA SET CONNECTION_ATTRIBUTES ...
ENGINE SQLMSS SET ISOLATION RU
ENGINE SQLORA SET ISOLATION RU
SET ACRSVRBTITL = ON
-INCLUDE IBFS:/EDA/EDASERVE/baseapp/dates.fex
-*
ENGINE SQLHYPG SET CONNECTION_ATTRIBUTES ...
APP PATH ...
 
ENGINE SQLHYPG SET BULKLOAD ON
 
ENGINE SQLHYPG SET FETCHSIZE 1000

Here's the contents of the dates.fex:

-* File: IBFS:/EDA/EDASERVE/baseapp/dates.fex Created by WebFOCUS AppStudio
 
DEFINE FILE .../DIMDATE
TODAY/YYMD       = DATEFULL;
YESTERDAY/YYMD   = DATEADD(DATEFULL, 'D', - 1);
DAYS_AGO_02/YYMD  = DATEADD(DATEFULL, 'D', - 2);
TOMORROW/YYMD    = DATEADD(DATEFULL, 'D', 1);
LAST_WK_BEG/YYMD = DATEADD(WEEKBEGINING, 'D', -7);
LAST_WK_END/YYMD = DATEADD(WEEKENDING, 'D', -7);
CURR_WK_BEG/YYMD = WEEKBEGINING;
CURR_WK_END/YYMD = WEEKENDING;
NEXT_WK_BEG/YYMD = DATEADD(WEEKBEGINING, 'D', 7);
NEXT_WK_END/YYMD = DATEADD(WEEKENDING, 'D', 7);
FISC_MO_BEG/YYMD = FISCALFIRSTDAYOFMONTH;
FISC_MO_END/YYMD = FISCALLASTDAYOFMONTH;
FISC_QT_BEG/YYMD = FISCALFIRSTDAYOFQUARTER;
FISC_QT_END/YYMD = FISCALLASTDAYOFQUARTER;
FISC_YR_BEG/YYMD = FISCALFIRSTDAYOFYEAR;
FISC_YR_END/YYMD = FISCALLASTDAYOFYEAR;
WKS_OUT_03_END/YYMD = DATEADD(WEEKENDING, 'D', ( 7 * 2 ) );
WKS_OUT_09_END/YYMD = DATEADD(WEEKENDING, 'D', ( 7 * 8 ) );
WKS_AGO_04_BEG/YYMD = DATEADD(WEEKBEGINING, 'D', ( -7 * 4 ) );
WKS_AGO_09_BEG/YYMD = DATEADD(WEEKBEGINING, 'D', ( -7 * 9 ) );
WKS_AGO_13_BEG/YYMD = DATEADD(WEEKBEGINING, 'D', ( -7 * 13 ) );
END
 
-* GET CURRENT YEAR DATA
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	DAYS_AGO_02
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE DATEFULL EQ &YYMD;
ON TABLE HOLD AS CY_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILE AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ CY_DT &TODAY.I8. &YESTERDAY.I8. &DAYS_AGO_02.I8. &TOMORROW.I8. &CURR_WK_BEG.I8. &CURR_WK_END.I8. &LAST_WK_BEG.I8. &LAST_WK_END.I8. &NEXT_WK_BEG.I8. &NEXT_WK_END.I8. &FISC_MO_BEG.I8. &FISC_MO_END.I8. &FISC_QT_BEG.I8. &FISC_QT_END.I8. &FISC_YR_BEG.I8. &FISC_YR_END.I8. &3WKS_OUT_END.I8 &9WKS_OUT_END.I8 &CURR_FISC_YR.I4 &CURR_FISC_WK.I6 &CURR_FISC_DAY.I11 &CY_4WKS_AGO_BEG.I8 &CY_9WKS_AGO_BEG.I8 &CY_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
-* GET LAST WEEK DATE DATA (AS OF TODAY - 7)
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	DAYS_AGO_02
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE DATEFULL EQ DATEADD('&YYMD', 'D', -7);
ON TABLE HOLD AS LWK_CY_DT FORMAT ALPHA
END
-RUN
-*-EXIT
-*READ HOLD FILE AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ LWK_CY_DT &LWK_CY_TODAY.I8. &LWK_CY_YESTERDAY.I8. &LWK_CY_DAYS_AGO_02.I8. &LWK_CY_TOMORROW.I8. &LWK_CY_CURR_WK_BEG.I8. &LWK_CY_CURR_WK_END.I8. &LWK_CY_LAST_WK_BEG.I8. &LWK_CY_LAST_WK_END.I8. &LWK_CY_NEXT_WK_BEG.I8. &LWK_CY_NEXT_WK_END.I8. &LWK_CY_FISC_MO_BEG.I8. &LWK_CY_FISC_MO_END.I8. &LWK_CY_FISC_QT_BEG.I8. &LWK_CY_FISC_QT_END.I8. &LWK_CY_FISC_YR_BEG.I8. &LWK_CY_FISC_YR_END.I8. &LWK_CY_3WKS_OUT_END.I8 &LWK_CY_9WKS_OUT_END.I8 &LWK_CY_FISC_YR.I4 &LWK_CY_FISC_WK.I6 &LWK_CY_FISC_DAY.I11 &LWK_CY_4WKS_AGO_BEG.I8 &LWK_CY_9WKS_AGO_BEG.I8 &LWK_CY_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
-* GET PREVIOUS YEAR DATA (CALENDAR)
 
-*CONVERT CURRENT DATE TO A YEAR AGO
-SET &PY_YYMD = DATECVT( DATEADD( &DATEYYMD, 'D', -364 ), 'YYMD', 'I8YYMD');
 
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE DATEFULL EQ &PY_YYMD;
ON TABLE HOLD AS PY_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILE AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ PY_DT &PY_TODAY.I8. &PY_YESTERDAY.I8. &PY_TOMORROW.I8. &PY_CURR_WK_BEG.I8. &PY_CURR_WK_END.I8. &PY_LAST_WK_BEG.I8. &PY_LAST_WK_END.I8. &PY_NEXT_WK_BEG.I8. &PY_NEXT_WK_END.I8. &PY_FISC_MO_BEG.I8. &PY_FISC_MO_END.I8. &PY_FISC_QT_BEG.I8. &PY_FISC_QT_END.I8. &PY_FISC_YR_BEG.I8. &PY_FISC_YR_END.I8. &PY_3WKS_OUT_END.I8 &PY_9WKS_OUT_END.I8 &PY_FISC_YR.I4 &PY_FISC_WK.I6 &PY_FISC_DAY.I11 &PY_4WKS_AGO_BEG.I8 &PY_9WKS_AGO_BEG.I8 &PY_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
-* GET PREVIOUS YEAR DATA (FISCAL)
 
-*CONVERT CURRENT FISCAL YEAR TO LAST YEAR
-SET &PFY_YY = (&CURR_FISC_YR) - 1;
 
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE FISCALYEAR EQ '&PFY_YY';
WHERE FISCALDAYOFYEAR EQ &CURR_FISC_DAY;
ON TABLE HOLD AS PFY_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILE AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ PFY_DT &PFY_TODAY.I8. &PFY_YESTERDAY.I8. &PFY_TOMORROW.I8. &PFY_CURR_WK_BEG.I8. &PFY_CURR_WK_END.I8. &PFY_LAST_WK_BEG.I8. &PFY_LAST_WK_END.I8. &PFY_NEXT_WK_BEG.I8. &PFY_NEXT_WK_END.I8. &PFY_FISC_MO_BEG.I8. &PFY_FISC_MO_END.I8. &PFY_FISC_QT_BEG.I8. &PFY_FISC_QT_END.I8. &PFY_FISC_YR_BEG.I8. &PFY_FISC_YR_END.I8. &PFY_3WKS_OUT_END.I8 &PFY_9WKS_OUT_END.I8 &PFY_FISC_YR.I4 &PFY_FISC_WK.I6 &PFY_FISC_DAY.I11 &PFY_4WKS_AGO_BEG.I8 &PFY_9WKS_AGO_BEG.I8 &PFY_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
-* GET LAST WEEK'S PREVIOUS YEAR DATA (FISCAL)
 
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE DATEFULL EQ DATEADD('&PFY_TODAY', 'D', -7);
ON TABLE HOLD AS LWK_PFY_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILE AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ LWK_PFY_DT &LWK_PFY_TODAY.I8. &LWK_PFY_YESTERDAY.I8. &LWK_PFY_TOMORROW.I8. &LWK_PFY_CURR_WK_BEG.I8. &LWK_PFY_CURR_WK_END.I8. &LWK_PFY_LAST_WK_BEG.I8. &LWK_PFY_LAST_WK_END.I8. &LWK_PFY_NEXT_WK_BEG.I8. &LWK_PFY_NEXT_WK_END.I8. &LWK_PFY_FISC_MO_BEG.I8. &LWK_PFY_FISC_MO_END.I8. &LWK_PFY_FISC_QT_BEG.I8. &LWK_PFY_FISC_QT_END.I8. &LWK_PFY_FISC_YR_BEG.I8. &LWK_PFY_FISC_YR_END.I8. &LWK_PFY_3WKS_OUT_END.I8 &LWK_PFY_9WKS_OUT_END.I8 &LWK_PFY_FISC_YR.I4 &LWK_PFY_FISC_WK.I6 &LWK_PFY_FISC_DAY.I11 &LWK_PFY_4WKS_AGO_BEG.I8 &LWK_PFY_9WKS_AGO_BEG.I8 &LWK_PFY_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
 
-* GET TWO YEAR AGO DATA (CALENDAR)
 
-*CONVERT CURRENT DATE TO TWO YEARS AGO ( 364 Days * 2 )
-SET &PY2_YYMD = DATECVT( DATEADD( &DATEYYMD, 'D', -728 ), 'YYMD', 'I8YYMD');
 
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE DATEFULL EQ &PY2_YYMD;
ON TABLE HOLD AS PY2_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILE AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ PY2_DT &PY2_TODAY.I8. &PY2_YESTERDAY.I8. &PY2_TOMORROW.I8. &PY2_CURR_WK_BEG.I8. &PY2_CURR_WK_END.I8. &PY2_LAST_WK_BEG.I8. &PY2_LAST_WK_END.I8. &PY2_NEXT_WK_BEG.I8. &PY2_NEXT_WK_END.I8. &PY2_FISC_MO_BEG.I8. &PY2_FISC_MO_END.I8. &PY2_FISC_QT_BEG.I8. &PY2_FISC_QT_END.I8. &PY2_FISC_YR_BEG.I8. &PY2_FISC_YR_END.I8. &PY2_3WKS_OUT_END.I8 &PY2_9WKS_OUT_END.I8 &PY2_FISC_YR.I4 &PY2_FISC_WK.I6 &PY2_FISC_DAY.I11 &PY2_4WKS_AGO_BEG.I8 &PY2_9WKS_AGO_BEG.I8 &PY2_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
-* GET TWO YEAR AGO DATA (FISCAL)
 
-*CONVERT CURRENT FISCAL YEAR TO TWO YEARS AGO
-SET &PFY2_YY = (&CURR_FISC_YR) - 2;
 
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE FISCALYEAR EQ '&PFY2_YY';
WHERE FISCALDAYOFYEAR EQ &CURR_FISC_DAY;
ON TABLE HOLD AS PFY2_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILES AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ PFY2_DT &PFY2_TODAY.I8. &PFY2_YESTERDAY.I8. &PFY2_TOMORROW.I8. &PFY2_CURR_WK_BEG.I8. &PFY2_CURR_WK_END.I8. &PFY2_LAST_WK_BEG.I8. &PFY2_LAST_WK_END.I8. &PFY2_NEXT_WK_BEG.I8. &PFY2_NEXT_WK_END.I8. &PFY2_FISC_MO_BEG.I8. &PFY2_FISC_MO_END.I8. &PFY2_FISC_QT_BEG.I8. &PFY2_FISC_QT_END.I8. &PFY2_FISC_YR_BEG.I8. &PFY2_FISC_YR_END.I8. &PFY2_3WKS_OUT_END.I8 &PFY2_9WKS_OUT_END.I8 &PFY2_FISC_YR.I4 &PFY2_FISC_WK.I6 &PFY2_FISC_DAY.I11  &PFY2_4WKS_AGO_BEG.I8 &PFY2_9WKS_AGO_BEG.I8 &PFY2_13WKS_AGO_BEG.I8
-*---------------------------------------------------
 
-* GET THREE YEAR AGO DATA (FISCAL)
 
-*CONVERT CURRENT FISCAL YEAR TO TWO YEARS AGO
-SET &PFY3_YY = (&CURR_FISC_YR) - 3;
 
TABLE FILE .../DIMDATE
PRINT
	TODAY
	YESTERDAY
	TOMORROW
	CURR_WK_BEG
	CURR_WK_END
	LAST_WK_BEG
	LAST_WK_END
	NEXT_WK_BEG
	NEXT_WK_END
	FISC_MO_BEG
	FISC_MO_END
	FISC_QT_BEG
	FISC_QT_END
	FISC_YR_BEG
	FISC_YR_END
	WKS_OUT_03_END
	WKS_OUT_09_END
	FISCALYEAR
	FISCALWEEKOFYEAR
	FISCALDAYOFYEAR
	WKS_AGO_04_BEG
	WKS_AGO_09_BEG
	WKS_AGO_13_BEG
WHERE FISCALYEAR EQ '&PFY3_YY';
WHERE FISCALDAYOFYEAR EQ &CURR_FISC_DAY;
ON TABLE HOLD AS PFY3_DT FORMAT ALPHA
END
-RUN
 
-*READ HOLD FILES AND SET LOCAL VARIABLES THAT ARE USING THIS FILE.
-READ PFY3_DT &PFY3_TODAY.I8. &PFY3_YESTERDAY.I8. &PFY3_TOMORROW.I8. &PFY3_CURR_WK_BEG.I8. &PFY3_CURR_WK_END.I8. &PFY3_LAST_WK_BEG.I8. &PFY3_LAST_WK_END.I8. &PFY3_NEXT_WK_BEG.I8. &PFY3_NEXT_WK_END.I8. &PFY3_FISC_MO_BEG.I8. &PFY3_FISC_MO_END.I8. &PFY3_FISC_QT_BEG.I8. &PFY3_FISC_QT_END.I8. &PFY3_FISC_YR_BEG.I8. &PFY3_FISC_YR_END.I8. &PFY3_3WKS_OUT_END.I8 &PFY3_9WKS_OUT_END.I8 &PFY3_FISC_YR.I4 &PFY3_FISC_WK.I6 &PFY3_FISC_DAY.I11  &PFY3_4WKS_AGO_BEG.I8 &PFY3_9WKS_AGO_BEG.I8 &PFY3_13WKS_AGO_BEG.I8
 
-*---------------------------------------------------
 
-*SET GLOBAL VARIABLES
-SET &&CY_TODAY = &TODAY;
-SET &&CY_YESTERDAY = &YESTERDAY;
-SET &&CY_DAYS_AGO_02 = &DAYS_AGO_02;
-SET &&CY_TOMORROW = &TOMORROW;
-SET &&CY_LAST_WK_BEG = &LAST_WK_BEG;
-SET &&CY_LAST_WK_END = &LAST_WK_END;
-SET &&CY_CURR_WK_BEG = &CURR_WK_BEG;
-SET &&CY_CURR_WK_END = &CURR_WK_END;
-SET &&CY_NEXT_WK_BEG = &NEXT_WK_BEG;
-SET &&CY_NEXT_WK_END = &NEXT_WK_END;
-SET &&CY_FISC_MO_BEG = &FISC_MO_BEG;
-SET &&CY_FISC_MO_END = &FISC_MO_END;
-SET &&CY_FISC_QT_BEG = &FISC_QT_BEG;
-SET &&CY_FISC_QT_END = &FISC_QT_END;
-SET &&CY_FISC_YR_BEG = &FISC_YR_BEG;
-SET &&CY_FISC_YR_END = &FISC_YR_END;
-SET &&CY_3WKS_OUT_END = &3WKS_OUT_END;
-SET &&CY_9WKS_OUT_END = &9WKS_OUT_END;
-SET &&CY_FISC_YR = &CURR_FISC_YR;
-SET &&CY_FISC_WK = &CURR_FISC_WK;
-SET &&CY_FISC_DAY = &CURR_FISC_DAY;
-SET &&CY_4WKS_AGO_BEG = &CY_4WKS_AGO_BEG;
-SET &&CY_9WKS_AGO_BEG = &CY_9WKS_AGO_BEG;
-SET &&CY_13WKS_AGO_BEG = &CY_13WKS_AGO_BEG;
 
-SET &&LWK_CY_TODAY = &LWK_CY_TODAY;
-SET &&LWK_CY_YESTERDAY = &LWK_CY_YESTERDAY;
-SET &&LWK_CY_DAYS_AGO_02 = &LWK_CY_DAYS_AGO_02;
-SET &&LWK_CY_TOMORROW = &LWK_CY_TOMORROW;
-SET &&LWK_CY_LAST_WK_BEG = &LWK_CY_LAST_WK_BEG;
-SET &&LWK_CY_LAST_WK_END = &LWK_CY_LAST_WK_END;
-SET &&LWK_CY_CURR_WK_BEG = &LWK_CY_CURR_WK_BEG;
-SET &&LWK_CY_CURR_WK_END = &LWK_CY_CURR_WK_END;
-SET &&LWK_CY_NEXT_WK_BEG = &LWK_CY_NEXT_WK_BEG;
-SET &&LWK_CY_NEXT_WK_END = &LWK_CY_NEXT_WK_END;
-SET &&LWK_CY_FISC_MO_BEG = &LWK_CY_FISC_MO_BEG;
-SET &&LWK_CY_FISC_MO_END = &LWK_CY_FISC_MO_END;
-SET &&LWK_CY_FISC_QT_BEG = &LWK_CY_FISC_QT_BEG;
-SET &&LWK_CY_FISC_QT_END = &LWK_CY_FISC_QT_END;
-SET &&LWK_CY_FISC_YR_BEG = &LWK_CY_FISC_YR_BEG;
-SET &&LWK_CY_FISC_YR_END = &LWK_CY_FISC_YR_END;
-SET &&LWK_CY_3WKS_OUT_END = &LWK_CY_3WKS_OUT_END;
-SET &&LWK_CY_9WKS_OUT_END = &LWK_CY_9WKS_OUT_END;
-SET &&LWK_CY_FISC_YR = &LWK_CY_FISC_YR;
-SET &&LWK_CY_FISC_WK = &LWK_CY_FISC_WK;
-SET &&LWK_CY_FISC_DAY = &LWK_CY_FISC_DAY;
-SET &&LWK_CY_4WKS_AGO_BEG = &LWK_CY_4WKS_AGO_BEG;
-SET &&LWK_CY_9WKS_AGO_BEG = &LWK_CY_9WKS_AGO_BEG;
-SET &&LWK_CY_13WKS_AGO_BEG = &LWK_CY_13WKS_AGO_BEG;
 
-SET &&PY_TODAY = &PY_TODAY;
-SET &&PY_YESTERDAY = &PY_YESTERDAY;
-SET &&PY_TOMORROW = &PY_TOMORROW;
-SET &&PY_LAST_WK_BEG = &PY_LAST_WK_BEG;
-SET &&PY_LAST_WK_END = &PY_LAST_WK_END;
-SET &&PY_CURR_WK_BEG = &PY_CURR_WK_BEG;
-SET &&PY_CURR_WK_END = &PY_CURR_WK_END;
-SET &&PY_NEXT_WK_BEG = &PY_NEXT_WK_BEG;
-SET &&PY_NEXT_WK_END = &PY_NEXT_WK_END;
-SET &&PY_FISC_MO_BEG = &PY_FISC_MO_BEG;
-SET &&PY_FISC_MO_END = &PY_FISC_MO_END;
-SET &&PY_FISC_QT_BEG = &PY_FISC_QT_BEG;
-SET &&PY_FISC_QT_END = &PY_FISC_QT_END;
-SET &&PY_FISC_YR_BEG = &PY_FISC_YR_BEG;
-SET &&PY_FISC_YR_END = &PY_FISC_YR_END;
-SET &&PY_3WKS_OUT_END = &PY_3WKS_OUT_END;
-SET &&PY_9WKS_OUT_END = &PY_9WKS_OUT_END;
-SET &&PY_FISC_YR = &PY_FISC_YR;
-SET &&PY_FISC_WK = &PY_FISC_WK;
-SET &&PY_FISC_DAY = &PY_FISC_DAY;
-SET &&PY_4WKS_AGO_BEG = &PY_4WKS_AGO_BEG;
-SET &&PY_9WKS_AGO_BEG = &PY_9WKS_AGO_BEG;
-SET &&PY_13WKS_AGO_BEG = &PY_13WKS_AGO_BEG;
 
-SET &&PFY_TODAY = &PFY_TODAY;
-SET &&PFY_YESTERDAY = &PFY_YESTERDAY;
-SET &&PFY_TOMORROW = &PFY_TOMORROW;
-SET &&PFY_LAST_WK_BEG = &PFY_LAST_WK_BEG;
-SET &&PFY_LAST_WK_END = &PFY_LAST_WK_END;
-SET &&PFY_CURR_WK_BEG = &PFY_CURR_WK_BEG;
-SET &&PFY_CURR_WK_END = &PFY_CURR_WK_END;
-SET &&PFY_NEXT_WK_BEG = &PFY_NEXT_WK_BEG;
-SET &&PFY_NEXT_WK_END = &PFY_NEXT_WK_END;
-SET &&PFY_FISC_MO_BEG = &PFY_FISC_MO_BEG;
-SET &&PFY_FISC_MO_END = &PFY_FISC_MO_END;
-SET &&PFY_FISC_QT_BEG = &PFY_FISC_QT_BEG;
-SET &&PFY_FISC_QT_END = &PFY_FISC_QT_END;
-SET &&PFY_FISC_YR_BEG = &PFY_FISC_YR_BEG;
-SET &&PFY_FISC_YR_END = &PFY_FISC_YR_END;
-SET &&PFY_3WKS_OUT_END = &PFY_3WKS_OUT_END;
-SET &&PFY_9WKS_OUT_END = &PFY_9WKS_OUT_END;
-SET &&PFY_FISC_YR = &PFY_FISC_YR;
-SET &&PFY_FISC_WK = &PFY_FISC_WK;
-SET &&PFY_FISC_DAY = &PFY_FISC_DAY;
-SET &&PFY_4WKS_AGO_BEG = &PFY_4WKS_AGO_BEG;
-SET &&PFY_9WKS_AGO_BEG = &PFY_9WKS_AGO_BEG;
-SET &&PFY_13WKS_AGO_BEG = &PFY_13WKS_AGO_BEG;
 
-SET &&LWK_PFY_TODAY = &LWK_PFY_TODAY;
-SET &&LWK_PFY_YESTERDAY = &LWK_PFY_YESTERDAY;
-SET &&LWK_PFY_TOMORROW = &LWK_PFY_TOMORROW;
-SET &&LWK_PFY_LAST_WK_BEG = &LWK_PFY_LAST_WK_BEG;
-SET &&LWK_PFY_LAST_WK_END = &LWK_PFY_LAST_WK_END;
-SET &&LWK_PFY_CURR_WK_BEG = &LWK_PFY_CURR_WK_BEG;
-SET &&LWK_PFY_CURR_WK_END = &LWK_PFY_CURR_WK_END;
-SET &&LWK_PFY_NEXT_WK_BEG = &LWK_PFY_NEXT_WK_BEG;
-SET &&LWK_PFY_NEXT_WK_END = &LWK_PFY_NEXT_WK_END;
-SET &&LWK_PFY_FISC_MO_BEG = &LWK_PFY_FISC_MO_BEG;
-SET &&LWK_PFY_FISC_MO_END = &LWK_PFY_FISC_MO_END;
-SET &&LWK_PFY_FISC_QT_BEG = &LWK_PFY_FISC_QT_BEG;
-SET &&LWK_PFY_FISC_QT_END = &LWK_PFY_FISC_QT_END;
-SET &&LWK_PFY_FISC_YR_BEG = &LWK_PFY_FISC_YR_BEG;
-SET &&LWK_PFY_FISC_YR_END = &LWK_PFY_FISC_YR_END;
-SET &&LWK_PFY_3WKS_OUT_END = &LWK_PFY_3WKS_OUT_END;
-SET &&LWK_PFY_9WKS_OUT_END = &LWK_PFY_9WKS_OUT_END;
-SET &&LWK_PFY_FISC_YR = &LWK_PFY_FISC_YR;
-SET &&LWK_PFY_FISC_WK = &LWK_PFY_FISC_WK;
-SET &&LWK_PFY_FISC_DAY = &LWK_PFY_FISC_DAY;
-SET &&LWK_PFY_4WKS_AGO_BEG = &LWK_PFY_4WKS_AGO_BEG;
-SET &&LWK_PFY_9WKS_AGO_BEG = &LWK_PFY_9WKS_AGO_BEG;
-SET &&LWK_PFY_13WKS_AGO_BEG = &LWK_PFY_13WKS_AGO_BEG;
 
-SET &&PY2_TODAY = &PY2_TODAY;
-SET &&PY2_YESTERDAY = &PY2_YESTERDAY;
-SET &&PY2_TOMORROW = &PY2_TOMORROW;
-SET &&PY2_LAST_WK_BEG = &PY2_LAST_WK_BEG;
-SET &&PY2_LAST_WK_END = &PY2_LAST_WK_END;
-SET &&PY2_CURR_WK_BEG = &PY2_CURR_WK_BEG;
-SET &&PY2_CURR_WK_END = &PY2_CURR_WK_END;
-SET &&PY2_NEXT_WK_BEG = &PY2_NEXT_WK_BEG;
-SET &&PY2_NEXT_WK_END = &PY2_NEXT_WK_END;
-SET &&PY2_FISC_MO_BEG = &PY2_FISC_MO_BEG;
-SET &&PY2_FISC_MO_END = &PY2_FISC_MO_END;
-SET &&PY2_FISC_QT_BEG = &PY2_FISC_QT_BEG;
-SET &&PY2_FISC_QT_END = &PY2_FISC_QT_END;
-SET &&PY2_FISC_YR_BEG = &PY2_FISC_YR_BEG;
-SET &&PY2_FISC_YR_END = &PY2_FISC_YR_END;
-SET &&PY2_3WKS_OUT_END = &PY2_3WKS_OUT_END;
-SET &&PY2_9WKS_OUT_END = &PY2_9WKS_OUT_END;
-SET &&PY2_FISC_YR = &PY2_FISC_YR;
-SET &&PY2_FISC_WK = &PY2_FISC_WK;
-SET &&PY2_FISC_DAY = &PY2_FISC_DAY;
-SET &&PY2_4WKS_AGO_BEG = &PY2_4WKS_AGO_BEG;
-SET &&PY2_9WKS_AGO_BEG = &PY2_9WKS_AGO_BEG;
-SET &&PY2_13WKS_AGO_BEG = &PY2_13WKS_AGO_BEG;
 
 
-SET &&PFY2_TODAY = &PFY2_TODAY;
-SET &&PFY2_YESTERDAY = &PFY2_YESTERDAY;
-SET &&PFY2_TOMORROW = &PFY2_TOMORROW;
-SET &&PFY2_LAST_WK_BEG = &PFY2_LAST_WK_BEG;
-SET &&PFY2_LAST_WK_END = &PFY2_LAST_WK_END;
-SET &&PFY2_CURR_WK_BEG = &PFY2_CURR_WK_BEG;
-SET &&PFY2_CURR_WK_END = &PFY2_CURR_WK_END;
-SET &&PFY2_NEXT_WK_BEG = &PFY2_NEXT_WK_BEG;
-SET &&PFY2_NEXT_WK_END = &PFY2_NEXT_WK_END;
-SET &&PFY2_FISC_MO_BEG = &PFY2_FISC_MO_BEG;
-SET &&PFY2_FISC_MO_END = &PFY2_FISC_MO_END;
-SET &&PFY2_FISC_QT_BEG = &PFY2_FISC_QT_BEG;
-SET &&PFY2_FISC_QT_END = &PFY2_FISC_QT_END;
-SET &&PFY2_FISC_YR_BEG = &PFY2_FISC_YR_BEG;
-SET &&PFY2_FISC_YR_END = &PFY2_FISC_YR_END;
-SET &&PFY2_3WKS_OUT_END = &PFY2_3WKS_OUT_END;
-SET &&PFY2_9WKS_OUT_END = &PFY2_9WKS_OUT_END;
-SET &&PFY2_FISC_YR = &PFY2_FISC_YR;
-SET &&PFY2_FISC_WK = &PFY2_FISC_WK;
-SET &&PFY2_FISC_DAY = &PFY2_FISC_DAY;
-SET &&PFY2_4WKS_AGO_BEG = &PFY2_4WKS_AGO_BEG;
-SET &&PFY2_9WKS_AGO_BEG = &PFY2_9WKS_AGO_BEG;
-SET &&PFY2_13WKS_AGO_BEG = &PFY2_13WKS_AGO_BEG;
 
 
-SET &&PFY3_TODAY = &PFY3_TODAY;
-SET &&PFY3_YESTERDAY = &PFY3_YESTERDAY;
-SET &&PFY3_TOMORROW = &PFY3_TOMORROW;
-SET &&PFY3_LAST_WK_BEG = &PFY3_LAST_WK_BEG;
-SET &&PFY3_LAST_WK_END = &PFY3_LAST_WK_END;
-SET &&PFY3_CURR_WK_BEG = &PFY3_CURR_WK_BEG;
-SET &&PFY3_CURR_WK_END = &PFY3_CURR_WK_END;
-SET &&PFY3_NEXT_WK_BEG = &PFY3_NEXT_WK_BEG;
-SET &&PFY3_NEXT_WK_END = &PFY3_NEXT_WK_END;
-SET &&PFY3_FISC_MO_BEG = &PFY3_FISC_MO_BEG;
-SET &&PFY3_FISC_MO_END = &PFY3_FISC_MO_END;
-SET &&PFY3_FISC_QT_BEG = &PFY3_FISC_QT_BEG;
-SET &&PFY3_FISC_QT_END = &PFY3_FISC_QT_END;
-SET &&PFY3_FISC_YR_BEG = &PFY3_FISC_YR_BEG;
-SET &&PFY3_FISC_YR_END = &PFY3_FISC_YR_END;
-SET &&PFY3_3WKS_OUT_END = &PFY3_3WKS_OUT_END;
-SET &&PFY3_9WKS_OUT_END = &PFY3_9WKS_OUT_END;
-SET &&PFY3_FISC_YR = &PFY3_FISC_YR;
-SET &&PFY3_FISC_WK = &PFY3_FISC_WK;
-SET &&PFY3_FISC_DAY = &PFY3_FISC_DAY;
-SET &&PFY3_4WKS_AGO_BEG = &PFY3_4WKS_AGO_BEG;
-SET &&PFY3_9WKS_AGO_BEG = &PFY3_9WKS_AGO_BEG;
-SET &&PFY3_13WKS_AGO_BEG = &PFY3_13WKS_AGO_BEG;
 
 
 
-*VIEW THE CURRENT GLOBAL DATE VARAIBLE VALUES
 
-*-TYPE ===============================================================================
-*-TYPE CY = CURRENT YEAR                  |   LWK_CY = CY DATA as of 7 DAYS AGO
-*-TYPE -----------------------------------|-------------------------------------------
-*-TYPE &&CY_FISC_YR     : &&|CY_FISC_YR            |        &&LWK_CY_FISC_YR : &&|LWK_CY_FISC_YR
-*-TYPE &&CY_FISC_WK       : &&|CY_FISC_WK            |      &&LWK_CY_FISC_WK : &&|LWK_CY_FISC_WK
-*-TYPE &&CY_FISC_DAY      : &&|CY_FISC_DAY           | &&LWK_CY_FISC_DAY : &&|LWK_CY_FISC_DAY
-*-TYPE &&CY_TODAY : &&|CY_TODAY              |    &&LWK_CY_TODAY : &&|LWK_CY_TODAY
-*-TYPE &&CY_YESTERDAY : &&|CY_YESTERDAY          |    &&LWK_CY_YESTERDAY : &&|LWK_CY_YESTERDAY
-*-TYPE &&CY_DAYS_AGO_02 : &&|CY_DAYS_AGO_02        |    &&LWK_CY_DAYS_AGO_02 : &&|LWK_CY_DAYS_AGO_02
-*-TYPE &&CY_TOMORROW : &&|CY_TOMORROW           |    &&LWK_CY_TOMORROW : &&|LWK_CY_TOMORROW
-*-TYPE &&CY_LAST_WK_BEG : &&|CY_LAST_WK_BEG        |    &&LWK_CY_LAST_WK_BEG : &&|LWK_CY_LAST_WK_BEG
-*-TYPE &&CY_LAST_WK_END : &&|CY_LAST_WK_END        |    &&LWK_CY_LAST_WK_END : &&|LWK_CY_LAST_WK_END
-*-TYPE &&CY_CURR_WK_BEG : &&|CY_CURR_WK_BEG        |    &&LWK_CY_CURR_WK_BEG : &&|LWK_CY_CURR_WK_BEG
-*-TYPE &&CY_CURR_WK_END : &&|CY_CURR_WK_END        |    &&LWK_CY_CURR_WK_END : &&|LWK_CY_CURR_WK_END
-*-TYPE &&CY_NEXT_WK_BEG : &&|CY_NEXT_WK_BEG        |    &&LWK_CY_NEXT_WK_BEG : &&|LWK_CY_NEXT_WK_BEG
-*-TYPE &&CY_NEXT_WK_END : &&|CY_NEXT_WK_END        |    &&LWK_CY_NEXT_WK_END : &&|LWK_CY_NEXT_WK_END
-*-TYPE &&CY_FISC_MO_BEG : &&|CY_FISC_MO_BEG        |    &&LWK_CY_FISC_MO_BEG : &&|LWK_CY_FISC_MO_BEG
-*-TYPE &&CY_FISC_MO_END : &&|CY_FISC_MO_END        |    &&LWK_CY_FISC_MO_END : &&|LWK_CY_FISC_MO_END
-*-TYPE &&CY_FISC_QT_BEG : &&|CY_FISC_QT_BEG        |    &&LWK_CY_FISC_QT_BEG : &&|LWK_CY_FISC_QT_BEG
-*-TYPE &&CY_FISC_QT_END : &&|CY_FISC_QT_END        |    &&LWK_CY_FISC_QT_END : &&|LWK_CY_FISC_QT_END
-*-TYPE &&CY_FISC_YR_BEG : &&|CY_FISC_YR_BEG        |    &&LWK_CY_FISC_YR_BEG : &&|LWK_CY_FISC_YR_BEG
-*-TYPE &&CY_FISC_YR_END : &&|CY_FISC_YR_END        |    &&LWK_CY_FISC_YR_END : &&|LWK_CY_FISC_YR_END
-*-TYPE &&CY_3WKS_OUT_END : &&|CY_3WKS_OUT_END       |    &&LWK_CY_3WKS_OUT_END : &&|LWK_CY_3WKS_OUT_END
-*-TYPE &&CY_9WKS_OUT_END : &&|CY_9WKS_OUT_END       |    &&LWK_CY_9WKS_OUT_END : &&|LWK_CY_9WKS_OUT_END
-*-TYPE &&CY_4WKS_AGO_BEG : &&|CY_4WKS_AGO_BEG       |    &&LWK_CY_4WKS_AGO_BEG : &&|LWK_CY_4WKS_AGO_BEG
-*-TYPE &&CY_9WKS_AGO_BEG : &&|CY_9WKS_AGO_BEG       |    &&LWK_CY_9WKS_AGO_BEG : &&|LWK_CY_9WKS_AGO_BEG
-*-TYPE &&CY_13WKS_AGO_BEG : &&|CY_13WKS_AGO_BEG      |    &&LWK_CY_13WKS_AGO_BEG : &&|LWK_CY_13WKS_AGO_BEG
-*
-*-TYPE ===========================================================================================================================
-*-TYPE PY = Previous Year (CALENDAR)      |    PFY = Previous FISCAL Year             |   LWK_PFY = PFY DATA as of 7 DAYS AGO
-*-TYPE -----------------------------------|-------------------------------------------|-------------------------------------------
-*-TYPE &&PY_FISC_YR     : &&|PY_FISC_YR            |        &&PFY_FISC_YR : &&|PFY_FISC_YR               |        &&LWK_PFY_FISC_YR : &&|LWK_PFY_FISC_YR
-*-TYPE &&PY_FISC_WK       : &&|PY_FISC_WK            |      &&PFY_FISC_WK : &&|PFY_FISC_WK               |      &&LWK_PFY_FISC_WK : &&|LWK_PFY_FISC_WK
-*-TYPE &&PY_FISC_DAY       : &&|PY_FISC_DAY          | &&PFY_FISC_DAY : &&|PFY_FISC_DAY              | &&LWK_PFY_FISC_DAY : &&|LWK_PFY_FISC_DAY
-*-TYPE &&PY_TODAY : &&|PY_TODAY              |    &&PFY_TODAY : &&|PFY_TODAY                 |    &&LWK_PFY_TODAY : &&|LWK_PFY_TODAY
-*-TYPE &&PY_YESTERDAY : &&|PY_YESTERDAY          |    &&PFY_YESTERDAY : &&|PFY_YESTERDAY             |    &&LWK_PFY_YESTERDAY : &&|LWK_PFY_YESTERDAY
-*-TYPE &&PY_TOMORROW : &&|PY_TOMORROW           |    &&PFY_TOMORROW : &&|PFY_TOMORROW              |    &&LWK_PFY_TOMORROW : &&|LWK_PFY_TOMORROW
-*-TYPE &&PY_LAST_WK_BEG : &&|PY_LAST_WK_BEG        |    &&PFY_LAST_WK_BEG : &&|PFY_LAST_WK_BEG           |    &&LWK_PFY_LAST_WK_BEG : &&|LWK_PFY_LAST_WK_BEG
-*-TYPE &&PY_LAST_WK_END : &&|PY_LAST_WK_END        |    &&PFY_LAST_WK_END : &&|PFY_LAST_WK_END           |    &&LWK_PFY_LAST_WK_END : &&|LWK_PFY_LAST_WK_END
-*-TYPE &&PY_CURR_WK_BEG : &&|PY_CURR_WK_BEG        |    &&PFY_CURR_WK_BEG : &&|PFY_CURR_WK_BEG           |    &&LWK_PFY_CURR_WK_BEG : &&|LWK_PFY_CURR_WK_BEG
-*-TYPE &&PY_CURR_WK_END : &&|PY_CURR_WK_END        |    &&PFY_CURR_WK_END : &&|PFY_CURR_WK_END           |    &&LWK_PFY_CURR_WK_END : &&|LWK_PFY_CURR_WK_END
-*-TYPE &&PY_NEXT_WK_BEG : &&|PY_NEXT_WK_BEG        |    &&PFY_NEXT_WK_BEG : &&|PFY_NEXT_WK_BEG           |    &&LWK_PFY_NEXT_WK_BEG : &&|LWK_PFY_NEXT_WK_BEG
-*-TYPE &&PY_NEXT_WK_END : &&|PY_NEXT_WK_END        |    &&PFY_NEXT_WK_END : &&|PFY_NEXT_WK_END           |    &&LWK_PFY_NEXT_WK_END : &&|LWK_PFY_NEXT_WK_END
-*-TYPE &&PY_FISC_MO_BEG : &&|PY_FISC_MO_BEG        |    &&PFY_FISC_MO_BEG : &&|PFY_FISC_MO_BEG           |    &&LWK_PFY_FISC_MO_BEG : &&|LWK_PFY_FISC_MO_BEG
-*-TYPE &&PY_FISC_MO_END : &&|PY_FISC_MO_END        |    &&PFY_FISC_MO_END : &&|PFY_FISC_MO_END           |    &&LWK_PFY_FISC_MO_END : &&|LWK_PFY_FISC_MO_END
-*-TYPE &&PY_FISC_QT_BEG : &&|PY_FISC_QT_BEG        |    &&PFY_FISC_QT_BEG : &&|PFY_FISC_QT_BEG           |    &&LWK_PFY_FISC_QT_BEG : &&|LWK_PFY_FISC_QT_BEG
-*-TYPE &&PY_FISC_QT_END : &&|PY_FISC_QT_END        |    &&PFY_FISC_QT_END : &&|PFY_FISC_QT_END           |    &&LWK_PFY_FISC_QT_END : &&|LWK_PFY_FISC_QT_END
-*-TYPE &&PY_FISC_YR_BEG : &&|PY_FISC_YR_BEG        |    &&PFY_FISC_YR_BEG : &&|PFY_FISC_YR_BEG           |    &&LWK_PFY_FISC_YR_BEG : &&|LWK_PFY_FISC_YR_BEG
-*-TYPE &&PY_FISC_YR_END : &&|PY_FISC_YR_END        |    &&PFY_FISC_YR_END : &&|PFY_FISC_YR_END           |    &&LWK_PFY_FISC_YR_END : &&|LWK_PFY_FISC_YR_END
-*-TYPE &&PY_3WKS_OUT_END : &&|PY_3WKS_OUT_END       |    &&PFY_3WKS_OUT_END : &&|PFY_3WKS_OUT_END          |    &&LWK_PFY_3WKS_OUT_END : &&|LWK_PFY_3WKS_OUT_END
-*-TYPE &&PY_9WKS_OUT_END : &&|PY_9WKS_OUT_END       |    &&PFY_9WKS_OUT_END : &&|PFY_9WKS_OUT_END          |    &&LWK_PFY_9WKS_OUT_END : &&|LWK_PFY_9WKS_OUT_END
-*-TYPE &&PY_4WKS_AGO_BEG : &&|PY_4WKS_AGO_BEG       |    &&PFY_4WKS_AGO_BEG : &&|PFY_4WKS_AGO_BEG          |    &&LWK_PFY_4WKS_AGO_BEG : &&|LWK_PFY_4WKS_AGO_BEG
-*-TYPE &&PY_9WKS_AGO_BEG : &&|PY_9WKS_AGO_BEG       |    &&PFY_9WKS_AGO_BEG : &&|PFY_9WKS_AGO_BEG          |    &&LWK_PFY_9WKS_AGO_BEG : &&|LWK_PFY_9WKS_AGO_BEG
-*-TYPE &&PY_13WKS_AGO_BEG : &&|PY_13WKS_AGO_BEG      |    &&PFY_13WKS_AGO_BEG : &&|PFY_13WKS_AGO_BEG         |    &&LWK_PFY_13WKS_AGO_BEG : &&|LWK_PFY_13WKS_AGO_BEG
-*
-*
-*-TYPE ================================================================================
-*-TYPE PY2 = Prev Year 2Yr Ago (CALENDAR) |    PFY2 = Prev FISCAL Yr (2YR AGO)
-*-TYPE -----------------------------------|--------------------------------------------
-*-TYPE &&PY2_FISC_YR     : &&|PY2_FISC_YR           |        &&PFY2_FISC_YR : &&|PFY2_FISC_YR
-*-TYPE &&PY2_FISC_WK       : &&|PY2_FISC_WK           |      &&PFY2_FISC_WK : &&|PFY2_FISC_WK
-*-TYPE &&PY2_FISC_DAY       : &&|PY2_FISC_DAY         | &&PFY2_FISC_DAY : &&|PFY2_FISC_DAY
-*-TYPE &&PY2_TODAY : &&|PY2_TODAY             |    &&PFY2_TODAY : &&|PFY2_TODAY
-*-TYPE &&PY2_YESTERDAY : &&|PY2_YESTERDAY         |    &&PFY2_YESTERDAY : &&|PFY2_YESTERDAY
-*-TYPE &&PY2_TOMORROW : &&|PY2_TOMORROW          |    &&PFY2_TOMORROW : &&|PFY2_TOMORROW
-*-TYPE &&PY2_LAST_WK_BEG : &&|PY2_LAST_WK_BEG       |    &&PFY2_LAST_WK_BEG : &&|PFY2_LAST_WK_BEG
-*-TYPE &&PY2_LAST_WK_END : &&|PY2_LAST_WK_END       |    &&PFY2_LAST_WK_END : &&|PFY2_LAST_WK_END
-*-TYPE &&PY2_CURR_WK_BEG : &&|PY2_CURR_WK_BEG       |    &&PFY2_CURR_WK_BEG : &&|PFY2_CURR_WK_BEG
-*-TYPE &&PY2_CURR_WK_END : &&|PY2_CURR_WK_END       |    &&PFY2_CURR_WK_END : &&|PFY2_CURR_WK_END
-*-TYPE &&PY2_NEXT_WK_BEG : &&|PY2_NEXT_WK_BEG       |    &&PFY2_NEXT_WK_BEG : &&|PFY2_NEXT_WK_BEG
-*-TYPE &&PY2_NEXT_WK_END : &&|PY2_NEXT_WK_END       |    &&PFY2_NEXT_WK_END : &&|PFY2_NEXT_WK_END
-*-TYPE &&PY2_FISC_MO_BEG : &&|PY2_FISC_MO_BEG       |    &&PFY2_FISC_MO_BEG : &&|PFY2_FISC_MO_BEG
-*-TYPE &&PY2_FISC_MO_END : &&|PY2_FISC_MO_END       |    &&PFY2_FISC_MO_END : &&|PFY2_FISC_MO_END
-*-TYPE &&PY2_FISC_QT_BEG : &&|PY2_FISC_QT_BEG       |    &&PFY2_FISC_QT_BEG : &&|PFY2_FISC_QT_BEG
-*-TYPE &&PY2_FISC_QT_END : &&|PY2_FISC_QT_END       |    &&PFY2_FISC_QT_END : &&|PFY2_FISC_QT_END
-*-TYPE &&PY2_FISC_YR_BEG : &&|PY2_FISC_YR_BEG       |    &&PFY2_FISC_YR_BEG : &&|PFY2_FISC_YR_BEG
-*-TYPE &&PY2_FISC_YR_END : &&|PY2_FISC_YR_END       |    &&PFY2_FISC_YR_END : &&|PFY2_FISC_YR_END
-*-TYPE &&PY2_3WKS_OUT_END : &&|PY2_3WKS_OUT_END      |    &&PFY2_3WKS_OUT_END : &&|PFY2_3WKS_OUT_END
-*-TYPE &&PY2_9WKS_OUT_END : &&|PY2_9WKS_OUT_END      |    &&PFY2_9WKS_OUT_END : &&|PFY2_9WKS_OUT_END
-*-TYPE &&PY2_4WKS_AGO_BEG : &&|PY2_4WKS_AGO_BEG      |    &&PFY2_4WKS_AGO_BEG : &&|PFY2_4WKS_AGO_BEG
-*-TYPE &&PY2_9WKS_AGO_BEG : &&|PY2_9WKS_AGO_BEG      |    &&PFY2_9WKS_AGO_BEG : &&|PFY2_9WKS_AGO_BEG
-*-TYPE &&PY2_13WKS_AGO_BEG : &&|PY2_13WKS_AGO_BEG     |    &&PFY2_13WKS_AGO_BEG : &&|PFY2_13WKS_AGO_BEG

quote:

ENGINE SQLORA SET ISOLATION RU

Do you have Oracle and SQL Server adapters configured? I can't tell from here. But if you don't, back up your edasprof and get rid of all these references to them and see if the error goes away.

BabakNYC,

We do have both types configured. Do we really need to set ISOLATION levels for these here? What are the defaults for this? Do you know?

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

Chuck,

Found the OCI.dll file here: \\serverName\...\ibi\srv82\home\etc\dbms\oracle_instant_client Is there a reason why the RS can't find it for some reason? Should something be set in the system environment variables?

CoolGuy

I didn't realize that we packaged the instant client with the product. I am not sure how to register it though. I think your best option is to have H install the full Oracle client. I believe there are some limitations with using the instant client.

Chuck,

Didn't know there was an option for such. Good to know. Thanks for chiming in and lettings me know about these things. I'll let my team know this is an issue and the probable cause of some of the errors we've been getting.

All,

After lowering the fetch size for our data adapters yesterday, we haven't had any new crashes as of yet, but am still holding out for one or two to come. Hoping not though and that this was the cause or part of it at least. Thanks to everyone that willingly posted to help me on this. I will update this post as SOLVED in about a week if we no longer have any crashes by then.