• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Re: Connect Using SQLCA is, probably, closing the application in Lenova Yoga Book (Win 10)

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Re: Connect Using SQLCA is, probably, closing the application in Lenova Yoga Book (Win 10)

  1. Issue
0
Votes
Undo
  1. Sivaprakash BKR
    Sivaprakash BKR
  2. PowerBuilder
  3. Thursday, 16 September 2021 02:36 AM UTC

Hello,

PB 2017 R3

We have a migrated application from PB 10.5 to PB 2017R3 which is working fine when run from desktop, surface pro, laptops.   We found an issue when we run the same application in a Lenovo Yoga book (Win 10 Home).  While executing the command

Connect using SQLCA ;

the application gets closed (crashes ?) it seems.   We don't get any response after that.  We tried with messagebox before and after that command, and we get the messagebox put before that command.  No messages after that.

We have another application, developed in PB 11.5, with the same set of commands, which is working fine in that Yoga book.  

What could be the issue ?  Any idea to debug ?

Happiness Always
BKR Sivaprakash

Update:  We migrated (compiled) the PB 2017R3 application with PB 2019 R3.  It's working in Yoga Book.   As we are not in a position to rollout this upgrade (to PB2019) is there any way to solve this issue in PB 2017 ?

 

  1. PowerBuilder (Appeon)
Re: PB 11.5 runtime installation issue
Default font settings do not apply in new datawind...
Responses (4)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 September 2021 04:38 AM UTC
  2. PowerBuilder
  3. # 1

Are you on latest build of PB 2017 R3?

Comment
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Thursday, 16 September 2021 05:04 AM UTC
PB 2017 R3 Build 1951

Hope this is latest.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 16 September 2021 05:37 AM UTC
Yes, that is the latest build.
  1. Helpful
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Thursday, 16 September 2021 05:30 AM UTC
  2. PowerBuilder
  3. # 2

Created one simple application.   Application open event contains

*****************************************
SQLCA.DBMS = "OLEDB"
SQLCA.Database = "DatabaseName"
SQLCA.UserID = ""
SQLCA.DBPass = ""
SQLCA.LogID = "logid"
SQLCA.LogPass = "logpass"
SQLCA.ServerName = "ServerName"        // eg.  "Servername\SQL2012"
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='Servername',PBMaxBlobSize='100000',PBMaxTextSize='100000',PROVIDERSTRING='Database=databasename'"
SQLCA.Lock = "RC"
SQLCA.AutoCommit = True

Messagebox('open', 'going to connect')
Connect using SQLCA;
Messagebox('Error', SQLCA.Sqlcode)

If SQLCA.Sqlcode = 0 Then
Open(w_main)
Else
Messagebox('Error', 'Cannot Continue')
End If
*******************************************

We get the first message (going to connect) and application closes.   We found this issue in Lenova Yoga Book with Win 10 Home.

 

Comment
Load more comments
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Thursday, 16 September 2021 05:49 AM UTC
We use PB 2017 R3 build 1951, which I think is the latest. No other build we use. Should we downgrade and check at our end ?
  1. Helpful
mike S
  1. mike S
  2. Thursday, 16 September 2021 13:41 PM UTC
sounds like antivirus
  1. Helpful 1
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Friday, 17 September 2021 05:08 AM UTC
Thanks mike s,

1. No third party anti-virus software is there except Windows Defender. Scanned with Defender and found nothing exceptional.

2. If it's an issue of virus, I expect the same issue with PB 11.5 and PB 2019 applications too. We found both applications works. Issue is with PB 2017 application only.

  1. Helpful
There are no comments made yet.
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 September 2021 06:51 AM UTC
  2. PowerBuilder
  3. # 3

Hi Sivaprakash,

From your description, this crash issue happens against the connect statement and it only happens on Lenovo Yoga Book. We haven’t got any issue reported like this one.

I suggest you try:
1. Upgrade the Windows OS patch to the latest version on the Lenovo Yoga Book then try again.
2. Run your application with Run as administrator and see if it has the same issue.
3. Does running with PBL in PB IDE work normally? Or does the issue only happen with the application after the deployment (PBD + EXE)?
4. If the issue only happens with the application deployed, please check if the PB runtime files are correct.
5. If there is no PB IDE installed on the Lenovo Yoga Book, I suggest installing it then try again.
6. If the Lenovo Yoga Book already has PB IDE installed. Please uninstall, reinstall, then try again.


Regards,
Ken

 

Comment
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Thursday, 16 September 2021 07:29 AM UTC
Thanks Ken

1. Windows OS is the latest. Even today morning (IST time) there was an update. I re-checked and it says it's the latest and no further updates available.

2. Yes, the same issue when Run as Administrator also.

3. PB IDE is not available in Lenovo Yoga Book. Need to install it and check it.

4. Runtime files are correct. We re-created the runtime files and re-installed (after uninstalling) the runtime files in Yoga Book.

5. Need to install PB IDE and check.



Let me try the last one (PB IDE) and revert back.

  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Thursday, 16 September 2021 07:38 AM UTC
The same code works fine when executed from PB 11.5 & PB 2019 applications. Issue is with PB 2017 application.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 17 September 2021 07:56 AM UTC
  2. PowerBuilder
  3. # 4

Since it crashed on the connection to the database, try adding TRACE to the dbms value of sqlca, it might give you some information.

Also check the windows event viewer. I think it might be more of a client db driver issue than anything else.

regards

Comment
Load more comments
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Friday, 17 September 2021 11:19 AM UTC
Miguel,

1. Issue is with PB 2017 application where MSOLEDBSQL is not there.

2. MSOLEDBSQL is available in PB 2019. When migrated from PB 2017, the same application works fine with OLEDB itself.

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 17 September 2021 12:23 PM UTC
My bad, have you tried to do the TRACE? Have you checked in the event viewer?
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Friday, 17 September 2021 12:53 PM UTC
Miguel,

Need to check with TRACE, check event viewer and installing PB 2017 IDE. Need to visit client place, will do it soon.
  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.