LogViewPlus Support » LogViewPlus Support » Help & Support » Database connection - Insufficient column mappings

Database connection - Insufficient column mappings

morten — Mon, 07 Jun 2021 11:06:42 GMT

When I add a data source I got the error after connectiong to database -> "Insufficient column mappings -a minimum of two columns are required.", but in the column list it is listed 6 columns.

RE: Database connection - Insufficient column mappings

LogViewPlus Support — Mon, 07 Jun 2021 11:06:42 GMT

Glad that helped - thanks for letting me know Morten.

I will take a look at that error message for the next release. I think we can make it more clear.

Thanks again,

Toby

RE: Database connection - Insufficient column mappings

morten — Mon, 07 Jun 2021 11:03:50 GMT

Thanks, it was that the timestamp was not on correct format. Thanks for fast reply!

RE: Database connection - Insufficient column mappings

LogViewPlus Support — Mon, 07 Jun 2021 10:46:45 GMT

Hi Morten,

Thanks for reporting this issue. I am unfortunately unable to recreate this problem locally.

This error message is somewhat deceptive as it is displayed when:
1. There are less than two visible columns.
2. A timestamp column has not been identified.

From the screenshot, it looks like neither of these situations is a problem here. Can you please confirm that you are using the latest version of LogViewPlus (v2.5.14 or greater)? Also, please try navigating between the tabs after making column changes - maybe the grid updates have not been saved?

Finally, what is the underlying data type of the Timestamp field (as defined in the database)?

Thanks,

Toby