| Author |
|
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 05 2006 at 12:08 | IP Logged
|
|
|
I've been getting the error indicated below. I don't know what it is related to as it seems to occur randomly. Closing PH and reopening it seems to clear the error, but the last time this happened it also lost the connection to the USB-UIRT and I had to reboot. Thus it might be connected somehow to the USB-UIRT since I am sending it IR commands to transmit frequently.
"Database transaction information not available. Call SetTrans or SetTransObject function."
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 06 2006 at 11:56 | IP Logged
|
|
|
Noel,
This is bad and is a code mistake on my part somewhere (I left out a statement). I will look through the USB-Uirt module and see if I can locate it and get it patched up.
Thanks for reporting this.
Dave.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 06 2006 at 13:25 | IP Logged
|
|
|
Noel,
Ive looked all through the USB-Uirt module as well as anything that changed in the last version and cannot locate a missing settrans statement. Can you provide a little more info concerning where you're seeing this? I know you're using the USB-Uirt but what other modules are you using? Are you using the USB-Uirt for receiving or only transmitting. It appears randomly, but how often? Does it only appear when PowerHome is running on it's own, or are you actively at the screen doing something? Can you correlate the appearance of the message to something in the eventlog?
Any info you can provide would be great.
Thanks,
Dave.
|
| Back to Top |
|
| |
smarty
Super User
Joined: May 21 2006
Location: United States
Online Status: Offline
Posts: 728
|
| Posted: October 06 2006 at 16:04 | IP Logged
|
|
|
Dave,
I have seen this dialog box as well. I am not sending any IR commands, but I do have the USBUIRT controller enabled.
I only see the error after I let Insteon polling run and run and run. I have not seen any specific event to "force" the error to occur (yet). I will look more and post back.
I have seen that closing PH and restarting clears the error and it doesn't seem to come back until approx >30 minutes later...odd.
__________________
Elk - Insteon - BlueIris - DMC1 - PowerHome - XLobby - HA_Bridge w/Dots - Brultech
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 06 2006 at 17:02 | IP Logged
|
|
|
I don't have much more info yet, but I will keep watching.
When it happens the CPU is pinned at 100%. When polling is on my CPU gets pinned at 100% every few seconds. WHen polling is off my CPU is 7% or below usually. So I've been turning polling off, but Smarty might be on to something there, because I think it occurred more with polling on.
It happened a lot when I am not at the computer. But the last time it happened I was at the computer trying to get an RS232 command to work in a macro. I seemed to get the error when I had the USB-UIRT transmit a code. In this macro it didn't receive anything, just transmit.
I'll keep looking and report anything I find.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 11 2006 at 17:03 | IP Logged
|
|
|
All,
Can this error be tied to using the ph_backupdb function? Ive been going through the code top to bottom and the only way I have found so far to cause this is with the Insteon Explorer open, pending operations (usually when polling is on) and the ph_backupdb function running.
Let me know because Ive had 3 separate people report this so far and I really need to squash this one.
Thanks,
Dave.
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 11 2006 at 19:19 | IP Logged
|
|
|
This error has not happened to me again after my last post. I did just go into insteon explorer and noticed I was NOT polling because of failures on all devices. It has probably been like that for days. I do backup the database once a day at 10:52 pm but nothing seems to happen out of the ordinary at that time. I also have not played with the USB-UIRT since the error trying to make it fail. But I will try to make it fail now just to see if I can generate the error again.
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 11 2006 at 19:29 | IP Logged
|
|
|
I just sent a couple of repeat IR commands to the USB-UIRT in quick succession. It pinned the CPU, froze PH, but did not generate any error messages. This has happened before with prior versions - same thing. I don't think it's related to the error message above. I have to end the PH process and the SDM process and then reload PH and PH works again. I'll keep checking and report if I find anything or get the error message again.
|
| Back to Top |
|
| |
ginigma
Senior Member
Joined: June 18 2006
Location: United States
Online Status: Offline
Posts: 127
|
| Posted: October 11 2006 at 21:24 | IP Logged
|
|
|
Dave,
I just started getting this error when using ph_backupdb. The function I was testing, and is in my timed events section is:
ph_backupdb ("c:\temp\dbbkup" + string (year (today ())) + string (month (today())) + string (day (today())) + ".db", 1)
Hope this helps
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 12 2006 at 13:03 | IP Logged
|
|
|
Guys,
Thanks for the feedback. It definately seems that everyone that has reported this error is using the ph_backupdb and has the Insteon Explorer open. The quick temporary fix is to not leave the Insteon Explorer open when a backup will be taking place. Ive gone ahead and patched the code so this will not be an issue very soon.
Noel,
How are you sending the IR codes in quick succession. Is it the ph_ir command, or are you pressing a couple of Control Center buttons, etc. I want to duplicate here so I can try to get this fixed.
Thanks to everyone for bringing this error to my attention and helping me locate it. It was a tough nut to crack but I think we've got it taken care of.
Dave.
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 12 2006 at 14:23 | IP Logged
|
|
|
Dave,
I am sending the IR command from an old remote to USB-UIRT which then triggers a PH macro. If I send the command from the remote enough times (usually only 2 or 3 times in quick succession) PH pins the CPU and locks up. The macro sends an IR command FROM the USB-UIRT to another device. I think what is happening is the USB-UIRT/PH is having trouble RECEIVING another IR command and at about the same time SENDING an IR command from the USB-UIRT. I usually see 2 (or more)macros in the execution queue when this happens. This is 100% reproducible. Happens every time. I've used other remotes and other macros sending different IR commands and it locks up every time. On the other hand if I send succesive IR commands to the USB-UIRT and it triggers a macro which does not send another IR command, every thing works with no lockup. So it seems it's definitely a problem with the interply between the receive and send of the USB-UIRT.
To clear this lockup, I have to go to Windows Task Manager and shut down the PH process and SDM process separately. If I try to close PH using the applications tab in Windows Task Manager the PH window "Are you sure you want to exit" comes up but I can't press either button. Sometimes upon reloading PH the USB-UIRT doesn't work and I have to reboot. All usually works after this.
HTH
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 12 2006 at 14:25 | IP Logged
|
|
|
I should add to the above that I have tried adding Waits and Delays and set flags to try and slow down the execution of the macro a second time it is trigger and altho this works somewhat it is too cumbersome a solution and doesn't work 100% of the time.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 12 2006 at 16:40 | IP Logged
|
|
|
Noel,
Im not sure if we've talked about this before or not but are your incoming IR triggers set as "Immediate" or "Queued"? This will definately happen if the trigger is set as "Immediate" and the "Queued" action is designed to work around a trigger action going to the same controller as a what caused the trigger.
Let me know what trigger style you're using and we'll proceed from there.
Dave.
|
| Back to Top |
|
| |
nadler
Super User
Joined: February 25 2006
Location: United States
Online Status: Offline
Posts: 354
|
| Posted: October 12 2006 at 17:16 | IP Logged
|
|
|
Both the macros I was testing this with were set to immediate. But I changed them to queued and they both still exhibit the behavior. One macro send 4 identical IR commands using Formula Button after being triggered. The other sends 2 IR commands directly from the macro. They both lock up PH. I wonder whether I should try just having 1 command in the macro and see if it doesn't lockup after repeatedly triggering the macro.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 13 2006 at 00:06 | IP Logged
|
|
|
Noel,
I'll test this out when I get a chance. The immediate will definately cause the behaviour you describe so I would leave the triggers Action Style as "Queued".
I would next try changing the Trigger Action Type from "Macro" to "Raw Formula". Set the action to the following formula:
ph_postformula("ph_macro('YOUR MACRO ID')")
Just adjust the macro ID as appropriate. Save the changes by pressing "F5" and see where we get with this.
Dave.
|
| Back to Top |
|
| |
smarty
Super User
Joined: May 21 2006
Location: United States
Online Status: Offline
Posts: 728
|
| Posted: October 15 2006 at 14:51 | IP Logged
|
|
|
I have not seen this error again. But I now have turned off polling (I like to see my link changes occur...the background traffic during this tends to add to my confusion  )
Yes, I do have a timed event that does a database backup.
I think you have solved the mystery.
__________________
Elk - Insteon - BlueIris - DMC1 - PowerHome - XLobby - HA_Bridge w/Dots - Brultech
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Bug Reports
Topic: Data Window Error
