Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [Solved]Resource Analyzer: SMRPCNAME & SMWFRPCNAME field values
Go
New
Search
Notify
Tools
Reply
  
[Solved]Resource Analyzer: SMRPCNAME & SMWFRPCNAME field values
 Login/Join
 
Member
posted
In the SMQUERY table the SMRPCNAME field value can be blank, and in the SMRPCS table the SMRPCNAME field can have values of ‘Ad-Hoc’ or ‘adhocrq’.
Digging a bit more, when the SMRPCS table field SMRPCNAME value is ‘Ad-Hoc’, the value in the SMWFRPCNAME is ‘AdhocRequest’. However, when the SMRPCS table field SMRPCNAME value is ‘adhocrq’, the value in the SMWFRPCNAME is Blank.

What are the factors that lists these as an Ad Hoc request? What’s the difference between an ‘Ad-Hoc’ and a ‘adhocrq’ request? What sets them apart?
What are the different situations that sets the SMRPCNAME & SMWFRPCNAME field values to these different values and/or combinations?

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


WF 8.2.01M, MF MVS 7.6.5
 
Posts: 26 | Location: Milwaukee, WI | Registered: September 10, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Hi wdusbank,

I consulted with our iWay people, and was suggested that you may want to open a case with Customer Support Services for further assistance, since this may involved more programming research. To open a case, please either call at 1-800-736-6130, or access online at InfoResponse.

Below is some suggestion/info that may be of interest:


The SMQUERY.SMRPCNAME will be blank for all Ad-Hoc requests. This is a UC issue for customers that have been using Resource Analyzer for many years. In Resource Analyzer we use a DEFINE to assign ‘Ad-Hoc’ to blank SMQUERY.SMRPCNAME records so they can be grouped on for reporting.

The values in SMRPCS fields are different. WebFOCUS sends the server several GKE commands in it data stream that control what is in the SMRPCNAME and SMWFRPCNAME fields. At the request of customers any request the has been opened in an editing tool and the RUN function was used to display the results it will be classified as an Ad-Hoc request and literal ‘Ad-Hoc’ was chosen to be the value used in SMRPCNAME. The value in SMWFRPCNAME is controlled by WebFOCUS and its value is determined by GKE commands sent by WebFOCUS. The rules for the usage these GKE commands are in default.wfs and they change over time. Since WF release 7.6.1 there has been fixes applied to default.wfs to correct the usage of the commands. The situation of SMRPCNAME with a value of ‘adhocrq’ and a blank SMWFRPCNAME indicates that the request may not have come from WebFOCUS.


Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [Solved]Resource Analyzer: SMRPCNAME & SMWFRPCNAME field values

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.