LBI/crystal issue

it would suggest an problem with your SQL in the report and the database its pointing to.

Or (depending on your setup) I've seen similar errors happen when I have the RAS service running just under local system acct.
Or if you are using a domain user acct, perhaps the password has expired? *In either of the above cases, I'd suspect that more than just one report would not be working, though.

Have you tried running the report from your desktop? This way you will eliminate whether is a crystal or an LBI issue or whether it is crystal installed on the LBI server.

Hi Ruma. Yesy I have successfully run the report from my desktop. The issue is whenI run it via LBI I get that error. However the report brings back the correct data. That's what I din't understand. Thanks Ruma.

Hi Matthew. This is tstanley. The database is oracle that I am using. I have had our DBA monitor the report when it is running and he see's nothing other then the SQL in his logs. The report seems to be bringing back the correct data. That's what I don't understand. Thanks Matthew.

Hi Greg. This is tstanley(tom). The database is oracle that I am using. I have had our DBA monitor the report when it is running and he see's nothing other then the SQL in his logs. The report seems to be bringing back the correct data. That's what I don't understand. Also there are other reports that are giving me the same error but are bringing back the correct data. Thanks Greg.

Tom,

if you are getting an error, how are you getting correct data? Seems the two would be mutually exclusive. There may be more messages related to this error. If you can provide more info we might be able to help a bit more. Maybe post the SQL for the report

If you have crystal installed on the LBI server try executing the report directly on the LBI server. If you get the same error there may be an issue with crsytal installed on the LBI server. Sometimes I have un-installed and re-installed crystal and this has resolved the issue.

Hi Matthew. Please see below for the information you requested. Thanks.

SQL:

select g.field-a field-a,
n.field-b field-b,
g.field-c field-c,
g.field-d field-d,
g.field-e field-e var_levels var_levels,
g.field-f field-f trans_type actvbud,
n.field-g field-g description deptname,
n.field-h field-h person_resp,
c.field-i field-i account_desc accountname,
c.field-j field-j chart_section chart_section,
c.field-k field-k sumry_acct_id sumry_acct_id,
s.field-l field-l account_desc sumryaccountname,
(g.db_amount1+g.cr_amount1) amt1,
(g.db_amount2+g.cr_amount2) amt2,
(g.db_amount3+g.cr_amount3) amt3,
(g.db_amount4+g.cr_amount4) amt4,
(g.db_amount5+g.cr_amount5) cypamt5,
(g.db_amount6+g.cr_amount6) cypamt6,
(g.db_amount7+g.cr_amount7) cypamt7,
(g.db_amount8+g.cr_amount8) cypamt8,
(g.db_amount9+g.cr_amount9) cypamt9,
(g.db_amount10+g.cr_amount10) cypamt10,
(g.db_amount11+g.cr_amount11) cypamt11,
(g.db_amount12+g.cr_amount12) cypamt12
from a-table g,
b-table n,
c-table c,
d-table s
where g.company = 1
and n.field-m = 1
and g.field-e = n.field-e
and g.field-c = c.field-c
and g.field-c not in(400600, 400700, 400800, 400950)
and g.field-d = c.field-d
and c.field-k = s.field-k
and c.field-n ='2'
and ((g.field-o = 1) or (g.field-p = 'A'));

Error Message:

[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The table 'v' could not be found.
Error in File ZBU 160 Dept Op Exp Actuals and Remaining Forecast {9D893A67-2C33-479D-A6FB-B94B53C2842C}.rpt:
The table could not be found.---- Error code:-2147482939 Error code name:failed
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException.throwReportSDKServerException(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.proxy.remoteagent.s.a(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.cf.a(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.z.a(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.ak.if(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.ad.int(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.bk.for(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.proxy.remoteagent.v.a(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.proxy.remoteagent.v.if(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.crystaldecisions.sdk.occa.report.application.DatabaseController.setTableLocation(Unknown Source)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.crystalreport.CRMainTable.setTableLocation(CRMainTable.java:31)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.crystalreport.CrystalReportDataSources.overrideDataSource(CrystalReportDataSources.java:370)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.ReportEngines.CrystalEngine.overrideDataSource(CrystalEngine.java:1434)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.ReportEngines.CrystalEngine.processDataSources(CrystalEngine.java:1268)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.ReportEngines.CrystalEngine.processReportRequest(CrystalEngine.java:246)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.ReportEngines.ReportEngine.processReportRequest(ReportEngine.java:80)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.ReportEngines.ReportRequest.process(ReportRequest.java:644)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.lawson.efs.ers.web.RequestHandlerServlet.doPost(RequestHandlerServlet.java:946)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[5/22/12 14:19:33:204 EDT] 00000016 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)

looks like youve modified the SQL from its actual structure making it a bit difficult to identify if the problem is in the SQL or not but you could be dealing with a special character issue. Make sure you remove all youre special characters from names of formulas, parameters, running totals etc. For the SQL, if you the field names really do have spaces, be sure to use the database platforms convention for explicitly identifying a field. I believe for oracle you use quotes and for SQL Server you use square brackets.