|
If you see this message.
The move to a new host has completed
|
|
|
Posts: 138
Joined: February 2014
|
|
#57338
10/08/2013 4:41 PM
|
Joined: Nov 2006
Posts: 2,084
Member
|
OP
Member
Joined: Nov 2006
Posts: 2,084 |
Several eRx renewals (received from different pharmacies) for the past week cannot be retransmitted. An error box appears "Incorrect syntax at '=' ". I have tried retyping the Rx in the Prescription Writer and rematching, but still the error. Has anyone seen this? I at first blamed it on the transmitting pharmacy, but it has been several different stores.
John
Internal Medicine
|
|
|
|
|
Joined: Nov 2006
Posts: 2,084
Member
|
|
OP
Member
Joined: Nov 2006
Posts: 2,084 |
John
Internal Medicine
|
|
|
|
|
Joined: Oct 2011
Posts: 1,612
Member
|
|
Member
Joined: Oct 2011
Posts: 1,612 |
jimmie
internal medicine
gab.com/jimmievanagon
|
|
|
|
|
Joined: Sep 2003
Posts: 12,845 Likes: 32
Member
|
|
Member
Joined: Sep 2003
Posts: 12,845 Likes: 32 |
I am not sure, but it seems to be an error generated by SQL Server. I suppose I would contact JamesNT first, then AC support. Are you using 2012?
Bert
Pediatrics
Brewer, Maine
|
|
|
|
|
Joined: Jun 2008
Posts: 1
Member
|
|
Member
Joined: Jun 2008
Posts: 1 |
Yes! I thought it was just something with my wonky server. I have had success sending from the chart rather than the renewal page but it is a pain. Let me know if you figure anything out.
Kirsten.carr@theMFCC.com
|
|
|
|
|
Joined: Nov 2006
Posts: 2,084
Member
|
|
OP
Member
Joined: Nov 2006
Posts: 2,084 |
John
Internal Medicine
|
|
|
|
|
Joined: Nov 2006
Posts: 2,084
Member
|
|
OP
Member
Joined: Nov 2006
Posts: 2,084 |
I also noted the count for received Rxs on the main window is incorrect again. I'll try to run the Database Tuner again to fix this. Will report back.
John
Internal Medicine
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
I also noted the count for received Rxs on the main window is incorrect again. I'll try to run the Database Tuner again to fix this. Will report back. Been on the road implementing for two weeks, missed this one. First, the eRX count will continue to be off over time, known bug. The fix is to run the tuner as you are planning. Second the error is @ the SQL server level. The fact that it just started showing up would indicate that something on the pharmacy network side has changed, and AC [SQL Server] is choking on it because it breaks their command syntax. AC will need to isolate it, and they could release updated code in a future release to fix it, but unless they modified something in the interface (without telling folks), the problem is coming from the pharmacy network side.
|
|
|
|
|
Joined: Nov 2006
Posts: 2,084
Member
|
|
OP
Member
Joined: Nov 2006
Posts: 2,084 |
I recently upgraded to version 6.61. Since upgrading, I have not seen the ERx count bug or the "incorrect syntax" error notice on requested refills.
John
Internal Medicine
|
|
|
|
|
Joined: May 2011
Posts: 89
Member
|
|
Member
Joined: May 2011
Posts: 89 |
I upgraded to 6.6.1 about a week ago. The ERx count bug is still there....
Theo A. Stephens, MD
Internal Medicine,
Baltimore, MD
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
I upgraded to 6.6.1 about a week ago. The ERx count bug is still there.... Well, that's disappointing.
|
|
|
|
|
Joined: Nov 2006
Posts: 2,084
Member
|
|
OP
Member
Joined: Nov 2006
Posts: 2,084 |
I recently upgraded to version 6.61. Since upgrading, I have not seen the ERx count bug... I was wrong, the bug is still happening in ver 6.61. 
John
Internal Medicine
|
|
|
|
|
Joined: Nov 2011
Posts: 17
Member
|
|
Member
Joined: Nov 2011
Posts: 17 |
I don't get any renewal requests from pharmacies. They continuously tell me that they send requests but I never see them. There must be some form of setup issue that I don't get. Has anyone had a similar problem and how did it get solved?
|
|
|
|
|
Joined: Jun 2009
Posts: 1,811
Member
|
|
Member
Joined: Jun 2009
Posts: 1,811 |
pnl - there is a form you need to get from AC support that you fill out and then they send that to the pharmacy network.
|
|
|
|
0 members (),
16
guests, and
14
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
![[Linked Image from ]](/ub/attachments/usergals/2013/10/full-636-520-syntax_error.jpg)
