ERROR Database connection TES: SQL error 30293 [ASE Error SQL30293:HY000][SAP][ASE ODBC Driver]

[former_member351272]

error1.pngerror2.pngHello

We are configuring Solman 7.2 SP07 Managed System Configuration, Step 5. Enter System Parameters:

We have this error:

[ASE Error SQL30293:HY000][SAP][ASE ODBC Driver]The socket failed to connect within the timeout specified.

We have read note https://launchpad.support.sap.com/#/notes/0002641477

The ports are 4901 in both systems, solution manager and TES, and are opened.

Could you help us?

Thanks in advance

Mary

[michael_loop]

I have removed the tag for SAP Advantage Database Server. This is a different database product unrelated to ASE or Solution Manager.

[former_member351272]

Hello,

Thank you all. The problem is resolved.

The problem was in the communications departament. The port 4901 were closed in the firewall.

Best Regards

Mary

[former_member274411]

Hi Mary,

we have a similar problem in SolMan/SAP ASE after the update to SP 03 PL 05 Hotfix 1 for SAP ASE 16.

Did you solve this one?

Regards,

Sergey

[former_member274411]

I've solved the problem by the verifying of the kernel update process under

https://wiki.scn.sap.com/wiki/display/SI/SAP+Kernel+Update+on+Unix+and+Linux, namely point 9 with permissions and point 10:

Run saproot.sh "<kernel folder>/saproot.sh <SID>" as root.

Regards,

Sergey

[victoria_normand]

Hi Mary,
Are you sure your ASE is running ? And if yes, can you check entry for the [<SID>] entry in the interfaces file ? (for Linux $SYBASE/interfaces | for Windows %SYBASE%\ini\sql.ini ). You may check from there which is the hostname server and the port which normally for SAP applications running on ASE, it should be 4901. If it is not 4901, prior to change, check on which port de process "dataserver" (for Linux , or "sqlsrvr.exe" for Windows) is running. That port should be mentioned in the sql.ini for entry [<SID>].

Best regards,
Victoria.

[former_member351272]

Hello Jogun,

Thank you for your help, we have executed the command isql -Usapsa -S<database host>:4901 -X with syb<solman SID> and this is the error:

CT-LIBRARY error: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed

Could you help us?

Thank you in advance

Best Regards

Mary

[jong-un_seo]

Hi,

Did you try to connect to the target ASE on the host running Solman using isql utility?

If not so, please try to do it after logging in to the host with syb<solman SID>.

isql -Usapsa -S<database host>:4901 -X

Regards,

Jongun