Reopening this bug. The SQL syntax generated for the create table statement does not handle groupset names with spaces e.g. "Group Set A" would simply be converted to a column with the name "Group Set A" which is not accepted in SQL. In stead the column name should be Group_Set_A" or use some other smart way of getting rid of the spaces in the names.
I got the following SQL for my test with the SL database, notice "Local Council" as one of the column names: CREATE TABLE orgunitgroupsetexclusivestructure ( organisationunitid INTEGER NOT NULL, Local Council VARCHAR (50), Mission VARCHAR (50), NGO VARCHAR (50), Ownership VARCHAR (50), Private VARCHAR (50), Public VARCHAR (50), Type VARCHAR (50), PRIMARY KEY ( organisationunitid ) ); (these group sets does not make sense to me as they look for like groups, but the bug is still valid...) Would also like to add that we need a similar table for exclusive data element group sets. -- Exclusive group set structure fails https://bugs.launchpad.net/bugs/423949 You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. Status in DHIS 2 - District Health Information Software: In Progress Bug description: Exclusive group set structure fails _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
