· 7 years ago · Oct 11, 2018, 06:12 AM
109:04:53,016 ERROR [sql] (ServerService Thread Pool -- 68) failed applying patch '2.2.2-21': org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [-- Function: create_or_update_function (className)
2CREATE TABLE IF NOT EXISTS public."ClassUpdateDate"
3()
4INHERITS (public."Class")
5WITH (
6 OIDS=FALSE
7);
8
9
10COMMENT ON TABLE public."ClassUpdateDate"
11 IS 'MODE: system|TYPE: class|DESCR: using for integrations|SUPERCLASS: false|STATUS: active';
12COMMENT ON COLUMN public."ClassUpdateDate"."Id" IS 'MODE: reserved';
13COMMENT ON COLUMN public."ClassUpdateDate"."IdClass" IS 'MODE: reserved';
14COMMENT ON COLUMN public."ClassUpdateDate"."Code" IS 'MODE: read|DESCR: Code|INDEX: 1|BASEDSP: true';
15COMMENT ON COLUMN public."ClassUpdateDate"."Description" IS 'MODE: read|DESCR: Description|INDEX: 2|BASEDSP: true';
16COMMENT ON COLUMN public."ClassUpdateDate"."Status" IS 'MODE: reserved';
17COMMENT ON COLUMN public."ClassUpdateDate"."User" IS 'MODE: reserved';
18COMMENT ON COLUMN public."ClassUpdateDate"."BeginDate" IS 'MODE: reserved';
19COMMENT ON COLUMN public."ClassUpdateDate"."Sys_owner" IS 'STRMASK: |STRREGEX: |STRERRMSG: |STATUS: active|BASEDSP: false|CLASSORDER: 0|DESCR: Org unit|GROUP: |SUBGROUP: |COLNUM: 0|ROWNUM: 0|LWIDTH: 0|FWIDTH: 0|INDEX: 3|HINTTXT: |VISIBLECONDITION: |REQUIREDCONDITION: |READONLYCONDITION: |EXTRADATA: |DEFAULTVALUE: |MODE: hidden|FIELDMODE: hidden';
20COMMENT ON COLUMN public."ClassUpdateDate"."_Status" IS 'STRMASK: |STRREGEX: |STRERRMSG: |STATUS: active|BASEDSP: false|CLASSORDER: 0|DESCR: Status|GROUP: |SUBGROUP: |COLNUM: 0|ROWNUM: 0|LWIDTH: 0|FWIDTH: 0|INDEX: 3|HINTTXT: |VISIBLECONDITION: |REQUIREDCONDITION: |READONLYCONDITION: |EXTRADATA: |DEFAULTVALUE: |MODE: hidden|FIELDMODE: hidden';
21COMMENT ON COLUMN public."ClassUpdateDate"."Inactive" IS 'STRMASK: |STRREGEX: |STRERRMSG: |STATUS: active|BASEDSP: false|CLASSORDER: 0|DESCR: Inactive|GROUP: |SUBGROUP: |COLNUM: 0|ROWNUM: 0|LWIDTH: 0|FWIDTH: 0|INDEX: 3|HINTTXT: |VISIBLECONDITION: |REQUIREDCONDITION: |READONLYCONDITION: |EXTRADATA: |DEFAULTVALUE: |MODE: hidden|FIELDMODE: hidden';
22
23
24
25
26CREATE OR REPLACE FUNCTION public.create_or_update_function (className varchar(40))
27RETURNS void AS
28$body$
29DECLARE
30 view_row "public"."ClassUpdateDate";
31 id integer = _cm_new_card_id();
32 oid oid = (SELECT oid FROM pg_class WHERE relname = 'ClassUpdateDate');
33 currentDate TIMESTAMP = (SELECT CURRENT_TIMESTAMP);
34BEGIN
35 UPDATE "public"."ClassUpdateDate"
36 SET "BeginDate" = currentDate
37 WHERE "Description" = className
38 RETURNING "Id" INTO view_row;
39 IF view_row."Id" IS NULL THEN
40 INSERT INTO "ClassUpdateDate"("Id","IdClass","Code","Description","Status","User","BeginDate","Sys_owner","_Status","Inactive")
41 VALUES (id,oid,'',className,'A','',currentDate,'','',false);
42 END IF;
43END;
44$body$
45LANGUAGE 'plpgsql'
46VOLATILE
47COST 10;
48
49]; nested exception is org.postgresql.util.PSQLException: ERROR: column "_Status" of relation "public.ClassUpdateDate" does not exist
50 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
51 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
52 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
53 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
54 at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:413)
55 at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:437)
56 at org.cmdbuild.services.DefaultPatchManager$2.doInTransactionWithoutResult(DefaultPatchManager.java:261)
57 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)
58 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
59 at org.cmdbuild.services.DefaultPatchManager.applyPatch(DefaultPatchManager.java:256)
60 at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:245)
61 at org.cmdbuild.spring.configuration.Startup$1.start(Startup.java:45)
62 at org.cmdbuild.services.startup.DefaultStartupManager.start(DefaultStartupManager.java:27)
63 at org.cmdbuild.services.startup.DefaultStartupLogic.earlyStart(DefaultStartupLogic.java:21)
64 at org.cmdbuild.plugins.CMDBInitListener.contextInitialized(CMDBInitListener.java:28)
65 at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
66 at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:215)
67 at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:184)
68 at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)
69 at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
70 at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
71 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
72 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
73 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
74 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
75 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
76 at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:249)
77 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:96)
78 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:78)
79 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
80 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
81 at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
82 at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
83 at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
84 at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)
85 at java.lang.Thread.run(Thread.java:748)
86 at org.jboss.threads.JBossThread.run(JBossThread.java:485)
87Caused by: org.postgresql.util.PSQLException: ERROR: column "_Status" of relation "public.ClassUpdateDate" does not exist
88 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
89 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
90 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
91 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
92 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
93 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
94 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
95 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
96 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
97 at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
98 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
99 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
100 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
101 at java.lang.reflect.Method.invoke(Method.java:498)
102 at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:412)
103 at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:137)
104 at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:294)
105 at com.sun.proxy.$Proxy305.execute(Unknown Source)
106 at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:429)
107 at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
108 ... 32 more
109
11009:04:53,023 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 68) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./platform: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./platform: java.lang.RuntimeException: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH
111 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:81)
112 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
113 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
114 at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
115 at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
116 at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
117 at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)
118 at java.lang.Thread.run(Thread.java:748)
119 at org.jboss.threads.JBossThread.run(JBossThread.java:485)
120Caused by: java.lang.RuntimeException: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH
121 at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:251)
122 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:96)
123 at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:78)
124 ... 8 more
125Caused by: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH
126 at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:59)
127 at org.cmdbuild.services.DefaultPatchManager.applyPatch(DefaultPatchManager.java:270)
128 at org.cmdbuild.services.DefaultPatchManager.applyPatchList(DefaultPatchManager.java:245)
129 at org.cmdbuild.spring.configuration.Startup$1.start(Startup.java:45)
130 at org.cmdbuild.services.startup.DefaultStartupManager.start(DefaultStartupManager.java:27)
131 at org.cmdbuild.services.startup.DefaultStartupLogic.earlyStart(DefaultStartupLogic.java:21)
132 at org.cmdbuild.plugins.CMDBInitListener.contextInitialized(CMDBInitListener.java:28)
133 at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
134 at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:215)
135 at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:184)
136 at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)
137 at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
138 at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
139 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
140 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
141 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
142 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
143 at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1526)
144 at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:249)
145 ... 10 more
146
14709:04:53,030 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "platform-war.war")]) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.undertow.deployment.default-server.default-host./platform" => "java.lang.RuntimeException: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH
148 Caused by: java.lang.RuntimeException: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH
149 Caused by: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH"}}
15009:04:53,064 INFO [org.jboss.as.server] (ServerService Thread Pool -- 37) WFLYSRV0010: Deployed "platform-war.war" (runtime-name : "platform-war.war")
15109:04:53,066 INFO [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
152WFLYCTL0186: Services which failed to start: service jboss.undertow.deployment.default-server.default-host./platform: java.lang.RuntimeException: org.cmdbuild.exception.ORMException: ORM_SQL_PATCH
153
15409:04:53,295 INFO [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0212: Resuming server
15509:04:53,297 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://0.0.0.0:9990/management
15609:04:53,298 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://0.0.0.0:9990