Announcement

Collapse
No announcement yet.

Error in Log

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Error in Log

    I keep getting this error every 2-3 days. Any idea how I can fix them?

    4/30/2013 4:29:54 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:29:54 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:29:54 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:29:54 PM ~!~Error~!~ADO Opening database: Unspecified error
    4/30/2013 4:29:54 PM ~!~Error~!~Delete (Event1) Error: Operation is not allowed when the object is closed.
    4/30/2013 4:29:54 PM ~!~Error~!~Deleting event with ref 5280
    4/30/2013 4:30:00 PM ~!~Event~!~Event Trigger "HSTV Set Device Strings"
    4/30/2013 4:30:00 PM ~!~Event~!~Running script statement immediately: &hs.Plugin("HSTV").setDeviceStrings()
    4/30/2013 4:30:00 PM ~!~HSTV~!~runSelectQueryAccess: SELECT c.channelDevCode, count(*) FROM tvchannels c WHERE c.channelDevCode IS NOT NULL GROUP BY c.channelDevCode HAVING count(*) > 1
    4/30/2013 4:30:00 PM ~!~Debug~!~Unspecified error
    4/30/2013 4:30:00 PM ~!~HSTV~!~runSelectQueryAccess: SELECT c.channelID, c.channelName, c.channelNickName, c.channelNumber, l.starttime, l.endtime, l.title, l.episode, l.episodenum, l.category, l.programyear, l.videoaspect, l.videocolor, l.starrating, l.ratingsystem, l.rating, l.ratingadvisory, l.subtitles, l.description, l.audio, l.actors, l.director, l.hosts, l.guests, l.producers, l.scheduledEvent, l.repeatshowing , c.channelDevCode FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID AND c.viewHide = 0 AND ( (l.starttime < DateAdd('n',5,Now()) AND l.endtime > DateAdd('n',5,Now()) ) OR (l.starttime < DateAdd('n',35,Now()) AND l.endtime > DateAdd('n',35,Now()) ) ) AND Len(c.channelDevCode) > 0 ORDER BY c.channelDevCode, c.channelNickname, l.starttime
    4/30/2013 4:30:00 PM ~!~Debug~!~Unspecified error
    4/30/2013 4:30:00 PM ~!~HSTV~!~runSelectQueryAccess: SELECT channelID, channelDevCode FROM tvChannels WHERE Len(channelDevCode) > 0 ORDER BY channelDevCode
    4/30/2013 4:30:00 PM ~!~Debug~!~Unspecified error
    4/30/2013 4:30:00 PM ~!~HSTV~!~Finished setting HSTV devices
    4/30/2013 4:30:04 PM ~!~Error~!~ADO Opening database: Unspecified error
    4/30/2013 4:30:04 PM ~!~Error~!~Delete (Event1) Error: Operation is not allowed when the object is closed.
    4/30/2013 4:30:04 PM ~!~Error~!~Deleting event with ref 9265
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:30:04 PM ~!~Error~!~ADO Opening database: Unspecified error
    4/30/2013 4:30:04 PM ~!~Error~!~Delete (Event1) Error: Operation is not allowed when the object is closed.
    4/30/2013 4:30:04 PM ~!~Error~!~Deleting event with ref 9054
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvent (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~Did not find an existing event record.
    4/30/2013 4:30:04 PM ~!~Error~!~GetEvents (Events) Error: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
    4/30/2013 4:30:04 PM ~!~Database~!~No Existing Event Record and GetNewEventSet failed - bad news - data NOT saved.
    4/30/2013 4:30:23 PM ~!~Error~!~Scripting runtime error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80004005): Unspecified error at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalL ateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCa ll(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at scriptcode2.scriptcode2.open_db() at scriptcode2.scriptcode2.init() at scriptcode2.scriptcode2.Main(Object Params) --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.

    #2
    Are you using an access database? If so, check to see how big the file is. If it is getting close or over 2 Gb, then it needs to be compacted.
    --
    Jeff Farmer
    HS 3, HSPhone
    My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
    Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

    Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

    Comment


      #3
      Originally posted by CFGuy View Post
      Are you using an access database? If so, check to see how big the file is. If it is getting close or over 2 Gb, then it needs to be compacted.
      I am using Access and the database file is only 34 mb.

      Comment


        #4
        Try running the compact and repair. Its size is fine. It doesn't need compacted but something must be wrong with the database file since you are getting errors when the queries are run. See if the repair will fix it.
        --
        Jeff Farmer
        HS 3, HSPhone
        My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
        Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

        Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

        Comment

        Working...
        X