Storage Area Question

[RoyGene]

I have completed the planning/testing storage areas on my Progress database and have run into a snag. I got stuck when I tried to truncate an area. Can anyone help?

P.S.
I have been looking on the internet and Progress for the last two days and found nothing.

*** This is what happened ***

D:\data>proutil unifipc -C truncate area "lt-bin-dtl area"
OpenEdge Release 10.0B as of Fri Aug 6 02:12:54 EDT 2004
The BI file is being automatically truncated. (1526)
The contents of table "lt-bin-dtl" will be deleted.
Are you sure you want to truncate storage area "lt-bin-dtl area" (y/n)
y
Truncating storage area "lt-bin-dtl area"
Index "acnt-id-seq" was deactivated. (1515)
Can't find template record 33024 for lt-bin-dtl

RoyGene

 

[Casper]

Hi RoyGene,

Truncate Area does the folowing:

Truncate bi
Deactivate indexes
Resets HWM
Zero Space allocation chains
Recreate template records
Recreates root blocks for indexes in this area

Looks like you have a problem with recreating template records.

Could it be that you truncated the same area, deleted the table and truncated the area again to remove the area?

To me it looks like the database has corrupted somewhere.

Try before truncating:

for first _file where _file._file-name = 'lt-bin-dtl',
      first lt-bin-dtl where recid (lt-bin-dtl) = _file._template:
     message 'found template' view-as alert-box.
end.

It seems the template is missing.

Regards,

Casper.

 

[RoyGene]

Casper,

I do appreciate your response. I have been working on my own for way to long and I just happened on this www.

I can answer one question now.

You asked me.
"Could it be that you truncated the same area, deleted the table and truncated the area again to remove the area?"

The answer to this question is no. I got the message the first time I tried to truncate lt-bin-dtl table.

I will also send the output to the program you sent me.

 

[RoyGene]

Casper,

I tried your program
(

for first _file where _file._file-name = 'lt-bin-dtl',
first 'lt-bin-dtl' where recid ('lt-bin-dtl') = _file._template:
message 'found template' view-as alert-box.
end.
)​

and got this:

** Unable to understand after -- "lt-bin-dtl, first". (247)
** Missing file specification after FOR keyword. (235)
** Line 15 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Did I miss something?

 

[Casper]

Sorry,

I corrected it just a minute ago....

Casper

 

[RoyGene]

I ran the program and the template record was found.​

 

[Casper]

does the error have a number?

Can't find template record 33024 for lt-bin-dtl

Casper

 

[RoyGene]

No it doesn't.

 

[Casper]

hi there,

Last night I tried really hard to reproduce your error, but I didn't succeed. Not on the sports database nor on a production database of ours.

Anything else in the log file?
Just to be sure: This error is produced by the proutil command during the truncate isn't it?

Maybe you can ask this question as well at: dba@peg.com or contact Progress techsupport.

If you find the answer then please let us know.

Regards,

Casper.

 

[RoyGene]

Thanks Casper for trying. I will ask the PEG also.

*** This is what happened ***

D:\data>proutil unifipc -C truncate area "lt-bin-dtl area"
OpenEdge Release 10.0B as of Fri Aug 6 02:12:54 EDT 2004
The BI file is being automatically truncated. (1526)
The contents of table "lt-bin-dtl" will be deleted.
Are you sure you want to truncate storage area "lt-bin-dtl area" (y/n)
y
Truncating storage area "lt-bin-dtl area"
Index "acnt-id-seq" was deactivated. (1515)
Can't find template record 33024 for lt-bin-dtl

*** End ***

P.S.
The history of this database is that I created storage areas for the first time and dumped and loaded the database.

RoyGene

 

[RoyGene]

Progress 10.0B
Win Server 2003 - dbase server, client
Win XP - desktop

D:\data>proutil unifipc -C truncate area "lt-bin-dtl area"
OpenEdge Release 10.0B05 as of Sat Apr 15 05:33:30 EDT 2006
The BI file is being automatically truncated. (1526)
The contents of table "lt-bin-dtl" will be deleted.
Are you sure you want to truncate storage area "lt-bin-dtl area" (y/n)
y
Truncating storage area "lt-bin-dtl area"
Index "acnt-id-seq" was deactivated. (1515)

I installed 10.0B05 and truncated the area just fine.

When all else fails install the latest patch.

Thanks everyone,

Roy Shiplett
BOK Mortgage
Unifi Support
918-488-7352

 

[bjag]

Hi, Roy

I see that you are using the Unifi application, as I am, and was dealing with the lt-bin-dtl table, which I am, also. Ours is now over 100 GB, and located in the Schema area (Area 6), along with a whole slew of other tables, so I'm looking at putting it in its own area, or at least a different one. How did it go for you? How long did it take, and what size of table was it? Just wondering what to expect....Thanks, in advance, for any info.

Brenda

Progress 10.0B
Win Server 2003 - dbase server, client
Win XP - desktop

D:\data>proutil unifipc -C truncate area "lt-bin-dtl area"
OpenEdge Release 10.0B05 as of Sat Apr 15 05:33:30 EDT 2006
The BI file is being automatically truncated. (1526)
The contents of table "lt-bin-dtl" will be deleted.
Are you sure you want to truncate storage area "lt-bin-dtl area" (y/n)
y
Truncating storage area "lt-bin-dtl area"
Index "acnt-id-seq" was deactivated. (1515)

I installed 10.0B05 and truncated the area just fine.

When all else fails install the latest patch.

Thanks everyone,

Roy Shiplett
BOK Mortgage
Unifi Support
918-488-7352

 

[RoyGene]

How did it go for you? It went very well, though I do not know how comparible we are. I used a analysis program provided by Fiserv. It worked ok for me. It basically told me to separate the large tables into their own storage areas. How long did it take, and what size of table was it? I tested for about a month on a separate test database server. I separated all the tables from schema area and the largest was 15G. Just wondering what to expect....Thanks, in advance, for any info.
P.S. It was eaiser than I thought. Make sure you test it first. I got the program from Dan McQuarter. He is the person that is in charge of this @ Fiserv even though he wasn't much help to me.

 

[bjag]

Thanks for your response! So far, FiServ has offered us nothing in the way of guidance or programs. We had to pay for V10 upgrade "support", but no one there seems to know Progress on Unix very well (at least the folks that we have talked to). I have been trying for a week just to get the answer to a basic question - one that Casper was able to answer within minutes on this blog. And Progress will not support us - they say we have to go to Fiserv with our questions. I'm glad that at least this website is available to trade info.

How did it go for you? It went very well, though I do not know how comparible we are. I used a analysis program provided by Fiserv. It worked ok for me. It basically told me to separate the large tables into their own storage areas. How long did it take, and what size of table was it? I tested for about a month on a separate test database server. I separated all the tables from schema area and the largest was 15G. Just wondering what to expect....Thanks, in advance, for any info.
P.S. It was eaiser than I thought. Make sure you test it first. I got the program from Dan McQuarter. He is the person that is in charge of this @ Fiserv even though he wasn't much help to me.

 

[RoyGene]

i understand your frustration. I will not be able to help at all with Unix since we are a W2k3 shop. But we should at least get to know each other. Since we have to deal with simluar issues. Let us talk offline.

 

[RoyGene]

P.S.

Call me. My number is listed.

 

[bjag]

Sounds good to me...I'll give you a call, if that's oK.

i understand your frustration. I will not be able to help at all with Unix since we are a W2k3 shop. But we should at least get to know each other. Since we have to deal with simluar issues. Let us talk offline.

 

[RoyGene]

please 918 488 7352