[CORE-366] Error on API request on endpoint /i2b2/services/QueryToolService/publishDataRequest Created: 18/May/17  Updated: 11/Nov/19  Resolved: 26/Sep/19

Status: Closed
Project: i2b2 Core Software
Component/s: None
Affects Version/s: None
Fix Version/s: 1.7.12

Type: Bug Priority: Blocker
Reporter: Jonas Assignee: Mike Mendis
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment: provided I2B2 VM (i2b2vmware-1708b.zip)

Attachments: PNG File Bildschirmfoto 2017-05-18 um 17.39.46.png    
Rank: 0|i003fj:
Affects Database/s:

we are trying to send messages to following endpoint:

Sadly these messages generating given error message:<status type="ERROR">org.springframework.dao.InvalidDataAccessApiUsageException: Property 'sql' is required

using the provided i2b2 VM in version 1.7.08b
More information available at the given screenshot.

The problem might result from not initialised sql property in method UploadStatusInsert(DataSource ds, String schemaName,
     DataSourceLookup dataSourceLookup) in edu.harvard.i2b2.crc/src/server/edu/harvard/i2b2/crc/loader/dao/UploadStatusDAO.java

Is this a know error?

Comment by Reeta Metta [ 11/Nov/19 ]
this has been fixed as part of REDCAP implementation
Generated at Sat Oct 23 14:46:44 UTC 2021 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.