cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

No SQL Anywhere EBF in 5+ months

wndstorm_sqlaf
Explorer
4,405

I noticed SAP has not released an EBF for SQL Anywhere 17 (Windows on X64 64BIT) in over 5 months, the longest gap in-between EBF's in at least 6 years. A month ago, I submitted a support ticket/question on SAP For Me about when we could anticipate a new update and was told that one would be coming soon, and that SAP was currently testing. One month later, nothing. Anyone know anything? Should I not be concerned about the lack of a recent EBF?

Accepted Solutions (0)

Answers (3)

Answers (3)

jason_noack
Associate
Associate

The end of SQL Anywhere? This is news to me. As product owner I feel like I would probably know. The EOM, the absolute minimum maintenance date for SQL Anywhere has been pushed out to Dec. 31, 2028. This means that 17.0 SP1 will be supported by engineering at the very least until that date. The date doesn't get pushed out too far into the future because if a new version comes out we don't want to be held responsible to support two versions at the same time for too long.

The reason that this latest EBF has taken so long is that we've upgraded the compiler, gone through extensive testing and had to deal with a number of issues as a result. The windows patch is on the verge of being released as all testing has completed.

I hope this helps!

André_Schild
Explorer

Interesting.... About one year back we did read somewhere on a sap web page that SQL Anywhere 17 will be EOL in late 2025.

So if in the meantime SAP did change ideas about the product, it did not reach (part) of it's users.

But some kind of "long term comitment" from sap would be nice to have

jason_noack
Associate
Associate

I'm not sure where you saw that but it doesn't even make sense to have an EOL date before an EOM date. Perhaps you are referring to some SQLA OEM agreements being discontinued at the end of 2025. That statement had no implications on the SQLA EOM date and says nothing about a SQL Anywhere EOL date which has never been announced.

VolkerBarth
Contributor

As product owner I feel like I would probably know.

Jason, IMHO it would be helpful if SQL Anywhere product owner(s) and marketing people would post within this forum more frequently - several questions on the "SQL Anywhere Future" had been asked in the last year and were discussed by customers for weeks or months before an "official SAP answer" was posted (say, by Mike Paola).

Those were basically OEM-related questions, but it easily leaves the impression that all things SQL Anywhere-wise are about to going down slowly... - in that respect I share André's impression.

So I'm very thankful for your clarification.

wndstorm_sqlaf
Explorer

Jason, thanks for the clarification and the detail on the upcoming EBF, much appreciated!

MCMartin
Participant

Jason, it would be good to also share this concept inside SAP, because a lot of SAP sales representatives refer to the current EOM date as being really the end date for SQLA. So talking to them you always get the impression that after 2028 we wont have any SQLA anymore.

Michael_Fischer
Explorer

Hello Jason,

This is Michael Fischer. We have been the largest distributor of OEM licenses in Germany for almost decades, and as of today, we seem to be the last. There is significant uncertainty among our customers regarding the future of SQL Anywhere, and we would very much like to get in touch with you as the Product Manager to discuss this further. We would appreciate it if you could contact us via email at mifi@appfact.de.

Best regards, Michael Fischer

P.S. Best regards to Mike Paola.

VolkerBarth
Contributor
0 Kudos

Michael, I would be glad to hear about those results, too...

FWIW, I guess you can reach out to Jason Noack via the usual Firstname.Surname at sap.com...

chris_keating
Product and Topic Expert
Product and Topic Expert

SQL Anywhere 17.0 SP1 PL15 Build 7672 has been posted for Windows and Linux today.

wndstorm_sqlaf
Explorer

Thanks Chris! Question for you. Is there a reason why the associated KBA isn't updated the same day the new EBF is posted for download so that notifications would be sent to SAP For Me users that have that article "favorited"?

https://me.sap.com/notes/2381119

wndstorm_sqlaf
Explorer

Chris and Reg - noticing another 4+ months has passed since Build 7672. While this may be a bad assumption on my part, maybe the delay is due to the focus on the migration of the forum or other tasks? Regardless, any rough idea when we can expect a new update?

SVS_CH
Explorer

There will be an new EBF (17.0.11.7801) in ~7 weeks. This is what SAP told us: "we had to wait for some other fixes to go into the next SP for SQL Anywhere. We will make a new build this week and then QA will start doing tests. If we do not find show-stoppers then an new SP will be available in about 8 week. The time can be shorter, but we cannot be more accurate."

wndstorm_sqlaf
Explorer
0 Kudos

Thanks for passing that along SVS 🙂

chris_keating
Product and Topic Expert
Product and Topic Expert

We are currently working on providing patches for Windows and Linux. The build will be at least 17.0.11.7813.

wndstorm_sqlaf
Explorer

Looks like SQL Anywhere 17.0 SP1 PL16 Build 7820 has been posted for Windows and Linux today.

André_Schild
Explorer
0 Kudos

You did read about the end of sql anywhere, correct?

So this is how products are dying today, less and less investments in the qualtity of the product.

Should you be concerned, perhaps, but you must anyway have a plan on where to go with your database in the next 18 months.

We are currently sheduling the move from sql anywhere 17 to postgresql, and we are wondering what this will result performance wise, as we have many large tables in frequent use.

wndstorm_sqlaf
Explorer

I mean, I know there hasn't been a new major release in a while, but per:

https://help.sap.com/docs/SUPPORT_CONTENT/sqlany/3362971125.html

...isn't mainstream maintenance (which I believe would include security updates as it always has) available until December 2027?

Our use of the software is for an application that will hopefully be decommissioned in late 2025, but you never know.

VolkerBarth
Contributor

André, where did you read about the "end of SQL Anywhere"? Currently the EOL for SQL Anywhere is December 2027 (and it has been enhanced at least twice in the past), and according to SAP Product Availability Maxtrix, is even December 2028, see Chris Keating comment here...

(If you are relating to the OEM edition, that's another issue, but that seems to be in discussion, see that thread, too.)

wndstorm_sqlaf
Explorer

Thank you Volker for that clarification. We're not using the "OEM edition" and I do see now the SAP PAM does indeed say 12/31/2028 for SQL Anywhere 17.

With that aside, do you feel it's odd that's it's been this long without an EBF for Windows X64? I'm probably overthinking this, and it's probably stemming from us finally trying our best to stay on top of applying the latest EBF releases for security purposes.

VolkerBarth
Contributor

applying the latest EBF releases for security purposes

In my understanding, SQL Anywhere EBFs are usually more about "functional bug fixes" and/or adaptions to changes in third-party software and less about security fixes. The whole version 17 readme file, which lists fixes since its introduction in 2015, contains only a few security topics so I do not expect that EBFs have to be published frequently to deal with that. Just my 2 cents. 🙂

wndstorm_sqlaf
Explorer
0 Kudos

Yes, I agree, definitely more functional bug fixes. But, if there were a security issue to address, it would be in there I would assume. For example, an update to the embedded JVM.

regdomaratzki
Product and Topic Expert
Product and Topic Expert

The delay in the EBF release for SQL Anywhere 17.0 SP1 PL15 Build 7672, which is now available for Windows and Linux, was because of a change in compilers, which lead to a lengthy testing process.

If there was a security issue that had required us to publish a fix during this time, we have a a process where we go back to the source code for the last released EBF, apply the fix for the security issue (it's often a 3rd party component), and then rebuild and retest the software. Since there is very little that has changed, the testing of that change is typically straightforward. If you look back on the SQL Anywhere releases, you can spot a "security" release as it is typically one build higher than the previous release. You'll see that we released builds 7058 and 7059 for Linux and Windows, and build 7059 was a security release.

Reg

wndstorm_sqlaf
Explorer
0 Kudos

Thanks Reg!

MCMartin
Participant

Andre, please share your experience with Postgres, all alternatives I have looked into so far seem inferior to SQLA (at least for our use cases)

justin_willey
Participant

That's what's so frustrating - it's a great product but SAP just don't seem interested in promoting it.