Showing results for 
Search instead for 
Did you mean: 
Reply

Lookout Citadel Losing Data

Lookout Citadel Losing Data

One day we have data, the next it is gone.  No loss of quality signal.  Backups are made on daily basis have not fixed issue, as we cannot recover into the working database as we are not losing the quality, therefore it is present.

 

Attached screenshots using the ODBC report we created many years ago.  Works great on other machines.  Curiously, they print these regularly and have one day with all rows, then the next time they view the report, missing rows and they never come back.

 

Machine:

Windows XP SP3, Lookout 6.1 (50 IO)

 

 

 

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 1 of 13 (3,229 Views)
Highlighted

Re: Lookout Citadel Losing Data

Can you archive some days worth of data to a new database and upload it to ftp://ftp.ni.com/incoming?

And also tell me the SQL statement you use.

 

Ryan Shi
National Instruments
Message 2 of 13 (3,221 Views)

Re: Lookout Citadel Losing Data

Ryan,

Will be back at clients next week and will get the data for you.

 

Mike

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 3 of 13 (3,219 Views)

Re: Lookout Citadel Losing Data

Delays... Getting files as soon as possible

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 4 of 13 (3,175 Views)

Re: Lookout Citadel Losing Data

Uploading to incoming FTP is being blocked?

~10MB zip file

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 5 of 13 (3,144 Views)

Re: Lookout Citadel Losing Data

No. Try again.

Ryan Shi
National Instruments
Message 6 of 13 (3,139 Views)

Re: Lookout Citadel Losing Data

Database:  4SHK-020212.zip

Screenshots: 4SHK-020212-screenshots.zip

 

 

 

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 7 of 13 (3,090 Views)

Re: Lookout Citadel Losing Data

Ryan, any news?  Client has been dealing with this for over a year now.  

 

Tried new hardware (hard drive, mobo, ram).  

Made new databases.

Created daily archives that cannot replace missing data even if in archive!

 

Thanks,

Mike

 

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 8 of 13 (3,034 Views)

Re: Lookout Citadel Losing Data

Does the application use SQL statement to query the database? Does it use any function like MATH_XXX()?

 

Can you give me the lookout process? I want to know how you get the number that I see on the screenshot. We had a issue in SQL query when the MATH function is used.

 

 

Ryan Shi
National Instruments
Message 9 of 13 (3,024 Views)

Re: Lookout Citadel Losing Data

We use MATH_xxx alot.  We have not noticed this issue in other systems using the same process.

 

This is our SQL query:

 

"SELECT MATH_ETM(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BC"")), MATH_starts(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BC"")), MATH_stops(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BC"")), MATH_ETM(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BM"")), MATH_starts(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BM"")), MATH_stops(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BM"")), MATH_etm(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BS"")), MATH_starts(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BS"")), MATH_stops(TO_DISCRETE("""&\..\$System.MachineName&"/Server/"&..\..\SaveFiles\PumpsList.B.txt.1&"/BS"")) FROM IntData WHERE LocalTime BETWEEN '"&Year&"-"&Month&"-2' AND '"&if(Month=12,Year+1,Year)&"-"&if(Month=12,1,Month+1)&"-2' and IntInterval ='1'"

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
Message 10 of 13 (3,015 Views)