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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] FOC 0003
 Login/Join
 
Mayank Agrawal
Member
posted
Hi, We have upgraded our webfocus server from 7.6.11 to 7.7.03.
We were having logic of sorting working in earlier version but now its giving error FOC0003.
Field Name Not Recognized.
Please suggest some solution.
Thanks in advance.
Regrads
Mayank

This message has been edited. Last edited by: Kerry,
 
Posts: 28 | Registered: April 11, 2011Report This Post
Prarie
Virtuoso
posted Hide Post
will you please post the code so we can see what's going on.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Waz
Expert
posted Hide Post
Also please post the master files as well.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Check whether all the Field names in the TABLE FILE request is present in the MFD.

Try to put a 
 TABLE FILE NAME
PRINT
*
END
-EXIT

also generate any error...

Else, If it's FILEDEF stuff, check the defenition one more time.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
ABT
Master
posted Hide Post
Is the APP PATH set?


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
MAdams1
Guru
posted Hide Post
We upgraded to 7.7.03 and had several issues one being with IF THEN ELSE statements in defines. Looks like IBI cracked down and now requires the ELSE clause, before we could get away without it. As soon as we changed this our fex's worked again. You might check that.


WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
 
Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
FOC0003.
Field Name Not Recognized.

This got resolved on changing IF THEN ELSE in DEFFINE clause.. Strange !


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
But my question once again is, Why the Backward compatiblity is not maintained in new Releases of WebFOCUS... The code what we have written in old version, without any changes should work on the latest version. The issues that arise can either be environmental or Configuration stuff. But why we need to debug and do code changes, on every Upgrade ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Waz
Expert
posted Hide Post
There are aways code tighening happening.

Did your define not have a semi-colon at the end, and the next line was the END statement or something line that ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
quote:
There are aways code tighening happening.


Yeah.. But, this should not be the case often. Code level issues, should not happen between various versions of the same tool. A general myth.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Waz
Expert
posted Hide Post
What was the change that you did to stop the error ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Enigma006
Master
posted Hide Post
Hi

I am getting FOC0003 saying field not found when trying to export AHTML report.
And it shows the "Title" of the field as not recognized.
If I directly run the fex, I dont have a problem but if I run from HTML page I get this error.
Any clues?

I am using double list box to send the fields into table request.

thank you..


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Hi Enigma,

This again happens after the upgrade or in the current constant version?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Tony A
Expert
posted Hide Post
quote:
The code what we have written in old version, without any changes should work on the latest version.


If you code as per documented syntax then your code should be OK. It's when (as Michelle mentioned "... before we could get away without it") coded syntax does not follow that which is documented where many people are caught out. It's happened for many years and is not new.

You'll have noticed that Francis is single minded in his determination to ensure he follows and understands the latest, documented, syntax rules. I am sure that it's an example we could all follow.

Safest way is to code correctly, then when you hit a problem (it will happen and WF is not the only language in which this occurs) you can normally assume that it's a bug (but not always Wink.

One of the main reasons for GUIs is that the syntax is controlled - that doesn't help old coders such as myself though Frowner

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Hi Tony,

Thank you for the explanatory reply.

I agree with your point, to follow exact synatx rules. Still, It is painful to debug and do changes the application that worked perfect before the upgarde. If not more on the FEX side, but Esp. on the HTML composer side.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
quote:
assume that it's a bug (but not always


A Myth again.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
MAdams1
Guru
posted Hide Post
I agree to an extent. I don't understand why IBI would change something like a style. Don't know if many of you noticed or even used it but they changed the endflt.sty in the 7.7.03 upgrade. It messed up the output on several of my reports, that use to look nice. So, I made my own and quit using any of their styles. Lesson learned, but if everyone is doing this, why bother having any IBI styles at all.


WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
 
Posts: 272 | Location: Kalamazoo, Michigan | Registered: September 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
This happened couple of time with ibirls JS also.

Mainly, most of the issues that I have faced on the course of upgrade arouse on the HTML part more than Reports. Anyways, HTML is something that we generate using composer all time, and not hand written code.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders