Todd Van Valkenburg Posted October 5, 2022 Share Posted October 5, 2022 I recently read that the SYSCOLUM mas stores the attributes to all mas tables. I would like to generate a report using this mas as the data source . I do not see an adapter that jumps out at me to expose this mas. I see that it is in the C:ibisrv82homecatalog directory. Do you know what steps I need to take to allow InfoAssist report writers to use SYSCOLUM mas? Link to comment Share on other sites More sharing options...
David Beagan Posted October 5, 2022 Share Posted October 5, 2022 I think you could copy C:ibisrv82homecatalogsyscolum.mas 🢂 C:ibiappsbaseappsyscolum.masBe aware, there may be changes to the sys*.mas metadata files in future releases. Link to comment Share on other sites More sharing options...
Todd Van Valkenburg Posted October 5, 2022 Author Share Posted October 5, 2022 Thank you. I copied it and I can now use it with InfoAssist. But the only column name appearing is TBNAME as shown in the screen print below. We are using 8207.28.11 And good point about changes in future releases. Seems like an adapter would help with that to point to the source rather than make a copy of it. Perhaps a new feature request? Link to comment Share on other sites More sharing options...
David Beagan Posted October 6, 2022 Share Posted October 6, 2022 You're right. I did a little more investigation and got it to work. I opened the baseapp/syscolum.mas in the synonym editor tool and save it. I recommend saving it to a new name, for example syscolum_ia.mas and then remove the syscolum.mas from baseapp. This seemed to fix whatever issues InfoAssist has with the older master file syntax. Link to comment Share on other sites More sharing options...
Todd Van Valkenburg Posted October 6, 2022 Author Share Posted October 6, 2022 Just renaming the syscolum.mas that I copied to the baseapp directory worked. Thank you again. Link to comment Share on other sites More sharing options...
Todd Van Valkenburg Posted October 11, 2022 Author Share Posted October 11, 2022 Created an idea to have TIBCO create adapters for this mas: https://ideas.tibco.com/ideas/TWFS-I-25 Link to comment Share on other sites More sharing options...
Dirk Kuerbig Posted October 17, 2022 Share Posted October 17, 2022 Hello Todd,please be careful to simply copy the system table master files to a new location, these files are used for some internal processing, and do change in between WebFOCUS releases.If you have an old version in your application search path (APP PATH) and then upgrade, there is a potential for you to break the proper server operation.A suggestion is to always point to the most current version of SYSTABLE / SYSCOLUM and others, by using the concept of "mapping" (pointing to) a directory and adding it to the path.This mapping can happen in your reporting server profile (edasprof.prf)Here is sample code you can use (depending on your environment).-* Step 1. Map a logical name to the directory containing the WebFOCUS system tables (use double quotes)APP MAP RPTONSYS "C:ibisrv82homecatalog"-* Step 2. Somewhere here you set your APP PATH-* Step 3. Add to WebFOCUS Application pathAPP APPENDPATH RPTONSYS This method guarantees that you will always pointing to the most up to date version (after upgrades) of your WebFOCUS system tables, and not interfere with any UI components utilizing the SYS tables as well. Link to comment Share on other sites More sharing options...
Todd Van Valkenburg Posted October 18, 2022 Author Share Posted October 18, 2022 Hi Dirk,Sounds like a good option and what I was looking for. So I am trying this on our Test box but I may be missing a step. This is what I did:1) I edited edasprof.prf and added: APP MAP syscolummap "C:ibisrv82homecatalogsyscolum.mas"2) I also added syscolummap to the APP PATH in edasprof.prf3) Signed off/on to WebFOCUS4) From the Workspaces, I right click on a repository folder and select Properties, then I am expecting (or hoping) to see the new syscolummap in the list under the "Assign Application Path". But it is not there. Todd Link to comment Share on other sites More sharing options...
David Beagan Posted October 18, 2022 Share Posted October 18, 2022 Todd, you are just supposed to MAP the folder, not the file:APP MAP syscolummap "C:ibisrv82homecatalog"I tried it and it worked for me. Link to comment Share on other sites More sharing options...
Todd Van Valkenburg Posted October 18, 2022 Author Share Posted October 18, 2022 Thanks. I now see the mapping. However, I am back to the problem where InfoAssist only "sees" the TBNAME column. I tried backing up the syscolum file, deleting it, and copying back in but it did not fix the issue. Link to comment Share on other sites More sharing options...
David Beagan Posted October 18, 2022 Share Posted October 18, 2022 I guess there is just something about the systable.mas in your release that it doesn't like. So I guess you will have to work with the renamed copy and then check if it works once you upgrade. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now