Issues with Standalone Change tracker on CE 7.2

[Former Member]

Followed below documentation,

http://help.sap.com/saphelp_nwmdm71/helpdata/en/49/add398968d0483e10000000a421938/frameset.htm

to configure jdbc custom data source and when i try change tracker in standalone mode its not fetching any values also Table drop down is not populated.

Connection parameter that i used are:

jdbc:oracle:thin:@<server>:1521:MD1

user : <DBA admin>

Password as additional parameters,

Any help on troubleshooting is much appreciated.

[Former Member]

Thanks guys for your time, but no luck (:

I tried all possible combinations with user's and now it goes failed to start,

here is the trace, any idea whats going wrong.

Global operation [startApp] over [application] [sap.com/oracle_mdm_datasource] finished with errors for [31]ms on server [6374650

>>> without warnings <<<

>>> Errors <<<

1). Cannot create DataSource "ora_mdm_ds".

-> class java.lang.NullPointerException

2). com.sap.engine.services.dbpool.exceptions.BaseDeploymentException: Cannot create DataSource "ora_mdm_ds".

at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1539)

at com.sap.engine.services.dbpool.deploy.ContainerImpl.prepareStart(ContainerImpl.java:522)

at com.sap.engine.services.deploy.server.utils.container.ContainerWrapper.prepareStart(ContainerWrapper.java:363)

at com.sap.engine.services.deploy.server.application.StartTransaction.prepareCommon(StartTransaction.java:251)

at com.sap.engine.services.deploy.server.application.StartTransaction.prepare(StartTransaction.java:209)

at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:502)

at com.sap.engine.services.deploy.server.application.ParallelAdapter.makeAllPhasesImpl(ParallelAdapter.java:483)

at com.sap.engine.services.deploy.server.application.StartTransaction.makeAllPhasesImpl(StartTransaction.java:584)

at com.sap.engine.services.deploy.server.application.ParallelAdapter.runMe(ParallelAdapter.java:180)

at com.sap.engine.services.deploy.server.application.ParallelAdapter.access$000(ParallelAdapter.java:43)

at com.sap.engine.services.deploy.server.application.ParallelAdapter$1.run(ParallelAdapter.java:340)

at com.sap.engine.frame.core.thread.Task.run(Task.java:73)

at com.sap.engine.core.thread.impl5.SingleThread.execute(SingleThread.java:175)

at com.sap.engine.core.thread.impl5.SingleThread.run(SingleThread.java:274)

Caused by: java.lang.NullPointerException

at java.util.Hashtable.put(Hashtable.java:396)

at java.util.Properties.setProperty(Properties.java:128)

at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:181)

at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:75)

at com.sap.sql.connect.factory.CPDSPooledConnectionFactory.getPooledConnection(CPDSPooledConnectionFactory.java:27)

at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:674)

at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.initConnections(DBDataSourcePoolImpl.java:1096)

at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.<init>(DBDataSourcePoolImpl.java:48)

at com.sap.sql.connect.datasource.DataSourceManager.createDataSource(DataSourceManager.java:507)

at com.sap.sql.connect.datasource.DataSourceManager.createDataSource(DataSourceManager.java:136)

at com.sap.sql.manager.OpenSQLManager.createDataSource(OpenSQLManager.java:140)

at com.sap.engine.core.database.impl.DataSourceAdministratorImpl.createDataSource(DataSourceAdministratorImpl.java:42)

at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1473)

... 13 more

[Former Member]

John,

User is clear, its available as <repository>_z000 , confusion is with password, what i tried is create a new user and assign the same roles that repository z user has, and tried it but dint work, so what is the password that we need to provide.

On availability datasource is showing green, but alias is red, any thoughts?

[Former Member]

Hi Venkat,

Try with DBMS User and Password.

Please find the below article for complete details. Refer page 4 and 5 of 8 with zoom option(200%) to check it correctly.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/807861ac-f941-2c10-8f8d-c57f9d421...

Regards,

Mandeep Saini

[former_member207367]

Hi Venkat,

As Mandeep told, Use Database User Name and Password for configuration.

Check the below link http://help.sap.com/saphelp_nwmdm71/helpdata/en/49/a42bc834de1b93e10000000a42189b/frameset.htm

for any help.

Regards

Sowseel

[junwu]

1.have you checked the availability of your jdbc datasource?

2.user name for the connection. it should be <repositoryname>_z000

I don't know the rule to compose this user name.

in my case, if there is underscore in the repository name, it is removed before you compose this name <repositoryname>_z000

actually you can logon to the date base to check what is the real user name created. you should be able to find something like this <repositoryname>_z000 in USERS table.

http://help.sap.com/saphelp_mdm71/helpdata/en/47/43ed2be4251a41e10000000a1553f7/frameset.htm