Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Having srv crashing issues due to losing excess amt of VRAM from edapgwy.exe process:

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Having srv crashing issues due to losing excess amt of VRAM from edapgwy.exe process:
 Login/Join
 
Virtuoso
posted
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!


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Expert
posted Hide Post
I would suggest talking to Techsupport about what edapgwy is expected to do and user


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
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.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Silver Member
posted Hide Post
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


8105 Tomcat and AIX reporting server
input: Teradata, SQL, DB2, Essbase, Oracle, text
output:html, excel, PDF,
 
Posts: 35 | Location: DFW Texas | Registered: May 30, 2008Report This Post
Virtuoso
posted Hide Post
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,


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Virtuoso
posted Hide Post
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 


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Virtuoso
posted Hide Post
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?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
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.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Virtuoso
posted Hide Post
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?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Virtuoso
posted Hide Post
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



8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Virtuoso
posted Hide Post
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.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Virtuoso
posted Hide Post
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,


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Virtuoso
posted Hide Post
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?


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Virtuoso
posted Hide Post
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.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Having srv crashing issues due to losing excess amt of VRAM from edapgwy.exe process:

Copyright © 1996-2020 Information Builders