Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hello all, I am currently dealing with a baffling situation....


Ricky Ray 2

Recommended Posts

Hello all,

I am currently dealing with a baffling situation. I have a procedure that runs fine, but is refusing to play nice with Reportcaster.

I set up the schedule, using the same parameters in the Task that I use when I run the procedure natively. An XLSX file is getting generated, however, in the Task Log View the log shows No Report To Distribute

 

Schedule Executed On Demand at ()

Job placed in the waiting queue at 2022-01-19 12:31:27.506-0600 (1,642,617,087,506)

Job started running at 2022-01-19 12:31:27.507-0600 (1,642,617,087,507)

Job remained in waiting queue for 0.001 seconds

Starting task: Task 1

Task type: WebFOCUS Report

WebFOCUS Report:

Task domain: null

Connecting to server EDASERVE with execution id at 2022-01-19 12:31:27.673-0600 (1,642,617,087,673)

Executing focexec.

0 XLSX FILE SAVED

Connection to the Reporting Server EDASERVE closed at 2022-01-19 12:32:28.353-0600 (1,642,617,148,353)

Job ran on the Reporting Server EDASERVE for 60.678 seconds

Task finished.

No report to distribute.

Job finished at 2022-01-19 12:32:28.360-0600 (1,642,617,148,360)

Job time on distribution server after the report completed was 0.001 seconds

Total running time was 60.853 seconds

Total elapsed time (including the queue time) was 60.854 seconds

 

I can set other schedules up just fine. I am on 8105m. Any help

Link to comment
Share on other sites

Hello Ricky,

ReportCaster can be quirky.

 

You need to check the override the format specified in the procedure on the tasks tab. Enter the filename, and the output format you need.

 

I have seen this with procedures that have hold files, and compound excel reports. The override format seems to solve it.

 

Make sure your report is PCHOLD and not HOLD. HOLD wont distribute. PCHOLD will.

Link to comment
Share on other sites

A thing that you can do when you use RC to create HOLD file is to add that last step in your fex

-* --------------------------------------------------

-* THIS STEP IS ONLY TO AVOID THE RC WARNING FROM NO REPORT TO DISTRIBUTE

-* --------------------------------------------------

TABLE FILE CAR

BY COUNTRY NOPRINT

HEADING

" END OF MY HOLD FILE"

WHERE READLIMIT EQ 1;

ON TABLE PCHOLD FORMAT HTML

END

-RUN

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...