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
REBUILD in Focexec
 Login/Join
 
Carol Dobson
Guru
posted
I'm trying to run a simple REBUILD in a Focexec in Dev Studio.

The kicker is, I can cut/paste the code into the CONSOLE and it REBUILDS the file just fine.

Has anyone put REBUILDS into a focexec?

Here's the code.....

REBUILD
REBUILD
D:\ibi\apps\charondev\charondeal.foc
NO

Perhaps it's a bug in 5.2.4?

Thanks in advance!
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
susannah
Expert
posted Hide Post
Hi Carol, here's some rebuild reorg code that works
USE
D:\IBI\....\EKGHST03.FOC
END
-RUN
REBUILD
REORG
DUMP
EKGHST03
NO
CMD ERASE D:\IBI\....\EKGHST03.FOC
REBUILD
REORG
LOAD
EKGHST03
-RUN
REBUILD
CHECK
EKGHST03
-RUN
CMD NET SEND GR48ET007 done some relevant message here
---
and some rebuild reindex
USE
D:\IBI\....\EKGHST03.FOC
END
-RUN
REBUILD
INDEX
EKGHST03 -- thats the filename
KEYUR -- thats the indexfield name
-RUN
? FILE EKGHST03
CMD NET SEND GR48ET007 done some other message here
---
and some rebuild check
USE
D:\IBI\....\EKGHST03.FOC
END
-RUN
REBUILD
CHECK
EKGHST03 -- thats the filename

.... that's all i know...maybe it can help.
the biggest difference that i see is that i name only the filename, not the full unc.
i've issued a USE beforehand.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
Hi Susannah,
I finally got it to work with your suggestions and I had to change all my code to uppercase!

Thanks a million!
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Dennis_V
Gold member
posted Hide Post
Here's one more twist to this. What if you have to update an MFD with field changes or new fields and update the db structure to reflect the changes? The process is to REBUILD/DUMP the data from the old structure, create an empty DB using the new structure, then load the dumped out data into it.

Here's some code I have that does just that:

-* Step 1: Dump out the data from the old database format
REBUILD
REORG
DUMP
<MYOLDDB>
NO
-RUN
-* Step 2: Copy the new master over the old master
-DOS COPY e:\ibi\apps\<myfolder\<newmfd>.mas e:\ibi\apps\<myfolder>\<oldmfd>.mas
-RUN
-* Step 3: Delete the old database
-DOS DEL e:\ibi\apps\<myfolder>\<myolddb>.foc
-* Step 4: Create a new empty database with the updated master
CREATE FILE <MYOLDDB>
-RUN
-* Step 5: Load the data from the old database into the newly created database
REBUILD
REORG
LOAD
<MYOLDDB>
Y
-RUN
-* Step 6: Copy the newly reloaded <myolddb>.foc database from the temp folder to the permanent location
-DOS COPY <myolddb>.foc e:\ibi\apps\<myfolder>\<myolddb>.foc

Dennis
 
Posts: 38 | Location: Denver, CO | Registered: March 16, 2005Report This Post
Carol Dobson
Guru
posted Hide Post
Thanks Dennis_V, I was just about to write a program to do this.
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
Hello everyone,

I've had a REBUILD job running in ReportCaster since January working fine, runs every Saturday. All of the sudden my job can't handle FOCUS database names longer than 8 characters which they all are. I can't rebuild CharonAsset.foc but I can rebuild CharonAs.foc
We upgraded our server to WF 5.2.9 a few weeks ago. Anyone run into this?

Thanks,
Carol



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
Note: Using the DOS Shortnames for these FOCUS databases does not work either.



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
susannah
Expert
posted Hide Post
holy cow that's a nightmare, Carol!
Can you do the shortname rebuild and then DOS RENAME the files? or DOS COPY?
Did you open a case? let us know what they say, would you?



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
Carol Dobson
Guru
posted Hide Post
Hi Susannah,

The REBUILDs worked in 5.2.8 and not 5.2.9 We recently installed 5.2.9 patch to take care of large alpha fields that failed if there were more than 1064 characters present in the fields which we needed for reporting. IBI said the REBUILD problem is a known problem in the later releases of 5.2x and it's in programming. I don't believe there's a patch at this time and they don't have a workaround. Since the DOS shortnames didn't work, I'm going to try to build into my batch the DOS COPies, REBUILDS, DOS Copy back to the database names the applicatoin expects. Sounds like it will work. I'll let you know if it doesn't. Thanks.

The REBUILDS are key, so I agree this is a nightmare, not sure how someting like this could have been missed.

Thanks,
Carol



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
This is interesting and just an FYI....

Database: CharonAsset.foc Shortname: CHARON~1.FOC Rebuild works
Database: CharonCDOComponents.foc Shortname: CH7182~1.FOC Rebuild fails

For the more normal looking DOS Shortnames, the REBUILDS work. Once DOS starts putting numerics in positon 3, the REBUILD fails.

Oh well.



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Carol Dobson
Guru
posted Hide Post
A workaround for this situation is:

DOS COPY longnames.foc to shortnames.foc along with it's master. Then REBUILD the shortname.foc and copy the files back to the longname. What a pain, I had 28 databases!!!!

IBI has not yet replied if there is a patch for this problem. I hope none of you run into this problem!



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders