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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Compare programs in different databases in 8.x

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Compare programs in different databases in 8.x
 Login/Join
 
Bob Shulkind
Member
posted
Does anyone have experience with the following?
Our Test and Prod environments should be identical after code is promoted from Test to Prod (via Change Management). Has anyone tried verifying that the multiple IBI databases match? I tried to determine which table(s) contain WF code but I'm wondering if they might be stored as CLOBs or BLOBs because I couldn't find any code. Any thoughts would be appreciated. Thanks.

This message has been edited. Last edited by: Bob Shulkind,


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Bob Shulkind
Member
posted Hide Post
IBI recommended uses dbVisualizer to compare tables but this is a manual process. I would open 1 table, open a 2nd table, and then compare the 2. I was looking for an automated process where I could list all tables to compare and schedule the process. However, now I'm wondering if the keys in the tables will be the same between databases. Does anyone know which tables contain WebFOCUS code?


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
The best method to compare code from two environments might be to use Change Management Export to export everything in the Repository and then use a file comparison utility to compare the extracted files.

There is a setting in the Admin Console to export files in "raw" format, making them readable. I have not found documentation on calling Change Management in batch, though it can be done.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Bob Shulkind
Member
posted Hide Post
Thanks Francis. I will look into the 'raw' format.


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Bob Shulkind
Member
posted Hide Post
Hi Francis - this is great! That greatly helps if we need to restore a file from backup. Using that option we can select an individual program, copy the code, and paste into the program that lost code.
Thank you very much!!
Bob


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
Yes, it's a great way to backup code. I'd like to find the documentation on running this in batch mode so that I can use Windows Task Scheduler to set up a batch process to export the whole Repository to a cm export folder, then copy that folder to a backup drive.

We were warned that this "raw" capability may not be available in a future release...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Bob Shulkind
Member
posted Hide Post
Close but not quite. I may be able to compare databases this way but the contents of a .fex is not in text format so I wouldn't be able to restore lost code from it unless I'm missing something. I got my hopes up.


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Bob Shulkind
Member
posted Hide Post
Do you think you can use it to restore code for individual programs since it doesn't seem to be text-based?


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
The fex is in text format. If you turned that "Raw" setting on in the Admin Console, after exporting there should be two sub-folders in the export folder: "root" and "root_content". Look in "root_content".


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Bob Shulkind
Member
posted Hide Post
I'm seeing the root directory under export but there isn't a root_content directory. I thought root_content may be a hidden directory but I changed the settings to show hidden files and it still wasn't there. Any ideas?


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Bob Shulkind
Member
posted Hide Post
Yes! It works. I needed to clear cache on the Admin console. Thanks greatly for your help Francis!!


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
I was just about to ask you about the cache clearing! Good news.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Bob Shulkind
Member
posted Hide Post
How do I flag this as resolved? Believe it or not, I haven't had a posting resolved before. You are the first!!! Thanks.


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Francis Mariani
Expert
posted Hide Post
Bob, edit your original post (using that middle icon and change the text in the subject - prepend with [SOLVED]


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Bob Shulkind
Member
posted Hide Post
Thanks again!


WebFOCUS 8.0.09 server, 8.0.07 Client, Windows 2012 R2 Server, InfoAssist, BI Portal, Graphs, Excel, PDF.
 
Posts: 13 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
David Briars
Master
posted Hide Post
quote:
...I'd like to find the documentation on running this in batch mode so that I can use Windows Task Scheduler to set up a batch process to export the whole Repository to a cm export folder, then copy that folder to a backup drive...

I have a goal to periodically backup several our Repository Content Folders.

In the 'WebFOCUS Security and Administration' manual (8105M) I see information regarding running a Change Management Export Scenario using the command line interface.

If I understand the manual correctly I create a scenario with the online WF Portal GUI, and then can call it via a .bat job.

I would then, schedule the .bat job.

As I start to delve into this, thought I'd see if anyone else has gone down this path.

[This was the only FocalPoint thread I could find on this topic, so I thought I would append (or DISP=MOD).]

This message has been edited. Last edited by: David Briars,




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
 
Posts: 822 | Registered: April 23, 2003Report 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] Compare programs in different databases in 8.x

Copyright © 1996-2020 Information Builders