aperezcrespo wrote on Wednesday, August 22, 2007:
Hi
When I click on Process X12 on the billing screen, the resulting file (X12) contains the following error on the first line and the data is not passed on to SQL-Ledger.
<HR>Fault: Code: 4 Reason ‘error executing RPC `ezybiz.add_invoice’.
failed to execute insert into parts queryERROR: invalid input syntax for type double precision: ""
Yet when I click on the link to the file the error is not there.
What do you think?
Alfonso
sunsetsystems wrote on Wednesday, August 22, 2007:
Clearly an error in talking to SQL-Ledger. If the link to SL otherwise seems to be working, then it sounds like some field in the claim that should have been numeric was not.
aperezcrespo wrote on Wednesday, August 22, 2007:
Any idea as to where to look for a clue as to what field this might be? A log file maybe?
Thanks
Alfonso
sunsetsystems wrote on Thursday, August 23, 2007:
I would check the generated X12 file to see if anything looks unusual.
However, looking at your error message again, it appears something else is going on. What version of SQL-Ledger are you using? 2.8.x is not supported.
sunsetsystems wrote on Thursday, August 23, 2007:
What version of PostgreSQL?
At this point I would suggest reviewing sql-ledger/ws_server.pl (was openemr/accounting/ws_server_26.pl), looking for places where an empty string might be inserted into a numeric database field, and changing those to 0 instead.
aperezcrespo wrote on Thursday, August 23, 2007:
PostgreSQL version 8.1.9
As far as ws_server. We still rename ws_server_26.pl to ws_server.pl and place it in the SQL-Ledger directory, right?
Thanks
Alfonso
sunsetsystems wrote on Friday, August 24, 2007:
Yes.
My hunch is this version of PostgreSQL no longer allows an empty string value to be assigned to a double precision column.
aperezcrespo wrote on Friday, August 24, 2007:
Got it! Corrupt ws_server.pl
Death to my ISP!
BTW do many folks still use sql-ledger 2.4.x? If not why dont we name ws_server_26.pl to ws_server.pl and ws_server.pl to ws_server_24.pl?
Thanks rod.
Alfonso