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     [CLOSED] prblem after upgrading version 767 to 7611

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] prblem after upgrading version 767 to 7611
 Login/Join
 
Gold member
posted
Hi All,
Recently we upgraded webfocus server version 767 to 7611 after that we are facing problem in one report, Please find below for the error message.
0 NUMBER OF RECORDS IN TABLE= 248 LINES= 248
Invalid root page
Invalid root page
Invalid root page
Invalid root page
Invalid root page
Invalid root page
Invalid root page
Invalid root page
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
-HTMLFORM VIN_PSR_RECEIPTS_HEADER
(FOC36225) UNABLE TO OPEN FILE VINPSR SPECIFIED BY WEBFOCUS TABLE

Could you please let me know what could be the issue.

Thanks,
Raghu

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


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
 
Posts: 56 | Registered: February 04, 2010Report This Post
Virtuoso
posted Hide Post
From past posts in this forum regarding the 'Invalid root page' error, possible causes are:

  • use of an index name longer than 12 characters with ON TABLE HOLD FORMAT FOCUS INDEX
  • JOINs between fields that are not the same length or have different formats
  • JOINs between fields that have the same length but one is fixed length and the other variable length

Unfortuntely, even if the cause is one of the above, this does not explain why the report worked in 767 but now fails in 7611. Have changes been made to the report code since the upgrade?


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Gold member
posted Hide Post
Hi Dan,
We haven't made any changes for the code .

Thanks,
Raghu


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
 
Posts: 56 | Registered: February 04, 2010Report This Post
Expert
posted Hide Post
I am assuming this is a FOCUS file. Try doing a REBUILD on the file making sure to back it up first. If that doesn't fix it, then possibly the file was corrupted somehow. Do you have a backup? Do you still have 7.6.7?


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
Gold member
posted Hide Post
quote:
this is a FOCUS file. Try doing a REBUILD on

Hi Ginny,
we haven't upgrade our local server ...In the local server is working fine ,but in the other environments(which are upgraded to 7.6.11) is not working.

Thanks,
Raghu


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
 
Posts: 56 | Registered: February 04, 2010Report This Post
Expert
posted Hide Post
Is it possible the environment where 7.6.11 is running on a different version of Windows? 64 bit perhaps? Which may be causing a problem reading a FOCUS DB, if it is a FOCUS DB?

Did you regenerate the meta-data or just copy it from one environment to the other? I would regenerate...


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
Gold member
posted Hide Post
Hi,
You may want to rebuild the FOCUS DBs manually using a combination of TABLE, TABLEF and TABLE through a physical view. For example, in an ABC structure, one over the other, you can use TABLE FILE X.C, dump the data into a HOLD file and load a fresh copy of the DB. This would use the "UP" pointers instead of the page and down pointers.
I would use this technique in the 7.6.7 version, if still available, and transport the data to the 7.6.11 version.

If this does not fix the problem, then you must go into debug mode and start eliminating features until the problem is gone. The last eliminated feature may be the culpret.
Hope this helps!
Nick


WebFOCUS 7.7.03 & 8.0.7
Windows
HTML, Excel, PDF, etc.
Also, using Maintain, etc.
 
Posts: 83 | Registered: February 26, 2009Report This Post
Master
posted Hide Post
Have we determined that this is a FOCUS DB (type .FOC)? In the program that is having a problem are you reading the file by an index? (TABLE FILE VIN_PSR_RECEIPTS_HEADER.FIELDNAME) If it is try removing the index from the table command. Otherwise, please post your master and your code.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Gold member
posted Hide Post
Hi ,
We are not using FOCUS DB.
We identified there is some join problem so we tried to put indexing but still we are getting invalid root page error.
please find below for code.
TABLE FILE CURRENCY_EXCHANGE_HOLD
PRINT CURRENCY_CODE
YEAR
EXCHANGE_RATE
ON TABLE HOLD AS CURR_EXCH FORMAT FOCUS INDEX YEAR
END
SQL
SELECT MIN(RD.COMGRP_GROUP_CODE) AS COMGRP_GROUP_CODE,
MIN(RD.COMGRP_DESC) AS COMGRP_DESC,
MIN(RD.COMMODITY_CODE) AS COMMODITY_CODE,
MIN(RD.COMMODITY_NAME) AS COMMODITY_NAME,
MIN(RD.REGION_CODE) AS REGION_CODE,
MIN(RD.REGION_NAME) AS REGION_NAME,
MIN(RD.PRODUCTLINE_CODE) AS PRODUCTLINE_CODE,
MIN(RD.PRODUCTLINE_DESC) AS PRODUCTLINE_DESC,
RD.PLANT_CODE,
MIN(RD.PLANT_NAME) AS PLANT_NAME,
RD.MST_CODE,
MIN(RD.SUPPLIER_NAME) AS SUPPLIER_NAME,
RD.RLDC_PART_NUMBER,
MIN(RD.PART_DESC) AS PART_DESC,
SUM(CEH1.EXCHANGE_RATE * RD.SPND * (1/CEH2.EXCHANGE_RATE)) AS SPND,
SUM(RD.QTY) AS QTY
FROM RECEIPTS_DTL RD,
CURR_EXCH CEH1,
CURR_EXCH CEH2
WHERE
RD.YR = CEH1.YEAR
AND
CEH1.CURRENCY_CODE = 'USD'
AND RD.YR = CEH2.YEAR
AND RD.RLDC_CUR_CODE = CEH2.CURRENCY_CODE
GROUP BY RD.MST_CODE,
RD.RLDC_PART_NUMBER,
RD.PLANT_CODE;
TABLE ON TABLE HOLD AS HLD_PSR
END
TABLE FILE HLD_PSR
PRINT *
END
-EXIT
0 TRANSACTIONS: TOTAL = 1 ACCEPTED= 1 REJECTED= 0
SEGMENTS: INPUT = 1 UPDATED = 0 DELETED = 0
0 NUMBER OF RECORDS IN TABLE= 248 LINES= 248
0 NUMBER OF RECORDS IN TABLE= 248 LINES= 248
Invalid root page
Invalid root page
Invalid root page
Invalid root page

We have n't put indexing on EXCHANGE_RATE,CURRENCY_CODE columns.
because it is not supporting more than 12 characters.

Thanks,
Raghu


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
 
Posts: 56 | Registered: February 04, 2010Report This Post
Virtuoso
posted Hide Post
I would try to eliminate the double join to your FOCUS hold file by using a multi-verb request to calculate the exchange rate factor for your SPND conversion. You can use a DEFINE to shorten the CURRENCY_CODE field name so you can INDEX the field.

DEFINE FILE CURRENCY_EXCHANGE_HOLD
 USD_RATE/D??.???? = IF CURRENCY_CODE EQ 'USD' THEN EXCHANGE_RATE ELSE 0 ;
 CUR_CODE/A3       = CURRENCY_CODE ;
END
-*
TABLE FILE CURRENCY_EXCHANGE_HOLD
 SUM MAX.USD_RATE NOPRINT
 BY YEAR
 PRINT EXCHANGE_RATE NOPRINT
 COMPUTE FACTOR/D??.???? = C1 * ( 1 / EXCHANGE_RATE );
 BY YEAR
 BY CUR_CODE
 ON TABLE HOLD AS CURR_EXCH FORMAT FOCUS INDEX YEAR CUR_CODE
END
-*
SQL
SELECT MIN(RD.COMGRP_GROUP_CODE) AS COMGRP_GROUP_CODE,
       MIN(RD.COMGRP_DESC) AS COMGRP_DESC,
       MIN(RD.COMMODITY_CODE) AS COMMODITY_CODE,
       MIN(RD.COMMODITY_NAME) AS COMMODITY_NAME,
       MIN(RD.REGION_CODE) AS REGION_CODE,
       MIN(RD.REGION_NAME) AS REGION_NAME,
       MIN(RD.PRODUCTLINE_CODE) AS PRODUCTLINE_CODE,
       MIN(RD.PRODUCTLINE_DESC) AS PRODUCTLINE_DESC,
       RD.PLANT_CODE,
       MIN(RD.PLANT_NAME) AS PLANT_NAME,
       RD.MST_CODE,
       MIN(RD.SUPPLIER_NAME) AS SUPPLIER_NAME,
       RD.RLDC_PART_NUMBER,
       MIN(RD.PART_DESC) AS PART_DESC,
       SUM(RD.SPND * CEH.FACTOR) AS SPND,
       SUM(RD.QTY) AS QTY
 FROM RECEIPTS_DTL RD,
      CURR_EXCH CEH,
 WHERE RD.YR = CEH.YEAR
   AND RD.RLDC_CUR_CODE = CEH.CUR_CODE
 GROUP BY RD.MST_CODE,
       RD.RLDC_PART_NUMBER,
       RD.PLANT_CODE;
TABLE ON TABLE HOLD AS HLD_PSR
END
-*
TABLE FILE HLD_PSR
 PRINT *
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Gold member
posted Hide Post
Hi,
Still I am getting the same error.

Thanks,
Raghu


WebFOCUS 7.6.7
Windows
Excel, PDF, HTML
 
Posts: 56 | Registered: February 04, 2010Report This Post
Virtuoso
posted Hide Post
Check that RECEIPTS_DTL.YR and CURR_EXCH.YEAR have the same format and length, and that RECEIPTS_DTL.CUR_CODE and CURR_EXCH.CUR_CODE do, also. You might also turn on the SQL trace facility to see how the WebFOCUS translator is handling the request. The trace might provide a clue as to where the problem lies. As a last resort, I think you have two options:

1. Hold your temporary file, CURR_EXCH, as a database table (ON TABLE HOLD AS CURR_EXCH FORMAT SQLORA/SQLMSS/SQLODBC/DB2/etc.) so it can be joined directly to table RECEIPTS_DTL as a relational table.
2. Split the data extract from the join - because the join to CURR_EXCH isn't necessary for record selection. Bring back the necessary data from the relational database and hold it. Then JOIN or MATCH the two hold files to produce your final output.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report 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     [CLOSED] prblem after upgrading version 767 to 7611

Copyright © 1996-2020 Information Builders