I am left joining the LTV Tables to my RunningTables.on UserID. And I can't seem to get it to load onto Tableau. Not through extract data, or even purely visualization.
It shows "Loading Data source for the first time.Load time may vary..." for a few hours before everything crashes. Is this because my file is too large? I don't think that's right, since I know others who have used files with over 12 GB with no issue.
This is the message I get when the extract fails.
[-8] PQresultStatus: 7 ERROR: unable to create database '//tsclient/D/LTV.hyper': unable to grow database file "\\?\UNC\tsclient\D\LTV.hyper": MapViewOfFileEx(): The handle is invalid [SQL State: 58000] [Severity: ERROR] [Primary message: unable to create database '//tsclient/D/LTV.hyper': unable to grow database file "\\?\UNC\tsclient\D\LTV.hyper": MapViewOfFileEx(): The handle is invalid]
RunningTables.txt (Main) 7.64GB over a billion rows
LTVTables.csv 137.6MB
Well, the error is telling you that the hyper process is hitting a file size limitation. So, I would suggest opening a support case and submitting some logs (from either Desktop or Prep - you don't way which one you're using).
