AdminException after changing depricated Floats to Decimals

0
Hi peeps I am experiencing an error I do not understand. I was changing floats to decimals to prepare for a MX 7 upgrade when suddenly the model doesnt run. More precicly; the SQL script containing the changes will not execute.   Anyone experienced something similar?   An error occurred while executing action 'Execute DDL commands'. -------- com.mendix.m2ee.api.AdminException: Executing DDL commands for component MyFirstComponent failed.  at com.mendix.core.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:127) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Error (SQL State: S0001, Error Code: 15336) on executing: EXEC sp_rename '[applicationadministration$product].[criteriamax]', '25e1d5f80e294cdfaa8feac184830294', 'COLUMN' All changes are rolled back.  at com.mendix.connectionbus.modelsynchronization.DDLCommandExecutor.execute(DDLCommandExecutor.java:77) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Object '[applicationadministration$product].[criteriamax]' cannot be renamed because the object participates in enforced dependencies.  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)  at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)  at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)  at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)  at com.mendix.connectionbus.modelsynchronization.DDLCommandExecutor.executeDDLCommands(DDLCommandExecutor.java:117)  at com.mendix.connectionbus.modelsynchronization.DDLCommandExecutor.execute(DDLCommandExecutor.java:41)  at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.synchronizeModel(SynchronizationManager.scala:134)  at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.executeImpl(SynchronizationManager.scala:125)  at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.execute(SynchronizationManager.scala:75)  at com.mendix.connectionbus.ConnectionBusImpl.executeDDLCommands(ConnectionBusImpl.java:398)  at com.mendix.core.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:124)  at com.mendix.core.impl.MxRuntimeImpl.executeDDLCommands(MxRuntimeImpl.java:872)  at com.mendix.core.action.admin.ExecuteDDLCommandsAction.call(ExecuteDDLCommandsAction.java:27)  at com.mendix.core.action.admin.RuntimeAdminAction$1.execute(RuntimeAdminAction.java:23)  at com.mendix.core.action.admin.RuntimeAdminAction$1.execute(RuntimeAdminAction.java:20)  at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)  at com.mendix.util.classloading.Runner$1.run(Runner.java:25)  at java.security.AccessController.doPrivileged(Native Method)  at com.mendix.util.classloading.Runner.runUsingClassLoaderOf(Runner.java:21)  at com.mendix.core.action.admin.RuntimeAdminAction.execute(RuntimeAdminAction.java:25)  at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122)  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)  at org.eclipse.jetty.server.Server.handle(Server.java:368)  at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)  at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)  at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)  at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)  at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)  at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)  at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)  at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)  at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)  at java.lang.Thread.run(Thread.java:748)  
asked
1 answers
0

Marius,

The issue in the script is that there seem to be enforced dependencies for the column that you are trying to rename.

See here for more information on the error: https://solutioncenter.apexsql.com/rename-column-without-breaking-sql-database/

Hope that with this information you'll be able to perform the script manually.

answered