December 1, 2009 at 8:45 am
Hi All,
here is yet another show stopper for me , I'm migrating CDE of SSRS 2005 to 2008 , in this process i've referenced new DLL's and recompiled the CDE DLL , it is working fine on my VS 2008 BIDS with out any problem. When the same report is run on the SSRS server I'm getting the following error:
"ERROR: Data source 'Custom_Data_Extension__Data_Merge_': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'Custom_Data_Extension__Data_Merge_'. ---> Oracle.DataAccess.Client.OracleException: Connection request timed out"
It is unable to open oracle connection for meta data required for CDE , I thought it was Oracle Client which is causing the problem, but Oracle connection is working fine when I tested it with a separate report which consumes same Oracle client but with a shared data source (not CDE).
Any ideas what I'm missing in this , any help is appreciated.
thanks
Dharmen
December 1, 2009 at 9:07 am
dharmen.somagani (12/1/2009)
Hi All,here is yet another show stopper for me , I'm migrating CDE of SSRS 2005 to 2008 , in this process i've referenced new DLL's and recompiled the CDE DLL , it is working fine on my VS 2008 BIDS with out any problem. When the same report is run on the SSRS server I'm getting the following error:
"ERROR: Data source 'Custom_Data_Extension__Data_Merge_': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'Custom_Data_Extension__Data_Merge_'. ---> Oracle.DataAccess.Client.OracleException: Connection request timed out"
It is unable to open oracle connection for meta data required for CDE , I thought it was Oracle Client which is causing the problem, but Oracle connection is working fine when I tested it with a separate report which consumes same Oracle client but with a shared data source (not CDE).
Any ideas what I'm missing in this , any help is appreciated.
thanks
Dharmen
Do you have Oracle client software for the version of Oracle you are connecting to on the server running SSRS 2008? The reason Oracle client installation is required for all Oracle development. And yes that includes deployment.
Kind regards,
Gift Peddie
December 1, 2009 at 9:26 am
Yes . SSRS 2008 box has required oracle client installed . I have tested this by running a separate report which uses oracle exclusively.
December 1, 2009 at 9:33 am
dharmen.somagani (12/1/2009)
Yes . SSRS 2008 box has required oracle client installed . I have tested this by running a separate report which uses oracle exclusively.
What do you mean use Oracle exclusively? So what is your CDE doing?
Kind regards,
Gift Peddie
December 1, 2009 at 9:40 am
Gift,
just to test whether oracle installed properly I have deployed a report which uses a oracle shared data source and it is working fine which proves that oracle software on SSRS 2008 box is working properly.
CDE issue is on different report.
thanks
Dharmen.
December 1, 2009 at 9:44 am
dharmen.somagani (12/1/2009)
Gift,just to test whether oracle installed properly I have deployed a report which uses a oracle shared data source and it is working fine which proves that oracle software on SSRS 2008 box is working properly.
CDE issue is on different report.
thanks
Dharmen.
Then you need to find out what is breaking the code in the CDE because there is something that is not working SSRS 2008 which does not use IIS while SSRS 2005 which is IIS dependent.
Kind regards,
Gift Peddie
December 1, 2009 at 10:09 am
this is a good catch, but CDE links to SSRS and ADOMDClient assemblies only not IIS, so there is nothing depending on IIS.
thanks
Dharmen.
December 1, 2009 at 10:12 am
dharmen.somagani (12/1/2009)
this is a good catch, but CDE links to SSRS and ADOMDClient assemblies only not IIS, so there is nothing depending on IIS.thanks
Dharmen.
So what is your CDE doing?
You left out the dependence on SSAS 2005 which creates complication so you need to trace the connection between SSAS and Oracle if your cube is working as expected. I covered what would have resolved your problem in my second post but you did not answer because you need to find out SSAS 2005 using Oracle datasource consumed in SSRS 2008.
Kind regards,
Gift Peddie
December 1, 2009 at 1:02 pm
Gift Peddie (12/1/2009)
dharmen.somagani (12/1/2009)
this is a good catch, but CDE links to SSRS and ADOMDClient assemblies only not IIS, so there is nothing depending on IIS.thanks
Dharmen.
So what is your CDE doing?
You left out the dependence on SSAS 2005 which creates complication so you need to trace the connection between SSAS and Oracle if your cube is working as expected. I covered what would have resolved your problem in my second post but you did not answer because you need to find out SSAS 2005 using Oracle datasource consumed in SSRS 2008.
I will find that, but this rings another idea in my mind , I'm able to run the report in 2008 VS-BIDS which is using 32Bit Oracle, on SSRS 2008 Box it is 64Bit Oracle , this is the only visible difference between both . can you please tell me - is 32Bit oracle is enough to run reports or we need 64 bit oracle on SSRS 2008 server?
December 1, 2009 at 2:28 pm
dharmen.somagani (12/1/2009)
Gift Peddie (12/1/2009)
dharmen.somagani (12/1/2009)
this is a good catch, but CDE links to SSRS and ADOMDClient assemblies only not IIS, so there is nothing depending on IIS.thanks
Dharmen.
So what is your CDE doing?
You left out the dependence on SSAS 2005 which creates complication so you need to trace the connection between SSAS and Oracle if your cube is working as expected. I covered what would have resolved your problem in my second post but you did not answer because you need to find out SSAS 2005 using Oracle datasource consumed in SSRS 2008.
I will find that, but this rings another idea in my mind , I'm able to run the report in 2008 VS-BIDS which is using 32Bit Oracle, on SSRS 2008 Box it is 64Bit Oracle , this is the only visible difference between both . can you please tell me - is 32Bit oracle is enough to run reports or we need 64 bit oracle on SSRS 2008 server?
Oracle x86 connection to VS2008 running is understandable because VS2008 is also x86, it may not be running in SSRS 2008 because if this is Windows 2008 it comes with new data access which creates problems and the solution is to download the Oracle OLE DB provider from Oracle's site which is x64 like the Oracle you are using.
Kind regards,
Gift Peddie
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply