Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.7.2
-
None
-
None
Description
Current Behavior:
In Oracle 12c, when searching for a job script from the Workflow tab, the following error message is returned:
{
"deliveryDate": "2024-12-04T12:07:02.585Z",
"error": {
"code": "JOC-420",
"message": "com.sos.commons.hibernate.exception.SOSHibernateQueryException: org.hibernate.query.sqm.produce.function.FunctionArgumentException: Parameter 1 of function 'lower()' has type 'STRING', but argument is of type 'java.lang.String' mapped to 'UserTypeSqlTypeAdapter(com.sos.commons.hibernate.type.SOSHibernateJsonType@52b53172)' [select mt.inventoryConfigurationId as id, mt.path as path, mt.type as type, mt.folder as folder, mt.name as name, mt.title as title, mt.controllerId as controllerId, true as valid, false as deleted, true as deployed, false as released, 0 as countReleased, 1 as countDeployed from DBItemDepConfiguration mt left join DBItemSearchWorkflow sw on mt.inventoryConfigurationId=sw.inventoryConfigurationId and sw.deployed=1 left join DBItemSearchWorkflow2DeploymentHistory swdh on swdh.deploymentHistoryId=mt.id and swdh.searchWorkflowId=sw.id where mt.type=:type and mt.controllerId=:controllerId and lower(sw.jobsScripts) like :jobScript ]"
},
"surveyDate": "2024-12-04T12:07:02.585Z"
}
Desired Behavior:
When searching for a job script from the Workflow tab, it should execute correctly and return the correct data without any errors.
Test Instructions
- Use Oracle 12c
- Test the search described in this issue:
- Return Workflow
- Advanced - Job Script
- Test search based on other input fields and Return types
- Expected result: no errors, and correct hits should be returned.
- Test the search described in this issue:
- Use newer Oracle versions (e.g., 18c, 21c) and repeat the tests
Attachments
Issue Links
- relates to
-
-
- Approved
-