LBI Installed - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

jellis

Veteran Member

Posts: 54

2/20/2009 8:43 PM

Well I have managed to install LBI (efs,ers, and sn) on Websphere 6.1 FP13 with CRAS VI R2. I can login and publish reports, but when I run them I get an error that the file could not be found. Below is my Websphere log-

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The device is not ready.
---- Error code:-2147467259 Error code name:failed
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The device is not ready.
---- Error code:-2147467259 Error code name:failed
    at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
    at com.crystaldecisions.proxy.remoteagent.s.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ClientDocument.open(Unknown Source)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.OpenReport(CrystalEngine.java:448)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.getParamCount(CrystalEngine.java:857)
    at com.lawson.efs.ers.Content.Report.hasCrystalParameters(Report.java:2114)
    at com.lawson.efs.ers.Content.Report.useCrystalParameterPage(Report.java:2076)
    at com.lawson.efs.ers.web.RequestHandlerServlet.getparameterMap(RequestHandlerServlet.java:1318)
    at com.lawson.efs.ers.web.RequestHandlerServlet.doPost(RequestHandlerServlet.java:884)
    at com.lawson.efs.ers.web.RequestHandlerServlet.doGet(RequestHandlerServlet.java:92)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:766)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:674)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498)
    at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
    at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
[2/20/09 12:36:50:071 PST] 00000022 SystemOut     O INFO [WebContainer : 3] (Repository.java:232) - Executing Database Statement: SELECT ATTRIBUTECATEGORY, ATTRIBUTENAME, ATTRIBUTEVALUE FROM ERS_SERVERATTRIBUTES WHERE (SCGROUP = ?) AND (SCTYPE = ?) AND (SCNAME = ?) ORDER BY ATTRIBUTECATEGORY
[2/20/09 12:36:50:071 PST] 00000022 SystemOut     O INFO [WebContainer : 3] (Repository.java:238) - Argument Count: 3
[2/20/09 12:36:50:071 PST] 00000022 SystemOut     O INFO [WebContainer : 3] (Repository.java:243) - Using Argument Value: 2
[2/20/09 12:36:50:071 PST] 00000022 SystemOut     O INFO [WebContainer : 3] (Repository.java:243) - Using Argument Value: 5
[2/20/09 12:36:50:071 PST] 00000022 SystemOut     O INFO [WebContainer : 3] (Repository.java:243) - Using Argument Value: ERS
[2/20/09 12:36:51:258 PST] 00000022 SystemOut     O ERROR [WebContainer : 3] (CrystalEngine.java:358) - CrystalEngine:GetCurrentDocument:com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The system cannot find the file specified.
---- Error code:-2147467259 Error code name:failed
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The system cannot find the file specified.
---- Error code:-2147467259 Error code name:failed
    at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
    at com.crystaldecisions.proxy.remoteagent.s.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ClientDocument.open(Unknown Source)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.OpenReport(CrystalEngine.java:448)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.getCurrentDocument(CrystalEngine.java:352)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.processReportRequest(CrystalEngine.java:170)
    at com.lawson.efs.ers.ReportEngines.ReportEngine.processReportRequest(ReportEngine.java:79)
    at com.lawson.efs.ers.ReportEngines.ReportRequest.process(ReportRequest.java:495)
    at com.lawson.efs.ers.web.RequestHandlerServlet.doPost(RequestHandlerServlet.java:893)
    at com.lawson.efs.ers.web.RequestHandlerServlet.doGet(RequestHandlerServlet.java:92)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:766)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:674)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498)
    at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
    at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
[2/20/09 12:36:51:258 PST] 00000022 SystemOut     O ERROR [WebContainer : 3] (CrystalEngine.java:315) - Error Processing Crystal Report File: The system cannot find the file specified.

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The system cannot find the file specified.
---- Error code:-2147467259 Error code name:failed
    at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
    at com.crystaldecisions.proxy.remoteagent.s.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.if(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ReportClientDocument.a(Unknown Source)
    at com.crystaldecisions.sdk.occa.report.application.ClientDocument.open(Unknown Source)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.OpenReport(CrystalEngine.java:448)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.getCurrentDocument(CrystalEngine.java:352)
    at com.lawson.efs.ers.ReportEngines.CrystalEngine.processReportRequest(CrystalEngine.java:170)
    at com.lawson.efs.ers.ReportEngines.ReportEngine.processReportRequest(ReportEngine.java:79)
    at com.lawson.efs.ers.ReportEngines.ReportRequest.process(ReportRequest.java:495)
    at com.lawson.efs.ers.web.RequestHandlerServlet.doPost(RequestHandlerServlet.java:893)
    at com.lawson.efs.ers.web.RequestHandlerServlet.doGet(RequestHandlerServlet.java:92)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:766)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:674)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498)
    at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
    at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
[2/20/09 12:36:51:258 PST] 00000022 SystemOut     O ERROR - RequestHandlerServlet caught ERSException: The system cannot find the file specified.

Any help would be great.

John Henley

Posts: 3353

2/20/2009 9:16 PM

Did you miss the step in the Crystal server install where you configure RAS?
Change Report Application server Parameters:
Option Type = Server
Maximum Simutanous Report Jobs = Unlimited
Report Directory = *

jellis

Veteran Member

Posts: 54

2/20/2009 9:34 PM

Yeah I did that part. My RAS is remote..different server. I also copied the \lib folder over to the LBI box. Here is my clientsdkoptions.xml file..maybe something is missing. Also a screenshot of the error is attached. Along with txt file of the .xml.

John Henley

Posts: 3353

2/20/2009 10:08 PM

Even if you are going to run RAS on a diff server, I think you still have to install RAS on the LBI server (check the install doc)

jellis

Veteran Member

Posts: 54

2/20/2009 10:35 PM

It did the steps as outlined in pages 17-22 of the manual. Basically it says to install a full copy on the remote, but only the SDK portion on the LBI. I then went through and did the post install setup as well. I can attach the manual I used if need be...not sure if that violates any rules though.

jellis

Veteran Member

Posts: 54

2/20/2009 10:41 PM

I have done as the document requires, which is to install full RAS on the
remote box, but the LBI box just gets the SDK installed.

(See attached file: LBI Installation Guide S3.pdf)

|------------>
| From: |
|------------>
>------------------------------------------------------------------------------------------------------------------------------------------|
|forums-epm-lbi@lawsonguru.com |
>------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>------------------------------------------------------------------------------------------------------------------------------------------|
|jellis@clackesd.k12.or.us |
>------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>------------------------------------------------------------------------------------------------------------------------------------------|
|02/20/2009 03:09 PM |
>------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>------------------------------------------------------------------------------------------------------------------------------------------|
|Re: LBI Installed [00005906:00006470] |
>------------------------------------------------------------------------------------------------------------------------------------------|

(Embedded image moved to file: pic13983.jpg)
Lawson Business Intelligence/Reporting/Crystal Forum Notification
A message was posted to a thread you were tracking.
|----------+--------------------------------------------------------------|
|John |Subject: Re: LBI Installed |
|Henley | |
|Posted:02/|Even if you are going to run RAS on a diff server, I think you|
|20/2009 |still have to install RAS on the LBI server (check the install|
|06:08 PM |doc) |
|----------+--------------------------------------------------------------|

You may reply to this thread via e-mail; please do not remove the message
tracking number from the subject line, and do not include this message in
your reply. To view the complete thread and reply via your browser, please
visit:
https://www.lawsonguru.co...fc/6470/Default.aspx

You were sent this email because you opted to receive email notifications
when someone posted and/or responded to a message on this forum.
To unsubscribe to this thread please visit your user profile page and
change your subscription options.

Thank you,
LawsonGuru.com

Chris Martin

Veteran Member

Posts: 277

2/21/2009 9:01 AM

Hmmm...it's been a little while since I've done one of these. It sounds like RAS (for remote RAS) was installed correctly. Are you running the RAS service as a Local System account or a network user? What is the path for your published reports in the Report Admin screen? Are you using a UNC?

jellis

Veteran Member

Posts: 54

2/23/2009 3:14 PM

I have tried it as both a system account and local user account with full rights. No luck. As for the path for published reports, what do you mean? The repository path?

Matthew Nye

Veteran Member

Posts: 514

2/23/2009 3:35 PM

just to validate that the separate instances of crystal are working can you point RS directly to each of your RAS instances. This is done from RS Administrator under System Settings. Put in the DNS name of one of the exact RAS server and see if you can run the reports.

I would also check your firewall settings. I cant remember off the top of my head what port they run on but make sure its open on all the servers.

jellis

Veteran Member

Posts: 54

2/23/2009 3:52 PM

Firewall on remote RAS is disabled, and I have tried reporting directly to it by changing the settings in Settings...I only have one remote instance at the moment.

Chris Martin

Veteran Member

Posts: 277

2/23/2009 4:03 PM

Before troubleshooting by pointing it directly to the RAS Server, you did have the Default RAS setting in RS as blank, correct?

jellis

Veteran Member

Posts: 54

2/23/2009 4:10 PM

Ok more info--

As for the reporting path, I am using d:\LawsonRespository on the LBI server...does this need to be a share that the remote RAS boxes need to be able to connect to in order to pickup the reports and run them?

I also have this same discussion over on Lawson Talk with only Chris. I will close down that post so as not to have the same thing in multiple places.

jellis

Veteran Member

Posts: 54

2/23/2009 4:19 PM

That is correct. Blank there and the clientsdkoptions configured as below-

lras1.server.com:1566
TCPIP

600000
true

true
C:/temp/
true
true

Matthew Nye

Veteran Member

Posts: 514

2/23/2009 4:27 PM

your RAS services need to be running under a network account that has read/write access to the document repository but the error doesnt seem to indicate a permissions issue. seems to be pointing to not being able to find the services youve set up. thats why id make sure those services are accessible from the LBI app server.

jellis

Veteran Member

Posts: 54

2/23/2009 4:55 PM

Ok I found I think part of the gremlin, and that was that it was putting the newly created reports to d:\lawsonrepository\lawsondocuments. I went back through and changed the settings in installvalidator to d:\ so now all reports are created to just lawsondocument. Restarted Websphere and then published a new report. Still the same. Attached are a new Websphere log and the clientsdkoptions.xml since it did not like being pasted in my last post.

On the remote RAS server I have set the RAS service to use the Administrator account which should give it full access to the LBI box.

Matthew Nye

Veteran Member

Posts: 514

2/23/2009 7:45 PM

could you post a bullet point of how your LBI env is set up:

Example
Server1 - FS, RS, SN
Server2 - RAS, IIS
Server3 - RAS, ISS

jellis

Veteran Member

Posts: 54

2/23/2009 8:08 PM

I can no problem-

I currently have four servers with one more RAS to bring online-

Server1-Websphere, Framework Services, Reporting Services, and Smart Notification

Server2-Is just RAS and nothing else...no IIS. Is that needed?

Server3-Is just RAS and nothing else...no IIS. Is that needed?

Server4-MSQL 2005.

I have also recently found that by modifying the directory information that is set in the RAS engine from * to say the \lawsondocuments folder on the LBI server then the error changes to a permissions error. Very interesting. How is the remote RAS suppose to connect back to the LBI server to actually pickup the report and run it?

Greg Moeller

Veteran Member

Posts: 1498

2/23/2009 8:25 PM

Running a remote RAS, you have to be running the service logging in as a domain user - If you have Repository Available to RAS set to TRUE.
Currently we are using a UNC path and in our RS settings, it states that under both Repository Path and Report Archive Path... just different directories.
ie. \\server.domain.com\ and \\server.domain.com\archive\ respectfully.

Matthew Nye

Veteran Member

Posts: 514

2/23/2009 8:25 PM

Which server does the report repository reside on?

Assuming server1, the RAS services on server2 and server3 need to run under a network account that has read/write permissions on the \lawsondocuments folder on server1. The administrator account on the RAS engines are local so they wont have that access.

Have you checked the Firewall settings also?

jellis

Veteran Member

Posts: 54

2/23/2009 8:41 PM

Ok just to clarify-

The firewalls on all of these boxes have been disabled and the servers rebooted to make sure the firewall is gone.

Currently in my Reporting Services>Settings I have the repository path set as d:\lawsondocuments on server1...do I need to change this to a global setting so that the remote RAS engines know how to get to it, or just configure on the RAS properties settings (on each individual RAS server) that the report directory is this share?

I do not have ADS running in this environment, I set the RAS service to run as the local administrator account which is the same for all of these boxes and have tested that that user can copy/paste/modify items in the shared folder. Traditional MS topology is not used as it is not a choice.

Greg Moeller

Veteran Member

Posts: 1498

2/23/2009 9:02 PM

I am thinking that the LawsonDocuments folder is a point of confusion here. When you have it set in Reporting Services>Settings to d:\lawsondocuments you will end up getting d:\lawsondocuments\lawsondocuments\reports -- If that is what you intend, that's fine. Just be aware of the assumption that LBI makes.

jellis

Veteran Member

Posts: 54

2/23/2009 9:21 PM

Thanks Gentlemen for your assistance. My mistake is that I had d:\ in the settings and it was just never going to find the appropriate folder. When I put in d:\lawsondocuments, it created the folder in two layers as d:\lawsondocuments\lawsondocuments and now everything works. Interesting how this works.

Anyway I am sure I will have another question or two as things move forward. Thanks again.