MiraPool1#localhost 2017-10-17 17:42:28.789 [http://localhost:8081/lms System] ERROR(org.springframework.scheduling.support.TaskUtils$LoggingErrorHandler): Unexpected error occurred in scheduled task.
java.lang.IllegalStateException: Error on run task 1843 of 1994: ORM.init
	at org.mirapolis.host.HostTask.run(HostTask.java:29)
	at org.mirapolis.host.HostExecutor.runTasks(HostExecutor.java:105)
	at org.mirapolis.multitenancy.MultiTenantHostExecutor.runTasks(MultiTenantHostExecutor.java:161)
	at org.mirapolis.multitenancy.MultiTenantHostExecutor.access$500(MultiTenantHostExecutor.java:24)
	at org.mirapolis.multitenancy.MultiTenantHostExecutor$1.run(MultiTenantHostExecutor.java:142)
	at org.mirapolis.core.Context.runInSystemContext(Context.java:440)
	at org.mirapolis.multitenancy.ContextHostResolverProvider$1.run(ContextHostResolverProvider.java:26)
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.mirapolis.exception.CoreException: org.mirapolis.orm.ddl.ExecScriptException: Error on exec sql:ALTER TABLE public.hr$vaccondition ADD CONSTRAINT FK_632037401025875 FOREIGN KEY (employmenttypeid) REFERENCES public.vv$employmenttype (rsid)  ON DELETE RESTRICT
	at org.mirapolis.orm.ddl.DDLUpdater.execute(DDLUpdater.java:557)
	at org.mirapolis.orm.ORM.makeUpdatesForChangedObjects(ORM.java:103)
	at org.mirapolis.orm.ORM.init(ORM.java:75)
	at org.mirapolis.configuration.SystemConfigurator$1.run(SystemConfigurator.java:68)
	at org.mirapolis.host.HostTask.run(HostTask.java:27)
	... 14 more
Caused by: org.mirapolis.orm.ddl.ExecScriptException: Error on exec sql:ALTER TABLE public.hr$vaccondition ADD CONSTRAINT FK_632037401025875 FOREIGN KEY (employmenttypeid) REFERENCES public.vv$employmenttype (rsid)  ON DELETE RESTRICT
	at org.mirapolis.orm.ddl.Script.execStmt(Script.java:49)
	at org.mirapolis.orm.ddl.SimpleScript.onSQLException(SimpleScript.java:66)
	at org.mirapolis.orm.ddl.CreateFkScript.onSQLException(CreateFkScript.java:36)
	at org.mirapolis.orm.ddl.Script.execute(Script.java:37)
	at org.mirapolis.orm.ddl.DDLUpdater.execute(DDLUpdater.java:533)
	at org.mirapolis.orm.ddl.DDLUpdater.execute(DDLUpdater.java:551)
	... 18 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "hr$vaccondition" violates foreign key constraint "fk_632037401025875"
  Detail: Key (employmenttypeid)=(39) is not present in table "vv$employmenttype".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
	at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
	at org.mirapolis.orm.ddl.Script.execStmt(Script.java:47)
	... 23 more