BusinessObjects Board

Any issues when upgrade from 5.1.4 to 5.1.8

Hello we are planning to upgrade 5.1.4 to 5.1.8, not 6 :frowning:
becuase we are using more vb sdk
Anyone comeacross major issues, upgrade from 5.1.4 to 5.1.8(webi2.7.4, bo518,bca 558)

Thanks


Shahubar Sadiq :india: (BOB member since 2003-02-28)

In theory, no. However, you should check out the calculation engine changes. Tech support has this on the Important Notices page. They even include a macro that will help you identify reports that may be affected.


Steve Krandel :us: (BOB member since 2002-06-25)

Thanks Steve
The calculation engine changes were implemented 5.1.4+
we are in 5.1.4 almost a year. do we need report verification/testing?

However, the tools available for 5.1.6, not 5.1.8, any sugesstion?


Shahubar Sadiq :india: (BOB member since 2003-02-28)

I never remember which version.

If youā€™re already on the version with the changes, then you should have nothing to worry about.

The tools would work with 5.1.8. There are no major changes, just fixes in the release.


Steve Krandel :us: (BOB member since 2002-06-25)

Hi

From what Iā€™ve experienced so far, I cannot recommend the 5.1.8 release. I installed it on one of our power usersā€™ computer only because we noticed that older versions donā€™t shrink a big report file properly even if you purge it.
That works but within two days the user encountered two quite serious problems:

Reports with Excel as data source ā€œlostā€ the connection to some Excel files or sheets within Excel files, although the path settings etc. look ok. We could work around it by pointing the affected data provider to a different Excel file and then back to the previous one. Utterly annoying.

A few, very big reports (several 10ā€™000 rows) would not open but produce ā€œout of memoryā€ errors. Not a problem with 5.1.4 or 5.1.6, though.

There were some more files the user couldnā€™t open anymore but I didnā€™t even look into that. We downgraded to 5.1.6 today and the guyā€™s happy. So am I. :wink:

Regards,
Silvan


apollonius :switzerland: (BOB member since 2003-11-11)

Silvan,
Thanks for this. Iā€™ve been very happy with 5.1.6 and really didnā€™t want to upgrade.


Steve Krandel :us: (BOB member since 2002-06-25)

We are upgrading to 5.1.8 also. I would appreciate any comments on stability or problems related to the upgrade. We are hoping that the move to 5.1.8 from 5.1.4 will fix our Print Legal formatting issues when using BCA. Any advice would be appreciated.

Thanks,
Andrew


Andrew Mitchell :canada: (BOB member since 2003-06-09)

Hi Andrew

Iā€™m using BCA 2.7.2 (resp. Console 5.5.6) on Windows. (I think this comes along with the Full Client version of 5.1.6).
Personally, Iā€™m quite happy with this version and I havenā€™t encountered any formatting problems with any version higher than 5.1.2 anymore.

Since Iā€™ll switch to 6.1 soon, Iā€™ll not use 5.1.8 anymore (see my problems mentioned in the earlier post). But I can recommend 5.1.6.

Regards,
Silvan


apollonius :switzerland: (BOB member since 2003-11-11)

Silvan,

Thanks for your comments on 5.1.8 ā€“ weā€™re planning on migrating to it soon and Iā€™m trying to get as much feedback as possible.

Based on what Iā€™ve heard, 5.1.7 is more stable than 5.1.6, and Iā€™m very surprised to hear that you had issues with 5.1.8, which is simply a release that improves 5.1.7. Are you sure it wasnā€™t a problem with the PC, report or the uninstall of the previous version? How did BOā€™s tech support respond to the issue?

What do you mean by ā€œBCA 2.7.2?ā€ Are you running BCA without WebI? It would be great if you could briefly describe your architecture.

Thanks again!
Chris


cjweis (BOB member since 2003-10-02)

Hello Chris

The issues with the Excel file as a datasource I described earlier were reproduceable on more than one PC. I refresh the report in 5.1.4 or 5.1.6, not a problem. Upgrade to 5.1.8, open the same file and some data providers have DMA0007 error. Deinstall 5.1.8 and reinstall 5.1.6, same file, works. Dosenā€™t matter whether Office XP or 2000 is in use.
The issue with the big report (lots of rows) I only saw on one PC. Got a memory error with the file, deinstall 5.1.8 and reinstall 5.1.6, open the same file, it works.

For the Excel thing, I had a case with BO. The first thing they came up with was the idea that the link to the datasource file was ā€œlostā€ and I should re-link the sources. Thatā€™s what I did, as described in the other post. However, this is of course quite annoying if you have to do it for a lot of reports. There was no bug mentioned by BO support.
We did not try more reports after that because Iā€™ll deploy 6.1a soon (and reduce the number of full clients significantly) and 5.1.x will become obsolete.

As for your BCA question, the answer is ā€œyesā€. :slight_smile: I installed ā€œonlyā€ BCA on that server although it automatically installs almost the entire WebI software. The configuration is done via the Admin Console you get with WebI as well but has - of course - fewer modules available than with a full WebI installation.
I did it this way because this server will never act as a full-blown WebI server, so thereā€™s also no Web server running on it.

Regards,
Silvan


apollonius :switzerland: (BOB member since 2003-11-11)

I think that if you donā€™t run Webi on the BCA box, you wonā€™t be able to schedule .wqy reports to run. We had some of that going on here. I donā€™t know whether 6.1a reports can be scheduled to BCA without Webi running there :confused: .


Cindy Clayton :us: (BOB member since 2002-06-11)

Hello Cindy

Youā€™re quite right. As I mentioned, it installs basically all the WebI stuff anyway and also starts most of the related processes on the system.
However, if installed this way, the only modules you can (and have to) configure are the SessionManager, StorageManager, BOManager and Broadcast Agent itself. And if you restart the setup program, it will ā€œtellā€ you that only BCA is installed.

But itā€™s almost a detail, really. The software it puts on your system is the WebI software.

Regards,
Silvan


apollonius :switzerland: (BOB member since 2003-11-11)

Silvan,

Thanks again. Could you share your tech support case #? Iā€™d just like to have it for future reference (if we encounter the same problem - which I hope we donā€™t).

Are you deploying WebI 6.1a with Tomcat? Iā€™ve heard thereā€™s stability issues with Tomcat. :?

Regards,
Chris


cjweis (BOB member since 2003-10-02)

Hi Chris

Hereā€™s the support case# I had for the Excel issue: 302457164

Yes, Iā€™m currently running the 6.1a with Apache/Tomcat on Windows2000. But itā€™s still in a test phase. So far, Iā€™d call it quite stable although Iā€™m struggling with occasional ā€œBoMgrā€ errors and ā€œunable to find sessionā€ and ā€œbad caller workflowā€ etc. A lot of it is related to parameter and timeout settings, though.
In the future, it should run on Unix with Bea WebLogic but thatā€™ll take a little longer to get in a reliable stateā€¦

Regards,
Silvan


apollonius :switzerland: (BOB member since 2003-11-11)

upgrade from 5.1.4/Webi27 to 5.1.8/Webi274
Uninstall and Reinstall new release or Update with current
which one is best practice? Any Suggestion


Shahubar Sadiq :india: (BOB member since 2003-02-28)

We had a problem when moving to 5.1.7 from 5.1.3 with Zabo clients as there was some change in the .rss file or something in 5.1.7 (apparently this is in the readme file). This meant uninstalling all our Zabo clients and doing a fresh install - takes the Zero out of Zero Admin. So beware if your using Zabo.


Alex McGibbon (BOB member since 2002-08-15)

I just completed my upgrade to 5.1.7 in development. I scheduled a report in BCA that prints legal landscape. :reallymad: When it came out of BCA it was formatted landscape on letter-sized paper and prints over two pages. I thought this was fixed in 5.1.7. Has anyone else seen this and do you have any advice?

Thanks,
Andrew


Andrew Mitchell :canada: (BOB member since 2003-06-09)

Hello Andrew

I had plenty of formatting issues with 5.1.2 and older versions but not after thatā€¦

However, did you make sure that the basic settings of the printers installed on your BCA server (ā€œPrinting Preferencesā€ resp. properties and available paper in the printer trays) are all set to ā€œlegalā€ format?
In my case, I even had issues with reports sent to the BCA by users who had their local printers set to the wrong paper format. In other words, the report had a setting for ā€œletterā€ on it, caused by the same setting in the printer driver on the usersā€™ PC - although the setting for the printers on the BCA was correct.

Regards,
Silvan


apollonius :switzerland: (BOB member since 2003-11-11)

Thanks for the advice, however I did not change the printer setting to legal. Most of my reports do not print on legal paper. This problem only happens when I retrieve a scheduled report from BCA to Full Client. When I get the same report in WebI and print it is fine.

We have been struggling with this one for a long line and our business thinks that WebI is garbage. Very Frustrating. :hb:

Thanks,
Andrew


Andrew Mitchell :canada: (BOB member since 2003-06-09)

Shahubar,
Another issue with 5.1.7/5.1.8 is that keyboard shorcut keys (Esc, Alt-R, etc.) do not work in the Query Panel (this is bug no. 1085699 and due t fixed in 5.1.9).


Amanjeev (BOB member since 2003-07-10)