Bug 6706

ORA-12537: Network Session: End of file error when connecting SnapDevelop to Oracle database 16 June, 2021

Mark Luckasavage
02 June, 2021
Product: SnapDevelop Category: Other
Version: 2019 R3 Build: 2703
Classification: Appeon bug Publishing: Public
Priority: P3
Status: Scheduling Reason:
Communication Status: Waiting for Appeon
Logan Liu @Appeon 16 June, 2021
#21
Hi Mark,

Since .NET DataStore hasn't supported the UI layer. You can't use it to save as PDF directly. You can submit another ticket as an enhancement requirement if needed.

Why do you want to use a C# .NET Framework console application? 

BTW: 
Have you ever tried PowerBuilder 2021 Beta? Maybe our PowerServer 2021 new feature can help you to find a good solution. 
For more about PowerServer 2021, refer to:
https://docs.appeon.com/pb2021/whats_new/PowerServer_deployment.html

Regards,
Logan
Mark Luckasavage 11 June, 2021
#20
Sorry, I should have done more research regarding datawindows being non-visual. Also, I don't need the Oracle SID fix yet as I cannot use SnapDevelop for a project I am working on. I need to retrieve datawindows and save as PDF in a C# .NET Framework console application (ODBC Oracle). Is this possible?
Logan Liu @Appeon 11 June, 2021
#19
(In reply to Mark  Luckasavage from comment #15)
In SnapDevelop, does the c# converter create a model and a visual? Is the
visual the same as defined or is it an XML representation?

None visual. It only converts data-related logic to a C# model.


(In reply to Mark  Luckasavage from comment #16)
060921A.PNG (22KB)

Could you specify Host/Port/Service Name/User Name/Password in SnapDevelop to
work around it?

Answer: I tried to use this advise and getting the end of file error. Here's
the generated connection:
(DESCRIPTION=(ADDRESS=(HOST=10.155.xx.
xxx)(PORT=1521)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=RESB.WORLD)))

Is "RESB.WORLD" a real database service name or TNS alias?  Please use a real database service name.


(In reply to Mark  Luckasavage from comment #17)
If I can't use SID then I can't recommend using SnapDevelop.

Sorry, I have reported this bug this our development team. They are trying to find a solution to support the TNS connection type. It only supports the Basic connection type using Oracle Service Name.


(In reply to Mark  Luckasavage from comment #18)
If you can't implement Oracle SID, how about an ODBC?
You can use ODBC to connect your Oracle database with SnapDevelop.
Mark Luckasavage 10 June, 2021
#18
If you can't implement Oracle SID, how about an ODBC?
Mark Luckasavage 09 June, 2021
#17
If I can't use SID then I can't recommend using SnapDevelop.
Mark Luckasavage 09 June, 2021
#16
060921A.PNG (22KB)

Could you specify Host/Port/Service Name/User Name/Password in SnapDevelop to
work around it?

Answer: I tried to use this advise and getting the end of file error. Here's the generated connection: (DESCRIPTION=(ADDRESS=(HOST=10.155.xx.xxx)(PORT=1521)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=RESB.WORLD)))
Mark Luckasavage 09 June, 2021
#15
In SnapDevelop, does the c# converter create a model and a visual? Is the visual the same as defined or is it an XML representation?
Logan Liu @Appeon 09 June, 2021
#14
Hi Mark,

I can see that SID hasn't been supported and we are still trying to find a solution. 

Could you specify Host/Port/Service Name/User Name/Password in SnapDevelop to work around it?

Regards,
Logan
Mark Luckasavage 08 June, 2021
#13
Can you please give me an example of connecting to Oracle in SnapDevelop without using TNSNAMES.ORA?
Logan Liu @Appeon 05 June, 2021
#12
Hi Mark,

Thank you for reporting this issue. I'm analyzing this issue.

1) TNSNAMEs haven't been supported. 

2) Do you mean that you can access your database with SID instead of the service name in SnapDevelop? Could you use a service name to work around it?

Regards,
Logan
I still haven't been able to come up with a possible explanation, nor been able to reproduce this issue. I'm gonna transfer this ticket to our Engineering Team so that someone with much more experience on Oracle Databases can help you out.

Regards,
Francisco
Mark Luckasavage 04 June, 2021
#10
I don't think it's a long running query. I get this in SnapDevelop trying to create a connection to a migrated c# datawindow. I think it has something to do with a SID defined in the TNSNAMES instead of a service name.
Hi Mark,

Sometimes you get this error due to long running queries or high volume of data due to any wrong join condition.

Try to get the query and also ask you DBA to check if there is any query taking a long time or occupying huge amounts of memory.

I would recommend to validate the ApplicationPool settings and the configuration tool for the Timeout settings, sometimes one of the timeout values can be too low.

At last, you might take a look in the database alert log to verify if the database is having problems.

Regards,
Francisco
Mark Luckasavage 04 June, 2021
#8
060421Aappeon.PNG (22KB)

I have several ODAC, I think it's this one.
I think that might be necessary if we cannot single out the issue. What ODAC version are you using?

Regards,
Francisco
Mark Luckasavage 03 June, 2021
#6
Thanks for looking into this. I'm open to a remote meeting so I can share my screen.
We're going to have to keep looking into this, I cannot seem to reproduce it on my side. I'm currently using 18c, but will get my hands on 12c and check there.

Regards,
Francisco
Mark Luckasavage 02 June, 2021
#4
060221appeon2.PNG (25KB)

That was a guess regarding the period in the service name. If I take it out then I get Unknown Service. We use SID's instead of SERVICE_NAME in the TNSNAMES.ORA. 

RESB.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.xx.xxx)(PORT = 1521))
    (CONNECT_DATA = (SID = RESB))
  )
Mark, one question.
Why do you suspect the problem is with the period in the service name?
Have you been able to connect when it doesn't have it?

Regards,
Francisco
Hi Mark!

Thanks for reporting this issue, I'm trying to reproduce it right now. I'll get back to you soon.

Regards,
Francisco
Mark Luckasavage 02 June, 2021
#1
060221appeon.PNG (25KB)

*Phenomenon:
I'm trying to create a database connection in SnapDevelop 2019 R3 to an Oracle database, but I get the error "ORA-12537: Network Session: End of file" setting up connection for datawindow. Using TNSNAMES.ORA.

*Reproduce Steps:
(DESCRIPTION=(ADDRESS=(HOST=10.155.xx.xxx)(PORT=1521)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=RESB.WORLD)))

Remarks: I think there is a bug when the service name has a period in it?
OS:
Windows 10
Platform:
64-bit
Database Type:
Oracle
Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production