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     [SOLVED] Drill from Excel Report gets RunItem Access Denied

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Drill from Excel Report gets RunItem Access Denied
 Login/Join
 
Platinum Member
posted
Hi All

We have a report that was working (Drill from Excel report) but now it is not working when you drill from the Excel Report. It gives ..fex (drill Fex) RunItem Access Denied error
I checked the security on this Fex, it is there.. I can run it by itself... Just when drilling from the main excel report it gives this error
here is the drill code
TYPE=DATA,
     COLUMN=N11,
     FOCEXEC=IBFS:/WFC/Repository/lawsonwf/std_reports/reportsfqcp5/pr_empannualsalary_by_distribution_drill.fex( \
     EmpNo=N11 \
     Job=N10 \
     ReportName='EMPANNUALSAL_BYDIST_BYPROC_DETAIL' \
     BeginDate=&RANGE_BEG_DATE.QUOTEDSTRING \
     EndDate=&RANGE_END_DATE.QUOTEDSTRING \
     REPORT_AUTO_NO=&HOLD_RAN.QUOTEDSTRING \
     ),
	 ALT='CLICK TO DRILL (N10)',
$  


if you had similar situation, would appreciate if you can share solution .. I opened the case with IBI, so far no solution that would get red of this error... about two weeks ago it was working , now getting this error..

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


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
 
Posts: 134 | Location: USA | Registered: August 21, 2008Report This Post
Virtuoso
posted Hide Post
Can you think of any changes on the Reporting Server or Client? Usually, code that used to work doesn't stop working unless something has changed. Are there other examples doing similar things that work or have all drill downs stopped working?

Would the drill down work if you switched from Excel to HTML or PDF?

Can you create whole new simple test report that does a drill down from Excel?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Platinum Member
posted Hide Post
Thank you BabaNYC

I figured out.. It has to do with Browser settings.. Somehow my browser settings were changed .. I did the following to resolve the issue.. in case someone else has the same issue

To address this issue for the user:
1. Access IE.
2. Click on "Tools", "Internet Options" and "Advanced".
3 Reset the Internet Explorer settings.

This will set the browser back to the original IE settings.

Now I get the excel warning message about opening the excel file after you click on the drill

Thanks


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
 
Posts: 134 | Location: USA | Registered: August 21, 2008Report This Post
Platinum Member
posted Hide Post
I did the above and it worked few times.. But now I am back to the same problem. Access Denied error comes again... Our drills from PDF/HTML files work , just from Excel Report Drill to another excel Report gives this error... I have called IBI tech support and no response so far.. So if anyone out here had the same issue and how they resolved it, please let me know

Thanks


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
 
Posts: 134 | Location: USA | Registered: August 21, 2008Report 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     [SOLVED] Drill from Excel Report gets RunItem Access Denied

Copyright © 1996-2020 Information Builders