Hi,

We were testing our migration process to 8201m. When i run my fex with -SET &ECHO=ALL; it does not show traces in the source.

On the client admin console, i have the Default options for FEX tracing set to 'Echo On, SQL On'

Is there something that i am missing?

Thank you in advance.

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

I normally have the following to see traces

SET SQLTOPTTF = ON
-* Deactivate SQL tracing
SET TRACEOFF  = ALL
-* Disable the trace stamp (Date/Time etc)
SET TRACESTAMP= OFF
-* Set trace line wrapping - # of characters
SET TRACEWRAP = 72
-* Enable Trace for the SQL Translator
SET TRACEON   = SQLTRANS
-* Show Optimization information in HTML page
SET TRACEON   = SQLAGGR//CLIENT
-* Show SQL statements in HTML page
SET TRACEON   = STMTRACE//CLIENT
-* Show SQL generated statement trace in HTML page
SET TRACEON   = STMTRACE/1/CLIENT
-* Show SQL generated sub-statement trace in HTML page
SET TRACEON   = STMTRACE/2/CLIENT

-* Activate SQL tracing
SET TRACEUSER = ON
SET MSG       = ON
SET HOLDSTAT  = ON
SET EMGSRV    = ON
-SET &ECHO    = ALL;

Martin,

It still does not show me all traces. The lines of code are not returned. I can see only dialog manager commands in the source.

Hi WF1326

One of the options on the run icon is to set message viewer on. This should display the results of the -SET &ECHO=ALL;

Chuck,

Tried that option too. It didn't work.

quote:

It still does not show me all traces. The lines of code are not returned.

And you have pasted "my" SET in your fex (ideally at the beginning) ?

Do you have INCLUDE that may change the trace setting ?

Martin,

And you have pasted "my" SET in your fex (ideally at the beginning) ? Yes

Do you have INCLUDE that may change the trace setting ? No

Does this show the code in your environment?

 
-SET &ECHO=ALL;
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ &COUNTRY;
END
 

Please share your code, it may help us to understand where is the issue.

This code gives me the report output
-SET &ECHO=ALL;
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY';
END

But, when i view the source it displays as

[!DOCTYPE html]
[html]
[head]
[meta name="HandheldFriendly" content="True"]
[meta name="PalmComputingPlatform" content="True"]
[title]WebFOCUS Report[/title]
[style type="text/css"]
[!--
TD { vertical-align:top; }
--]
[/style]
[/head]
[body]
[table border cellpadding=1]
[tr]
[td colspan=3]
[table cellpadding=0 width="100%"][tr]
[td]
PAGE 1[/td][/tr][/table][/td]
[/tr]
[tr]
[td style="vertical-align:bottom"]
COUNTRY[/td]
[td style="vertical-align:bottom"]
CAR[/td]
[td align=RIGHT style="vertical-align:bottom"]
SALES[/td]
[/tr]
[tr]
[td]
ENGLAND[/td]
[td]
JAGUAR[/td]
[td align=RIGHT]
12000[/td]
[/tr]
[tr]
[td]
[/td]
[td]
JENSEN[/td]
[td align=RIGHT]
0[/td]
[/tr]
[tr]
[td]
[/td]
[td]
TRIUMPH[/td]
[td align=RIGHT]
0[/td]
[/tr]
[/table]
[/body]
[/html]
[div id='_ibirunmsgs' style='display:none'][pre]
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
END
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 3
0 HOLDING HTML FILE ON PC DISK ...
[/pre][/div][script type='text/javascript']
var inlinemsgs = document.getElementById('_ibirunmsgs');
var msgBoxId = '_ibi_runmsgbox';
var winParent = window.parent
try {
var msgBox = winParent.document.getElementById(msgBoxId);
if (msgBox == null && winParent != null) {
winParent = winParent.parent;
if (winParent != null)
msgBox = winParent.document.getElementById(msgBoxId);
}
if (msgBox == null && winParent != null) {
winParent = winParent.parent;
if (winParent != null)
msgBox = winParent.document.getElementById(msgBoxId);
}
if (msgBox == null && winParent != null) {
winParent = winParent.parent;
if (winParent != null)
msgBox = winParent.document.getElementById(msgBoxId);
}
}catch(e){}
if (msgBox != null && inlinemsgs != null && inlinemsgs)
msgBox.innerHTML=inlinemsgs.innerHTML;
[/script]

Please use the code tag when posting sample data and/or sample code or whatever else that you copy/paste. This is the last icon on the ribbon

</>

As per what you shared (from a right click/view source on your report result) seems to be the normal behavior.

What is your issue ?

CAR is a FOCUS file, hence in your specimen code there is no generated SQL code and no interaction with a database server to trace.

I disagree -SET &ECHO = ALL; should "Echo" the code that was run showing parameter substitution etc. At least it does on my 8105 environment.


< !--
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
END
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 3
0 HOLDING HTML FILE ON PC DISK ...



There has to be a setting somewhere preventing this. Check the serever profile (edasprof.prf) to see what settings are in there.

Adding the -SET &ECHO=ALL (and/or all the previous SET that I posted) just before the TABLE FILE will overwrite any profile.

@Chuck : Doing a TABLE FILE CAR does NOT generates SQL code since it's not performed against a DB as j.gross stated and what is displayed as the traces (as you and WF1326 displayed) it's the result of an -SET &ECHO=ALL with Focus source file.

I think that WF1326 should share its code and the trace when executing the following:

-SET &ECHO=ALL;
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE HOLD
END
-RUN

Is giving this:

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD
END

And doing the following:

SET SQLTOPTTF = ON
-* Deactivate SQL tracing
SET TRACEOFF  = ALL
-* Disable the trace stamp (Date/Time etc)
SET TRACESTAMP= OFF
-* Set trace line wrapping - # of characters
SET TRACEWRAP = 72
-* Enable Trace for the SQL Translator
SET TRACEON   = SQLTRANS
-* Show Optimization information in HTML page
SET TRACEON   = SQLAGGR//CLIENT
-* Show SQL statements in HTML page
SET TRACEON   = STMTRACE//CLIENT
-* Show SQL generated statement trace in HTML page
SET TRACEON   = STMTRACE/1/CLIENT
-* Show SQL generated sub-statement trace in HTML page
SET TRACEON   = STMTRACE/2/CLIENT

-* Activate SQL tracing
SET TRACEUSER = ON
SET MSG       = ON
SET HOLDSTAT  = ON
SET EMGSRV    = ON
-SET &ECHO    = ALL;

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE HOLD
END

Is giving this:

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD
END
0 NUMBER OF RECORDS IN TABLE=        4  LINES=      3

quote:

Originally posted by MartinY:
Adding the -SET &ECHO=ALL (and/or all the previous SET that I posted) just before the TABLE FILE will overwrite any profile.

@Chuck : Doing a TABLE FILE CAR does NOT generates SQL code since it's not performed against a DB as j.gross stated and what is displayed as the traces (as you and WF1326 displayed) it's the result of an -SET &ECHO=ALL with Focus source file.

I think that WF1326 should share its code and the trace when executing the following:

-SET &ECHO=ALL;
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE HOLD
END
-RUN

Is giving this:

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD
END

And doing the following:

SET SQLTOPTTF = ON
-* Deactivate SQL tracing
SET TRACEOFF  = ALL
-* Disable the trace stamp (Date/Time etc)
SET TRACESTAMP= OFF
-* Set trace line wrapping - # of characters
SET TRACEWRAP = 72
-* Enable Trace for the SQL Translator
SET TRACEON   = SQLTRANS
-* Show Optimization information in HTML page
SET TRACEON   = SQLAGGR//CLIENT
-* Show SQL statements in HTML page
SET TRACEON   = STMTRACE//CLIENT
-* Show SQL generated statement trace in HTML page
SET TRACEON   = STMTRACE/1/CLIENT
-* Show SQL generated sub-statement trace in HTML page
SET TRACEON   = STMTRACE/2/CLIENT

-* Activate SQL tracing
SET TRACEUSER = ON
SET MSG       = ON
SET HOLDSTAT  = ON
SET EMGSRV    = ON
-SET &ECHO    = ALL;

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE HOLD
END

Is giving this:

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD
END
0 NUMBER OF RECORDS IN TABLE=        4  LINES=      3

@Martin: I get the same results as you got. This happens since i have ON TABLE HOLD.

Normally, for a HTML report output, when you do a view source, we see this code in green fonts at the end. This isn't happening in 8201m and works great in 8105 as chuck mentioned.

< !--
-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ 'ENGLAND';
END
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 3
0 HOLDING HTML FILE ON PC DISK ...

@Chuck: I checked the edasprof.prf file on the 8201 server. Inaddition to APP PATH and adapter connections, i see these

SET CDN=COMMAS_DOT
SET CURRENCY_ISO_CODE=USD
SET DATE_ORDER=MDY
SET WEEKFIRST=ISO1
SET LANGUAGE=AMENGLISH

I guess these have nothing to do with tracing

I think the 8201 is returning the traces but presenting them inside