Does migrating database to 7.8 change the structure or ? of the database?

[Former Member]

Good Morning Community,

I had migrated Maxdb Database from 7.6 to 7.8 and i realize the dbmcli connect to the database but he prints this error when i execute my usual queries:

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name or unknown schema:FILIALEN

what's happen? i check with an other application it uses the java sap driver of maxdb 7.6 it works but the queries work for some privelege account not all the account those queries must work by all the account

Need Help to find out Maxdb 7.8

[lbreddemann]

Why do you execute queries with DBMCLI ?

DBMCLI is a Database Management server CLIent.

For SQL queries, use SQLcli !

And based on the error message I've got the impression that you're logging on to the database with an SQL user that is not the owner of the tables.

Therefore, you're SQL statements (which we would have to see for more detailed analysis of your problem) would have to specify the schema of the tables you're selecting data from.

But all this has not changed from MaxDB 7.6 to 7.8!

The upgrade does not re-define your database contents.

regards,

Lars

[Former Member]

Ok thank you, in my database there is a number of user and when i logg with one of them i need to mention the schema, why it works in 7.6 and even when i update to 7.7 i didnt need to mention the schema

Is there any way to make a default schema for all users??