Not able to connect with DB from DevOps

General Discussion
1

I am seeing following error from Azure Piplines:

ERROR: Exception Details

ERROR: Exception Primary Class: SqlSyntaxErrorException

ERROR: Exception Primary Reason: DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=userid;CREATE TABLE, DRIVER=4.33.31

ERROR: Exception Primary Source: DB2/LINUXX8664 SQL1005B

Unexpected error running Liquibase: DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=userid;CREATE TABLE, DRIVER=4.33.31 [Failed SQL: (-552) CREATE TABLE “userid”.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))]

Please suggest

we have provdied proper database and url details in the liquibase validate command

2

Your user does not have permissions to create tables on the database.
The operation fails because the user does not have the authority on the database to issue the command.

If userid is your database you might need to try running something like the following SQL on your databse first:
GRANT ALL PRIVILEGES ON userid.* TO ‘<your_user_name_here>’@‘localhost’ WITH GRANT OPTION;

3

  1. Are you referring user id as database identity?

We use function id for database, so do we need to add function id in place of database name in the command ?

Can we add above cmd in liquibase Powershell task in azure devops and verify ?

4

Are you referring user id as database identity?

No. AFAIK the identity is not the name. I have not used the database identity I have always used the database name.

We use function id for database, so do we need to add function id in place of database name in the command ?

If I understand you correctly. No you need to use the actual database name. “Grant” is a SQL command.

Can we add above cmd in liquibase Powershell task in azure devops and verify ?

The the user using the “Grant” command needs root or Administrator access to give access to the Liquibase user.
You or your DBA would first have to “GRANT” the access rights “PRIVILEGES” to your Liquibase user.

You can also only grant specific rights or privileges like CREATE ALTER INDEX etc… ALL is a very shotgun approach and would not be advised on a public DB.

5

We tried above step, now we are seeing following error:

ERROR: Exception Primary Class: SqlSyntaxErrorException
ERROR: Exception Primary Reason: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=USER.DATABASECHANGELOG;ALIAS, DRIVER=4.33.31
ERROR: Exception Primary Source: DB2/LINUXX8664 SQL110590