80
Views
0
Comments
[Maintenance Manager] Oracle issues: Error executing query. ORA-00932: inconsistent datatypes
maintenance-manager
Reactive icon
Forge asset by Ossama Ghanem
Application Type
Reactive

Hi,

This component works fine in SQL Server but has some issues in Oracle.

I got this error when opening the homepage:

 In Service Center, I got these 2 errors:

  • DataBaseException: Error executing query.
  • Error executing query. ORA-00932: inconsistent datatypes: expected - got BLOB

I was able to fix the code by removing the "Group By" from the aggregates.

It seems that having a "group by" of a Binary Data attribute was causing the error.

I hope this helps someone with the same issue.

Best regards,

João

MaintenanceManager_error_stack.txt
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.