11.1 -> 11.2 upgrade problems

[John DeSoi]

I have a pretty simple application I upgraded to 11.2 where I have  
noticed a number of problems I was not having with 11.1.

To start, 11.2 did not recognize any of my previous preferences. I had  
to reset method colors and just about every setting in preferences.

My runtime volume build with no changes other than the 11.2 upgrade no  
longer knows about all the words I saved in the dictionary during  
spell checking.

A procedure that worked in 11.1 now sometimes reports that a record is  
locked, but if you check LOCKED ATTRIBUTES in the same method all the  
values are empty.

The worst problem is that the Sum function returns an incorrect value  
when called from a form method or object script. It finally dawned on  
me it was summing all the selected record values except for the  
current record. Here are two traces of the same code, one called from  
a form method and the other called from a method run in a new process:







Here the current record value amount is 50, but Sum returns zero.







4D reports both the structure and data are OK.


Anyone else having these problems, or just me?


John DeSoi, Ph.D.





**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************

[Yogi Jivanandanatha]

Aloha John,

We just upgraded from 2004.7 to v11.2 server. Lots of issues we are  
working out. One is the Sum function. For us, it works properly when  
the field is indexed, and returns bogus values when the field is not  
indexed. Are you using sum on an un-indexed field? I'm going to chat  
with tech support about this and see what they can do. Seems like a bug.

Interesting about the current record not being summed. In my example I  
thought it was only negative numbers that were being summed (on a  
field with no index), but it could have been the current record that  
was excluded.

Yogi Jivanandanatha


On Jul 1, 2008, at 6:46 PM, John DeSoi wrote:

> I have a pretty simple application I upgraded to 11.2 where I have  
> noticed a number of problems I was not having with 11.1.
>
> To start, 11.2 did not recognize any of my previous preferences. I  
> had to reset method colors and just about every setting in  
> preferences.
>
> My runtime volume build with no changes other than the 11.2 upgrade  
> no longer knows about all the words I saved in the dictionary during  
> spell checking.
>
> A procedure that worked in 11.1 now sometimes reports that a record  
> is locked, but if you check LOCKED ATTRIBUTES in the same method all  
> the values are empty.
>
> The worst problem is that the Sum function returns an incorrect  
> value when called from a form method or object script. It finally  
> dawned on me it was summing all the selected record values except  
> for the current record. Here are two traces of the same code, one  
> called from a form method and the other called from a method run in  
> a new process:
>
>
>
>
>
>
> Here the current record value amount is 50, but Sum returns zero.
>
>
>
>
>
>
> 4D reports both the structure and data are OK.
>
>
> Anyone else having these problems, or just me?
>
>
> John DeSoi, Ph.D.
>
>
>
>
> **********************************************************************
> 4D Server v11 SQL has arrived!
> Buy it NOW at http://store.4ddepot.com
>
> 4th Dimension Internet Users Group (4D iNUG)
> FAQ:  http://www.4d.com/support/faqnug.html
> Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> Post: mailto:4d_tech@...
> Options: https://lists.4d.com/mailman/listinfo/4d_tech
> **********************************************************************

**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************

[John DeSoi]

Hi Yogi,

On Jul 6, 2008, at 3:22 PM, Yogi Jivanandanatha wrote:

> We just upgraded from 2004.7 to v11.2 server. Lots of issues we are  
> working out. One is the Sum function. For us, it works properly when  
> the field is indexed, and returns bogus values when the field is not  
> indexed. Are you using sum on an un-indexed field? I'm going to chat  
> with tech support about this and see what they can do. Seems like a  
> bug.
>

Yes, I was using an unindexed real field. If I index it it, I get the  
correct value.


> Interesting about the current record not being summed. In my example  
> I thought it was only negative numbers that were being summed (on a  
> field with no index), but it could have been the current record that  
> was excluded.

I did some further investigating and here is what I found. I was only  
seeing this error in my form or object methods. The form was being  
opened from a generic listbox project form which lists records for all  
my tables (uses fields, not arrays). If I open the form in a separate  
process, Sum gives the correct value. So that led me back to the  
process displaying the fields with the list box. If I put the code in  
a menu item procedure called from that process, Sum gives the wrong  
value.


John DeSoi, Ph.D.




**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************

[Brendan Coveney]

John/Yogi,

There is a known issue with the Sum command in 11.2. I know there is a fix
coming in an upcoming hotfix which will address this issue.


I will see if we can post the exact issue when the guys get to work later
today.
Brendan


On 7/6/08 8:42 PM, "John DeSoi" <desoi@...> wrote:

> Hi Yogi,
>
> On Jul 6, 2008, at 3:22 PM, Yogi Jivanandanatha wrote:
>
>> We just upgraded from 2004.7 to v11.2 server. Lots of issues we are
>> working out. One is the Sum function. For us, it works properly when
>> the field is indexed, and returns bogus values when the field is not
>> indexed. Are you using sum on an un-indexed field? I'm going to chat
>> with tech support about this and see what they can do. Seems like a
>

**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************