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 - Creating report off Reportcaster Log file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
SOLVED - Creating report off Reportcaster Log file
 Login/Join
 
LaVonne
Member
posted
I am trying to create a daily report off the Reportcaster Botlog, Botlog2 and Botsched files but am running into a problem with the message field on Botlog2. Has anyone done any of this kind of reporting? I want a report that will tell me when certain verbage appears in the message field.

This message has been edited. Last edited by: LaVonne,


WF/7.1, Windows NT, PDF/EXCEL
 
Posts: 13 | Location: Detroit | Registered: October 26, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
I have a number of reports that go against BOTLOG and BOTLOG2. The MESSAGE field in BOTLOG2 is defined as an A150. I currently don't do any CONTAINS on it.

What kinds of problems are you having? Have you created synonyms for the tables?


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
LaVonne
Member
posted Hide Post
Yes, I've created synonyms. I'm trying to get the most recent comment to go with each daily job. Contains doesn't seem to be working properly as I've come across jobs with verbage that I'm looking for that isn't showing up on my report. I've tried the contains against the actual message field and also against a defined field and neither seems to be working. I've tried FST. and LST. also. Any ideas?


WF/7.1, Windows NT, PDF/EXCEL
 
Posts: 13 | Location: Detroit | Registered: October 26, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
Well, the most recent comment or log would be the one with the highest datetime stamp as stored in BOTLOG. You have to join BOTLOG to BOTLOG2 to get this to work. There are multiple MESSAGE records per 'job' execution, each uniquely identified by the COUNTER field. You would have to search all of the lines to find what you are looking for.

Why don't you post your code? I may not have time to look at it this afternoon as I have to do a training session for my users. But if it ends early, I'll take a quick peek.

Where in Detroit are you? I grew up there and have a home in Ann Arbor.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
LaVonne
Member
posted Hide Post
My problem seems to be with the variable length fields .. the A150V message field and the A12V scheduleid field. I've never worked with this type of field before and couldn't find anything in the manuals on reading them, only on creating them. How do you edit them? Is there something special you have to do if you want to print them? 150 bytes is a large field,,,I'd like to edit it down to say 50 or 60 bytes.

I live by Port Huron and work in downtown Detroit. Raised in Windsor.


WF/7.1, Windows NT, PDF/EXCEL
 
Posts: 13 | Location: Detroit | Registered: October 26, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
Mine aren't defined as V fields. You can use a DEFINE to equate them to a non-variable field. Also there are variable versions of some of the functions, SUBSTV for instance.

I have not tried PARAG on a V field but you might want to give that a try.

Boy, that's a long drive for you.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
I just thought of something else. In my edasprof.prf or global profile, for each of my relational adapters, I have the line

SET ENGINE xxx SET VARCHAR OFF

Now when I create my synonyms, I don't get V columns. You might want to try that and regenerate your synonyms for your RC tables. That would save you a lot of hassle.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
LaVonne
Member
posted Hide Post
Parag worked. This is the subroutine I had been trying to use but evidently something else in the code was causing a problem as its working now. Thanks all.


WF/7.1, Windows NT, PDF/EXCEL
 
Posts: 13 | Location: Detroit | Registered: October 26, 2006Report 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 - Creating report off Reportcaster Log file

Copyright © 1996-2020 Information Builders