wso2/product-apim

Error when run <API-M_HOME>/dbscripts/mssql.sql "There is already an object named 'AM_APPLICATION_REGISTRATION' in the database."

kwalker78 opened this issue · 0 comments

This error has occured when try to run <API-M_HOME>/dbscripts/mssql.sql script and default db schema not is DBO.

The script contains the creation of the AM_APPLICATION_REGISTRATION table twice, but check exists in DBO schema
IF NOT EXISTS (SELECT * FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[AM_APPLICATION_REGISTRATION]') AND TYPE IN (N'U'))