🟦SAP, I'll Pass
SAP ASE on DBeaver
In case of SAP ASE, it is a hell of a mess. We have so many products, I'm wondering why.
Problem: Couldn't connect to by server, even after the correct credentials and port. Got the error
1. Connection Already Closed
services, on windows, restart
if that doesn't work, kill pid of the service.
start again.
could be issue of space not being enough.
2. Curious case of 'Connection Already Closed' but we did the above step:
The users of my SAP ASE instance, especially team DataStage, who run automated tests on the instance, were getting connection refused or connection already closed. I restarted the server like above, it worked for me as an sa
but it didn't for them. I was on the verge of crying, when angel Pallavi Koganti helped me with the command:
This helped me solve the frequently logged out issue. Thanks, Pallavi!
3. Timed out on CREATE statements
Did some digging around (cough *chat GPT* cough) and realised that space might have run out of CONOPS database, so I increased it, with the following commands.
Last updated