7.3 Community - Reports not working

We tried to make LogicalDOC as intuitive as possible, but an advice is always welcome.

Moderator: car031

HawkHogan
Posts: 4
Joined: Tue Feb 04, 2014 12:20 am

7.3 Community - Reports not working

Mon Oct 26, 2015 5:10 pm

I have a clean 7.3 install of the community edition, and the Reports functionality is not working.

In the dms.log file, anytime I run a report, I'm getting:

Code: Select all

org.hibernate.exception.SQLGrammarException: Table  "ld73.ld_workflowhistory" doesn't exist 
I'm on mysql. The ld_history table has the available data. Could someone provide the MySQL table create for ld_workflowhistory for 7.3 so I can use the reporting function?

Thanks
car031
Posts: 154
Joined: Tue Apr 17, 2012 8:27 am

Re: 7.3 Community - Reports not working

Mon Oct 26, 2015 5:41 pm

Sure, here you go:

create table ld_workflowhistory (ld_id bigint not null, ld_lastmodified timestamp not null, ld_recordversion bigint not null,
ld_deleted int not null, ld_tenantid bigint not null, ld_date timestamp, ld_event varchar(255),
ld_comment varchar(4000), ld_docid bigint, ld_userid bigint,
ld_username varchar(255), ld_templateid bigint not null,
ld_instanceid varchar(255), ld_sessionid varchar(255),
ld_new int, ld_filename varchar(255), primary key (ld_id));
HawkHogan
Posts: 4
Joined: Tue Feb 04, 2014 12:20 am

Re: 7.3 Community - Reports not working

Tue Oct 27, 2015 5:29 pm

Thanks, that did it!

Return to “Usage”

Who is online

Users browsing this forum: No registered users and 23 guests