on 10-21-2021 4:17 PM
Hi guys.
I created a new database in SQL Anywhere 17 (installed on Windows).
In the creation wizard I have left practically all the default settings.
The database has been created but now, if I am disconnected from the database and I single click on its icon I get the following error:
The curious thing is that, if I right click, I can easily connect to the database and everything seems to work correctly.
I have created, on this DB, a new SAP Data Services repository and I have not encountered any problems, however, not being an SQL Anywhere expert, I do not know if this error can hide other pitfalls.
I tried to apply SAP Note 2489450 but it didn't solve the problem.
Can anyone help me ?
Than you very much guys.
Best regards.
You need to update SQL Central. I have no idea when the fix was made. But I have tested with several later versions of SQL Central including 17.0.8.4103 and cannot reproduce the behavior.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This issue appears to have been fixed since the GA release of SQL Anywhere. I would recommend that you upgrade to the latest SP. There are also security reasons not be running GA - a number of updates to components that had security vulnerabilities have been made.
The issue is that sp_displayroles is added when in v16 and later role based security model feature. SQL Central would execute that statement on the first database running on the server. If that database was not v16 (initialized or upgraded), the statement would not exist and hence the error that is reported. I cannot identify a specific fix for this but testing with current SP did not execute that query against the SA12 database being tested.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris
thank you very much for your answer.
Currently I am using SQL Anywhere database version 17.0.8.4103 and SQL AW Central version 17.0.0.1062.
SQL Anywhere database is at this version because it is the one automatically installed by the last upgrade that was made to the SAP BO / DS platform.
Are you advising me to manually update the database or client tool (SQL AW Central)?
I ask because I would prefer not to do manual upgrades as this database is bundled with SAP Business Objects and SAP Data Services products.
Of course, updating the client tool would be much easier.
Thank you very much.
Kind regards.
HI,
i also get the same error, does anyone have a solution?
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.