As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.
While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."
You will need to register or log in or register to engage in the new community.
WebFOCUS Repository : Information about FEX and Master files
I need to get informaiton about FEX and Masterfiles from WebFOCUS Repository is that possible ?
FEX procedures are on WF client i.e. WF Repository not in WF server.
Also, can we get informaiton about the FEX files referenced in portals ?
we are using WF 8202m
(2) Answers
What type of information are you looking for? We run a few queries against the repository tables to find, for example, FEXs that use a particular table or field. I find the SQL query to be more helpful than trying to use the reports in the Admin console. This is the query I use:
SELECT
T2.PRT_PATH AS 'Location',
T2.OBJNAME AS 'Object Name',
OBJDESC AS 'Title'
, T2.LASTACCESSON
, T2.LASTACCESSBY
, T1.CREATEDBY
, T2.LASTMODON
FROM WF_CONTENT_REVS T1
INNER JOIN WF_REPOSOBJ T2
ON T1.OBJ_HANDLE = T2.HANDLE
INNER JOINWF_NLSOBJ T3
ON T1.OBJ_HANDLE = T3.OBJ_HANDLE
--LIKE '%blank'', FOCEXEC=%' should give reports with drill through links
WHERE UPPER(CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE '%MANAGER_AUDIT%'
ORDER BY 1, 3
Hi ranegi,
As you also mentioned the Portal FEXes are in the WebFOCUS repository, but note the Mastefiles are not. These can be found on the WebFOCUS Server under "ibi\apps\...".
You can view the readable version of the Repository content by using Change Management from the Portal/Legacy page to export it. This will place the extracted content in a subdirectory under "ibi\WebFOCUS82\cm\export" and if you then navigate to the
"<package_name>\root_content\WFC\Repository\<domain_name>\"
directory, you should be able to see the related FEXes and subdirectories with more FEXes, as well as any portals used and exported.
BEFORE EXPORTING, make sure to check the Export RAW format setting. You are using a very old version of WebFOCUS and I am not sure if this was available then, but if it was, it should be under
WebFOCUS Administration Console > Configuration> Application Settings > Change management.
If not there, you could try adding this command in the Custom Settings ("site.wfs") and see if it works:
IBI_CM_Format_RAW=TRUE
Tomcat may need restarting after this change.
Regards,
Eleni