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     Error - (FOC1022) INVALID DUMMY KEY DESCRIPTION IN MASTER FILE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Error - (FOC1022) INVALID DUMMY KEY DESCRIPTION IN MASTER FILE
 Login/Join
 
Rodney Chan
Member
posted
My work place is currently moving from 7.6 to 7.7 and we are testing the reports in 7.7

One of our reports returned the following error

(FOC1022) INVALID DUMMY KEY DESCRIPTION IN MASTER FILE

I checked the HTML and I dont see any other major errors.

The report is based off an ESSBASE cube, and works perfectly fine in 7.6 but once in 7.7 it craps out on the above error.

The master file was regenerated in 7.7 as well, just the base report fex code and HTML was copied over.

The .acx generated by our local admin also returns data so he was suggesting its a reporting code error, but i see it working fine in 7.6

I tried to google around but couldnt find anything beyond what the error message above states.

Has anyone come across of this?

Thanks in advance...


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 26 | Registered: October 27, 2011Report This Post
FrankDutch
Virtuoso
posted Hide Post
maybe posting the master file description might give some information




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Rodney Chan
Member
posted Hide Post
Heres the contents of the .MAS file in the version that is giving us problems (7.7)

I dont see "DUMMY" anywhere in the file

  FILENAME=DRVXMT2, SUFFIX=ESSBASE , $
  SEGMENT=DRVXM, SEGTYPE=S0, $
$  DIMENSION: TotalYear
 DIMENSION=TotalYear, CAPTION='TotalYear', $
  HIERARCHY=TotalYear, CAPTION='TotalYear Levels', HRY_DIMENSION=TotalYear, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=TOTALYEAR, ALIAS='Gen1,TotalYear', USAGE=A10, ACTUAL=A10,
      WITHIN='*TotalYear',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_TOTALYEAR, ALIAS='Gen2,TotalYear', USAGE=A10, ACTUAL=A10,
      WITHIN=TOTALYEAR,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_TOTALYEAR, ALIAS='Gen3,TotalYear', USAGE=A14, ACTUAL=A14,
      WITHIN=GEN2_TOTALYEAR,
      PROPERTY=UID,  $
    FIELDNAME=GEN4_TOTALYEAR, ALIAS='Gen4,TotalYear', USAGE=A6, ACTUAL=A6,
      WITHIN=GEN3_TOTALYEAR,
      PROPERTY=UID,  $
  HIERARCHY=TotalYear2, CAPTION='TotalYear Parent-Child', HRY_DIMENSION=TotalYear, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=TOTALYEAR_MEMBER, ALIAS=TotalYear, USAGE=A14, ACTUAL=A14,
      WITHIN='*TotalYear2',
      PROPERTY=UID,  $
    FIELDNAME=TOTALYEAR_CAPTION, USAGE=A10, ACTUAL=A10,
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=TOTALYEAR_PARENT, USAGE=A14, ACTUAL=A14,
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=TOTALYEAR_PARENTCAP, USAGE=A10, ACTUAL=A10,
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=TOTALYEAR_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='TotalYear_LVLNO LEVEL_NUMBER',
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: CalendarYear
 DIMENSION=CalendarYear, CAPTION='CalendarYear', $
  HIERARCHY=CalendarYear, CAPTION='CalendarYear Levels', HRY_DIMENSION=CalendarYear, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=CALENDARYEAR, ALIAS='Gen1,CalendarYear', USAGE=A13, ACTUAL=A13,
      WITHIN='*CalendarYear',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_CALENDARYEAR, ALIAS='Gen2,CalendarYear', USAGE=A4, ACTUAL=A4,
      WITHIN=CALENDARYEAR,
      PROPERTY=UID,  $
  HIERARCHY=CalendarYear2, CAPTION='CalendarYear Parent-Child', HRY_DIMENSION=CalendarYear, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=CALENDARYEAR_MEMBER, ALIAS=CalendarYear, USAGE=A12, ACTUAL=A12,
      WITHIN='*CalendarYear2',
      PROPERTY=UID,  $
    FIELDNAME=CALENDARYEAR_CAPTION, USAGE=A13, ACTUAL=A13,
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=CALENDARYEAR_PARENT, USAGE=A12, ACTUAL=A12,
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=CALENDARYEAR_PARENTCAP, USAGE=A13, ACTUAL=A13,
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=CALENDARYEAR_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='CalendarYear_LVLNO LEVEL_NUMBER',
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: Location
 DIMENSION=Location, CAPTION='Location', $
  HIERARCHY=Location, CAPTION='Location Levels', HRY_DIMENSION=Location, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=LOCATION, ALIAS='Gen1,Location', USAGE=A8, ACTUAL=A8,
      WITHIN='*Location',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_LOCATION, ALIAS='Gen2,Location', USAGE=A5, ACTUAL=A5,
      WITHIN=LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_LOCATION, ALIAS='Gen3,Location', USAGE=A24, ACTUAL=A24,
      WITHIN=GEN2_LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN4_LOCATION, ALIAS='Gen4,Location', USAGE=A30, ACTUAL=A30,
      WITHIN=GEN3_LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN5_LOCATION, ALIAS='Gen5,Location', USAGE=A38, ACTUAL=A38,
      WITHIN=GEN4_LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN6_LOCATION, ALIAS='Gen6,Location', USAGE=A35, ACTUAL=A35,
      WITHIN=GEN5_LOCATION,
      PROPERTY=UID,  $
  HIERARCHY=Location2, CAPTION='Location Parent-Child', HRY_DIMENSION=Location, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=LOCATION_MEMBER, ALIAS=Location, USAGE=A8, ACTUAL=A8,
      WITHIN='*Location2',
      PROPERTY=UID,  $
    FIELDNAME=LOCATION_CAPTION, USAGE=A38, ACTUAL=A38,
      REFERENCE=LOCATION_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=LOCATION_PARENT, USAGE=A8, ACTUAL=A8,
      REFERENCE=LOCATION_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=LOCATION_PARENTCAP, USAGE=A38, ACTUAL=A38,
      REFERENCE=LOCATION_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=LOCATION_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='Location_LVLNO LEVEL_NUMBER',
      REFERENCE=LOCATION_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: LicenceClass
 DIMENSION=LicenceClass, CAPTION='LicenceClass', $
  HIERARCHY=LicenceClass, CAPTION='LicenceClass Levels', HRY_DIMENSION=LicenceClass, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=LICENCECLASS, ALIAS='Gen1,LicenceClass', USAGE=A12, ACTUAL=A12,
      WITHIN='*LicenceClass',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_LICENCECLASS, ALIAS='Gen2,LicenceClass', USAGE=A10, ACTUAL=A10,
      WITHIN=LICENCECLASS,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_LICENCECLASS, ALIAS='Gen3,LicenceClass', USAGE=A8, ACTUAL=A8,
      WITHIN=GEN2_LICENCECLASS,
      PROPERTY=UID,  $
    FIELDNAME=GEN4_LICENCECLASS, ALIAS='Gen4,LicenceClass', USAGE=A2, ACTUAL=A2,
      WITHIN=GEN3_LICENCECLASS,
      PROPERTY=UID,  $
  HIERARCHY=LicenceClass2, CAPTION='LicenceClass Parent-Child', HRY_DIMENSION=LicenceClass, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=LICENCECLASS_MEMBER, ALIAS=LicenceClass, USAGE=A12, ACTUAL=A12,
      WITHIN='*LicenceClass2',
      PROPERTY=UID,  $
    FIELDNAME=LICENCECLASS_CAPTION, USAGE=A5, ACTUAL=A5,
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=LICENCECLASS_PARENT, USAGE=A12, ACTUAL=A12,
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=LICENCECLASS_PARENTCAP, USAGE=A5, ACTUAL=A5,
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=LICENCECLASS_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='LicenceClass_LVLNO LEVEL_NUMBER',
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: 00Reasons
 DIMENSION=00Reasons, CAPTION='00Reasons', $
  HIERARCHY=00Reasons, CAPTION='00Reasons Levels', HRY_DIMENSION=00Reasons, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=00REASONS, ALIAS='Gen1,00Reasons', USAGE=A9, ACTUAL=A9,
      WITHIN='*00Reasons',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_00REASONS, ALIAS='Gen2,00Reasons', USAGE=A17, ACTUAL=A17,
      WITHIN=00REASONS,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_00REASONS, ALIAS='Gen3,00Reasons', USAGE=A41, ACTUAL=A41,
      WITHIN=GEN2_00REASONS,
      PROPERTY=UID,  $
  HIERARCHY=00Reasons2, CAPTION='00Reasons Parent-Child', HRY_DIMENSION=00Reasons, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=00REASONS_MEMBER, ALIAS=00Reasons, USAGE=A9, ACTUAL=A9,
      WITHIN='*00Reasons2',
      PROPERTY=UID,  $
    FIELDNAME=00REASONS_CAPTION, USAGE=A41, ACTUAL=A41,
      REFERENCE=00REASONS_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=00REASONS_PARENT, USAGE=A9, ACTUAL=A9,
      REFERENCE=00REASONS_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=00REASONS_PARENTCAP, USAGE=A41, ACTUAL=A41,
      REFERENCE=00REASONS_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=00REASONS_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='00Reasons_LVLNO LEVEL_NUMBER',
      REFERENCE=00REASONS_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: Examiners
 DIMENSION=Examiners, CAPTION='Examiners', $
  HIERARCHY=Examiners, CAPTION='Examiners Levels', HRY_DIMENSION=Examiners, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=EXAMINERS, ALIAS='Gen1,Examiners', USAGE=A9, ACTUAL=A9,
      WITHIN='*Examiners',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_EXAMINERS, ALIAS='Gen2,Examiners', USAGE=A10, ACTUAL=A10,
      WITHIN=EXAMINERS,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_EXAMINERS, ALIAS='Gen3,Examiners', USAGE=A6, ACTUAL=A6,
      WITHIN=GEN2_EXAMINERS,
      PROPERTY=UID,  $
  HIERARCHY=Examiners2, CAPTION='Examiners Parent-Child', HRY_DIMENSION=Examiners, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=EXAMINERS_MEMBER, ALIAS=Examiners, USAGE=A10, ACTUAL=A10,
      WITHIN='*Examiners2',
      PROPERTY=UID,  $
    FIELDNAME=EXAMINERS_CAPTION, USAGE=A10, ACTUAL=A10,
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=EXAMINERS_PARENT, USAGE=A10, ACTUAL=A10,
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=EXAMINERS_PARENTCAP, USAGE=A10, ACTUAL=A10,
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=EXAMINERS_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='Examiners_LVLNO LEVEL_NUMBER',
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: Measur1
  SEGMENT=MEASUR1, SEGTYPE=U, PARENT=DRVXM, $
    FIELDNAME=TESTS, ALIAS=TESTS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='TESTS',
      PROPERTY=MEASURE,  $
    FIELDNAME=DISPATCHED, ALIAS=DISPATCHED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='DISPATCHED',
      PROPERTY=MEASURE,  $
    FIELDNAME=CONDUCTED, ALIAS=CONDUCTED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='CONDUCTED',
      PROPERTY=MEASURE,  $
    FIELDNAME=PASSED, ALIAS=PASSED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='PASSED',
      PROPERTY=MEASURE,  $
    FIELDNAME=FAILED, ALIAS=FAILED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='FAILED',
      PROPERTY=MEASURE,  $
    FIELDNAME=OUT_ORDER, ALIAS=OUT_ORDER, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='OUT_ORDER',
      PROPERTY=MEASURE,  $
    FIELDNAME=NOT_DISPATCHED, ALIAS=NOT_DISPATCHED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NOT_DISPATCHED',
      PROPERTY=MEASURE,  $
    FIELDNAME=CANCELLED, ALIAS=CANCELLED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='CANCELLED',
      PROPERTY=MEASURE,  $
    FIELDNAME=NO_SHOW, ALIAS=NO_SHOW, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NO_SHOW',
      PROPERTY=MEASURE,  $
    FIELDNAME=NO_RESULTS, ALIAS=NO_RESULTS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NO_RESULTS',
      PROPERTY=MEASURE,  $
    FIELDNAME=WAIT_WKS, ALIAS=WAIT_WKS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='WAIT_WKS',
      PROPERTY=MEASURE,  $
    FIELDNAME=WAITWKS2, ALIAS=WAITWKS2, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='WAITWKS2',
      PROPERTY=MEASURE,  $
    FIELDNAME=BACKLOG, ALIAS=BACKLOG, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='BACKLOG',
      PROPERTY=MEASURE,  $
    FIELDNAME=PASS_PCT, ALIAS=PASS_PCT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='PASS_PCT',
      PROPERTY=MEASURE,  $
    FIELDNAME=FAIL_PCT, ALIAS=FAIL_PCT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='FAIL_PCT',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_ALLOC, ALIAS=EXR_ALLOC, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_ALLOC',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_BOOKED, ALIAS=EXR_BOOKED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_BOOKED',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_AVAIL, ALIAS=EXR_AVAIL, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_AVAIL',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_AVAIL_PCT, ALIAS=EXR_AVAIL_PCT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_AVAIL_PCT',
      PROPERTY=MEASURE,  $
    FIELDNAME=RESERVEDME, ALIAS=ReservedME, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='ReservedME',
      PROPERTY=MEASURE,  $
    FIELDNAME=NO_RESULT, ALIAS=NO_RESULT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NO_RESULT',
      PROPERTY=MEASURE,  $
    FIELDNAME=OWAITWKS, ALIAS=OWAITWKS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='OWAITWKS',
      PROPERTY=MEASURE,  $


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 26 | Registered: October 27, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Any chance of comparing the two versions of the Masters?


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
Rodney Chan
Member
posted Hide Post
You betcha Francis Smiler

I do notice that a few lines are different such as instead of A8 its A10 now for example

 FILENAME=DRVXM, SUFFIX=ESSBASE , $
  SEGMENT=DRVXM, SEGTYPE=S0, $
$  DIMENSION: TotalYear
 DIMENSION=TotalYear, CAPTION='TotalYear', $
  HIERARCHY=TotalYear, CAPTION='TotalYear Levels', HRY_DIMENSION=TotalYear, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=TOTALYEAR, ALIAS='Gen1,TotalYear', USAGE=A10, ACTUAL=A10,
      WITHIN='*TotalYear',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_TOTALYEAR, ALIAS='Gen2,TotalYear', USAGE=A10, ACTUAL=A10,
      WITHIN=TOTALYEAR,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_TOTALYEAR, ALIAS='Gen3,TotalYear', USAGE=A14, ACTUAL=A14,
      WITHIN=GEN2_TOTALYEAR,
      PROPERTY=UID,  $
    FIELDNAME=GEN4_TOTALYEAR, ALIAS='Gen4,TotalYear', USAGE=A6, ACTUAL=A6,
      WITHIN=GEN3_TOTALYEAR,
      PROPERTY=UID,  $
  HIERARCHY=TotalYear2, CAPTION='TotalYear Parent-Child', HRY_DIMENSION=TotalYear, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=TOTALYEAR_MEMBER, ALIAS=TotalYear, USAGE=A14, ACTUAL=A14,
      WITHIN='*TotalYear2',
      PROPERTY=UID,  $
    FIELDNAME=TOTALYEAR_CAPTION, USAGE=A10, ACTUAL=A10,
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=TOTALYEAR_PARENT, USAGE=A14, ACTUAL=A14,
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=TOTALYEAR_PARENTCAP, USAGE=A10, ACTUAL=A10,
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=TOTALYEAR_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='TotalYear_LVLNO LEVEL_NUMBER',
      REFERENCE=TOTALYEAR_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: CalendarYear
 DIMENSION=CalendarYear, CAPTION='CalendarYear', $
  HIERARCHY=CalendarYear, CAPTION='CalendarYear Levels', HRY_DIMENSION=CalendarYear, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=CALENDARYEAR, ALIAS='Gen1,CalendarYear', USAGE=A13, ACTUAL=A13,
      WITHIN='*CalendarYear',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_CALENDARYEAR, ALIAS='Gen2,CalendarYear', USAGE=A4, ACTUAL=A4,
      WITHIN=CALENDARYEAR,
      PROPERTY=UID,  $
  HIERARCHY=CalendarYear2, CAPTION='CalendarYear Parent-Child', HRY_DIMENSION=CalendarYear, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=CALENDARYEAR_MEMBER, ALIAS=CalendarYear, USAGE=A12, ACTUAL=A12,
      WITHIN='*CalendarYear2',
      PROPERTY=UID,  $
    FIELDNAME=CALENDARYEAR_CAPTION, USAGE=A13, ACTUAL=A13,
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=CALENDARYEAR_PARENT, USAGE=A12, ACTUAL=A12,
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=CALENDARYEAR_PARENTCAP, USAGE=A13, ACTUAL=A13,
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=CALENDARYEAR_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='CalendarYear_LVLNO LEVEL_NUMBER',
      REFERENCE=CALENDARYEAR_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: Location
 DIMENSION=Location, CAPTION='Location', $
  HIERARCHY=Location, CAPTION='Location Levels', HRY_DIMENSION=Location, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=LOCATION, ALIAS='Gen1,Location', USAGE=A8, ACTUAL=A8,
      WITHIN='*Location',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_LOCATION, ALIAS='Gen2,Location', USAGE=A8, ACTUAL=A8,
      WITHIN=LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_LOCATION, ALIAS='Gen3,Location', USAGE=A24, ACTUAL=A24,
      WITHIN=GEN2_LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN4_LOCATION, ALIAS='Gen4,Location', USAGE=A30, ACTUAL=A30,
      WITHIN=GEN3_LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN5_LOCATION, ALIAS='Gen5,Location', USAGE=A38, ACTUAL=A38,
      WITHIN=GEN4_LOCATION,
      PROPERTY=UID,  $
    FIELDNAME=GEN6_LOCATION, ALIAS='Gen6,Location', USAGE=A35, ACTUAL=A35,
      WITHIN=GEN5_LOCATION,
      PROPERTY=UID,  $
  HIERARCHY=Location2, CAPTION='Location Parent-Child', HRY_DIMENSION=Location, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=LOCATION_MEMBER, ALIAS=Location, USAGE=A8, ACTUAL=A8,
      WITHIN='*Location2',
      PROPERTY=UID,  $
    FIELDNAME=LOCATION_CAPTION, USAGE=A38, ACTUAL=A38,
      REFERENCE=LOCATION_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=LOCATION_PARENT, USAGE=A8, ACTUAL=A8,
      REFERENCE=LOCATION_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=LOCATION_PARENTCAP, USAGE=A38, ACTUAL=A38,
      REFERENCE=LOCATION_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=LOCATION_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='Location_LVLNO LEVEL_NUMBER',
      REFERENCE=LOCATION_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: LicenceClass
 DIMENSION=LicenceClass, CAPTION='LicenceClass', $
  HIERARCHY=LicenceClass, CAPTION='LicenceClass Levels', HRY_DIMENSION=LicenceClass, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=LICENCECLASS, ALIAS='Gen1,LicenceClass', USAGE=A12, ACTUAL=A12,
      WITHIN='*LicenceClass',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_LICENCECLASS, ALIAS='Gen2,LicenceClass', USAGE=A19, ACTUAL=A19,
      WITHIN=LICENCECLASS,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_LICENCECLASS, ALIAS='Gen3,LicenceClass', USAGE=A8, ACTUAL=A8,
      WITHIN=GEN2_LICENCECLASS,
      PROPERTY=UID,  $
    FIELDNAME=GEN4_LICENCECLASS, ALIAS='Gen4,LicenceClass', USAGE=A2, ACTUAL=A2,
      WITHIN=GEN3_LICENCECLASS,
      PROPERTY=UID,  $
  HIERARCHY=LicenceClass2, CAPTION='LicenceClass Parent-Child', HRY_DIMENSION=LicenceClass, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=LICENCECLASS_MEMBER, ALIAS=LicenceClass, USAGE=A12, ACTUAL=A12,
      WITHIN='*LicenceClass2',
      PROPERTY=UID,  $
    FIELDNAME=LICENCECLASS_CAPTION, USAGE=A19, ACTUAL=A19,
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=LICENCECLASS_PARENT, USAGE=A12, ACTUAL=A12,
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=LICENCECLASS_PARENTCAP, USAGE=A19, ACTUAL=A19,
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=LICENCECLASS_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='LicenceClass_LVLNO LEVEL_NUMBER',
      REFERENCE=LICENCECLASS_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: OOReasons
 DIMENSION=OOReasons, CAPTION='OOReasons', $
  HIERARCHY=OOReasons, CAPTION='OOReasons Levels', HRY_DIMENSION=OOReasons, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=OOREASONS, ALIAS='Gen1,OOReasons', USAGE=A9, ACTUAL=A9,
      WITHIN='*OOReasons',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_OOREASONS, ALIAS='Gen2,OOReasons', USAGE=A17, ACTUAL=A17,
      WITHIN=OOREASONS,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_OOREASONS, ALIAS='Gen3,OOReasons', USAGE=A41, ACTUAL=A41,
      WITHIN=GEN2_OOREASONS,
      PROPERTY=UID,  $
  HIERARCHY=OOReasons2, CAPTION='OOReasons Parent-Child', HRY_DIMENSION=OOReasons, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=OOREASONS_MEMBER, ALIAS=OOReasons, USAGE=A9, ACTUAL=A9,
      WITHIN='*OOReasons2',
      PROPERTY=UID,  $
    FIELDNAME=OOREASONS_CAPTION, USAGE=A41, ACTUAL=A41,
      REFERENCE=OOREASONS_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=OOREASONS_PARENT, USAGE=A9, ACTUAL=A9,
      REFERENCE=OOREASONS_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=OOREASONS_PARENTCAP, USAGE=A41, ACTUAL=A41,
      REFERENCE=OOREASONS_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=OOREASONS_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='OOReasons_LVLNO LEVEL_NUMBER',
      REFERENCE=OOREASONS_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: Examiners
 DIMENSION=Examiners, CAPTION='Examiners', $
  HIERARCHY=Examiners, CAPTION='Examiners Levels', HRY_DIMENSION=Examiners, HRY_STRUCTURE=STANDARD, $
    FIELDNAME=EXAMINERS, ALIAS='Gen1,Examiners', USAGE=A9, ACTUAL=A9,
      WITHIN='*Examiners',
      PROPERTY=UID,  $
    FIELDNAME=GEN2_EXAMINERS, ALIAS='Gen2,Examiners', USAGE=A10, ACTUAL=A10,
      WITHIN=EXAMINERS,
      PROPERTY=UID,  $
    FIELDNAME=GEN3_EXAMINERS, ALIAS='Gen3,Examiners', USAGE=A7, ACTUAL=A7,
      WITHIN=GEN2_EXAMINERS,
      PROPERTY=UID,  $
  HIERARCHY=Examiners2, CAPTION='Examiners Parent-Child', HRY_DIMENSION=Examiners, HRY_STRUCTURE=RECURSIVE, $
    FIELDNAME=EXAMINERS_MEMBER, ALIAS=Examiners, USAGE=A10, ACTUAL=A10,
      WITHIN='*Examiners2',
      PROPERTY=UID,  $
    FIELDNAME=EXAMINERS_CAPTION, USAGE=A10, ACTUAL=A10,
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=CAPTION,  $
    FIELDNAME=EXAMINERS_PARENT, USAGE=A10, ACTUAL=A10,
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=PARENT_OF,  $
    FIELDNAME=EXAMINERS_PARENTCAP, USAGE=A10, ACTUAL=A10,
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=CAP_PARENT,  $
    FIELDNAME=EXAMINERS_LVLNO, USAGE=I2L, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(INTERNAL),
      TITLE='Examiners_LVLNO LEVEL_NUMBER',
      REFERENCE=EXAMINERS_MEMBER, PROPERTY=LEVEL_NUMBER,  $
$  DIMENSION: Measur1
  SEGMENT=MEASUR1, SEGTYPE=U, PARENT=DRVXM, $
    FIELDNAME=TESTS, ALIAS=TESTS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='TESTS',
      PROPERTY=MEASURE,  $
    FIELDNAME=DISPATCHED, ALIAS=DISPATCHED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='DISPATCHED',
      PROPERTY=MEASURE,  $
    FIELDNAME=CONDUCTED, ALIAS=CONDUCTED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='CONDUCTED',
      PROPERTY=MEASURE,  $
    FIELDNAME=PASSED, ALIAS=PASSED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='PASSED',
      PROPERTY=MEASURE,  $
    FIELDNAME=FAILED, ALIAS=FAILED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='FAILED',
      PROPERTY=MEASURE,  $
    FIELDNAME=OUT_ORDER, ALIAS=OUT_ORDER, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='OUT_ORDER',
      PROPERTY=MEASURE,  $
    FIELDNAME=NOT_DISPATCHED, ALIAS=NOT_DISPATCHED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NOT_DISPATCHED',
      PROPERTY=MEASURE,  $
    FIELDNAME=CANCELLED, ALIAS=CANCELLED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='CANCELLED',
      PROPERTY=MEASURE,  $
    FIELDNAME=NO_SHOW, ALIAS=NO_SHOW, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NO_SHOW',
      PROPERTY=MEASURE,  $
    FIELDNAME=NO_RESULT, ALIAS=NO_RESULT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='NO_RESULT',
      PROPERTY=MEASURE,  $
    FIELDNAME=WAIT_WKS, ALIAS=WAIT_WKS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='WAIT_WKS',
      PROPERTY=MEASURE,  $
    FIELDNAME=WAITWKS2, ALIAS=WAITWKS2, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='WAITWKS2',
      PROPERTY=MEASURE,  $
    FIELDNAME=BACKLOG, ALIAS=BACKLOG, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='BACKLOG',
      PROPERTY=MEASURE,  $
    FIELDNAME=PASS_PCT, ALIAS=PASS_PCT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='PASS_PCT',
      PROPERTY=MEASURE,  $
    FIELDNAME=FAIL_PCT, ALIAS=FAIL_PCT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='FAIL_PCT',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_ALLOC, ALIAS=EXR_ALLOC, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_ALLOC',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_BOOKED, ALIAS=EXR_BOOKED, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_BOOKED',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_AVAIL, ALIAS=EXR_AVAIL, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_AVAIL',
      PROPERTY=MEASURE,  $
    FIELDNAME=EXR_AVAIL_PCT, ALIAS=EXR_AVAIL_PCT, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='EXR_AVAIL_PCT',
      PROPERTY=MEASURE,  $
    FIELDNAME=RESERVEDME, ALIAS=ReservedME, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='ReservedME',
      PROPERTY=MEASURE,  $
    FIELDNAME=OWAITWKS, ALIAS=OWAITWKS, USAGE=D20.2, ACTUAL=D8,
      MISSING=ON,
      TITLE='OWAITWKS',
      PROPERTY=MEASURE,  $


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 26 | Registered: October 27, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
A8 instead A10, hmmmm.

How about the ACX files - do they look the same?

Are you using the same (or the correct) version of the data adapter?


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
Rodney Chan
Member
posted Hide Post
V 7.66 ACX file

 SEGNAME=DRVXM, SERVER=DRVXMcube, DBNAME=DRVXM, APPLNAME=DRVXM, $
 TIMEDIM=TOTALYEAR, $
 MEASURE=Measures, $
  MEMBER=WAIT_WKS, AGGREGATE=NO, $
  MEMBER=WAITWKS2, AGGREGATE=NO, $
  MEMBER=BACKLOG, AGGREGATE=NO, $
  MEMBER=PASS_PCT, AGGREGATE=NO, $
  MEMBER=FAIL_PCT, AGGREGATE=NO, $
  MEMBER=EXR_ALLOC, AGGREGATE=NO, $
  MEMBER=EXR_BOOKED, AGGREGATE=NO, $
  MEMBER=EXR_AVAIL, AGGREGATE=NO, $
  MEMBER=EXR_AVAIL_PCT, AGGREGATE=NO, $
  MEMBER=ReservedME, AGGREGATE=NO, $


V 7.7

 SEGNAME=DRVXM, SERVER=localhost, DBNAME=DRVXM, APPLNAME=DRVXMT2, $
 TIMEDIM=TOTALYEAR, $
 MEASURE=Measures, $
  MEMBER=MEASUR1.WAIT_WKS, AGGREGATE=NO, $
  MEMBER=MEASUR1.WAITWKS2, AGGREGATE=NO, $
  MEMBER=MEASUR1.BACKLOG, AGGREGATE=NO, $
  MEMBER=MEASUR1.PASS_PCT, AGGREGATE=NO, $
  MEMBER=MEASUR1.FAIL_PCT, AGGREGATE=NO, $
  MEMBER=MEASUR1.EXR_ALLOC, AGGREGATE=NO, $
  MEMBER=MEASUR1.EXR_BOOKED, AGGREGATE=NO, $
  MEMBER=MEASUR1.EXR_AVAIL, AGGREGATE=NO, $
  MEMBER=MEASUR1.EXR_AVAIL_PCT, AGGREGATE=NO, $
  MEMBER=MEASUR1.RESERVEDME, AGGREGATE=NO, $


Not a huge diff either, and no DUMMY reference either....

I had to ask our admin but he said that he is using the data adapater that was supplied by IBI (i am guessing stock) for 7.7....


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 26 | Registered: October 27, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
quote:
SEGNAME=DRVXM, SERVER=localhost, DBNAME=DRVXM, APPLNAME=DRVXMT2,

Does localhost and applname not ring any alarm bells?


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error - (FOC1022) INVALID DUMMY KEY DESCRIPTION IN MASTER FILE

Copyright © 1996-2020 Information Builders