cancel
Showing results for 
Search instead for 
Did you mean: 

Migrated to PB 12.6 from 11. Weird errors with number fields.

Former Member
0 Kudos

Hi,

I recently migrated to 12.6 from 11.2. In the datawindows numeric fields of length 10 or more are having weird behavior.

I have a column of type "Number", editmask as "##########". When I enter 1111111111 it changes to 1111111168.

90000025 changes to 90000024.

90000028 changes to 90000032.

This is the same behavior with all the number fields in the all the datawindows.

What am I missing here ? Did something change about number fields between 11.2 and 12.6 ?

Please help me.

Thanks,

Chan.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Chan;

Can you tell us ...

1) O/S version?

2) PB 12.6 build number?

3) DB's column data type of the number based fields in the DWO?

4) Do the columns having the issue have both a Display Mask & and Edit Mask?

5) If you edit the source of a problem DWO - does it state "release 12.6;" as the 1st line?

Regards ... Chris

Former Member
0 Kudos

Hi Chris,

1) O/S version?

OS: Windows 7 64 bit

2) PB 12.6 build number?

PB : v12.6 Build 3506 - 32 bit

3) DB's column data type of the number based fields in the DWO?

There is no DB, its an External dw and the datatype of the column is Number.

4) Do the columns having the issue have both a Display Mask & and Edit Mask?

No, just the edit mask.

5) If you edit the source of a problem DWO - does it state "release 12.6;" as the 1st line?

Yes.

Former Member
0 Kudos

Hi Chan;

  That information is very helpful .. thanks! 

2) Do you have access to SAP Support for PB? If so, I would highly recommend that you apply one of the latest EBF's (build 4088 or 4091). There were a lot of issues with the GA version of PB 12.6 (build 3506)

3) External DW's - very interesting. A key piece of information for me! 

Some more questions ...

6) I assume this is a PB Classic application?

7) Can you attach the DWO source of one of your problem external DWO's?

Regards ... Chris

Former Member
0 Kudos

Hi Chris,

Thanks for your quick replies. I dont have SAP support for PB, but I will try to get it. Yes I am using Classic PB and I have attached the DWO source here.

Thanks in Advance.

Chan.

Former Member
0 Kudos

Chris,

I just tried something. I created a new external datawindow with just one number field and added editmask ##########. And when I entered 1111111111 in the preview mode, it converted it to 1111111136.

So its not happening with just migrated datawindows, but even ones newly created. I have attached the new dw as well just in case you wanted to check that.

Thanks,

Chan.

arnd_schmidt
Active Contributor
0 Kudos

This PowerBuilder Build 3506 is really buggy.

I do not understand why SAP still offers this Build for evaluation.

Former Member
0 Kudos

Hi Chan;

  No issues with this DWO in PB 12,6 build 4088 ...

Regards ... Chris

Former Member
0 Kudos

Hi Arnd;

You can say that again!  

I cannot wait for Appeon to take over PB!  

Regards ... Chris

Former Member
0 Kudos

Hi Chan;

   This DWO works OK for me in PB 12.6 build 4088 ...

Regards ... Chris

arnd_schmidt
Active Contributor
0 Kudos

It is a PowerBuilder bug in Build 3506.

Over and Out.

arnd_schmidt
Active Contributor
0 Kudos

With or without appeon there is no reason for SAP to still offer such a buggy release as an evaluation version without a serious warning!

Former Member
0 Kudos

Comes down to SAP should not be offering PB or any software IMHO.  

Great news this year though ... my Canadian government got rid of SAP for their HR/Payroll system and went with PeopleSoft <sigh of relief>.  

Come on A-p-p-e-o-n!!!  

Former Member
0 Kudos

Thanks for trying out Chris.

Former Member
0 Kudos

hi Chris,

I didn't realize there was a 4091 build, until today. The only thing, I could download the EBF itself, but couldn't seem to see or download the fixes txt or htm files. Maybe a temporary flaw on SAP site

Could you paste the fixes that have been made if you have them?

TIA,

regards,

MiguelL

Former Member
0 Kudos

Chris, If you reply, please do to this message and not the previous one.

MiguelL

Former Member
0 Kudos

Hi Keith;

  I am sad to say that I do not have list of the fixes included in the latest EBF either. Build 4091 too is a compilation of the many EBF's that have been released beforehand. There should be quite an extensive list of fixes .. somewhere. 

   Maybe someone from SAP Technical Support can jump in here and point us to the comprehensive list of fixes. These were always included in a proper Maintenance Release - but of unfortunately, we have not seen one of those yet. 

Regards ... Chris

arnd_schmidt
Active Contributor
0 Kudos

Tick tack... Time for SAP to make the EBFs "real public" .

Former Member
0 Kudos

Yes, thank you, I guess you're right Chris.

Let me just see if it's a temporary problem. If tomorrow it doesn't work I'll try to "loose myself" for another hour or so on making a ticket on the SAP site and doing 4 or times login to get there :s

By the way, I installed the 4091 (just for a moment) and it DOES seem to have fixed a weird problem:  (Edit: no it didn't)

I have of windows with a TreeView datawindow "blowing-up" randomly, but on the other hand: a complete uninstall and re-install (without going up to 4091), seemed to fix the problem previously.

(on Windows 8.1, same executable with older patches than 4088 don't seem to have that treeview window problem on the client computers).

Can't wait for December to come and dump this S$%£

Message was edited by: Miguel Leeuwe

Former Member
0 Kudos

Today I tried again and now the bugfixes for 4091 are available:

Here they are:

   List of Fixes for EBF 25970

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

   Following is a list of fixes which are cumulative to this release.  Each

   fix is listed along with the EBF in which it was first released and the

   description of the problem. The list is sorted by the EBFID column.

   EBFID   BugID            Description

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

   25970   795073           KBA 2271669    Customer is trying to use the

                            Microsoft UDP class

                            (System.Net.Sockets.UdpClient) in his PB

                            .NET application.  The constructor he is

                            trying to use takes a String.Int32 and does

                            not compile using either a long or

                            String.Int32 datatype in PowerBuilder.

                            Other constructors in the same class using

                            this parameter do work.

   25970   794893           KBA 2270609  Customer has a PB.Net

                            application where they have found that

                            several of their datastores are not getting

                            populated correctly when importing from XML.

   25970   794868           LeftA, RightA, MidA DataWindow function does

                            not return the correct Japanese string

   25970   794706           Application is crashing when function

                            IM_DefineView defined in IMW32D20.DLL is

                            being called.  KBA 2268977 created

   25970   794544           KBA 2270652  When a transaction object is

                            not set on a datastore, modifying the select

                            statement returns "Object reference not set

                            to an instance of an object" even though the

                            modify seems to work.

   25970   794509           If you set an expression in the detail

                            band's background color property of a Grid

                            DataWindow, you may encounter a DataWindow

                            painting issue when last row has the focus:

                            lines of the Grid DataWindow will disappear

                            KBA 2266912 created

   25970   794457           Difference in behavior between pb 12.6

                            classic and pb 12.6 .net  on the following

                            statement: selectStatement =

                            account.Describe("datawindow.table.select")

                            In PB classic, a value is returned in the

                            selectStatement In PB .NET, the

                            selectStatement returns a empty string

                            DataStore account string selectStatement

                            account = create DataStore

                            account.DataObject = "d_ds_oe_hdr_import"

                            account.SetTransObject(sqlca)

                            selectStatement =

                            account.Describe("datawindow.table.select")

   25970   794184           Customer has some treeview datawindows that

                            when migrated from PB 11.5.x to PB 12.6,

                            will not open past the second level of the

                            treeview.   Other treeview datawindows do

                            not show this behavior when migrated.

   25970   793965           When using Orca to deploy components to EAS,

                            it works fine if all the pbls are in the

                            same folder as the target. If you have many

                            folders, and a target file in another one it

                            fails with the error : Orca error in

                            'buildProject'. Result Code -20.

   25970   793912           Compile error "C0097: invalid statement" is

                            not raised in a script of a non visual

                            object inherited from an ancestor: KBA

                            2263386 created

   25970   792997           Customer is trying to set a debugger in one

                            of his objects and when he sets a

                            breakpoint.

   25970   792678           FileReadEx fails to return all lines when

                            reading a file with LineMode! filemode

Miguel

Former Member
0 Kudos

Thanks Miguel!  

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you both Chris and Arndt. I downloaded 4091 per your suggestion, and it's working now.

Chan.

Former Member
0 Kudos

Hi Chan;

  Excellent news!  

Now you can HUG your DataWindow(s) again.  

regards ... Chris

Former Member
0 Kudos

Hi,

Just a warning: (I don't want to know anymore "what's been fixed" in PB 12.6 - build 4091).

Since we've installed build 4088 (the previous one), we are having our windows with pfc treeviews "blowing up" randomly. I've been testing for 2 weeks and come to the conclusion that everything works perfectly fine until I install build 4088. I've tried installing build 4091 but it doesn't correct whatever has been "scre wed" with 4088.


So my advice to anyone using pfc's and treeviews, having a picture index column that uses a computed column with LookUpValue() to determine the index picture for the treeview: DON'T go past pb 12.6 - build 4081, the last one that seems to work well for us.

(I also get the feeling that performance is better with 4081 but for now it's just a feeling)


Kind regards,

Former Member
0 Kudos

Hi Miguel;

  Did you upgrade your PFC version to v12.6 as well or just migrate the old PFC code forward?

Regards ... Chris

Former Member
0 Kudos

Hi Chris,

Yes, we're using the PFC's of 12.5.

Is there a 12.6 version of the pfc's, can only see 12.5 on codeplex: PFC - Home

Anyway, the app runs fine with any of the 12.6 EBF's, but the minute I build with EBF 4081 or 4091, the app starts freezing our treeview containing windows (not constantly, some windows only when running the second time).

I uninstall everything, then go back to build 4081 and everything works again, enduring any amount of tests successfully.

Tested the same process on a virtual machine with windows 7 too: same results as on my 8.1.

Maybe I'll try to distill the problem in a small sample app, but altogether, I've lost weeks with this one already, let me first get ahead with some work.

Regards,

Miguel Leeuwe

In addition to your question:

We have two releases of our app: One using an (a lot) older PFC version and one with the latest 12.5 beta.

Both releases suffer exactly the same problem and behaviour.

It's the EBF 4088 that does something. That's why I recommend people to stay away from 4088 and 4091.

arnd_schmidt
Active Contributor
0 Kudos

Check out this thread

Former Member
0 Kudos

Oh yes!

You've nailed it Arnd:

We (un)effectively, do something very similar and debugging, things seem to blow up somewhere around the stuff described there.

I've added my warning at the link you gave me:

"Ha!

Experiencing a very similar problem with the pfc treeview, doing sort of the same thing.


Beware: SAP might have fixed it in build 4011, but they seem to have "broken it again" in build 4088 and upwards: 4091. At least that's what I found out "the hard way".

The last build that does not give me the problem is 4081, so I'll stick to that one.

Regards,

miguelL

"


Certainly looks like regression to me.

Thanks Chris and Arnd.