New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

History tables missing #2228

Closed
sujithgeorge opened this Issue Dec 2, 2018 · 11 comments

Comments

6 participants
@sujithgeorge
Copy link

sujithgeorge commented Dec 2, 2018

I am using Activiti 7.0.0.Beta3 core (and not cloud) in my Spring Boot application. I enabled history by setting spring boot config property: spring.activiti.historyLevel=full. When I start Activiti , it fails by reporting a missing table "Table '.ACT_HI_VARINST' doesn't exist". I have auto DDL enabled(I know this for sure because the other non-history Activiti tables got created automatically). What should I do to get all the history tables created automatically? I was expecting it to be driven by the spring.activiti.historyLevel, but apparently it doesn't.

@salaboy salaboy added this to Open in Activiti 7.x via automation Dec 3, 2018

@salaboy salaboy added this to the Beta5 milestone Dec 3, 2018

@salaboy

This comment has been minimized.

Copy link
Member

salaboy commented Dec 3, 2018

@sujithgeorge as I mention on the gitter channel we discourage the use of Local History, but we will look into this issue to at least not fail. Moving forward this might NOT be supported.

@ryandawsonuk

This comment has been minimized.

Copy link
Member

ryandawsonuk commented Dec 6, 2018

@sujithgeorge could you try also setting spring.activiti.isDbHistoryUsed to true?

@salaboy salaboy modified the milestones: Beta5, RC1 Dec 13, 2018

@ryandawsonuk

This comment has been minimized.

Copy link
Member

ryandawsonuk commented Jan 7, 2019

@sujithgeorge did that work for you? Please do let us know if you're still having trouble

@salaboy salaboy modified the milestones: RC1, RC2 Jan 8, 2019

@salaboy

This comment has been minimized.

Copy link
Member

salaboy commented Jan 17, 2019

closing due inactivity, if this is still a problem after testing @ryandawsonuk suggestion we can reopen

@salaboy salaboy closed this Jan 17, 2019

Activiti 7.x automation moved this from Open to Closed Jan 17, 2019

@ryandawsonuk ryandawsonuk reopened this Jan 22, 2019

Activiti 7.x automation moved this from Closed to Open Jan 22, 2019

@prajwal11

This comment has been minimized.

Copy link

prajwal11 commented Jan 22, 2019

I am using Activiti 7 core in my spring boot application and I tried enabling spring.activiti.historyLevel=full but this dint create history tables in activiti 7 database.I also tried enabling spring.activiti.isDbHistoryUsed=true and even that dint create any database.Is there anything else that should be enabled?

@homeant

This comment has been minimized.

Copy link

homeant commented Jan 23, 2019

very good

@salaboy

This comment has been minimized.

Copy link
Member

salaboy commented Jan 23, 2019

@prajwal11 thanks a lot for confirming that the proposed work around doesn't work .. we will look into it and fix it before GA

@daisuke-yoshimoto

This comment has been minimized.

Copy link
Member

daisuke-yoshimoto commented Jan 28, 2019

I created pr for fixing thie issue.
#2423

@prajwal11

This comment has been minimized.

Copy link

prajwal11 commented Jan 28, 2019

Thanks a lot for fixing the issue.Adding spring.activiti.dbHistoryUsed = true and spring.activiti.historyLevel=audit will create history tables and is storing all the data is proper format.

@salaboy

This comment has been minimized.

Copy link
Member

salaboy commented Jan 28, 2019

This fix will be included in the GA release.

@salaboy salaboy closed this in 230b3ff Feb 5, 2019

salaboy added a commit that referenced this issue Feb 5, 2019

Activiti 7.x automation moved this from Open to Closed Feb 5, 2019

@salaboy

This comment has been minimized.

Copy link
Member

salaboy commented Feb 5, 2019

merged

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment