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

Gehman, Kirby kirby.gehman at sap.com
Wed Aug 30 11:58:06 MST 2017


Hi Anitha,

I picked up that incident and responded.

In a nutshell, in case you get this first, see https://launchpad.support.sap.com/#/notes/2497589

I searched for your error “vplib/vp_Projections.cxx 751” and that KBA was the first hit.  You can save yourself a lot of time by searching the Knowledge Base with error messages and phrases from your stack traces.  The exact cause seems to be slightly different, but please test the workarounds and solution as this may simply be a different expression of the same issue.

The issue listed in the KBA is resolved in SAP IQ 16 SP11 PL09, and there are workarounds listed as well.



Kirby Gehman
Platinum Technical Support Engineer
SAP Canada - Waterloo 445 Wes Graham Way, N2L6R2 Waterloo, Canada
T +1 519 883-4803, E kirby.gehman at sap.com

http://www.sap.com/ unsubscribe<https://global.sap.com/profile/unsubscribe.epx?PID=10386&PFID=12894>



From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Pai, Anitha
Sent: Wednesday, August 30, 2017 1:42 PM
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/7c1fb4c9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4700 bytes
Desc: image001.png
URL: <http://iqug.org/pipermail/iqug/attachments/20170830/7c1fb4c9/attachment-0001.png>


More information about the IQUG mailing list