Symptom
- A query that had been working suddenly stopped returning results. The html is creating many plans with no data.
SELECT CAST(CASE WHEN EXISTS(SELECT * FROM tclient cl JOIN tclient2 map ON cl.fid = map.fid WHERE cl.fcode = 'INFO' AND map.fsid = 3) THEN 1 ELSE 0 END AS BIT) as available - This is preventing reports that were previously created in seconds, to not being created at all.
- No errors in the IQMSG nor the SRVLOG.
- Would like to know why this is failing.
Read more...
Environment
SAP IQ 16.1
Product
SAP IQ 16.0
Keywords
KBA , BC-SYB-IQ , Sybase IQ , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.