July 09, 2007, 04:29 PM
JeevaWebFOCUS 762 join problem
We recently upgraded WebFOCUS 711 to 762. Some of the reports no longer work. I get 0 records or empty report if I have a join between WebFOCUS hold table and Oracle table. Anybody else have join problems with 762? Any help to fix this problem would be appreciated.
Thanks,
Jeeva
July 09, 2007, 04:50 PM
LeahNot that particular issue, had some issues with IE and drop down selection in BID.
July 10, 2007, 07:43 AM
hammo1jTry mucking around with settings of ORACHAR
(FOC1450) CURRENT ORACLE INTERFACE SETTINGS ARE :
(FOC1656) DEFAULT SERVER NAME - : WF_IFS
(FOC1502) USERID AND PASSWORD ARE - :
(FOC1496) AUTODISCONNECT OPTION IS - : ON FIN
(FOC1499) AUTOCOMMIT OPTION IS - : ON COMMAND
(FOC1491) FETCH BUFFERING FACTOR - : 5000
(FOC1531) INSERT BUFFERING FACTOR - : 500
------------------------- THIS ONE NEEDS TO BE VAR
(FOC1652) CHARACTER TYPE FOR INSERT OR UPDATE - : VAR
(FOC1653) CONVERSION STYLE FOR ORACLE NUMBERS - : COMPAT
(FOC1654) ORACLE HOME - : Not set
(FOC1655) ORACLE SID - : Not set
(FOC1441) WRITE FUNCTIONALITY IS - : ON
(FOC1445) OPTIMIZATION OPTION IS - : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS - : ON
(FOC1484) SQL ERROR MESSAGE TYPE IS - : DBMS
(FOC1552) INTERFACE DEFAULT DATE TYPE - : NEW
(FOC1446) DEFAULT DBSPACE IS - :
July 10, 2007, 08:13 AM
linusCheck the formats of the fields you're joining on, I would bet the fields from one of the tables, probably the hold file, are in AnV and some are straight An. Add 'FORMAT ALPHA' to you ON TABLE HOLD statement when creating the hold file.