on 04-09-2013 2:24 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.