Error "invalid use of an aggregate function" while refreshing WEBI on Syabse IQ 15.4 datasource

[Former Member]

I have few WEBI reports which are working very well in my test environment on BO XI 3.1 SP3 FP3.5 with Sybase IQ 15.1 as data source. When I moved these reports to production where we have Sybase IQ 15.4 as data source, I am getting error "[Sybase][ODBC Driver][Sybase IQ] " Invalid use of an aggregate function" (WIS 10901)". (attached)

In my report I have used functions like STDDEV, AVERAGE, SUM. COVAR_SAMP etc which I have activated in asiq and asiqen .prm files. I am not able to reach conclusion as what is causing this error.

Quick help will be a great relief as we are overdue to go live.

[former_member191664 · Accepted solution]

Hi,

In order for your Webi reports to use Sybase 15.4, you'd have to upgrade your BOXI3.1 SP3 to at least SP5.  See page 14 of the SAP BusinessObjects Enterprise XI 3.1 SP5 for Windows – Supported Platforms.

The reason is that BOXI3.1 SP3 supports up to Sybase 15.2.

Help this helps,

Jin-Chong

[Former Member · Accepted solution]

Hi JinChong/Zahid,

Thanks for your replies. I was unwell and could not check on these. I will definitely look into these on Sunday when our customer opens (We have Fri-Sat week-end).

Update to SP5 looks a distant possibility as customer being a financial institution,  everything small update in production is an assignment. I will then try to switch back to Sybase 15.2. Lets see.

I shall update you guys on this.

Thanks & Regards

Piyush

[Former Member]

Hi,

This is an SQL-error reported back from the database, not Business Objects, probably because IQ 15.4 is more stringent as to correct usage than 15,1. From time to time Sybase removes functionality which worked on earlier versions because it was incorretly implemented as per the ANSI SQl standards.

I have had this kind of error many times before, and it was always an SQL-issue. Can you send us the actual SQL which ypu are running?

[Former Member]

is your dev universe connection equal to your prod universe connection? was it defined as generic odbc  or sybase odbc?

why did you have to activate  those parameters in your asiqen .prm? weren't those aggregate functions working properly in the universe from the first moment?

[former_member184594]

Hello,

1. Did you have sysbase ODBC or connection drivers installed on your PROD machine?

2. Did you define ODBC connection in your Production system just like in your DEV? (Keep in mind that you need you use the same as ODBC name defined in DEV when creating odbc in PROD.)

[Former Member]

Hi Zahid,

Thanks for your reply. I have ODBC properly configured as I am able to access the datasource from Universe and can see table values through it.

only difference between PROD and DEV is Sybase IQ version. on PROD it is 15.4 and on DEV it is 15.1.

I have copied the asiq.prm and asiqen.prm file from DEV to PROD as well.

It is puzzling as I am not able to trace the error causing function.

Thanks again for responding.

Piyush

[former_member184594]

Another question. I know you said you configured odbc correctly but did you configure odbc with 64bit driver or 32 bit? Try to create both 32 bit and 64 bit odbc connection with the same name.