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,

Lois

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

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)

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.

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

7.7 has ACTUAL=DATE which may explain the problem but not why WF is changing it when it upgrades the report.

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?

We installed 8.1 on different server and migrated all 7.7 reports. Oracle and Banner did not change.

I haven't done anything to report/server since I ported report from 7.7 to 8.1

The ACTIVITY_DATE is defined as:
USAGE = YYMD
ACTUAL = HYYMDS

They should be the same? Should I try to change ACTUAL?

Lois

The ACTUAL should be DATE and USAGE YYMD unless you do want the timestamp then the ACTUAL and USAGE should match with HYYMDS