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 | mdm-migration
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
  • 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