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

Ray Naugle rnaugle at dssolutions.com
Wed Aug 30 13:48:15 MST 2017


Just to document for the SAP folks, this is a private knowledge base and is locked up somewhere behind the SAP firewalls.  Not everybody on this distribution has (or maybe even wants or can get) a login to crack into that safe.  J

 

From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Gehman, Kirby
Sent: Wednesday, August 30, 2017 1:31 PM
To: Vidal, Escarlet; Pai, Anitha; 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

 

Just to document for the IQUG archives, that KBA does document the details of this issue, the workaround is successful and the fix is in the version listed in the KBA.

 

 

 

Kirby Gehman

Platinum Technical Support Engineer

SAP Canada - Waterloo 445 Wes Graham Way, N2L6R2 Waterloo, Canada

T +1 519 883-4803, E  <mailto:kirby.gehman at sap.com> kirby.gehman at sap.com

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




 

 

From: Vidal, Escarlet [mailto:Escarlet.Vidal at blackrock.com] 
Sent: Wednesday, August 30, 2017 2:45 PM
To: Pai, Anitha <Anitha.Pai at blackrock.com>; Gehman, Kirby <kirby.gehman at sap.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

 

Hi Kirby, 

 

Can you please call me or Anitha, we have a few questions about this case..

 

Thanks!!

 

302-797-6293

 

From: Pai, Anitha 
Sent: Wednesday, August 30, 2017 3:19 PM
To: Gehman, Kirby <kirby.gehman at sap.com>; iqug at iqug.org
Cc: Vidal, Escarlet <Escarlet.Vidal at blackrock.com>
Subject: RE: [IQUG] URGENT- Query against a view with a group by clause returning Internal error on one server not on others

 

Thanks for the response Kirby and thanks for picking up the case!

Think we added the iqmsg for specifics of our case too.

 

Thanks again

Anitha

 

 

From: Gehman, Kirby [mailto:kirby.gehman at sap.com] 
Sent: Wednesday, August 30, 2017 2:58 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

 

Hi Anitha,

 

I picked up that incident and responded.  

 

In a nutshell, in case you get this first, see  <https://urldefense.proofpoint.com/v2/url?u=https-3A__launchpad.support.sap.com_-23_notes_2497589&d=DwMGaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=bVUQ4VnC5bkps8UaCa2zhRJCN7S9nQjjQadKLNAPaJg&m=B5SKNo0SDQDVCHYZGRjWZYj9WE7PFYqYRYwSxh50MCE&s=Nrro1gTwhabGUGSiKscy68q8r7C5IU6CACzRoXFQYEw&e=> 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  <mailto:kirby.gehman at sap.com> kirby.gehman at sap.com

 <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sap.com_&d=DwMGaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=bVUQ4VnC5bkps8UaCa2zhRJCN7S9nQjjQadKLNAPaJg&m=B5SKNo0SDQDVCHYZGRjWZYj9WE7PFYqYRYwSxh50MCE&s=wCEGYY08KYhtIAz-i93az7yfdI4r1uu_CDjxe17Y2wc&e=> http://www.sap.com/  <https://urldefense.proofpoint.com/v2/url?u=https-3A__global.sap.com_profile_unsubscribe.epx-3FPID-3D10386-26PFID-3D12894&d=DwMGaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=bVUQ4VnC5bkps8UaCa2zhRJCN7S9nQjjQadKLNAPaJg&m=B5SKNo0SDQDVCHYZGRjWZYj9WE7PFYqYRYwSxh50MCE&s=GORXlj4cP56YAhwSTbJsM1RRnDkimAdcCohk9MydA1s&e=> unsubscribe




 

 

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 <https://urldefense.proofpoint.com/v2/url?u=http-3A__X.fund&d=DwQGaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=bVUQ4VnC5bkps8UaCa2zhRJCN7S9nQjjQadKLNAPaJg&m=B5SKNo0SDQDVCHYZGRjWZYj9WE7PFYqYRYwSxh50MCE&s=NKdeFk94rogFirspF7_AjDDXHQwm6H_wWgYJR82CycQ&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/8cab22da/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4700 bytes
Desc: not available
URL: <http://iqug.org/pipermail/iqug/attachments/20170830/8cab22da/attachment-0001.png>


More information about the IQUG mailing list