Servoy 5.2.7

Servoy announcements

Re: Servoy 5.2.7

Postby martinh » Wed Apr 06, 2011 12:54 pm

Other changes are not saved as well.
I added a new screenshot
It happens more and more
Maybe the repository database is corrupt?
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Servoy 5.2.7

Postby ellenmeserow » Wed Apr 13, 2011 12:44 am

Fairly sure I have a 5.2.7 bug. My test server went from 5.2.4 to 5.2.7 on Friday while my production server is still on 5.2.2. Since the 5.2.7 update I'm consistently getting a validation error about trying to null a field _nothing_is telling Servoy to null. I have no method or calculation code which refers to "emergency_yn", the column that is reporting the error. The field is not allowed to be null, so I get an actual error when Servoy nulls it. Weirdly, it nulls it while firing calculations/methods on an entirely different screen/table. I've localized the moment it's doing it, in the middle of a loop that is _very_ complicated but working on a very different part of the system. Nothing in that loop touches that field. My production server does not have the same problem on 5.2.2 and my test server did not have this problem thursday on 5.2.4, with my code unchanged in any of those versions.
ellen escarcega (formerly meserow)
meserow design
Servoy 2019 9
MSSQL 2017
Windows AWS Servers
ellenmeserow
 
Posts: 366
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Re: Servoy 5.2.7

Postby jcompagner » Wed Apr 13, 2011 9:51 am

what sql statements are then fired to the database?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 5.2.7

Postby ellenmeserow » Wed Apr 13, 2011 10:01 pm

From the Performance log, cleared just before i encounter the problem. None of the below refers to emergency_yn:

Total Time (mm:ss:ms) Count Avg Time (mm:ss:ms) Type Action
00:00:016 1 00:00:016 Aggregate SQL select top 2 sum(cast(actual as double precision)) as sumactual, sum(cast(target as double precision)) as sumtarget, sum(cast(model as double precision)) as summodel, sum(cast(etc as double precision)) as sumetc, sum(cast(eac as double precision)) as sumeac from cm where (userid = ? and fk_projid = ?)
00:00:016 1 00:00:016 Find select top 201 proj_id from TblProj01Project where proj_id = ? order by proj_id asc
00:00:016 2 00:00:008 Relation select top 61 qa_id, tier0_id, tier1_id, recommendedrange, qacomment, tier2_id from TblLookup33QA where (tier1_id = ? and tier0_id = ? and tier2_id = ?) order by qa_id asc
00:00:015 2 00:00:007 Insert insert into cm (sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modlamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
00:00:000 1 00:00:000 Delete delete from cm where (userid = ? and fk_projid = ?) and userid = ?
00:00:000 1 00:00:000 Insert insert into cm (sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modlamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
00:00:000 1 00:00:000 Load valueList select distinct top 801 section_id, section_title from TblLookup10Section where section_id = ? order by section_title asc
00:00:000 3 00:00:000 Refresh/Rollback select top 2 sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, costmanagementid, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modl_display, modlamt, modelamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt from cm where costmanagementid = ?
00:00:000 2 00:00:000 Aggregate SQL select top 2 sum(cast(actual as double precision)) as sumactual, sum(cast(target as double precision)) as sumtarget, sum(cast(model as double precision)) as summodel, sum(cast(etc as double precision)) as sumetc, sum(cast(eac as double precision)) as sumeac from cm where (fk_projid = ? and userid = ? and tier2_id = ?)
00:00:000 1 00:00:000 Aggregate SQL select top 2 sum(cast(calcpercent as double precision)) as sumpercent, sum(cast(budget as double precision)) as sumbudget from TblContractPlan01Budget where budget_id = ?
00:00:000 1 00:00:000 Find select top 201 costmanagementid from cm where (userid = ? and fk_projid = ?) and userid = ? order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 budget_id, proj_id, tier2_id, bct_code, budget, contract_nbr, contract_desc, curve_type, update_date, end_date, start_date, UserId, update_mark, tier3_id, contract_id, calcyear, calcpercent, subnbr, tax_percent, parentbudget_id, contracttype_id, contractmilestoneshow_yn, hide_yn, converted, ytdstatusmonth, contract_title, paytype_id, loe_amt, otherfund_yn, shortscope, user_requested_id, inqtrlyrpt_yn, milestone_yn, showbudgetQtrly_yn, rfpad_date, reqrfpaddate, origscope_id from TblContractPlan01Budget where budget_id = ? order by budget_id asc
00:00:000 2 00:00:000 Load foundset select top 61 costmanagementid from cm where (fk_projid = ? and userid = ? and tier2_id = ?) order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 proj_id, ratingyear_id, eval_desc, eval_reason, eval_scope, budgetphase_id, budgetshare_id, percent_new, percent_existing, update_date, userid, update_mark, art_yn, artreason_id, artother_desc, artpercent_id, escalated_yn, model_yn, highrisk_yn, annualop_amt, opstartyear_nbr, highriskscore_amt from TblProj12EvalInfo where (proj_id = ? and ratingyear_id = ?) order by proj_id asc, ratingyear_id asc
00:00:000 1 00:00:000 Relation select top 61 screen_id, code, name, reminder_id, formname, tabname, nickname, hometabindex, projecttabindex, contracttabindex, projectfinancialstabindex, contractfinancialstabindex, projectscheduletabindex, tab1index, tab2index, tab3index, tab4index, tab5index, printing, exporting, storedproc, printing_notes, exporting_notes, readonly, help from screens where code = ? order by screen_id asc
00:00:000 2 00:00:000 Relation select top 61 sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, costmanagementid, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modl_display, modlamt, modelamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt from cm where (fk_projid = ? and userid = ? and tier2_id = ?) order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 sortby0, userid, contract_nbr, budget_title, fk_projid, tier1_desc, target, tier2_desc, tier3_id, eac, budget_id, tier1_id, tier0_desc, sortby3, numchildren, contract_id, tier2_id, sortby4, contract_title, sortby, etc, actual, etceac, tier3_desc, model, sortby2, currentlyopen, cost_center, constant1, budget_nbr, mindate, maxdate, toggle, curryrplussix, curryr, curryrplusfive, curryrallrest, tier1_phase_order, curryrplustwo, tier0_id, curryrplusfour, color, diff, curryrplusthree, curryrplusone, datadate, currentlyincl, usingallfunction, currentlyediting, parentbudget_id, tier2sort, costmanagementid, monththru, ytd_actual, fc_remaining, model_display, curryrplusfour_display, curryr_display, curryrplussix_display, curryrplustwo_display, curryrplusfive_display, ytdactual_display, total_display, forecast_display, diff_display, actual_display, curryrallrest_display, fcremaining_display, curryrplusthree_display, curryrplusone_display, background, ytdstatusmonth, exclamation, currentlyhilited, currentlyuptodate, log_display, qarecommendedrange, qacomments, qamodelou, title_yn, target_id, escalate_yn, showsalestax, curradopted_amt, modl_display, modlamt, modelamt, escalated, monthremaining, display_tier2_desc, contract_tooltip, arrow, arrow2, cm_id, gate3_amt from cm where (userid = ? and fk_projid = ?) order by costmanagementid asc
00:00:000 1 00:00:000 Relation select top 61 target_id, target_desc, target_date, datadate, update_date, userid, escalate_amt, proj_id, prevtarget_id, master_projid, formula_id, escalatetype, CRaboveline_yn from TblLookup25TargetDate where target_id = ? order by target_id asc
00:00:000 2 00:00:000 Relation select top 61 tier2_id, tier1_id, tier2_desc, obsolete, sort_order, phase_id, budgetgroup, title_yn, omb_id, milestonegroup, ShowTaxPercent_yn from TblLookup02Tier2 where tier2_id = ? order by tier2_id asc
ellen escarcega (formerly meserow)
meserow design
Servoy 2019 9
MSSQL 2017
Windows AWS Servers
ellenmeserow
 
Posts: 366
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Re: Servoy 5.2.7

Postby ellenmeserow » Wed Apr 13, 2011 10:11 pm

I was reading through 5.2.7's notes, and since emergency_yn is a related radio button, I wondered if the below change affected it:

[fix] 359924 RadioChoice build on a related dataprovider can't be set

So I changed emergency_yn to NOT go through a relationship, still a radio button, and the error about trying to null a not null field ceased. Still a bug in Servoy, I'd say, and probably happening elsewhere where nulls are allowed, but my error is gone...
ellen escarcega (formerly meserow)
meserow design
Servoy 2019 9
MSSQL 2017
Windows AWS Servers
ellenmeserow
 
Posts: 366
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Re: Servoy 5.2.7

Postby jcompagner » Thu Apr 14, 2011 9:11 am

so now you know the exact cause? Can you create a sample and attach that to a case?
I guess we are updating the dataprovider now even if the radio is not really touched by a user.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 5.2.7

Postby Karel Broer » Thu Apr 21, 2011 12:43 pm

I do like to say I'm very impressed with the webclient behaviour.
I've created a webclient application in just a few days and I find it really amazing how Servoy handles data loading and ui display.
Excellent work Servoyians! :)
Karel Broer
ServoyCamp - http://www.servoycamp.com
User avatar
Karel Broer
 
Posts: 779
Joined: Mon May 03, 2004 12:49 am
Location: Doetinchem

Re: Servoy 5.2.7

Postby martinh » Thu Apr 21, 2011 4:55 pm

martinh wrote:Other changes are not saved as well.
I added a new screenshot
It happens more and more
Maybe the repository database is corrupt?


The problem has been reported as fixed again.

-----------------------------------------
Status: closed-fixed
Resolution:
fixed by saving column info comming from team into the db always (it was not the case before if the column info did not existed on the team server)


I hope soon there will be a 5.2.8, because I can't save local changes into the repository
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Servoy 5.2.7

Postby ellenmeserow » Tue Apr 26, 2011 8:01 pm

I'm hoping for 5.2.8 soon as well to resolve the nulling of related radio buttons... Really sorry I haven't had time to create a sample case -- but it's running rampant on my dev database and I'm re-installing 5.2.6 now. :D
ellen escarcega (formerly meserow)
meserow design
Servoy 2019 9
MSSQL 2017
Windows AWS Servers
ellenmeserow
 
Posts: 366
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Re: Servoy 5.2.7

Postby antonio » Sat May 07, 2011 11:59 pm

Is it possible that 5.2.7 has changed the sorting of integer fields ? where the value is null or 0 in the past they were treated as the same value, now null < 0 for sorting. Or so it seems, I've just spent a few hours trying to find a change in behaviour, and this seems the likely cause.
Tony
Servoy 8 - 2022.03 LTS
antonio
 
Posts: 638
Joined: Sun Apr 02, 2006 2:14 am
Location: Australia

Re: Servoy 5.2.7

Postby ROCLASI » Sun May 08, 2011 11:32 am

Hi Tony,

First, Servoy itself doesn't sort at all. The backend database does.
That said, Servoy could send SQL to the backend database that can change the sorting behavior but I believe this is pretty RDBMS specific.

Did you move to a new/other database version recently ?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Servoy 5.2.7

Postby antonio » Sun May 08, 2011 11:50 am

Using a stock standard MySQL, haven't changed that intentionally.
The change in behaviour happened at the same time as upgrading to 5.2.7 - it's been well behaved for many months.
What I observed was that on the client null and 0 sorted as the same value, but when I ran the same sort in a headless client on the same DB connection, null sorted before 0. Replacing all the nulls with 0 fixed the problem, ie the sort order on the HC is now the same as the client.

fsItems.sort('dva_km_sort asc, date_sort asc, item_sort_order desc')

where the 3 fields are all integer types. I now have autoenter 0 for those fields.
Tony
Servoy 8 - 2022.03 LTS
antonio
 
Posts: 638
Joined: Sun Apr 02, 2006 2:14 am
Location: Australia

Re: Servoy 5.2.7

Postby ellenmeserow » Thu May 19, 2011 6:14 pm

I need to get a 5.2.6 installer to rollback until 5.2.8 solves my radio button issue. Can someone point me to a download site?
ellen escarcega (formerly meserow)
meserow design
Servoy 2019 9
MSSQL 2017
Windows AWS Servers
ellenmeserow
 
Posts: 366
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Re: Servoy 5.2.7

Postby jcompagner » Thu May 19, 2011 7:09 pm

5.2.8 is just around the corner if everything works out, don't know if you can wait for that a few more days?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 5.2.7

Postby jwservoy » Thu May 19, 2011 7:25 pm

jcompagner wrote:5.2.8 is just around the corner if everything works out, don't know if you can wait for that a few more days?


Plugin Changes
[fix] 377576 rawSQL.executeStoredProcedure to return the last resultset, not the first one

Was part of Servoy 6 beta 2 is this part of 5.2.8 or is there anyway it could be added?

Thanks,
Jason
________________________
Jason Walsh
ReadQ Technologies LLC
Servoy Certified Developer
jwservoy
 
Posts: 29
Joined: Mon Sep 14, 2009 10:35 pm
Location: New York, NY

PreviousNext

Return to Announcements

Who is online

Users browsing this forum: No registered users and 10 guests

cron