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

Ron Watkins rwatkins at dssolutions.com
Wed Aug 30 12:07:21 MST 2017


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] On Behalf Of Pai, Anitha
Sent: Wednesday, August 30, 2017 11:42 AM
To: 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 = 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/8787f321/attachment.html>


More information about the IQUG mailing list