How to remove data that is in the future

[Cino]

Somehow I have data in the DB that is in future. How can I remove this data without removing current data?

here is an export of the data:

C:\Users\Administrator>"C:\Program Files (x86)\Java\jre7\bin\java.exe" -jar "D:\its-electric\its-electric-1.8.jar" -d D:\its-electric\Database --export 2014-01 2037-02 1
Dec 01, 2013 10:38:56 AM org.tupelo_schneck.electric.Main openEnvironment
INFO: Environment opened.
2036-02-07 01:28:16-0500,1,1041,124.3,748
2036-02-07 01:28:16-0500,2,0,123.7,89
2036-02-07 01:28:17-0500,1,1041,124.3,1076
2036-02-07 01:28:17-0500,2,0,123.7,14
2036-02-07 01:28:18-0500,1,1041,124.3,743
2036-02-07 01:28:18-0500,2,0,123.65,89
2036-02-07 01:28:19-0500,1,1041,124.3,1076
2036-02-07 01:28:19-0500,2,0,123.65,14
2036-02-07 01:28:20-0500,1,1041,124.3,743
2036-02-07 01:28:20-0500,2,0,123.65,89
2036-02-07 01:28:21-0500,1,1041,124.3,1076
2036-02-07 01:28:21-0500,2,0,123.65,14
2036-02-07 01:28:22-0500,1,1043,124.25,740
2036-02-07 01:28:22-0500,2,0,123.65,89
2036-02-07 01:28:23-0500,1,1043,124.25,1078
2036-02-07 01:28:23-0500,2,0,123.6,14
2036-02-07 01:28:24-0500,1,1043,124.25,740
2036-02-07 01:28:24-0500,2,0,123.6,89
2036-02-07 01:28:25-0500,1,1043,124.25,1078
2036-02-07 01:28:25-0500,2,0,123.6,14
2036-02-07 01:28:26-0500,1,1043,124.25,740
2036-02-07 01:28:26-0500,2,0,123.6,89
2036-02-07 01:28:27-0500,1,1040,124.15,1076
2036-02-07 01:28:27-0500,2,0,123.6,14
2036-02-07 01:28:28-0500,1,1040,124.15,737
2036-02-07 01:28:28-0500,2,0,123.6,89
2036-02-07 01:28:29-0500,1,1040,124.15,1076
2036-02-07 01:28:29-0500,2,0,123.5,14
2036-02-07 01:28:30-0500,1,1040,124.15,737
2036-02-07 01:28:30-0500,2,0,123.5,89
2036-02-07 01:28:31-0500,1,1040,124.15,1076
2036-02-07 01:28:31-0500,2,0,123.5,14
2036-02-07 01:28:32-0500,1,1040,124.2,738
2036-02-07 01:28:32-0500,2,0,123.5,89
2036-02-07 01:28:33-0500,1,1040,124.2,1075
2036-02-07 01:28:33-0500,2,0,123.55,13
2036-02-07 01:28:34-0500,1,1040,124.2,738
2036-02-07 01:28:34-0500,2,0,123.55,89
2036-02-07 01:28:35-0500,1,1040,124.2,1075
2036-02-07 01:28:35-0500,2,0,123.55,13
2036-02-07 01:28:36-0500,1,1040,124.2,738
2036-02-07 01:28:36-0500,2,0,123.55,89
2036-02-07 01:28:37-0500,1,1042,124.2,1077
2036-02-07 01:28:37-0500,2,0,123.55,13
2036-02-07 01:28:38-0500,1,1042,124.2,735
2036-02-07 01:28:38-0500,2,0,123.6,89
2036-02-07 01:28:39-0500,1,1042,124.2,1077
2036-02-07 01:28:39-0500,2,0,123.6,14
2036-02-07 01:28:40-0500,1,1042,124.2,735
2036-02-07 01:28:40-0500,2,0,123.6,89
2036-02-07 01:28:41-0500,1,1042,124.2,1077
2036-02-07 01:28:41-0500,2,0,123.6,14
2036-02-07 01:28:42-0500,1,1041,124.15,739
2036-02-07 01:28:42-0500,2,0,123.6,89
2036-02-07 01:28:43-0500,1,1041,124.15,1076
2036-02-07 01:28:43-0500,2,0,123.55,14
2036-02-07 01:28:44-0500,1,1041,124.15,739
2036-02-07 01:28:44-0500,2,0,123.55,89
2036-02-07 01:28:45-0500,1,1041,124.15,1076
2036-02-07 01:28:45-0500,2,0,123.55,14
2036-02-07 01:28:46-0500,1,1041,124.15,739
2036-02-07 01:28:46-0500,2,0,123.55,89
2036-02-07 01:28:47-0500,1,1039,124.25,1074
2036-02-07 01:28:47-0500,2,0,123.55,14
2036-02-07 01:28:48-0500,1,1039,124.25,739
2036-02-07 01:28:48-0500,2,0,123.65,89
2036-02-07 01:28:49-0500,1,1039,124.25,1074
2036-02-07 01:28:49-0500,2,0,123.65,14
2036-02-07 01:28:50-0500,1,1039,124.25,739
2036-02-07 01:28:50-0500,2,0,123.65,89
2036-02-07 01:28:51-0500,1,1039,124.25,1074
2036-02-07 01:28:51-0500,2,0,123.65,14
2036-02-07 01:28:52-0500,1,1041,124.25,738
2036-02-07 01:28:52-0500,2,0,123.65,89
2036-02-07 01:28:53-0500,1,1041,124.25,1076
2036-02-07 01:28:53-0500,2,0,123.65,14
2036-02-07 01:28:54-0500,1,1041,124.25,738
2036-02-07 01:28:54-0500,2,0,123.65,89
2036-02-07 01:28:55-0500,1,1041,124.25,1076
2036-02-07 01:28:55-0500,2,0,123.65,14
2036-02-07 01:28:56-0500,1,1041,124.25,738
2036-02-07 01:28:56-0500,2,0,123.65,89
2036-02-07 01:28:57-0500,1,1041,124.25,1073
2036-02-07 01:28:57-0500,2,0,123.65,14
2036-02-07 01:28:58-0500,1,1038,124.2,734
2036-02-07 01:28:58-0500,2,0,123.65,89
2036-02-07 01:28:59-0500,1,1038,124.2,1073
2036-02-07 01:28:59-0500,2,0,123.5,14
2036-02-07 01:29:00-0500,1,1038,124.2,734
2036-02-07 01:29:00-0500,2,0,123.5,89
2036-02-07 01:29:01-0500,1,1038,124.2,1073
2036-02-07 01:29:01-0500,2,0,123.5,14
2036-02-07 01:29:02-0500,1,1038,124.2,733
2036-02-07 01:29:02-0500,2,0,123.5,89
2036-02-07 01:29:03-0500,1,1038,124.2,1073
2036-02-07 01:29:03-0500,2,0,123.65,14
2036-02-07 01:29:04-0500,1,1038,124.2,733
2036-02-07 01:29:04-0500,2,0,123.65,89
2036-02-07 01:29:05-0500,1,1038,124.2,1073
2036-02-07 01:29:05-0500,2,0,123.65,14
2036-02-07 01:29:06-0500,1,1038,124.2,733
2036-02-07 01:29:06-0500,2,0,123.65,89
2036-02-07 01:29:07-0500,1,1042,124.25,1077
2036-02-07 01:29:07-0500,2,0,123.65,14
2036-02-07 01:29:08-0500,1,1042,124.25,733
2036-02-07 01:29:08-0500,2,0,123.65,89
2036-02-07 01:29:09-0500,1,1117,124.25,1157
2036-02-07 01:29:09-0500,2,0,123.65,14
2036-02-07 01:29:10-0500,1,1117,124.25,744
2036-02-07 01:29:10-0500,2,0,123.65,89
2036-02-07 01:29:11-0500,1,1117,124.25,1157
2036-02-07 01:29:11-0500,2,0,123.65,14
2036-02-07 01:29:12-0500,1,1117,124.25,744
2036-02-07 01:29:12-0500,2,0,123.65,89
2036-02-07 01:29:13-0500,1,1117,124.25,1157
2036-02-07 01:29:13-0500,2,0,123.65,13
2036-02-07 01:29:14-0500,1,1043,124.35,745
2036-02-07 01:29:14-0500,2,0,123.65,89
2036-02-07 01:29:15-0500,1,1043,124.35,1078
2036-02-07 01:29:15-0500,2,0,123.65,13
2036-02-07 01:29:16-0500,1,1043,124.35,745
2036-02-07 01:29:16-0500,2,0,123.65,89
2036-02-07 01:29:17-0500,1,1043,124.35,1078
2036-02-07 01:29:17-0500,2,0,123.65,13
2036-02-07 01:29:18-0500,1,1043,124.35,745
2036-02-07 01:29:18-0500,2,0,123.7,89
2036-02-07 01:29:19-0500,1,1043,124.4,1078
2036-02-07 01:29:19-0500,2,0,123.7,14
2036-02-07 01:29:20-0500,1,1043,124.4,734
2036-02-07 01:29:20-0500,2,0,123.7,89
2036-02-07 01:29:21-0500,1,1043,124.4,1078
2036-02-07 01:29:21-0500,2,0,123.7,14
2036-02-07 01:29:22-0500,1,1043,124.4,734
2036-02-07 01:29:22-0500,2,0,123.7,89
2036-02-07 01:29:23-0500,1,1043,124.4,1078
2036-02-07 01:29:23-0500,2,0,123.75,13
2036-02-07 01:29:24-0500,1,1039,124.35,742
2036-02-07 01:29:24-0500,2,0,123.75,89
2036-02-07 01:29:25-0500,1,1039,124.35,1074
2036-02-07 01:29:25-0500,2,0,123.75,13
2036-02-07 01:29:26-0500,1,1039,124.35,742
2036-02-07 01:29:26-0500,2,0,123.75,89
2036-02-07 01:29:27-0500,1,1039,124.35,1074
2036-02-07 01:29:27-0500,2,0,123.75,13
2036-02-07 01:29:28-0500,1,1039,124.35,742
2036-02-07 01:29:28-0500,2,0,123.75,90
2036-02-07 01:29:29-0500,1,1045,124.35,1080
2036-02-07 01:29:29-0500,2,0,123.75,14
2036-02-07 01:29:30-0500,1,1045,124.35,746
2036-02-07 01:29:30-0500,2,0,123.75,90
2036-02-07 01:29:31-0500,1,1045,124.35,1080
2036-02-07 01:29:31-0500,2,0,123.75,14
2036-02-07 01:29:32-0500,1,1045,124.35,746
2036-02-07 01:29:32-0500,2,0,123.75,90
2036-02-07 01:29:33-0500,1,1045,124.35,1080
2036-02-07 01:29:33-0500,2,0,123.75,14
2036-02-07 01:29:34-0500,1,1040,124.4,745
2036-02-07 01:29:34-0500,2,0,123.75,90
2036-02-07 01:29:35-0500,1,1040,124.4,1075
2036-02-07 01:29:35-0500,2,0,123.75,14
2036-02-07 01:29:36-0500,1,1040,124.4,745
2036-02-07 01:29:36-0500,2,0,123.75,90
2036-02-07 01:29:37-0500,1,1040,124.4,1075
2036-02-07 01:29:37-0500,2,0,123.75,14
2036-02-07 01:29:38-0500,1,1040,124.4,745
2036-02-07 01:29:38-0500,2,0,123.75,90
2036-02-07 01:29:39-0500,1,1042,124.4,1077
2036-02-07 01:29:39-0500,2,0,123.75,14
2036-02-07 01:29:40-0500,1,1042,124.4,737
2036-02-07 01:29:40-0500,2,0,123.75,90
2036-02-07 01:29:41-0500,1,1042,124.4,1077
2036-02-07 01:29:41-0500,2,0,123.75,14
2036-02-07 01:29:42-0500,1,1042,124.4,749
2036-02-07 01:29:42-0500,2,0,123.75,89
2036-02-07 01:29:43-0500,1,1042,124.4,1077
2036-02-07 01:29:43-0500,2,0,123.7,14
2036-02-07 01:29:44-0500,1,1043,124.35,749
2036-02-07 01:29:44-0500,2,0,123.7,89
2036-02-07 01:29:45-0500,1,1043,124.35,1078
2036-02-07 01:29:45-0500,2,0,123.7,14
2036-02-07 01:29:46-0500,1,1043,124.35,736
2036-02-07 01:29:46-0500,2,0,123.7,89
2036-02-07 01:29:47-0500,1,1043,124.35,1078
2036-02-07 01:29:47-0500,2,0,123.7,14
2036-02-07 01:29:48-0500,1,1043,124.35,736
2036-02-07 01:29:48-0500,2,0,123.65,89
2036-02-07 01:29:49-0500,1,1041,124.25,1076
2036-02-07 01:29:49-0500,2,0,123.65,14
2036-02-07 01:29:50-0500,1,1041,124.25,749
2036-02-07 01:29:50-0500,2,0,123.65,89
2036-02-07 01:29:51-0500,1,1041,124.25,1076
2036-02-07 01:29:51-0500,2,0,123.65,14
2036-02-07 01:29:52-0500,1,1041,124.25,758
2036-02-07 01:29:52-0500,2,0,123.65,90
2036-02-07 01:29:53-0500,1,1041,124.25,1076
2036-02-07 01:29:53-0500,2,0,123.7,14
2036-02-07 01:29:54-0500,1,1038,124.3,928
2036-02-07 01:29:54-0500,2,0,123.7,90
2036-02-07 01:29:55-0500,1,1038,124.3,1073
2036-02-07 01:29:55-0500,2,0,123.7,14
2036-02-07 01:29:56-0500,1,1038,124.3,928
2036-02-07 01:29:56-0500,2,0,123.7,90
2036-02-07 01:29:57-0500,1,1038,124.3,1073
2036-02-07 01:29:57-0500,2,0,123.7,14
2036-02-07 01:29:58-0500,1,1038,124.3,928
2036-02-07 01:29:58-0500,2,0,123.7,89
2036-02-07 01:29:59-0500,1,1050,124.3,1085
2036-02-07 01:29:59-0500,2,0,123.7,14
2036-02-07 01:30:00-0500,1,1050,124.3,
2036-02-07 01:30:00-0500,2,0,123.7,
2036-02-07 01:32:14-0500,1,0,0.0,
2036-02-07 01:32:14-0500,2,0,0.0,
2036-02-07 01:32:15-0500,1,0,0.0,
2036-02-07 01:32:15-0500,2,0,0.0,
2036-02-07 01:32:16-0500,1,0,0.0,0
2036-02-07 01:32:16-0500,2,0,0.0,0
2036-02-07 01:32:17-0500,1,0,0.0,0
2036-02-07 01:32:17-0500,2,0,0.0,0
2036-02-07 01:32:19-0500,1,0,0.0,
2036-02-07 01:32:19-0500,2,0,0.0,
2036-02-07 01:32:20-0500,1,0,0.0,
2036-02-07 01:32:20-0500,2,0,0.0,
2036-02-07 01:32:21-0500,1,0,0.0,
2036-02-07 01:32:21-0500,2,0,0.0,

Thanks in advance!!!

[Robert Tupelo-Schneck]

I think I had this problem once and I even have commented-out code
that removes all data after 2030. (Why did I comment this code out?)

I've put that code back in, and uploaded a preliminary alpha release
of its-electric 1.9 at
https://code.google.com/p/its-electric/downloads/detail?name=its-electric-1.9alpha1.zip

BACKUP YOUR DATA before running with the new version. Honestly I
think I intended to release 1.9 a year and a half ago but got
distracted. I've been running 1.9 myself for that long without
problems, so I have every reason to think it will work swimmingly, but
since I don't really remember everything I did, proceed with caution.

In the best of all worlds, you'll start up with the new version, it
will delete the offending data, and everything will run more or less
the same as before.

Keep me posted.

Robert

> --
> You received this message because you are subscribed to the Google Groups
> "its-electric-software" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to its-electric-sof...@googlegroups.com.
> To post to this group, send email to its-electr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/its-electric-software.
> For more options, visit https://groups.google.com/groups/opt_out.

[Cino]

Robert,

Thank for the quick reply to this! I uploaded the new version to my web server and its still showing data for 2036-2-7. I did a quick cmdline export and its stills there. Maybe the code is still commented out? Let me know what I shoudl try next.

Stephen

[Robert Tupelo-Schneck]

Ah, it's only running the delete routines when one specifically
requests to delete data.

Now it does it always. Try again:
https://code.google.com/p/its-electric/downloads/detail?name=its-electric-1.9alpha2.zip

Don't forget to back up your data!

Robert

[Stephen P. Culhane]

Thank did the trick!! Thank you so much!

You received this message because you are subscribed to a topic in the Google Groups "its-electric-software" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/its-electric-software/9GbNSOStMLg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to its-electric-sof...@googlegroups.com.

To post to this group, send email to its-electr...@googlegroups.com.
Visit this group at http://groups.google.com/group/its-electric-software.
For more options, visit https://groups.google.com/groups/opt_out.

--
Thanks,

Stephen