Hi all

We are experiencing an issue where some of our LARGE reports (xml of 35mb or larger) are not getting converted completely to PDF format for viewing via reporting services and in some cases doesn't get converted at all.

Has anyone experienced this and what did you all do?

Also, I have working with the ftp settings for that particular datasource and i wanted to know what other company's lbi ftp data source settings were like. We had our timeout at 10 seconds and i worry that might be part of our issue.

Any help is appreciated.

Versions
LBI RS: 9.0.1.6
ENV: 8.0.3.6
APP: 8.1.0.2

So is it safe to assume you are using LBI 9.0.x and that the reports you are referring to are published Lawson back office reports?

Are you on tomcat or websphere? I would look at your LBI logs, they should give some indication of what is happening there.

I will take a look at the timeout setting on some other instances and post back.

hth,
matt

Yes ... you are right on the LBI version and also that it's a Lawson Back Office report. Also, we use Tomcat for now until we go up on Env 9.0.

Do you know how i can find where the logs are stored. Unfortunately i'm flying by the seat of my pants. Our Sys Admin is on vacation this week.

Any and all help is appreciated.

Almost all information is going to be written to the stdout.log file. That is in the [tomcat_root]\logs directory. Default lawson installation put the [tomcat_root] in [drive]:\LawsonBusinessIntelligenct\tomcat-5.0.28\

Also, sparse information will be written to stderr.out and localhost_log.2007-07-11.txt (one for every day).

Also, Id consider patching you LBI system. You are 3 patches behind on RS for the 9.0.1.x release. There is a 9.0.2 release but be sure to review you setup and improvements because the upgrade is very tricky.

hth,
matt

There's a directory on the Reporting Services server, \Broadcast\Lawson Back Office (located at \\LawsonBusinessIntelligence\ReportingServices\PublishedReports\LawsonDocuments if default options were chosen when installing), that contains a file called "Broadcasting (YYYY-MM-DD HH:MM:SS AM/PM Timezone).csv" that is created each time a new Back Office report is published to LBI. The file contains the LBI report id, the date/time the .prt file was created on the Lawson server, and the path of the .prt file on the Lawson server.

There's another directory on the RS server, \Pending\Lawson Back Office (located in the same directory as \Broadcast\Lawson Back Office). that you may want to check.

One other thing I've noticed with LBO reports is that if a historical instance is created, but the user doesn't have rights to see any of the data that is on the report, the users gets a blank viewer window when selecting the instance. This can create confusion if there is no data that the user can see (the report may appear as if it's not working). To alleviate some of this confusion, you can force something to be displayed all of the time by enabling the Report Information Page or the Report Parameter Page, checkboxes on the report Output Options in LBI.