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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] FOC1418
 Login/Join
 
Member
posted
WF 8.1
Converting a report from 7.7; receiving this message on a field I'm not using!

(FOC1418) ACTUAL/USAGE TYPE MISMATCH FOR DATETIME FIELD : ACTIVITY_DATE ACTIVITY_DATE

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 13 | Registered: October 08, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Lois

It is still parsing the entire master file. Edit that master file and check how ACTIVITY_DATE is defined.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1569 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
FIELDNAME=ACTIVITY_DATE, ALIAS=ACTIVITY_DATE, USAGE=YYMD, ACTUAL=HYYMDS,

Here is definition; should I change it; delete it? (field is null for all records)
 
Posts: 13 | Registered: October 08, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try USAGE=HYYMD

However, the more fundamental question is why do you have mismatched USAGE and ACTUAL. Did you recreate the master file or change something?

Also, what's the data source? Is it an RDBMS? It would help if we knew a little more about this conversion.


WebFOCUS 8206, Unix, Windows
 
Posts: 1660 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
I have no idea why the USAGE and ACTUAL are different. This report runs fine on 7.7 and but when I ported it to 8.1, this is what happened.

Oracle running the Banner ERP
 
Posts: 13 | Registered: October 08, 2013Reply With QuoteReport This Post
Member
posted Hide Post
7.7 has ACTUAL=DATE which may explain the problem but not why WF is changing it when it upgrades the report.
 
Posts: 13 | Registered: October 08, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Did you actually recreate the metadata? Does it work when you change the Actual to to DATE? Is your upgrade limited to only WebFOCUS or did you also upgrade Banner and/or Oracle? Can you test create a dummy master file for this table and check to see what the USAGE and ACTUALs are for the date fields?


WebFOCUS 8206, Unix, Windows
 
Posts: 1660 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 


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