 |
|||||
|
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. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Running MREXTRACT from dashboard | Login/Join |
| Platinum Member |
Does anyone know if there is a way to run the MREEXTRACT utility from a dashboard. Our issue is that our client is on zLinux. We have several group admins who for SOX controls need to run reports against the data provided by the MREXTRACT utility. We would like to set it up so that they can run the utility without having to logon to zLinux and run the utility especially since some are not familiar with that environment. This is a new environment for myself also as in past the client was on windows. Thanks Webfocus 8.0.7 on Windows | ||
|
| Expert |
You didn't say which dashboard. If it is WebFOCUS, you can create a focexec that runs the mrextract.bat file by putting a ! in front of it, e.g.: !/home/ibi/WebFOCUS76/utilities/mrextract.bat Check the permissions on the file to make sure it is world executable. Then have code to report off of the extract files. If it is not a WebFOCUS dashboard, the mradmin manual describes how you can run the extract via java. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Platinum Member |
Sorry I meant the webfocus dashboard. My problem is that with the reporting server running on windows and the client on zLinux no code I write can seem to find the mrextract file. Which I think makes sense as this is running on the Reporting server so it looks for the file on windows and it is not there as this is a client utilitiy Webfocus 8.0.7 on Windows | |||
|
| Member |
We run the mrrextract utility from a dashboard as part of our administration routine whenever we add users, groups, etc.. Our reporting server is on AIX, but the concept should be similar. Create a htm pointing to a fex or just a fex and add to the dashboard. Add the below line first in your fex with the correct path. (Fully path the command) Create a batch file (.bat) that contains the command or call the command directly. -WINNT C:\...\mrextract.bat This is how we do it, but we use the -UNIX instead of -WINNT We wrapper the mreeextract program in a .ksh, because we need to do additional system level processing on files. Hope this helps David wf: 7.6.4 App. and reporting server: UNIX/AIX 5.3 | |||
|
| Platinum Member |
Thanks, That worked great on our servers where the client and the reporting server our on the same platform. However on the systems where the client is zLinux and the reporting server is windows this does not work. If I change the command to UNIX instead of DOS it seems to ignore the command as nothing happens no errors that I can find but no data either. Any ideas how to do this in a mixed environment ? Webfocus 8.0.7 on Windows | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |