Author Topic: ERR-2002 Error when trying to create a data source connection NO STABLE  (Read 4084 times)

Offline bhupalalerts@gmail.com

  • Full Member
  • ***
  • Join Date: Nov 2016
  • Posts: 16
  • Forum Citizenship: +0/-0
I have installed the CA11.0.6 and configured the SAPBW connection for Dynamic/JDBC connectio is succeed .
But After few days and I noticed that connection suddenly failed and getting error as :DPR-ERR-2002 Error" and after 5 minutes its succeeded without any issues. It means its working sometimes and not working sometimes. While working I imported and created the dashboards using SAPBW everything, Suddenly its getting error .There is no issue with credentials for SAPBW. I restarted the services and server everything but still same issue. Can you please help me on priority ? PFA



Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,348
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
I have installed the CA11.0.6 and configured the SAPBW connection for Dynamic/JDBC connectio is succeed .
But After few days and I noticed that connection suddenly failed and getting error as :DPR-ERR-2002 Error" and after 5 minutes its succeeded without any issues. It means its working sometimes and not working sometimes. While working I imported and created the dashboards using SAPBW everything, Suddenly its getting error .There is no issue with credentials for SAPBW. I restarted the services and server everything but still same issue. Can you please help me on priority ? PFA

Hi,

Take a look in cogserver.log to see if any further details are being recorded.

If I had to guess, I'd probably suggest you don't have enough memory allocated to the Query Service jvm? What values are the Initial JVM Heap Size for the query service, and the JVM Heap Size Limit for the query service set to?

MF.
Meep!