Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Upgrading to LBI 10
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
TomV
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5186
People Online:
Visitors:
277
Members:
0
Total:
277
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Upgrading to LBI 10
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Page 1 of 2
1
2
>
>>
Author
Messages
ric9d
Veteran Member
Posts: 76
3/27/2013 2:29 PM
Has anyone here upgraded from LBI 9.05 to 10?
I called Infor Support and was told that it would take 1-2 hours, maybe even less. And that it would just be an install on top of the existing one.
Is it really that easy? What should I look out for?
We are only upgrading LBI to 10. None of the other Lawson apps would be upgraded. Is that possible? recommended?
Thanks!
Matthew Nye
Veteran Member
Posts: 514
3/27/2013 2:49 PM
I think youve got your versioning wrong. the last minor version of LBI in the 9.0.x major version was 9.0.4.2.
The effort all depends on a number of variables:
> How many servers is your LBI instance installed on?
> What database platform are the LBI repositories using
> Are you using DSSO?
> Is your current LBI instance on WebSphere 6.1?
> Will you be upgrading Crystal components?
For someone that is experienced with LBI upgrades you can certainly complete this upgrade in a couple of hours however when you do hit an issue, they can take hours to resolve. If you have a distributed instance of LBI Id say this estimate is pretty aggressive.
Greg Moeller
Veteran Member
Posts: 1498
3/27/2013 2:49 PM
Yes, I've done it. 2 hours would be a good estimate.
Are you using DSSO for LBI authentication?
The format of the pages change a little bit from 9 to 10 with 10 looking more squared-off.
It is just an upgrade of the existing LBI so you would just install on top of what you already have...
Make sure you follow the 'Upgrade existing...'
There are really no gotcha's that I've encountered. Recommended to upgrade LBI to version 10 way before your Lawson app upgrade, YES!
Greg Moeller
Veteran Member
Posts: 1498
3/27/2013 3:00 PM
Matthew brings up several good points! I had assumed that you already were on Websphere 7, with the required FixPack and no updates to Crystal. Good job, Matthew!!
ric9d
Veteran Member
Posts: 76
3/27/2013 3:08 PM
Thanks a lot Matthew & Greg.
Here are my responses to your questions:
1. We are using DSSO.
2. One server for LBI Dev another for PROD
3. We are using SQLServer
4. We are on Websphere 6.1
5. Yes we have Crystal Components
Is there a problem upgrading only LBI? I mean all the other Lawson Apps will not upgraded.
(Yep, my mistake on the version. Im old!)
Thanks in advance. You Rock!
Greg Moeller
Veteran Member
Posts: 1498
3/27/2013 3:22 PM
Then your upgrade will likely take a bit more time and effort.
Some Requirements for LBI 10 are:
MS Windows Server 2008 (64-bit) * Will this require a hardware change for you?
WebSphere 7.0 with a minimum FixPack of 11 (we have FP 25 installed)
I would suggest upgrading/updating the Crystal components along with this upgrade as outlined in the Install Guide.
Go through (read and re-read) the Install guide and release notes a couple times, just to make sure that you know what you are about to undertake and follow the install guide exactly.
Ruma Malhotra
Veteran Member
Posts: 412
3/27/2013 3:23 PM
We had upgraded to LBI 10 last july with a similar setup except our database was oracle and we did not have any issues.
ric9d
Veteran Member
Posts: 76
3/27/2013 3:24 PM
Correction. We are on Websphere ver 7.0.
Matthew Nye
Veteran Member
Posts: 514
3/27/2013 3:43 PM
and your SQL Server version? 2008 R2 is the only version supported with LBI 10.
You dodged a bullet on the WebSphere version. Moving from 6.1 to 7 usually necessitates basically a fresh install but looks like youre in pretty good shape. I still think 2 hours is pretty optimistic and probably, if youre being meticulous and creating good documentation, it should be more like a 4-8 hour effort with no issues.
good luck and let us know how it goes.
ric9d
Veteran Member
Posts: 76
3/27/2013 6:27 PM
Matthew, are you positive abour R2? We only have SQLServer 2008. The install/upgrade doc clearly says SQLServer 2008 or SQLServer 2008 R2. The document is dated May 2012, maybe it has changed.
Matthew Nye
Veteran Member
Posts: 514
3/27/2013 6:54 PM
Im not 100% but the LBI 10.1 install doc for SQL Server states:
Repository Database: Microsoft® SQL Server 2008 R2
I dont really see what the problem would be as the difference between SQL Server 2008 and SQL Server 2008 R2 is pretty minimal but you might want to ask Infor for an official response.
ric9d
Veteran Member
Posts: 76
3/27/2013 7:28 PM
I got a response from Infor Support: LBI 10 requires SQLServer 2008 R2.
ric9d
Veteran Member
Posts: 76
3/28/2013 10:17 PM
SQLServer 2012 is NOT supported either.
ric9d
Veteran Member
Posts: 76
9/16/2013 2:44 PM
Follow question to you all:
We upgraded DEV (well Actually LMS did it). We are having some issues with the reports. They run fine before in Version 9, and now its returning reports with 0 records in LBI 10.1. It still runs perfectly in stand Alone crystal 2008. It's just in LBI 10.1 that it returns 0 records. My question is: 1. anybody out there who have had this problem?
2. Is it "ok" to publish CR 2008 in LBI 10.1? or do I have to go higher version Crystal?
Thanks!
Greg Moeller
Veteran Member
Posts: 1498
9/16/2013 3:00 PM
Make sure your data sources on your RAS server are pointing to the correct place....
Yes, perfectly fine CR2008 and LBI 10.
Anne-Marie
Basic Member
Posts: 7
10/30/2013 8:47 PM
What about Scorcard? It seems that it is with a new product in LBI 10. Has someone has experience with this?
ric9d
Veteran Member
Posts: 76
10/31/2013 12:54 PM
We are still having issues with our reports in LBI 10.1. We have an open ticket with Infor Support and no resolution as of yet. One of the major issues is that some reports are returning 0 records; One particular report runs in standalone Crystal 2008 (and also 2011) and returns records. It has also been running for more than 2 years in LBI version 9.0.4. Its just that after the upgrade we are having all these issues.
Greg Moeller
Veteran Member
Posts: 1498
10/31/2013 1:15 PM
You could try deleting one of your problem reports from LBI - Delete the whole thing from LBI, and start over... republish as a new report. See if that fixes things without changing the actual .rpt file.
Matthew Nye
Veteran Member
Posts: 514
10/31/2013 3:09 PM
have you tried opening the report in the same version of the designer that you have as your RAS engine, saving the report and republishing?
ric9d
Veteran Member
Posts: 76
10/31/2013 6:19 PM
Gregg & Matt: Unfotunately I have tried that, and more. The report(s) have been running for more than 2 years in both DEV and PROD. Its only the upgrade that messed it up. Inspite of that I still tried to do some stuff with the report just to make sure. Also because of this we have not upgraded our PROD yet, and the reports are all running fine there. The reports are fine with Crystal 2008 and 2011 stand alone, it works. Some of the things I've done: deleted, published and republished report in both 2008 and 2011, changed DataSource from OLE to ODBC and back. I also saved the report in 2011 and the published it in PROD, and it works there.
Matthew Nye
Veteran Member
Posts: 514
10/31/2013 6:30 PM
I would do a profile on the target database and see what SQL is actually being executed. This could actually be a Reporting Services bug and not a Crystal version issue. report back what you see and we'll see if we can add anything.
ric9d
Veteran Member
Posts: 76
11/1/2013 2:45 PM
I need a huge favor from anyone. We are still having this issue, and I was wondering if anybody can help me troubleshoot.
Like I have mentioned in my previous posts, we have this report that is returning 0 records (the report is generated with the headings etc but with no data). I would appreciate so much if somebody could publish this report on his/her own LBI environment and see if it works. (I would give a copy of my .rpt file and you could publish it).
Thank you.
Greg Moeller
Veteran Member
Posts: 1498
11/1/2013 6:56 PM
Sure... We're on LBI 10.1.11.0.176 with Oracle databases.. If that's acceptable to you, I'll publish your report file if you'd give it to me.
ric9d
Veteran Member
Posts: 76
11/1/2013 7:09 PM
Greg: we are using SQLServer 2008 r2. Is that gonna be a problem?
ric9d
Veteran Member
Posts: 76
11/1/2013 7:16 PM
Matt: I followed your advise and worked with my dba to get the sql thrown by lbi to the db when running the report. VERY interesting: one of my filters is -->USR_STATUS='AC' OR USR_STATUS='CP'<--. However when we caught the sql from lbi it is changing it to
-->USR_STATUS='ac' OR USR_STATUS='cp'<--. Hence the 0 records. I sent this to support, and waiting on their response.
Thanks.
You are not authorized to post a reply.
Page 1 of 2
1
2
>
>>