• 1 reply
  • Latest Post - ‏2016-12-14T10:01:28Z by FJYC_Magwati_Valentine
2 Posts

Pinned topic metadata database cannot be retrieved

‏2013-10-11T12:51:41Z |

i get the DWE7001E error when opening the infosphere warehouse console in browser.".....metadata database cannot be retrieved......". this is the error in the system.out log

RES37601E: The system cannot obtain an SQL connection for metadata database for the following reason [jcc][t4][2043][11550][3.63.138] Exception Error opening socket to server / on port 50,001 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001


i checked the port, db2comm and tco/ip configurations are set correctly.  how am i to resolve this problem? there are control flows running every night and i find the database down every morning. please help.


  • FJYC_Magwati_Valentine
    1 Post

    Re: metadata database cannot be retrieved


    1. Check if your db2 is running, if not start it.

    2. Try to backup & restore the backup image of the metadata db and try to run your control flows.