[SOLVED] Not sure what is causing an agent crash on a simple table file request
If I could get some assistance please. I have a request for a report showing all 48 fields in the table for one record(merchant ID). The request is to have the report show in a table format, so I am employing the use of OVER. I am also computing some blank lines in the fex. Additionally, with the OVER command, column headings are shown to the left of the field and not above the field. So I am trying to "compute" those column headings as seperate items. After adding the second set of column COMPUTES, I get the following error.
Unknown error occurred. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log.
If I comment out 2 of the seven COMPUTES (as you see in the code below), I have no issue. Commenting out the sixth column compute, and it crashes.
Here is the TABLE FILE part of the fex. TABLE FILE DCC_ALL_ITEMS PRINT COMPUTE 1STCOLUMN1/A50='Card Number'; AS '' COMPUTE 2NDCOLUMN1/A50='Transaction Date'; AS '' COMPUTE 3RDCOLUMN1/A50='Assoc Auth Code'; AS '' COMPUTE 4THCOLUMN1/A50='Transaction Amount'; AS '' COMPUTE 5THCOLUMN1/A50='MAS Proc Date'; AS '' COMPUTE 6THCOLUMN1/A50='Sequence Number'; AS '' COMPUTE 7THCOLUMN1/A50='Acqu Merchant ID'; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARD_NUMBER' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.NEW_TRANS_DATE' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSOC_AUTH_CODE' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_TRANS_AMT' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.NEW_MAS_PROC_DATE1' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_SEQ_NUMBER' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ACQ_MERCH_ID' AS '' OVER COMPUTE 1STBLANKLINE/A1=''; AS '' OVER COMPUTE 1STCOLUMN2/A50='Chain MID'; AS '' COMPUTE 2NDCOLUMN2/A50='MAS Bank ID'; AS '' COMPUTE 3RDCOLUMN2/A50='File Trans Code Indicator'; AS '' COMPUTE 4THCOLUMN2/A50='File Card Type Indicator'; AS '' -* COMPUTE 5THCOLUMN2/A50='File Card Type Pneumonic'; AS '' -* COMPUTE 6THCOLUMN2/A50='Extern Bank Batch Number'; AS '' COMPUTE 7THCOLUMN2/A50='Sequence Number'; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CHAIN_MID' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MAS_BANK_ID' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_FILE_TRANS_CODE_ID' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_FILE_CARD_TYPE_ID' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARD_TYPE' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_EXT_BANK_BATCH_NUM' AS '' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_REJECT_REASON' AS '' OVER COMPUTE 2NDBLANKLINE/A1=''; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INT_MAS_CH_TYPE_IND' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CROSS_BORDER_TRANS_FLG' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_FUNDING_FLG' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_POS_ENTRY_MODE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TRANSACTION_TIME' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INT_MAS_BATCH_NUM' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.NEW_DEP_DATE' OVER COMPUTE 3RDBLANKLINE/A1=''; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_BATCH_AMT' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_EXT_BANK_BATCH_ID' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSOC_ARN' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSESSMENT_AMT' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARDHOLDER_TRANS_CURR_CODE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARDHOLDER_CONV_RATE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TRANS_MARK_UP_PCT' OVER COMPUTE 4THBLANKLINE/A1=''; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_CARDHOLDER_TRANS_AMT' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INT_MAS_BANK_PROC_FLG' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TERMINAL_ID' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_PLANNED_INT_FEE_STNG' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ASSOC_FEE_PROG_IND' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_INTERCHANT_AMT_ASSESSED' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_TRANS_GROSS_REV' OVER COMPUTE 5THBLANKLINE/A1=''; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_ACQ_REV_SHARE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_PP_REV_SHARE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_REV_SHARE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_OHT_PTCP_REV_SHARE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MCC' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_DBA_NAME' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_STREET_ADDR' OVER COMPUTE 6THBLANKLINE/A1=''; AS '' OVER 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_CITY' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_STATE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_ZIP' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_PHONE' 'DCC_ALL_ITEMS.DCC_ALL_ITEMS.AI_MERCH_CONTACT' HEADING "" FOOTING "" WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $
Any help, or leads in the right direction would be much appreciated.
Thanks!This message has been edited. Last edited by: Kerry,
release 7.7.03M OS - Linux HTML, PDF, Excel, Delimited files, Graphs, Dashboards, MRE, Report Caster
December 21, 2011, 02:46 PM
MonkeyP
It would seem that HTMLCSS being ON is what caused the problem. I have turned that off and am having no problems. Other than now I have this default grid in there that I don't want. Any idea how to get rid of it? Or is this solution not the right one?
release 7.7.03M OS - Linux HTML, PDF, Excel, Delimited files, Graphs, Dashboards, MRE, Report Caster
December 21, 2011, 03:28 PM
Dan Satchell
Add GRID=OFF to your StyleSheet statement.
WebFOCUS 7.7.05
December 21, 2011, 03:43 PM
MonkeyP
That did it. Gotta love stylesheet quirkiness. All is well. Consider this item closed.
Thanks!
release 7.7.03M OS - Linux HTML, PDF, Excel, Delimited files, Graphs, Dashboards, MRE, Report Caster