MAX times out when exporting data to TXT

[F Heatherly]

We are having trouble getting the data out of Lookout.

We have to send clients the tabular data of the temperatures each week. We have the database connected to an Access database and until this week this method worked wonderfully. We get an error stating that the ODBC connection failed. I tried to disconnect the tables and link them and still nothing. I even created a whole new database and started all over again and still nothing.

So I tried to get the data out of MAX and export the data to a .TXT file, it gets to 1% and then says "Operation Timed Out" and will not go any further. I get this message only about 1 minute into the export.

I have tried getting the data out through Excel also, but to no avail.

Are there any other methods of obtaining the data? It is vital we be able to extract this data.

[Ryan.S]

Do you log the data into NI Citadel database? How do you have the database connected to the Access database?

If you create a new Citadel database in MAX, and let Lookout log data to the new one, can you view the data in MAX? The new database should work if the old one is corrupted.

If you cannot view the data in MAX, you can not export it. The database may have something wrong.

[F Heatherly]

It appears that a portion of the data, for the timeframe I was running the report for, may be corrupt. I was able to run the report for 4/16, but then I had to skip 4/17-4/19, but then from 4/20 on, the data is fine.

I looked in the Event Viewer and there doesn't appear to be any errors that would have caused the data to be corrupt.

[Ryan.S]

Create a new database, and try to archive 4/17~4/19 data, and see if the archive will succeed.

One or more database files are corrupted, which may not generate error in event viewer.

What's your lookout version? If it's 4.x or 5.x, take a look at this kb. Follow it to fix the database.

http://digital.ni.com/public.nsf/allkb/6FC62F75B74D706D8625694900768F69?OpenDocument

But if the file is corrupted, I think you have to lose some data.

[F Heatherly]

We are on version 6.1. I already tried to archive the database to and the archive database will not work either.

I guess the data is unretrievable.

Thanks anyway