[IQUG] URGENT- Query against a view with a group by clause returning Internal error on one server not on others

Pai, Anitha Anitha.Pai at blackrock.com
Wed Aug 30 11:42:06 MST 2017


Issue - Query against a view with a group by clause returning Internal error on one server not on others

Query:
select pos_date, count(1) from dbo.analytics_position group by pos_date

NOTE: count(*) is ok , adding one more column to the select and group by is ok too….
All forms work fine on other servers…

View :
create VIEW dbo.analytics_position as SELECT X.* from dbo.actual_analytics_position X
INNER JOIN dbo.port_view_perms p on X.fund = p.portfolio_id WHERE X.is_current = 1


Error:
Msg 21, Level 23, State 0
SQL Anywhere Error -1006001: IQ Internal error. Please report this to SAP IQ support.
-- (vplib/vp_Projections.cxx 751)
-- (vplib/vp_Projections.cxx 751)
(0 rows affected)


Stack traces happened too – Pretty long but the line below seems related to the count..
08/30 13:51:17. 0002164933 [20535]:         Production 2:
I. 08/30 13:51:17. 0002164933 [20535]:           CAST(CAST(SUM(SUM(COUNT(*)))`(1) AS NUMERIC(25,0)) AS UINT64)

IQ version:
SAP IQ/16.0.110.2422/10448/P/sp11.07/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2017-03-14 03:53:48


Any input appreciated.. case opened with SAP too just now..

Thanks
Anitha Pai

This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

© 2017 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20170830/a3de9e4b/attachment-0001.html>


More information about the IQUG mailing list