Search This Blog

Thursday, April 25, 2024

MAS - JDBC error in MAS Core Suite Admin

 In suite administration, configuration section user gets an error related to database connection.


Error snippet:
Error: Message: JDBC configuration was unable to be verified: [IBM][CLI Driver][DB2/LINUXX8664] SQL0601N The name of the object to be created is identical to the existing name "DB2INST1.MYTESTTABLE" of type "TABLE". SQLSTATE=42710 SQLCODE=-601


An attempt to name an object failed because the name is already in use for an object of the same type.

Answer

DB2INST1.MYTESTTABLE table can be drop as it plays no role here.

Below is the command to drop table:
$ db2 drop table DB2INST1.MYTESTTABLE

For more information on SQLCODE=-601:
https://www.ibm.com/docs/en/db2-for-zos/11?topic=codes-601


No comments:

Post a Comment

Error 'Unable to connect to server' is displayed when you run a task that prompts for server restart

  Problem On Windows system, when you select a task that requires a server restart in Administration Services UI, and run that task, the tas...