I am having a problem with some customized reports I have created. The software I am using is created with Java and acts as the front end with a tie back to Crystal. I use a OLE DB driver to connect. I am currently using Crystal Reports version 11.5.3.417. Something happend recently after an update to their software that has caused all of my custom reports to fail with the following error message:
class com.prologic.teams.common.crystal.CrystalHelper
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Unknown Database Connector Error
Failed to retrieve data from the database.
Error in File C:\WINDOWS\TEMP\{5D6A360E-069A-413E-BFB7-FDAB4F6FAC27}.rpt:
Unknown Database Connector Error---- Error code:-2147482942 Error code name:failed
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at com.prologic.teams.common.crystal.CrystalHelper.getReportAsStream(CrystalHelper.java:524)
at com.prologic.teams.common.crystal.BatchRunnableReportProcess.run(BatchRunnableReportProcess.java:53)
at com.prologic.teams.common.batchrunner.OnlineBatchManager$1.run(OnlineBatchManager.java:85)
at com.prologic.teams.common.crystal.CrystalHelper.getReportAsStream(CrystalHelper.java:535)
at com.prologic.teams.common.crystal.BatchRunnableReportProcess.run(BatchRunnableReportProcess.java:53)
at com.prologic.teams.common.batchrunner.OnlineBatchManager$1.run(OnlineBatchManager.java:85)
I have been running the updated version of Crystal for more then a month now and haven't had problems with it until the recent update they performed. I can process the report in Crystal and get results, but when using the parameters provided with the software, the report fails with the given error message. I have found instances of this error message all over the internet and they all talk about problems being caused by certain hot fixes. I believe the monthly hot fixes are the only ones that have been installed, but am not 100% sure.
The software company feels that it has something to do with my version of crystal being more updated then their version or the server's version. Is this a possiblity? Again, I had the updates installed and was able to process the reports through the java interface for more then a month without problem. I have tried moving the reports, renaming the reports, making changes and re-saving the reports, all to no avail. I have been able to create reports from scratch that will function properly. Problem is, I have upwards of 150+ reports so starting over isn't really an option.
Do the Crystal server, all installs of Crystal Reports software and any other Crystal related products have to be the exact same in terms of versions, service packs, etc.? I believe that we functioned without issue for quite a while but am unsure what changed caused the reports to fail continuously.
Does anyone have any thoughts or ideas on what I might try to fix this problem. I know I am lacking some specific information, but I have had problems getting that info from the software developers.
Any help would be greatly appreciated.
Thanks.
class com.prologic.teams.common.crystal.CrystalHelper
com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Unknown Database Connector Error
Failed to retrieve data from the database.
Error in File C:\WINDOWS\TEMP\{5D6A360E-069A-413E-BFB7-FDAB4F6FAC27}.rpt:
Unknown Database Connector Error---- Error code:-2147482942 Error code name:failed
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
at com.prologic.teams.common.crystal.CrystalHelper.getReportAsStream(CrystalHelper.java:524)
at com.prologic.teams.common.crystal.BatchRunnableReportProcess.run(BatchRunnableReportProcess.java:53)
at com.prologic.teams.common.batchrunner.OnlineBatchManager$1.run(OnlineBatchManager.java:85)
at com.prologic.teams.common.crystal.CrystalHelper.getReportAsStream(CrystalHelper.java:535)
at com.prologic.teams.common.crystal.BatchRunnableReportProcess.run(BatchRunnableReportProcess.java:53)
at com.prologic.teams.common.batchrunner.OnlineBatchManager$1.run(OnlineBatchManager.java:85)
I have been running the updated version of Crystal for more then a month now and haven't had problems with it until the recent update they performed. I can process the report in Crystal and get results, but when using the parameters provided with the software, the report fails with the given error message. I have found instances of this error message all over the internet and they all talk about problems being caused by certain hot fixes. I believe the monthly hot fixes are the only ones that have been installed, but am not 100% sure.
The software company feels that it has something to do with my version of crystal being more updated then their version or the server's version. Is this a possiblity? Again, I had the updates installed and was able to process the reports through the java interface for more then a month without problem. I have tried moving the reports, renaming the reports, making changes and re-saving the reports, all to no avail. I have been able to create reports from scratch that will function properly. Problem is, I have upwards of 150+ reports so starting over isn't really an option.
Do the Crystal server, all installs of Crystal Reports software and any other Crystal related products have to be the exact same in terms of versions, service packs, etc.? I believe that we functioned without issue for quite a while but am unsure what changed caused the reports to fail continuously.
Does anyone have any thoughts or ideas on what I might try to fix this problem. I know I am lacking some specific information, but I have had problems getting that info from the software developers.
Any help would be greatly appreciated.
Thanks.