Search results by user ID 6015

Re: Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

furrywombat — Fri, 24 Mar 2017 19:11:42 GMT

Outstanding. Very quickly, though -- the API that we are connecting to, as I mentioned, is not the standard API. If you would please confirm that our stuff has been re-pointed as well. And I will monitor for any additional errors coming through.

Re: Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

furrywombat — Fri, 24 Mar 2017 16:54:40 GMT

Two more of these errors since my initial post. One desktop sync request at 8:35am this morning, and a failed select at 11:51am.

Any idea what's going on here, please? Nothing has changed on our side.

Exception Caught: user 'root' using method 'mysql_native_password' failed ... attempted to read past end of stream

furrywombat — Fri, 24 Mar 2017 13:06:18 GMT

We've been getting this particular error periodically, ever since the recent reconfiguration of the API server. This particular case is an interesting one as well, as we do have a unique API server configuration which you may reference internally.

The error is not specific to any type of query, and has been returned now for both select, and desktop sync requests. Started off on 3/21 as a large number of internal server error exceptions. Those were primarily for insert statements, but also came up for a few select & desktop sync requests. Now, this is the primary error I'm getting, which started on 3/22, early afternoon:

Exception Caught: Server was unable to process request. ---> Authentication to host 'REDACTED*' for user 'root' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ---> Reading from the stream has failed. ---> Attempted to read past the end of the stream.

*Please contact me directly for any redacted info.

Would very much like to know why we are receiving these errors, and what is being done to resolve.

Re: Quickbooks manually closing sales orders?

furrywombat — Thu, 05 May 2016 17:41:46 GMT

Ben,

That's a solid answer if I've ever seen one. Thanks! So, if it's fully invoiced, the IsFullyInvoiced boolean will be TRUE, and IsManuallyClosed will be false, because the two cannot coexist. So the ONLY way we would get this message would be in a scenario where a sales order is already fully invoiced, or zeroed out, synced to QB, then somebody manually closes it and tries to sync. Is that correct? Is there any possibility that zeroing out a sales order for all line items could cause a false-positive?

Re: Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 15:14:09 GMT

Audisho, the only thing that's preventing us from making that move is the lack of SQL override. And we've been itching to make the move. I'm sure we are not alone in this... are you guys going to be souping it up a bit? Is that why it's taking so long?

Re: Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 15:01:09 GMT

Thanks, Audisho. Quick question regarding Method New -- have you implemented custom SQL fields yet?

Re: Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 14:41:29 GMT

Well, it's just kind of a pain to have to sort out the DeleteFromDesktop conflicts from actual conflicts requiring attention. Would be nice if we could do a Clear All on a filtered list or checkbox selection, rather than having to click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click, click. I'm sure it's not a priority for Method, just wanted to throw it out there.

Quickbooks manually closing sales orders?

furrywombat — Thu, 05 May 2016 13:58:44 GMT

Is this something new? Or has QuickBooks always manually closed sales orders after they've been fully invoiced? Lots of synchronization conflicts popping up, telling me that a sales order cannot be synced because it is manually closed, but is already fully invoiced. Is this a Method setting, or a QuickBooks setting?

Clearing items from ountingConflicts / QB Sync Error table via API

furrywombat — Thu, 05 May 2016 13:19:30 GMT

We are archiving certain transactions older than a year, and we get over a hundred "DeleteFromDesktop" errors per day for transactions that are in the process of being archived. The current procedure is to clear all of the false-positives, but wondering if there is a way to do this programmatically.

Web page window object / action affecting items outside of window object

furrywombat — Wed, 20 Jan 2016 16:44:26 GMT

I would like to know if there is a way for us to insert a web page window object into a custom screen, then have an action inside that screen affect an object outside of the window object, i.e. call a Refresh Grid action, call a web service, or something along those lines?

Is this possible?