1. Edinson Nongrados
  2. PowerBuilder
  3. Thursday, 3 June 2021 09:00 AM UTC

Good morning,

I got a problem with some of my crosstabs datawindows, when i do a retrieve my crosstab starts blinking and after that the application automatically close.

If somebody can help me with this issue. 

 

Do you know what is happening ?

 

Regards,

Edi

Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 3 June 2021 13:05 PM UTC
  2. PowerBuilder
  3. # 1

The first step is to take the SQL from the DW and run it in the DW Painter. Ensure that you are getting the results you expect.

Once the SQL is correct, then REBUILD your corsstab DW. In my experience there is no way to REPAIR a crosstab dw once it begins to misbehave.

Comment
  1. Olan Knight
  2. Wednesday, 14 July 2021 13:21 PM UTC
Did you ever get this issue resolved?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 June 2021 14:44 PM UTC
  2. PowerBuilder
  3. # 2

Hi Edinson;

   Can you tell us ....

1) PB version & build that you are using?

2) O/S version & build that you are using?

3) Is your App 32 or 64 bit compiled EXE?

4) Is your App M-Code or P-Code compiled?

5) Does this happen in the IDE as well as the EXE of the App?

6) Are you running the IDE and/or App EXE on a real or virtual machine?

7) Do you use any remote software to access your IDE / EXE (ie: RDT, Citrix, etc)?

8) Is there any information in the O/S Application Event logs?

Regards ... Chris

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 6 July 2021 14:31 PM UTC
Hi Edinson;

If it now works OK on your development PC, it should work the same on the deployed PC's assuming that a) you redeploy the App recompiled with build 2703 and B) you update the PB runtime from build 2670 to 2703.

Regards ... Chris
  1. Helpful
  1. Edinson Nongrados
  2. Monday, 12 July 2021 11:41 AM UTC
Hi Chris,



i've deploy my app in a computer which has the PB IDE Build 2703 and the PB Runtime Build 2703 then I installed the app from my computer to another PC, this computes has the IDE Runtime 2703 installed and the PB IDE Build 2703 too, but it continues not working.



I forget to tell you, there's other error in the Event Viewer this.



Event 1026, .NET Runtime



Application: pb190.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: exception code c0000005, exception address 503FF990

Stack:

  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 12 July 2021 16:54 PM UTC
Hi Edinson;



Not sure if this is your issue but just remember that R3 no longer uses numbering in its DLLs and the location of the R3 runtime is now located via the App EXE which looks for a new XML file that the PB Compile produces. Both the EXE and XML file should now be deployed in the same folder and then make sure that the XML file points to the correct location of the PB R3 runtime where you installed it on the deployment PC.

Also note that the .Net runtime for W10 machines would be the .Net redistributable. FWIW: I am using .Net 4.8.



Regards ... Chris
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.