[Fwd: Re: Deadlock situation]

[Cesar Baquerizo]

Kenneth Brody wrote:

>
> That error indicates one of two possible scenarios:
>
> 1 - A true deadlock situation would have occurred.  For example, I 
> have record
>     1 locked, and you have record 2 locked.  I attempt to lock record 
> 2, which
>     means I will wait until you unlock it.  Then, you attempt to lock 
> record 1.
>     Because you need to wait for me to unlock it, but I'm already 
> waiting for
>     you, if this were allowed, we would both wait forever.
>
> 2 - There are too many locks system-wide.
>

Sorry if duplicated, my copy of original was junk...

Everyone, thanks for the responses.  Unfortunately I am still having 
trouble.  A little more info:

1.   Just migrated to openserver 6 using Filepro V 4.5
2.   I ran the process with no one else logged on, and still the same thing
3.   I also tried the suggestion to change the alias (interestingly 
enough it ran through more records)
4.   All processing below pretty simple.

The error simply "pops up", and I have no way of seeing the record 
number that it is processing.  Anyway to do this?
Also, I found some rpa* files in the /tmp directory.  I have a vague 
recollection of rpa* files.  Anyone know what causes them?

Thanks again,

    ■ If: 21 eq 
""                                                          ■
      Then: 
end                                                               ■
 2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ 
If:                                                                   ■
      Then: 
ke(23,*)=2&4                                                      ■
 3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ 
If:                                                                   ■
      Then: lookup apen = mropenitems  k=ke   i=F 
-nx                         ■
 4  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: not 
apen                                                          ■
      Then: show  "Timesheet not found" & 2 
;end                              ■
 5  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: 3 ne 
"RSW"                                                        ■
      Then: apen(7)=apen(7)+ 7 ; oa(14,.4) = 
apen(6)                          ■
 6  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: 3 eq 
"RSW"                                                        ■
      Then: apen(7)=apen(7)- 7 ; oa = 
apen(6)                                

 7    ■ If: apen(8) eq 
"Y"                                                    ■
      Then: 
end                                                               ■
 8  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: oa eq 
"0"                                                         ■
      Then: 
apen(8)="Y";apen(6)="0";end                                       ■
 9  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: oa gt 
7                                                           ■
      Then: apen(6)=apen(6) - 7 
;qt(14,.4)=7                                  ■
10  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: 7 ge 
oa                                                           ■
      Then: 
apen(6)="0";qt=oa                                                 ■
11  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ 
If:                                                                   ■
      Then: lookup mrinvmaster  k=4    i=A 
-nx                                ■
12  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
      ■ If: not 
mrinvmaster                                                   ■
      Then: show "Item not found" & 4 ;end               
   
13      ■ 
If:                                                                   ■
      Then: mrinvmaster(3)=mrinvmaster(3)-qt    



-- 
---------------------

Cesar Baquerizo

ces at cescom.com
Off. - (718) 343-0829
Fax. - (718) 343-3111
Cell - (917) 685-8447

http://www.linkedin.com/in/cbaquerizo


********************************************************************

This message and any attachments are solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited.

If you received this message in error, please notify the sender and permanently delete.