KM Date Error
Error: Database Error: Error Executing Database Query. - Detail: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
- SQL: SELECT E.ORIGIN_TIME, E.EVENT_ID, E.SFILE_ID, E.CATALOG, E.LAYER,
COALESCE(S.URL, E.SFILE_ID) as SFILE_URL
FROM tremor.EVENTS E
LEFT JOIN tremor.SFILES S ON E.SFILE_ID = S.SFILE_ID
WHERE ORIGIN_TIME >= (param 1)
AND ORIGIN_TIME <= (param 2)
AND LAYER = 'EWA'
AND COUNTY_CODE IS NOT NULL
AND NOT EXISTS (
SELECT NULL
FROM tremor.EVENTS
WHERE QUAKE_ID = E.QUAKE_ID
AND LAYER = 'KGS-P'
)
ORDER BY ORIGIN_TIME - Query Error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
✓ No Data Quality Issues Found
All EWA events occur after the first KGS-P event. No data issues detected.
Debug Information:
Current KM Date: Error
Show Form: false
Show Success: false
Found Problems: false
Problems Count: 0