Topic
  • 8 replies
  • Latest Post - ‏2013-11-29T00:05:43Z by dwprofile
sumeetvaidya
sumeetvaidya
18 Posts

Pinned topic MDM Data Sources...

‏2012-06-08T21:54:37Z |
I have an MDM application instance that is running on my Websphere Local Test Environment and using a MDM Database configured on the local machine.

Is it possible to run the MDM server locally and but connect to a remote database?
If so, then is it enough to change the database server/db name parameters for the MDM data sources and the associated credentials in the JAAS entries on the Local Test Environment? Or are there additional configuration changes required?

Thanks,
Sumeet
Updated on 2012-06-13T18:55:32Z at 2012-06-13T18:55:32Z by sumeetvaidya
  • sreeman
    sreeman
    1 Post

    Re: MDM Data Sources...

    ‏2012-06-10T15:27:01Z  
    Yes, only change in JDBC configuration on WAS admin console will work.
  • sumeetvaidya
    sumeetvaidya
    18 Posts

    Re: MDM Data Sources...

    ‏2012-06-12T13:23:55Z  
    • sreeman
    • ‏2012-06-10T15:27:01Z
    Yes, only change in JDBC configuration on WAS admin console will work.
    By changing the data source connection properties did not work. I get the following exception

    6/12/12 8:22:18:021 CDT 0000002d SystemOut O ERROR - com.dwl.management.config.repository.RepositoryStoreException: Exception_RepositoryImpl_CreateConnectionFailed: CDKCR2019E:A failure occurred while trying to create a connection to the configuration repository database.
    6/12/12 8:22:19:583 CDT 0000002d SystemOut O ERROR - jcct4201311249http://3.57.82 Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
    6/12/12 8:22:22:036 CDT 0000002d SystemOut O ERROR - jcct4201311249http://3.57.82 Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
    6/12/12 8:22:23:333 CDT 0000002d SystemOut O ERROR - jcct4201311249http://3.57.82 Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
    6/12/12 8:22:23:333 CDT 0000002d SystemErr R com.dwl.management.config.repository.RepositoryStoreException: Exception_RepositoryImpl_CreateConnectionFailed: CDKCR2019E:A failure occurred while trying to create a connection to the configuration repository database.
  • SystemAdmin
    SystemAdmin
    938 Posts

    Re: MDM Data Sources...

    ‏2012-06-12T14:24:31Z  
    By changing the data source connection properties did not work. I get the following exception

    6/12/12 8:22:18:021 CDT 0000002d SystemOut O ERROR - com.dwl.management.config.repository.RepositoryStoreException: Exception_RepositoryImpl_CreateConnectionFailed: CDKCR2019E:A failure occurred while trying to create a connection to the configuration repository database.
    6/12/12 8:22:19:583 CDT 0000002d SystemOut O ERROR - jcct4201311249http://3.57.82 Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
    6/12/12 8:22:22:036 CDT 0000002d SystemOut O ERROR - jcct4201311249http://3.57.82 Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
    6/12/12 8:22:23:333 CDT 0000002d SystemOut O ERROR - jcct4201311249http://3.57.82 Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000DSRA0010E: SQL State = 28000, Error Code = -4,214
    6/12/12 8:22:23:333 CDT 0000002d SystemErr R com.dwl.management.config.repository.RepositoryStoreException: Exception_RepositoryImpl_CreateConnectionFailed: CDKCR2019E:A failure occurred while trying to create a connection to the configuration repository database.
    Hi,
    The message clearly says User ID or Password invalid.

    Try a Test Connection From the WAS adminconsole and make sure it succeeds.

    If you restart the WAS with the wrong userid/pasword it may even lock your database.

    Regards
    Nikkie
  • sumeetvaidya
    sumeetvaidya
    18 Posts

    Re: MDM Data Sources...

    ‏2012-06-12T14:47:44Z  
    Hi,
    The message clearly says User ID or Password invalid.

    Try a Test Connection From the WAS adminconsole and make sure it succeeds.

    If you restart the WAS with the wrong userid/pasword it may even lock your database.

    Regards
    Nikkie
    The Test Connection for the data sources is successful. Is there a properties file or another location that I need to update?

    Thanks,
    Sumeet
  • SystemAdmin
    SystemAdmin
    938 Posts

    Re: MDM Data Sources...

    ‏2012-06-13T14:34:54Z  
    The Test Connection for the data sources is successful. Is there a properties file or another location that I need to update?

    Thanks,
    Sumeet
    Hi,
    A few pointers
    Hope you have already updated
    Data sources > DWLConfig > JAAS - J2C authentication data
    the UserID and Password for WCC-DB-User and Config.

    Please verify that your bootstrap.properties has repository.uri=config:database:jdbc/DWLConfig.

    Hope that helps!
    Regards
    Nikkie
  • sumeetvaidya
    sumeetvaidya
    18 Posts

    Re: MDM Data Sources...

    ‏2012-06-13T18:55:32Z  
    Hi,
    A few pointers
    Hope you have already updated
    Data sources > DWLConfig > JAAS - J2C authentication data
    the UserID and Password for WCC-DB-User and Config.

    Please verify that your bootstrap.properties has repository.uri=config:database:jdbc/DWLConfig.

    Hope that helps!
    Regards
    Nikkie
    Never Mind.
    Found and fixed the issue.

    Thanks,
    Sumeet
  • AtharHussain
    AtharHussain
    1 Post

    Re: MDM Data Sources...

    ‏2013-08-22T15:25:59Z  
    Hi,
    The message clearly says User ID or Password invalid.

    Try a Test Connection From the WAS adminconsole and make sure it succeeds.

    If you restart the WAS with the wrong userid/pasword it may even lock your database.

    Regards
    Nikkie

    Hi Nikkie,

    I found below error,i checked Connection from the WAS adminconsole it fails giving the below error.Can you tell what to do know...

    8/22/13 11:10:25:180 EDT] 000000bc SystemErr     R java.sql.SQLException: [jcc][t4][2013][11249][3.63.75] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4,214
        [8/22/13 11:10:25:180 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.am.fd.a(fd.java:677)
        [8/22/13 11:10:25:180 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.am.fd.a(fd.java:60)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.am.fd.a(fd.java:120)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.q(b.java:2282)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.c(b.java:1701)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.ab.r(ab.java:944)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.ab.k(ab.java:491)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.ab.c(ab.java:138)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.Wc(b.java:1308)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.b(b.java:1227)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.a(b.java:5983)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.c(b.java:792)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.b(b.java:735)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.a(b.java:402)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.<init>(b.java:331)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.c.<init>(c.java:32)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2PooledConnection.java:199)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2XAConnection.<init>(DB2XAConnection.java:56)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:168)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:136)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigHelper$1.run(DSConfigHelper.java:1251)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5453)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5579)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.spi.ServerFunction$6.run(ServerFunction.java:565)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1266)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1174)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1975)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1851)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2709)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at java.lang.reflect.Method.invoke(Method.java:611)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:556)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:484)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at java.lang.reflect.Method.invoke(Method.java:611)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:49)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at java.lang.reflect.Method.invoke(Method.java:611)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:256

    Regards:

    Athar

     

  • dwprofile
    dwprofile
    2 Posts

    Re: MDM Data Sources...

    ‏2013-11-29T00:05:43Z  

    Hi Nikkie,

    I found below error,i checked Connection from the WAS adminconsole it fails giving the below error.Can you tell what to do know...

    8/22/13 11:10:25:180 EDT] 000000bc SystemErr     R java.sql.SQLException: [jcc][t4][2013][11249][3.63.75] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4,214
        [8/22/13 11:10:25:180 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.am.fd.a(fd.java:677)
        [8/22/13 11:10:25:180 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.am.fd.a(fd.java:60)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.am.fd.a(fd.java:120)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.q(b.java:2282)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.c(b.java:1701)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.ab.r(ab.java:944)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.ab.k(ab.java:491)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.ab.c(ab.java:138)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.Wc(b.java:1308)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.b(b.java:1227)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.a(b.java:5983)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.c(b.java:792)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.b(b.java:735)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.a(b.java:402)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.b.<init>(b.java:331)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.t4.c.<init>(c.java:32)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2PooledConnection.java:199)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2XAConnection.<init>(DB2XAConnection.java:56)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:168)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:136)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigHelper$1.run(DSConfigHelper.java:1251)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5453)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5579)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.spi.ServerFunction$6.run(ServerFunction.java:565)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1266)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigHelper.getPooledConnection(DSConfigHelper.java:1174)
        [8/22/13 11:10:25:181 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1975)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:1851)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2709)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at java.lang.reflect.Method.invoke(Method.java:611)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:556)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:484)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at java.lang.reflect.Method.invoke(Method.java:611)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:49)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at java.lang.reflect.Method.invoke(Method.java:611)
        [8/22/13 11:10:25:182 EDT] 000000bc SystemErr     R     at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:256

    Regards:

    Athar

     

    Hi,

    Apart from what I mentioed above , please delete the password variable under DWLConfig and DWLCustomer and recreate it, and key in your password.

    Data sources > DWLConfig > Custom properties