View CCDA error

OpenEMR Development
1

arnabnaha wrote on Monday, September 28, 2015:

hello

When I try to view CCDA on clicking “CCDA button” in care cordination module screen, it shows the following error -
ERROR :
Exception: Statement could not be executed
Exception: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
SQL statement : SELECT prs.result AS result_value, prs.units, prs.range, prs.result_text as order_title, prs.result_code as result_code,
prs.result_text as result_desc, prs.code_suffix AS test_code, po.date_ordered, prs.date AS result_time, prs.abnormal AS abnormal_flag
FROM procedure_order AS po
JOIN procedure_report AS pr ON pr.procedure_order_id = po.procedure_order_id
JOIN procedure_result AS prs ON prs.procedure_report_id = pr.procedure_report_id
WHERE po.patient_id = ? AND prs.result NOT IN (‘DNR’,‘TNP’)(‘2’,‘2’)
##0 C:\xampp\htdocs\openemr\interface\modules\zend_modules\module\Application\src\Application\Model\ApplicationTable.php(62): Zend\Db\Adapter\Driver\Pdo\Statement->execute(Array)
##1 C:\xampp\htdocs\openemr\interface\modules\zend_modules\module\Carecoordination\src\Carecoordination\Model\EncounterccdadispatchTable.php(887): Application\Model\ApplicationTable->zQuery(‘SELECT prs.resu…’, Array)
##2 C:\xampp\htdocs\openemr\interface\modules\zend_modules\module\Carecoordination\src\Carecoordination\Controller\EncounterccdadispatchController.php(498): Carecoordination\Model\EncounterccdadispatchTable->getResults(‘2’, NULL)
##3 C:\xampp\htdocs\openemr\interface\modules\zend_modules\module\Carecoordination\src\Carecoordination\Controller\EncounterccdadispatchController.php(443): Carecoordination\Controller\EncounterccdadispatchController->getContinuityCareDocument(‘2’, NULL)
##4 C:\xampp\htdocs\openemr\interface\modules\zend_modules\module\Carecoordination\src\Carecoordination\Controller\EncounterccdadispatchController.php(289): Carecoordination\Controller\EncounterccdadispatchController->create_data(‘2’, NULL, ‘progress_note|c…’, 0)
##5 C:\xampp\htdocs\openemr\interface\modules\zend_modules\library\Zend\Mvc\Controller\AbstractActionController.php(83): Carecoordination\Controller\EncounterccdadispatchController->indexAction()**

2

zhhealthcare wrote on Monday, September 28, 2015:

Hi Arnab,

We have fixed the issue. We will commit it ASAP. Also there are some modifications in the module. We will be doing that after completing the MU testing. Hopefully by the end of this week.

Thanks & Regards,
ZHHealthCare

3

arnabnaha wrote on Monday, September 28, 2015:

Thanks ZH…I got ur fix just now…but still the same error is being displayed…does care coordination needs a special setup?

4

zhhealthcare wrote on Monday, September 28, 2015:

Is that the same error?

ZH

5

arnabnaha wrote on Monday, September 28, 2015:

After looking carefully this time…the error is different…error is attached…Mr. vinish gave me a testing Mirth Configuration…after using that I was able to create the CCDA but still with the error statement.