Hello All!

I’m working with some dialog manager code and I keep getting the dreaded error code “Unknown error occurred. Agent on reporting server EDASERVE may have crashed.
Please investigate reporting server log.”

I was wondering if I was hitting some kind of limitation (I believe 4k) because I just added another label and it started to bomb. I checked everything (that I know to check) and don’t see any problems. Is there a way to debug the DM code to see if I hit a limitation? My code is below if that helps

Thanks everyone!


-SET &ECHO=ALL;
-SET ASNAMES = ON;
-DEFAULT &StartDate = '01/01/2006';
-DEFAULT &EndDate = '06/01/2006';
-DEFAULT &REPORTNAME = 'Recovery Identified to Recovery Payment';
-DEFAULT &REPORTTYPE = 'Months';
-DEFAULT &NEXTLEVELFLAG ='DLVL1';
-DEFAULT &GeographyTypeCode ='DLVL0';
-DEFAULT &REPORTNAME = 'Recovery Identified to Recovery Payment';
-DEFAULT &WFFMT = 'HTML';
-DEFAULT &REPORTMETRICTYPE = 'Months';
-DEFAULT &GEOGRAPHYKEY = 1;
-DEFAULT &REPORTMETRICTYPE ='Dollars';


-IF (&LVLCOUNT GE 1) THEN GOTO SETLEVEL ELSE GOTO DRILLFLAG;

-SETLEVEL
-SET &GeographyTypeCode = &NEXTLEVELFLAG;


-GOTO DRILLFLAG
-DRILLFLAG
-IF (&GeographyTypeCode EQ 'OLVL0') THEN GOTO CBLVL0;
-IF (&GeographyTypeCode EQ 'OLVL1') THEN GOTO CBLVL1;
-IF (&GeographyTypeCode EQ 'OLVL2') THEN GOTO CBLVL2;
-IF (&GeographyTypeCode EQ 'OLVL3') THEN GOTO CBLVL3;
-IF (&GeographyTypeCode EQ 'CBO') THEN GOTO CBLVL4;
-IF (&GeographyTypeCode EQ 'DLVL0') THEN GOTO DMLVL0;
-IF (&GeographyTypeCode EQ 'DLVL1') THEN GOTO DMLVL1;
-IF (&GeographyTypeCode EQ 'DLVL2') THEN GOTO DMLVL2;

-GOTO ReportFormat

-CBLVL0
-SET &NextLevel = 'Division';
-SET &DrillFlag = 1;
-SET &NEXTLEVELFLAG = 'OLVL1';
-GOTO ReportFormat


-CBLVL1
-SET &NextLevel = 'Region';
-SET &DrillFlag = 1;
-SET &NEXTLEVELFLAG = 'OLVL2';
-GOTO ReportFormat


-CBLVL2
-SET &NextLevel = 'Territory';
-SET &DrillFlag = 1;
-SET &NEXTLEVELFLAG = 'OLVL3';
-GOTO ReportFormat


-CBLVL3
-SET &NextLevel = 'CBO';
-SET &NEXTLEVELFLAG = 'CBO';
-SET &DrillFlag = 1;
-GOTO ReportFormat


-CBLVL4
-SET &NextLevel = 'NONE';
-SET &DrillFlag = 0;
-GOTO ReportFormat


-DMLVL0
-SET &NEXTLEVELFLAG = 'DLVL1';
-SET &NextLevel = 'Region';
-SET &DrillFlag = 1;
-GOTO ReportFormat


-DMLVL1
-SET &NextLevel = 'Insurer';
-SET &NEXTLEVELFLAG = 'DLVL2';
-SET &DrillFlag = 1;
-GOTO ReportFormat


-DMLVL2

-SET &NextLevel = 'NONE';
-SET &DrillFlag = 0;
-GOTO ReportFormat


-GOTO ReportFormat
-ReportFormat
-IF &DrillFlag EQ 0 THEN GOTO SETLINE ELSE GOTO DEFAULTLINE;
-SETLINE
-SET &LINE = 6;
-GOTO SprocLogic
-DEFAULTLINE
-SET &LINE = 7;
-GOTO SprocLogic


-SprocLogic
-IF ((&REPORTNAME EQ 'Recovery Identified to Recovery Payment') AND
- (&REPORTTYPE EQ 'Months')
-AND (&REPORTMETRICTYPE EQ 'Dollars'))
-THEN GOTO IdentPdMnAmt;

-IF ((&REPORTNAME EQ 'Recovery Identified to Recovery Payment')
-AND (&REPORTTYPE EQ 'Days') AND (&REPORTMETRICTYPE EQ 'Dollars'))
-THEN GOTO IdentPdAgAmt;

-IF ((&REPORTNAME EQ 'Recovery Identified to Recovery Payment')
-AND (&REPORTTYPE EQ 'Months') AND (&REPORTMETRICTYPE EQ 'Counts'))
-THEN GOTO IdentPdMnCnt;

-IF ((&REPORTNAME EQ 'Recovery Identified to Recovery Payment')
-AND (&REPORTTYPE EQ 'Days') AND (&REPORTMETRICTYPE EQ 'Counts'))
-THEN GOTO IdentPdAgCnt;

-IF ((&REPORTNAME EQ 'Client Approved to Recovery Payment') AND
- (&REPORTTYPE EQ 'Months')
-AND (&REPORTMETRICTYPE EQ 'Dollars'))
-THEN GOTO AprvPdMnAmt;

-IF ((&REPORTNAME EQ 'Client Approved to Recovery Payment')
-AND (&REPORTTYPE EQ 'Days') AND (&REPORTMETRICTYPE EQ 'Dollars'))
-THEN GOTO AprvPdAgAmt;

-IF ((&REPORTNAME EQ 'Client Approved to Recovery Payment')
-AND (&REPORTTYPE EQ 'Months') AND (&REPORTMETRICTYPE EQ 'Counts'))
-THEN GOTO AprvPdMnCnt;

-IF ((&REPORTNAME EQ 'Client Approved to Recovery Payment')
-AND (&REPORTTYPE EQ 'Days') AND (&REPORTMETRICTYPE EQ 'Counts'))
-THEN GOTO AprvPdAgCnt;

-IF ((&REPORTNAME EQ 'Recovery Identified to Invoiced') AND
- (&REPORTTYPE EQ 'Months')
-AND (&REPORTMETRICTYPE EQ 'Dollars'))
-THEN GOTO IdentIvMnAmt;

-IF ((&REPORTNAME EQ 'Recovery Identified to Invoiced') AND
- (&REPORTTYPE EQ 'Months')
-AND (&REPORTMETRICTYPE EQ 'Counts'))
-THEN GOTO IdentIvMnCnt;


-IdentPdMnAmt

-SET &SPROCNAME='wfWedgeIdentPaidMnAmt';
-SET &BASEDATE='BaseDate';
-SET &BASEMETRIC='BaseAmt';
-SET &BASEMETRICCOL='BaseCount';
-SET &COMPAREMETRIC = 'ComparisonAmt';
-SET &COMPAREDATE = 'ComparisonDate';
-SET &BASEDATENAME = 'span title="Month in which the refund was loaded into the recovery system.">Recovery Identified Month/span>';
-SET &BASEAMTNAME = 'span title="Total dollar amount of the refund loaded into Safari Corporate net of refund debit and credit adjustments.">Adjusted Recovery Identified Amount/span>';
-SET &BASECNTNAME = 'span title="Number of refunds loaded into the recovery system.">Recovery Identified Count/span>';
-SET &COMPAREAMTNAME = 'span title="Total dollar payments and payment adjustments posted to a refund to satisfy Recovery AR">Recovery Payment Amt/span>';
-SET &COMPAREDATENAME = 'span title="Maximum recovery payment month where Recovery AR has been satisfied.">Recovery Satisfied Date/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Aoumnt by Identified Month">Row Total/span>';
-INCLUDE WedgeMns.fex
-EXIT


-IdentPdAgAmt
-SET &SPROCNAME = 'wfWedgeIdentPaidAgingAmt';
-SET &BASEMETRICCOL = 'BaseCount';
-SET &BASEMETRIC = 'BaseAmt';
-SET &BASEDATE = 'BaseDate';
-SET &COMPAREAMTNAME ='Amount';
-SET &BASEDATENAME = 'span title="Month in which the refund was loaded into the recovery system.">Recovery Identified Month/span>';
-SET &BASEAMTNAME = 'span title="Total dollar amount of the refund loaded into Safari Corporate net of refund debit and credit adjustments.">Adjusted Recovery Identified Amount/span>';
-SET &BASECNTNAME = 'span title="Number of refunds loaded into the recovery system.">Recovery Identified Count/span>';
-SET &ZERONAME = 'span title="Total dollar payments and payment adjustments posted between 0 and 30 days to satisfy a refund">0-30 Recovery Payment Amount/span>';
-SET &THIRTYNAME = 'span title="Total dollar payments and payment adjustments posted between 31 and 60 days to satisfy a refund">31-60 Recovery Payment Amount/span>';
-SET &SIXTEYNAME = 'span title="Total dollar payments and payment adjustments posted between 61 and 90 days to satisfy a refund">61-90 Recovery Payment Amount/span>';
-SET &NINTEYNAME = 'span title="Total dollar payments and payment adjustments posted between 91 and 121 days to satisfy a refund">91-121 Recovery Payment Amount/span>';
-SET &ONETWENTYNAME = 'span title="Total dollar payments and payment adjustments posted between 121 and 150 days to satisfy a refund">121-150 Recovery Payment Amount/span>';
-SET &ONEFIFTEYNAME = 'span title="Total dollar payments and payment adjustments posted between 151 and 180 days to satisfy a refund">151-180 Recovery Payment Amount/span>';
-SET &ONEEIGHTYNAME = 'span title="Total dollar payments and payment adjustments posted over 180 days to satisfy a refund">180+ Recovery Payment Amount/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Amount by Identified Month">Total Amount/span>';
-INCLUDE WedgeAgg.fex
-EXIT

-IdentPdMnCnt
-SET &SPROCNAME = 'wfWedgeIdentPaidMnAmt';
-SET &BASEDATE = 'BaseDate';
-SET &BASEMETRIC = 'BaseCount';
-SET &BASEMETRICCOL = 'BaseAmt';
-SET &COMPAREMETRIC = 'ComparisonCount';
-SET &COMPAREDATE = 'ComparisonDate';
-SET &BASEDATENAME = 'span title="Month in which the refund was loaded into the recovery system.">Recovery Identified Month/span>';
-SET &BASEAMTNAME ='span title="Number of refunds loaded into the recovery system.">Recovery Identified Count/span>';
-SET &BASECNTNAME = 'span title="Total dollar amount of the refund loaded into Safari Corporate net of refund debit and credit adjustments.">Adjusted Recovery Identified Amount/span>';
-SET &COMPAREAMTNAME ='span title="Number of refunds where Recovery AR has been satisfied">Recovery Payment Count/span>';
-SET &COMPAREDATENAME = 'span title="Maximum recovery payment month where Recovery AR has been satisfied">Recovery Satisfied Date/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Count by Identified Month">Row Total/span>';
-INCLUDE WedgeMns.fex
-EXIT

-IdentPdAgCnt
-SET &SPROCNAME = 'wfWedgeIdentPaidAgingCnt';
-SET &BASEMETRICCOL = 'BaseAmt';
-SET &BASEMETRIC = 'BaseCount';
-SET &BASEDATE = 'BaseDate';
-SET &COMPAREAMTNAME ='Count';
-SET &BASEDATENAME = 'span title="Month in which the refund was loaded into the recovery system.">Recovery Identified Month/span>';
-SET &BASEAMTNAME = 'span title="Number of refunds loaded into the recovery system.">Recovery Identified Count/span>';
-SET &BASECNTNAME ='span title="Total dollar amount of the refund loaded into Safari Corporate net of refund debit and credit adjustments.">Adjusted Recovery Identified Amount/span>';
-SET &ZERONAME = 'span title="Number of refunds where Recovery AR has been satisfied between 0 and 30 days">0-30 Recovery Payment Count/span>';
-SET &THIRTYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 31 and 60 days">31-60 Recovery Payment Count/span>';
-SET &SIXTEYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 61 and 90 days">61-90 Recovery Payment Count/span>';
-SET &NINTEYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 91 and 120 days">91-120 Recovery Payment Count/span>';
-SET &ONETWENTYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 121 and 150 days">121-150 Recovery Payment Count/span>';
-SET &ONEFIFTEYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 151 and 180 days">151-180 Recovery Payment Count/span>';
-SET &ONEEIGHTYNAME = 'span title="Number of refunds where Recovery AR has been satisfied over 180 days">180+ Recovery Payment Count/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Count by Identified Month">Total Count/span>';
-INCLUDE WedgeAgg.fex
-EXIT


-AprvPdMnAmt
-SET &SPROCNAME = 'wfWedgeApprovPaidMnAmt';
-SET &BASEDATE='BaseDate';
-SET &BASEMETRIC='BaseAmt';
-SET &BASEMETRICCOL='BaseCount';
-SET &COMPAREMETRIC = 'ComparisonAmt';
-SET &COMPAREDATE = 'ComparisonDate';
-SET &BASEDATENAME = 'span title="Month in which the refund was approved for recovery by the client.">Client Approved Month/span>';
-SET &BASEAMTNAME = 'span title="Total dollar amount net of refund debit and credit adjustments that was approved for recovery by the client.">Client Approved Amount/span>';
-SET &BASECNTNAME = 'span title="Number of refunds approved by the client for recovery">Client Approved Count/span>';
-SET &COMPAREAMTNAME = 'span title="Total dollar payments and payment adjustments posted to a refund to satisfy Recovery AR">Recovery Payment Amt/span>';
-SET &COMPAREDATENAME = 'span title="Maximum recovery payment month where Recovery AR has been satisfied.">Recovery Satisfied Date/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Aoumnt by Identified Month">Row Total/span>';
-INCLUDE WedgeMns.fex
-EXIT

-AprvPdAgAmt
-SET &SPROCNAME = 'wfWedgeApprovPaidAgingAmt';
-SET &BASEMETRICCOL = 'BaseCount';
-SET &BASEMETRIC = 'BaseAmt';
-SET &BASEDATE = 'BaseDate';
-SET &COMPAREAMTNAME ='Amount';
-SET &BASEDATENAME = 'span title="Month in which the refund was approved for recovery by the client.">Client Approved Month/span>';
-SET &BASEAMTNAME = 'span title="Total dollar amount net of refund debit and credit adjustments that was approved for recovery by the client.">Client Approved Amount/span>';
-SET &BASECNTNAME = 'span title="Number of refunds approved by the client for recovery">Client Approved Count/span>';
-SET &ZERONAME = 'span title="Total dollar payments and payment adjustments posted between 0 and 30 days to satisfy a refund">0-30 Recovery Payment Amount/span>';
-SET &THIRTYNAME = 'span title="Total dollar payments and payment adjustments posted between 31 and 60 days to satisfy a refund">31-60 Recovery Payment Amount/span>';
-SET &SIXTEYNAME = 'span title="Total dollar payments and payment adjustments posted between 61 and 90 days to satisfy a refund">61-90 Recovery Payment Amount/span>';
-SET &NINTEYNAME = 'span title="Total dollar payments and payment adjustments posted between 91 and 121 days to satisfy a refund">91-121 Recovery Payment Amount/span>';
-SET &ONETWENTYNAME = 'span title="Total dollar payments and payment adjustments posted between 121 and 150 days to satisfy a refund">121-150 Recovery Payment Amount/span>';
-SET &ONEFIFTEYNAME = 'span title="Total dollar payments and payment adjustments posted between 151 and 180 days to satisfy a refund">151-180 Recovery Payment Amount/span>';
-SET &ONEEIGHTYNAME = 'span title="Total dollar payments and payment adjustments posted over 180 days to satisfy a refund">180+ Recovery Payment Amount/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Amount by Identified Month">Total Amount/span>';
-INCLUDE WedgeAgg.fex
-EXIT

-AprvPdMnCnt
-SET &SPROCNAME = 'wfWedgeApprovPaidMnAmt';
-SET &BASEDATE = 'BaseDate';
-SET &BASEMETRIC = 'BaseCount';
-SET &BASEMETRICCOL = 'BaseAmt';
-SET &COMPAREMETRIC = 'ComparisonCount';
-SET &COMPAREDATE = 'ComparisonDate';
-SET &BASEDATENAME = 'span title="Month in which the refund was approved for recovery by the client.">Client Approved Month/span>';
-SET &BASEAMTNAME ='span title="Number of refunds approved by the client for recovery">Client Approved Count/span>';
-SET &BASECNTNAME = 'span title="Total dollar amount net of refund debit and credit adjustments that was approved for recovery by the client.">Client Approved Amount/span>';
-SET &COMPAREAMTNAME ='span title="Number of refunds where Recovery AR has been satisfied">Recovery Payment Count/span>';
-SET &COMPAREDATENAME = 'span title="Maximum recovery payment month where Recovery AR has been satisfied">Recovery Satisfied Date/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Count by Identified Month">Row Total/span>';
-INCLUDE WedgeMns.fex
-EXIT

-AprvPdAgCnt
-SET &SPROCNAME = 'wfWedgeApprovPaidAgingCnt';
-SET &BASEMETRICCOL = 'BaseAmt';
-SET &BASEMETRIC = 'BaseCount';
-SET &BASEDATE = 'BaseDate';
-SET &COMPAREAMTNAME ='Count';
-SET &BASEDATENAME = 'span title="Month in which the refund was approved for recovery by the client.">Client Approved Month/span>';
-SET &BASEAMTNAME = 'span title="Number of refunds approved by the client for recovery">Client Approved Count/span>';
-SET &BASECNTNAME ='span title="Total dollar amount net of refund debit and credit adjustments that was approved for recovery by the client.">Client Approved Amount/span>';
-SET &ZERONAME = 'span title="Number of refunds where Recovery AR has been satisfied between 0 and 30 days">0-30 Recovery Payment Count/span>';
-SET &THIRTYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 31 and 60 days">31-60 Recovery Payment Count/span>';
-SET &SIXTEYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 61 and 90 days">61-90 Recovery Payment Count/span>';
-SET &NINTEYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 91 and 120 days">91-120 Recovery Payment Count/span>';
-SET &ONETWENTYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 121 and 150 days">121-150 Recovery Payment Count/span>';
-SET &ONEFIFTEYNAME = 'span title="Number of refunds where Recovery AR has been satisfied between 151 and 180 days">151-180 Recovery Payment Count/span>';
-SET &ONEEIGHTYNAME = 'span title="Number of refunds where Recovery AR has been satisfied over 180 days">180+ Recovery Payment Count/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Count by Identified Month">Total Count/span>';
-INCLUDE WedgeAgg.fex
-EXIT

-IdentIvMnAmt
-SET &SPROCNAME='wfWedgeApprovInvoicMnAmt';
-SET &BASEDATE='BaseDate';
-SET &BASEMETRIC='BaseAmt';
-SET &BASEMETRICCOL='BaseCount';
-SET &COMPAREMETRIC = 'ComparisonAmt';
-SET &COMPAREDATE = 'ComparisonDate';
-SET &BASEDATENAME = 'span title="Month in which the refund was loaded into the recovery system.">Recovery Identified Month/span>';
-SET &BASEAMTNAME = 'span title="Total dollar amount of the refund loaded into Safari Corporate net of refund debit and credit adjustments.">Adjusted Recovery Identified Amount/span>';
-SET &BASECNTNAME = 'span title="Number of refunds loaded into the recovery system.">Recovery Identified Count/span>';
-SET &COMPAREAMTNAME = 'span title="Total dollar payments and payment adjustments posted to a refund to satisfy Recovery AR">Invoiced Amt/span>';
-SET &COMPAREDATENAME = 'span title="Maximum recovery payment month where Recovery AR has been satisfied.">Invoiced Date/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Aoumnt by Identified Month">Row Total/span>';
-INCLUDE WedgeMns.fex
-EXIT

-IdentIvMnCnt
-SET &SPROCNAME = 'wfWedgeApprovInvoicMnAmt';
-SET &BASEDATE = 'BaseDate';
-SET &BASEMETRIC = 'BaseCount';
-SET &BASEMETRICCOL = 'BaseAmt';
-SET &COMPAREMETRIC = 'ComparisonCount';
-SET &COMPAREDATE = 'ComparisonDate';
-SET &BASEDATENAME = 'span title="Month in which the refund was loaded into the recovery system.">Recovery Identified Month/span>';
-SET &BASEAMTNAME ='span title="Number of refunds loaded into the recovery system.">Recovery Identified Count/span>';
-SET &BASECNTNAME = 'span title="Total dollar amount of the refund loaded into Safari Corporate net of refund debit and credit adjustments.">Adjusted Recovery Identified Amount/span>';
-SET &COMPAREAMTNAME ='span title="Number of refunds where Recovery AR has been satisfied">Invoiced Payment Count/span>';
-SET &COMPAREDATENAME = 'span title="Maximum recovery payment month where Recovery AR has been satisfied">Invoiced Date/span>';
-SET &ACROSSNAME = 'span title="This is the total Recovery Payment Count by Identified Month">Row Total/span>';
-INCLUDE WedgeMns.fex
-EXIT


****Edit because the tooltip code was showing up. I removed the ‘<’ on each variable with ‘NAME’ on it****

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

ETL,

Which one did you add???

Well each variable that has ‘NAME’ on the end has tooltips code like : -SET &ACROSSNAME = span title="This is the total Recovery Payment Count by Identified Month">Row Total
I’m not sure why it didn't post correctly

When the added the label -IdentIvMnCnt (the last label) it started to bomb; before that it worked.

Art

ETL,

Reserved Words???

You have ECHO=ALL - The error comes after the -INCLUDE WedgeMns.fex (I don't usually add the .fex part, BUT, if it works), outside of that, all your labels are 12 or less. The 4k dosen't come into play because of the branching; make any stylesheet changes??? Always gets me.
Don't see anything obvious; Can you post the -INCLUDE, then the error???

Thanks for the help Tom!

Well I’d love to give you the error code, but unfortunately it is giving me the “unknown error”; that is why I’m posting it here.

I’m posting (below) my –include fex (WedgeMns.fex) , but I don’t think that is where the problem is because I can execute that fex by itself.


-SET &ECHO=ALL;
-*-SET &STACK=OFF;
-DEFAULT &StartDate = '01/01/2006'
-DEFAULT &EndDate = '06/01/2006'
-DEFAULT &LVLCOUNT = '0'
-DEFAULT &SPROCNAME = 'wfWedgeIdentPaidMnAmt'
-DEFAULT &NextLevel = 'Region'
-DEFAULT &WFFMT = 'HTML'
-DEFAULT &LINE = 7
-DEFAULT &NEXTLEVELFLAG ='DLVL1'
-DEFAULT &GeographyTypeCode ='DLVL0'
-DEFAULT &REPORTNAME = 'Recovery Identified to Recovery Payment'
-DEFAULT &DrillFlag = 1
-DEFAULT &REPORTTYPE = 'Months'
-DEFAULT &REPORTMETRICTYPE = 'Counts'
-DEFAULT &BASEDATE = 'BaseDate'
-DEFAULT &COMPAREDATE = 'ComparisonDate'
-DEFAULT &BASEMETRIC = 'BaseAmt'
-DEFAULT &BASEMETRICCOL = 'BaseCount'
-DEFAULT &COMPAREMETRIC = 'ComparisonAmt'
-DEFAULT &GEOGRAPHYKEY = 1

-SET &COLUMNNAME = 'Totals for';
-SET &LVLCOUNT = &LVLCOUNT + 1;
ENGINE SQLMSS SET DEFAULT_CONNECTION BIW_View
SQL SQLMSS EX &SPROCNAME '&GEOGRAPHYKEY','&StartDate','&EndDate','&GeographyTypeCode';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END
TABLE FILE SQLOUT
SUM
&BASEMETRICCOL/D12B AS &BASECNTNAME.QUOTEDSTRING
&BASEMETRIC/D12B AS &BASEAMTNAME.QUOTEDSTRING
BY GeographyName NOPRINT
BY &BASEDATE AS &BASEDATENAME.QUOTEDSTRING
BY GeographyKey NOPRINT
SUM
&COMPAREMETRIC/D12B AS &COMPAREAMTNAME.QUOTEDSTRING
COMPUTE PCT_COMP/D15.2% = ABS((&COMPAREMETRIC/&BASEMETRIC) * 100); AS 'Percent by Month'
BY GeographyName NOPRINT
BY &BASEDATE
BY GeographyKey NOPRINT
ACROSS &COMPAREDATE AS &COMPAREDATENAME.QUOTEDSTRING
ACROSS-TOTAL AS &ACROSSNAME.QUOTEDSTRING
-*ON GeographyName SUBTOTAL AS 'Total'
ON GeographyName RECOMPUTE PCT_COMP
ON GeographyName RECOMPUTE &BASEMETRIC
ON GeographyName RECOMPUTE &BASEMETRICCOL
ON GeographyName RECOMPUTE &COMPAREMETRIC AS &COLUMNNAME.QUOTEDSTRING
ON GeographyName PAGE-BREAK NOPRINT
HEADING
"Page "Report Date: <+0>&DATEMDYY <+0> "
-IF &DrillFlag EQ 0 THEN GOTO :No_Drill;
"Drill Down to &NextLevel for -:No_Drill
"Wedge Reports"
"&REPORTNAME"
"&StartDate thru &EndDate "
"For FOOTING
"Report generated by: &IBIMR_user"
"Procedure Name: wwrm0001.fex "
"Data Source: AIMBIW-DEV.BIW_View"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT AHTML
ON TABLE PCHOLD FORMAT &WFFMT.(,,,).Select type of display output.
ON TABLE SET COMPOUND 'BYTOC 1'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
SIZE=8,
BACKCOLOR=( RGB(228 228 228) 'WHITE' ),

$
TYPE=DATA,
COLUMN=N10,
COLOR='BLACK',


$
TYPE=DATA,
COLUMN=N1,
COLOR='BLACK',
STYLE=BOLD,

$
TYPE=TITLE,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
SIZE=8,
COLOR='BLACK',
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N10,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N1,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N9,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N8,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N7,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N6,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N5,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N4,
COLOR='BLACK',
$
TYPE=TITLE,
COLUMN=N3,
COLOR='BLACK',
$
TYPE=TABHEADING,
STYLE=BOLD,
$
TYPE=TABFOOTING,
STYLE=BOLD,
$
TYPE=HEADING,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
SIZE=12,
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=RIGHT,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,


$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=8,
STYLE=NORMAL,

$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=RIGHT,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=8,
STYLE=NORMAL,
-IF &DrillFlag EQ 0 THEN GOTO :Skip_Title;
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
ALT='Drilldown to see the &NextLevel''s broken out',
TARGET='_blank',
FOCEXEC=app/wedgemas(GEOGRAPHYKEY=GeographyKey StartDate='&StartDate' EndDate='&EndDate' NEXTLEVELFLAG='&NEXTLEVELFLAG' GeographyTypeCode ='&GeographyTypeCode' REPORTNAME='&REPORTNAME' REPORTTYPE='Months' LVLCOUNT='&LVLCOUNT' WFFMT='&WFFMT' REPORTMETRICTYPE='&REPORTMETRICTYPE'),

$
TYPE=HEADING,
LINE=3,
SIZE=8,
STYLE=NORMAL,
JUSTIFY=RIGHT,

-:Skip_Title
$
TYPE=FOOTING,
LINE=3,
JUSTIFY=RIGHT,
$
TYPE=FOOTING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=&LINE,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
TOC=1,
$
TYPE=HEADING,
LINE=7,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
BACKCOLOR=RGB(198 211 236),
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=1,
JUSTIFY=RIGHT,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
JUSTIFY=RIGHT,
$
TYPE=FOOTING,
LINE=3,
JUSTIFY=RIGHT,
$
TYPE=FOOTING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=SUBHEAD,
STYLE=BOLD,
$
TYPE=SUBFOOT,
BORDER=LIGHT,
BORDER-STYLE=RIDGE,
BORDER-COLOR=RGB(51 51 153),
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
$
TYPE=SUBTOTAL,
SIZE=8,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
SIZE=8,
COLOR='BLACK',
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(1),
BACKCOLOR=RGB(228 228 228),
$
TYPE=ACROSSTITLE,
SIZE=8,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
SIZE=9,
STYLE=BOLD,
$
TYPE=REPORT,
IMAGE=aimlogo.gif,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.541667,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=0.680556,
$
ENDSTYLE
END

Dev 7.1.4 WinNT SQL Server 2005 DB
Prod 7.1.4 WinNT SQL Server 2000 DB

After adding -DEFAULT &LVLCOUNT = 1; this code runs fine on my WF 5.3.2 server.

A couple of points:

The .fex for the -INCLUDE statement is not required.

-SET ASNAMES = ON; should be SET ASNAMES = ON (not that it would make a difference to the snippet of code you posted).

If you have embedded HMTL code in a message on this forum ( in your case), you should click on the "Options" hyperlink of the Message window and check the "Disable HTML" checkbox.

Have you tried sticking a -EXIT right after the label -IdentPdAgAmt and then moving the -EXIT progressively down the code until the error occurs?

Or, of course, it could be something in the -INCLUDE.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Hey Art,

Yea, nothing is popping out; by-the-way: Cool Code.

Just suggest you go 1 Amper at a time; I am assuming if you branched another way, it's working fine.

Another idea would be the source pull; any new columns missing or needed???


Edited to add:

-SET &SPROCNAME = 'wfWedgeApprovInvoicMnAmt';

New fex that may have a different HREF name than the fex name???? Check the properties...

Nothing obvious...Tom

This message has been edited. Last edited by: Tom Flynn,

Hey guys…. Thanks for the help.

I added -DEFAULT &LVLCOUNT = 1; and it still doesn’t work.

I’ve also gone through line by line to see where the problem is and it somewhere around the line “-SET &COMPAREMETRIC = 'ComparisonCount';” in the IdentIvMnCnt label.

There are no new columns or missing columns coming from the stored procedure. I’m a little perplexed by this.

I want to point out that when I run this fex, it doesn’t even prompt for parameters. It just bombs right from the get go.

I’ve opened a case and I’ll see what they come up with.

E, i notice two things:your span variables lack an opening left caret (as francis says, there are ways to post html code here, surrounding your code with code tags [ code] and [ /code]

and you've got two variables defaulted with the same name &REPORTNAME, which focus doesn't like.

Also,

&REPORTMETRICTYPE is Defaulted twice.

Best of luck,

Kevin

Thanks for all the responses.

A quick little update. This will run on the reporting server, but when I try to run this in MRE, it bombs. Problem is that I have to have a HTML page to hook up to this procedure.