Errors while running index analysis

[taqvia]

Hi,

While running the index analysis I encountered the following error
SYSTEM ERROR: lkrels record <recid> not locked. (435) and
Internal error in upifix [11150] I could not find any entry in KB for 11150. Can anyone please let meknow the reason for getting the above error and how to rectify it. Also the utilty got aborted because of the above error.

Regards,

Arshad Taqvi

 

[TomBascom]

What version of Progress?

Was the db online at the time? (It sounds like it was.)

Does your configuration have any interesting characteristics? Such as Fathom Replication...

You should check the KB for error 435 -- there are a lot of entries.

 

[taqvia]

We are using 9.1 E and yes DB was online. The error 435 do indicate that not able to acquire lock but there is no entries for 11150. Also I have one other query is it posiible to execute the idxfix/idxanalysis(progress commands) in a nohup mode for the unix box.



will the below work
proutil <dbname> -C idxfix < input.txt(containing the commands input 2 some Table-name index name yyy) | tee -a > /file.txt

placing the above command in a shell script and running it in nohup shellscript.sh

Anyways i will give a try now


Arshad Taqvi

 

[shanthimarie79]

Hi Taqvia,

I am using OE10.2a running on the Windows platform
I have 2 questions :

We had recently modified some index in our database by flagging them as Unique.
I need to now identify records in my database that breaks this unique rule.

I want to isolate the list to a bunch of specific index only.

Question 1: I wanted to ask if your script above was successful or not?

Also, I keep getting this error in my database when i try to run proutils idxfix :

proenv>proutil mfgsys -C idxfix -NL
OpenEdge Release 10.2A0210 as of Thu Jan 28 10:17:08 EST 2010
Use "-cpinternal UTF-8" with idxfix only with a UTF-8 database. (8557)

Question 2: If my DB is not UTF-8, would you know how may I run the proutil idxfix ?

Thanks and looking forward to your answer.
Do let me know should i need to provide more information.

 

[Casper]

Hi,

We had recently modified some index in our database by flagging them as Unique.
I need to now identify records in my database that breaks this unique rule.

This means that first you change the index to make it unique and after that you want to identify records which are duplicate?
In my opinion you should that the other way around. Anyway, after changing the index to unique idxbuild tells you which rowids give duplicate errors, so you have already identified them.

proenv>proutil mfgsys -C idxfix -NL
OpenEdge Release 10.2A0210 as of Thu Jan 28 10:17:08 EST 2010
Use "-cpinternal UTF-8" with idxfix only with a UTF-8 database. (8557)

Question 2: If my DB is not UTF-8, would you know how may I run the proutil idxfix ?

you have in $DLC/startup.pf set cpinternal as UTF-8 if the databases isnt that codepage yo have to run the proutil command with the proper -cpinternal flag.
You find the codepage of your database in data administration/utilities/information.

HTH,

Casper.

 

[shanthimarie79]

Hey,
Thanks for the reply.
Noted that the search for conflicting records should have been done first fro question 1.

The reply for question 2 worked liked a charm!!

Thanks.
Kind Regards,
Shanthi