View Issue Details

IDProjectCategoryView StatusLast Update
0026785mantisbtdb oraclepublic2020-03-16 04:39
Reporteramrodmbt Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version2.24.0 
Summary0026785: Database query failed when loading "Configuration Report" under "Manage Configuration"
Description

The following error occurs when trying to open "Configuration Report" under "Manage Configuration":

APPLICATION ERROR 0000401

Database query failed. Error received from database was #932: ORA-00932: inconsistent datatypes: expected NUMBER got CHAR for the query: SELECT config_id, user_id, project_id, type, access_reqd, CASE type WHEN :0 THEN null ELSE value END value FROM m_config WHERE 1=1 AND user_id = :1 AND project_id=:2 ORDER BY user_id, project_id, config_id .

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Additional Information

It seems the issue is related to data type conversion issue of parameter 0.
I have successfully solved this issue in Oracle DB by changing line 213 of adm_config_report.php from
"CASE type WHEN :complex THEN null ELSE value END"
to
"CASE WHEN type = :complex THEN null ELSE value END",
but I am not sure if this change will cause any problem in other types of database server.

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-03-16 04:39 amrodmbt New Issue