Bug 4875

Issue Apeon with ADO.Net 01 July, 2020

Daniel Oralek
30 June, 2020
Product: PowerBuilder Category: Database
Version: 2019 R2 Build: 2338
Classification: Publishing: Public
Priority: P3
Status: Reproducing Reason:
Mark Lee @Appeon 01 July, 2020
#4
Hi Daniel,

Thanks for reporting this problem.
We will work on it and get back to you soon.
Thanks for your understanding.

Regards,
Mark Lee
armando herrera @Appeon 30 June, 2020
#3
Hi Daniel,

Thank you very much for the test case. I'm transferring this case to our Engineering Team for further analysis!. 

We will keep you posted here!

Regards!
armando herrera @Appeon 30 June, 2020
#2
Hi Daniel,

Thank you very much for your report. We are working on it and we will get back to you after analyzing it.

We'll keep you posted here!


Regards!
Daniel Oralek 30 June, 2020
#1
TestApeon.zip (486KB)

*Phenomenon:
We used nonvisual objects with PowerBuilder 11.2 as COM+ Objects with IIS server for computing.
Now we are converting the same objects to NET assemblies, because Appeon PowerBuilder R2 2019 doesn’t support COM object any more.
We have very serious issue regarding Database Connection to MSSQL.

*Reproduce Steps:
I prepared demo which illustrates the problem. Demo contains PB project for assembly and Visual Studio for testing program, which uses this assembly.
There is a nonvisual object with one function of_testdb. This function cretates local transaction object, connects database, test SQL command and closes connection and destroys transaction object.
Everything works fine when used only in single process.
If I start more process in parallel mode, transactions seem to be some kind intertwined.

Starting in single process:
1. Task started
Task finished, ok = 100 fail = 0

Starting 5 processes:
1. Task started
3. Task started
4. Task started
2. Task started
5. Task started
5.0 Error:Error reading data: tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connectedDisconnect error: tr_trans.DBMS = ADO.Net
tr_trans.ServerName =.
tr_trans.LogId =sa
tr_trans.LogPass =
tr_trans.AutoCommit = false
tr_trans.DBParm = Datasource='.', Database='testvypocet',Namespace='System.Data.SqlClient', App=Test5
tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connected
2.0 Error:Error reading data: tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connectedDisconnect error: tr_trans.DBMS = ADO.Net
tr_trans.ServerName =.
tr_trans.LogId =sa
tr_trans.LogPass =
tr_trans.AutoCommit = false
tr_trans.DBParm = Datasource='.', Database='testvypocet',Namespace='System.Data.SqlClient', App=Test2
tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connected
1.0 Error:Error reading data: tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connectedDisconnect error: tr_trans.DBMS = ADO.Net
tr_trans.ServerName =.
tr_trans.LogId =sa
tr_trans.LogPass =
tr_trans.AutoCommit = false
tr_trans.DBParm = Datasource='.', Database='testvypocet',Namespace='System.Data.SqlClient', App=Test1
tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connected
3.0 Error:Disconnect error: tr_trans.DBMS = ADO.Net
tr_trans.ServerName =.
tr_trans.LogId =sa
tr_trans.LogPass =
tr_trans.AutoCommit = false
tr_trans.DBParm = Datasource='.', Database='testvypocet',Namespace='System.Data.SqlClient', App=Test3
tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connected
4.0 Error:Disconnect error: tr_trans.DBMS = ADO.Net
tr_trans.ServerName =.
tr_trans.LogId =sa
tr_trans.LogPass =
tr_trans.AutoCommit = false
tr_trans.DBParm = Datasource='.', Database='testvypocet',Namespace='System.Data.SqlClient', App=Test4
tr_trans.sqlcode =-1
tr_trans.sqlerrtext =Transaction not connected
Exception:Description not initialized
Exception:Description not initialized


And in eventlog several events:

Error Block: 2123532178597720376, typ 1
Event name: APPCRASH
Reaction: Není k dispozici.
File ID CAB: 0

Description of problem:
P1: TestApeonAssembly.exe
P2: 1.0.0.0
P3: bfb5639a
P4: PBSHR190.dll
P5: 19.1.0.2328
P6: 5e99c38d
P7: 4000001f
P8: 0012c9a0
P9: 
P10: 



Remarks:
OS:
Windows 10
Platform:
64-bit
Database Type:
Microsoft SQL Server
Database Version:
MSSQL 2017