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
Error: FOC1133
 Login/Join
 
Member
posted
(FOC1133) INTERNAL ERROR IN DATA CONVERSION ROUTINES


I keep getting this message. I have never seen it before, and cannot find anything wrong with my code. None of the error message manuals give any further information about what this message means.

Can anyone offer any insight into this message? Anyone with similar issues?

Thanks
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Report This Post
Expert
posted Hide Post
Crystal, we need to know your configuration. Can you edit your profile, and say your platform and version? thanks.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Member
posted Hide Post
I thought that info was there. I see it in the profile. Anyway, version 533, win2k, dev studio.
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Report This Post
Member
posted Hide Post
Anyone, anyone?
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Report This Post
Virtuoso
posted Hide Post
If you will go here, log in and do a search on Foc(1133) you will get several possible reasons
and solutions. Good Luck.
http://techsupport.informationbuilders.com/tech/search.html


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Member
posted Hide Post
No luck with that. The only possiblity I found is the actual and usage types in my mfd have to match. I checked and they do match in both masters.

Any other suggestions?
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Report This Post
Guru
posted Hide Post
What type of data are you reading? flat file, rdbms, etc?

Is there more detail with the error message?

What does your procedure do?


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
Member
posted Hide Post
I have two hold files that I'm trying to join. That's where the message seems to happen. There is nothing special about these files, just regular hold files.

The fields that I am joining on are of the same data type and have same usage and actual in the mfd.

There is no other detail to the message. I can't even find further detail in any of the error documents.
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Report This Post
Guru
posted Hide Post
Are both your files sorted by the join to field?

Try putting the join to file in a hold format focus index joinfield....and see if that helps.



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
Crystal,

Posting your hold master files along with your JOIN statement might help us help you?

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
Member
posted Hide Post
Thanks for all of the suggestions, but they didn't work out. It looks like I have figured out where the problem is coming from, just not why its happening.

I was wrong about the message being on the joins. The message was appearing after trying to TABLE FILE a particular hold file. I went every field and found that it was a particular date field that was causing the problem. Once I took that field out, it ran fine. Lucky for me, I didn't need that particular field for my report.

I still have no idea why its happening, but I've moved on. Lots to do and I can't spend anymore time on that. But, I can tell you that I have used that same date field in other programs successfully. And that I held that field 3 times before getting to the point where I got the message. It almost seems like another WF quirk to me.

What gets me is the lack of an explanation in any of the documentation for what that error is supposed to mean.

I appreciate the help and suggestions from everyone.
 
Posts: 23 | Location: North Carolina | Registered: August 09, 2005Report This Post
Member
posted Hide Post
I ran into almost the exact same problem. After doing a "format alpha" on my hold file, I went into the MFD and changed the datetime format to an alpha format and WF was happy w/ that. That was my fix ... it may work for others.
Ex. before: FIELDNAME =WHATEVER ,E44 ,HYYMDm ,A20 ,$

after: FIELDNAME =WHATEVER ,E44 ,A20 ,A20 ,$
 
Posts: 16 | Registered: November 17, 2005Report This Post
Platinum Member
posted Hide Post
The FOC1133 is based on DATA. Typically the FOC1133 error would indicate that there is a problem with the way a particular field or column is being described in the Master File Description.
The error could also indicate that a FOCUS function has an incorrect argument in it, or that is is related to the new MASTER Parser (SET MASTER=NEW/OLD).
If you are only getting an occassional FOC1133, and there are not a lot (1 for each record in your file), then it probably is something that is not valid. For instance, a date field that does not contain a valid date.
Hope this helps,
Rich


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012
 
Posts: 173 | Registered: November 16, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders