Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Using RUN for distributionmre is failing

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Using RUN for distributionmre is failing
 Login/Join
 
Member
posted
Hello, I have inherited some IBI consulting code that was working before but is failing now. Here is the call that's failing:

TABLE FILE RUN
PRINT
RESPONSE.RUNRETURN
WHERE USER EQ '&&USERID.EVAL'
WHERE DESCRIPTION EQ '&reportname.EVAL'
-* DISTRIBUTIONMRE settings
WHERE NAME EQ 'dropbox'
-* TASKLISTMYREPORT Settings
WHERE PROCEDURENAME5 EQ '&Rpt_Run.EVAL'
WHERE SENDFORMAT2 EQ '&WFFMT'
WHERE SERVERNAME6 EQ 'EDASERVE'
WHERE EXECID2 EQ '&&USERID.EVAL'
WHERE DOMAINHREF1 EQ 'reportcr/reportcr.htm'
WHERE FOLDERHREF1 EQ 'reportcr/reportcr.htm#rptcreatobbp'
WHERE FIRSTPREPROCESSINGPROCEDURE2 EQ '&&userAppsFolder.EVAL/&Sched_Fex.EVAL'
WHERE FIRSTPOSTPROCESSINGPROCEDURE2 EQ 'infoassist/rc_clean_sched.fex'
WHERE REPORTNAME4 EQ '&MREREPORTNAME'
WHERE STARTTIME EQ DT('&STARTTIME.EVAL')
ON TABLE SAVE AS run_output
END


The error in botsched2 is:

J1eb1oo532o2 | 0000000013 | Unable to distribute to Managed Report:Error occurred when processing the Managed Repor
ting procedure information. Possible cause of this error is an

Any help will be appreciated

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 7
 
Posts: 3 | Registered: May 29, 2020Report This Post
Virtuoso
posted Hide Post
Gary

First of all welcome to Focal Point!!!!

Does the code run successfully outside of ReportCaster?

This message has been edited. Last edited by: FP Mod Chuck,


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Hi Chuck, sorry for the late reply, I was working on another project...
I'm not sure what you mean by "Does the code run successfully outside of ReportCaster?"

Gary


WebFOCUS 7
 
Posts: 3 | Registered: May 29, 2020Report This Post
Virtuoso
posted Hide Post
hI Gary

From app studio or the web inteface does the report run when you right mouse click on it a choose run and it will hopefully work. If it doesn't then fix the issue and then test it again with ReportCaster. You can also turn on ReportCaster tracing and see if it give you more info..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Hello Chuck,
How can I run on Report Caster tracing w/o using the console? Is there a setting on the server that we can change? No one knows the password to the IBI admin account
Gary


WebFOCUS 7
 
Posts: 3 | Registered: May 29, 2020Report This Post
Master
posted Hide Post
First, you don't have your own admin?

Second, it wasn't changed it is admin.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Virtuoso
posted Hide Post
With some SQL you can update the UOA_USERS table password field for the admin user. Using that ID is the only way you will be able to log in and turn on reportcaster tracing.

John may be right the the admin password could be admin but whoever installed the product set that password originally.

You never did answer the question if you could just run this report from app studio or the web interface without an error...


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Using RUN for distributionmre is failing

Copyright © 1996-2020 Information Builders