Database connection - Insufficient column mappings


Author
Message
morten
morten
New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)
Group: Forum Members
Posts: 2, Visits: 3
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.


Attachments
logviewplus-issue.jpg (188 views, 38.00 KB)
LogViewPlus Support
LogViewPlus Support
Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)
Group: Moderators
Posts: 1.1K, Visits: 3.8K
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
morten
morten
New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)New Member (13 reputation)
Group: Forum Members
Posts: 2, Visits: 3
Thanks, it was that the timestamp was not on correct format. Thanks for fast reply!
LogViewPlus Support
LogViewPlus Support
Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)Supreme Being (6.1K reputation)
Group: Moderators
Posts: 1.1K, Visits: 3.8K
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
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Login

Explore
Messages
Mentions
Search