When storing data into the reports database, the first time the Report command (or the Report activity in a workflow) is executed, it creates the database table defined into its ReportOptions configuration and fills in with the retrieved statistics data.

The next time it is executed, the Report command verifies that the table already exists and so it simply inserts new data into the table (see Duplicated data).

Note that if you change the ReportOptions, for example, by adding a column, then you get an Invalid column name SQL error, because the Report command tries to store data into a missing column. To solve it you can:

•Delete and re-create the whole reports database

In that way you lose all the statistics data already stored into the reports database. To re-fill the database you have to re-run again the wf_GN4Report.xml workflow on the old GN4 objects you have already processed.

•Modify the sql table manually, running the “ALTER TABLE…” sql statement

In that way the wf_GN4Report.xml workflow works, but all the old statistics data rows (already stored into the reports database) will have the new column empty, until you re-run again the wf_GN4Report.xml workflow on the old GN4 objects you have already processed.