SET ASNAMES = ON TABLE FILE DISTRIBUTION_TBL PRINT BURSTVAL AS 'VALUE' WHERETO AS 'DEST' WHERE ID EQ 'Flooring Open Orders'; ON TABLE PCHOLD END
<?xml version="1.0" encoding="ISO-8859-1" ?> - <fxf version="1.0" data="hold"> - <report records="159" lines="159" columns="2" rows="159"> <target format="" version="" type="" destination="HOLD" /> - <column_desc> <col colnum="c0" fieldname="VALUE" alias="BURSTVAL" datatype="char" width="20" focus_format="A20" description="" accept="" help_message="" title="" property="" reference="" valign="left" /> <col colnum="c1" fieldname="DEST" alias="WHERETO" datatype="char" width="80" focus_format="A80V" description="" accept="" help_message="" title="" property="" reference="" valign="left" /> </column_desc> - <table> - <tr linetype="data" linenum="1"> <td colnum="c0">02908</td> <td colnum="c1">jdoe@email.com</td> </tr>
Starting task: Task 1 Task type: MR Standard Report Task domain: ssa11lc4/ssa11lc4.htm Retrieving MR report: app/flooring_open_orders_by_ticket_burst Connecting to server EDASERVE with execution id jdoe Executing focexec. Task finished. Dynamically creating distribution information 02908 distributed to jdoe@email.com
<?xml version="1.0" encoding="UTF-8" ?> - <fxf version="1.0" data="hold"> - <report records="159" lines="159" columns="2" rows="159"> <target format="" version="" type="" destination="HOLD" /> - <column_desc> <col colnum="c0" fieldname="VALUE" alias="BURSTVAL" datatype="char" width="20" focus_format="A20" description="" accept="" help_message="" title="" property="" reference="" valign="left" /> <col colnum="c1" fieldname="DEST" alias="WHERETO" datatype="char" width="80" focus_format="A80V" description="" accept="" help_message="" title="" property="" reference="" valign="left" /> </column_desc> - <table> - <tr linetype="data" linenum="1"> <td colnum="c0">02908</td> <td colnum="c1" rawvalue="jdoe@email.com">jdoe@email.com</td> </tr>
Starting task: Task 1 Task type: WebFOCUS Report WebFOCUS Report: IBFS:/WFC/Repository/Flooring/Corporate/flooring_open_orders_by_ticket_burst.fex Task domain: Connecting to server EDASERVE with execution id jdoe at 2015-09-29 15:20:43.682-0500 (1,443,558,043,682) Executing focexec. 1 Connection to the Reporting Server EDASERVE closed at 2015-09-29 15:21:08.285-0500 (1,443,558,068,285) Job ran on the Reporting Server EDASERVE for 24.598 seconds Task finished. Starting distribution: Email Distribution method: Email Dynamically creating distribution information Distribution finished. Job finished at 2015-09-29 15:21:08.789-0500 (1,443,558,068,789) Job time on distribution server after the report completed was 0.492 seconds Total running time was 25.307 seconds Total elapsed time (including the queue time) was 25.308 seconds
<?xml version="1.0" encoding="ISO-8859-1" ?> <td colnum="c1">jdoe@email.com</td>
<?xml version="1.0" encoding="UTF-8" ?> <td colnum="c1" rawvalue="jdoe@email.com">jdoe@email.com</td>
SET PAGE = NOLEAD TABLE FILE SAS30DDL SUM DEST VALUE BY STORE_NUMBER NOPRINT ON TABLE SET HOLDLIST PRINTONLY ON TABLE PCHOLD END
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
quote:Originally posted by Doug:
Maybe it's the HOLDLIST? The following works just fine for me.SET PAGE = NOLEAD TABLE FILE SAS30DDL SUM DEST VALUE BY STORE_NUMBER NOPRINT ON TABLE SET HOLDLIST PRINTONLY ON TABLE PCHOLD END
quote:Originally posted by jgelona:
Glad to know this. We are just starting an update from 8.0.08 to 8.1.05 and we use dynamic distribution a lot. This would be a show stopper for us. Have you opened a problem report with IBI?
Doug, when you say that it works fine for you, are you saying that it works on 8.1.05?
BTP1010 Schedule Executed On Demand at WDWBFV11:8200 (WTWBFV11/10.255.208.236) BTP1010 Job placed in the waiting queue at 2015-09-30 09:29:18.998-0400 (1,443,619,758,998) BTP1010 Job started running at 2015-09-30 09:29:19.000-0400 (1,443,619,759,000) BTP1010 Job remained in waiting queue for 0.0020 seconds BTP1010 The Schedule does not exist: Item does not exist IBFS:/WFC/5816adf8Ie0f8I4fefI8c1eI5f144460eb91 . BTP1010 Total running time was 0.472 seconds BTP1010 Total elapsed time (including the queue time) was 0.474 seconds
:GetWFServerRPCAmperParametersProducer] - Failed to get the execid data for the server EDASERVE
SET EXCELSERVURL = ''
quote:Originally posted by MattC:
You do have this in your fex right?
SET EXCELSERVURL = ''
SET EXCELSERVURL = ''and
SET EXCELSERVURL=http://ourserver:8080/ibi_apps/and neither one worked.