[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 12:18:08 MST 2017


Thanks for the response Ron !

Just  simplex server in our env… worst case options may be different and data set too!


Thanks again
No Ron

From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Wednesday, August 30, 2017 3:07 PM
To: Pai, Anitha <Anitha.Pai at blackrock.com>; iqug at iqug.org
Subject: RE: [IQUG] URGENT- Query against a view with a group by clause returning Internal error on one server not on others

Is this a MPX server which you get different results on or separate servers without any shared data?

From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of Pai, Anitha
Sent: Wednesday, August 30, 2017 11:42 AM
To: iqug at iqug.org<mailto:iqug at iqug.org>
Subject: [IQUG] URGENT- Query against a view with a group by clause returning Internal error on one server not on others

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<https://urldefense.proofpoint.com/v2/url?u=http-3A__X.fund&d=DwQFaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=bVUQ4VnC5bkps8UaCa2zhRJCN7S9nQjjQadKLNAPaJg&m=CHmwk2rK-cis0A5SWrA2rOzjuI9h4O4b3yqngF3Lnq0&s=nbLOD5pLK6GvuU4fwmhD9rRG-m8VdKl8lWViMv65z-k&e=> = 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/1860c2b4/attachment-0001.html>


More information about the IQUG mailing list