Data Deploy - Not able to connect to MS SQL Server database

Hi,

We are trying to deploy into DB using datadeploy module into the MS SQL Server 2012.

We have added the required jars into the drivers folder, added DB details into database.xml file. But when we invoke the data deployment, DD is not able to connect to the database and give error: Login Failed for user [sa].

We are able to connect to the database using the sa - user credentials directly on the DB server. We have also checked that the DB login authentication is set to SQL server + windows authentication.

Any pointer, whether there is any other configuration that needs to be done at the OpenDeploy or DB server level. Is there anything we are missing?

OD : 7.4.1 - Windows 2012
DB: MS SQLServer 2012 - windows 2012

Thanks,

Amit

Find more posts tagged with

Comments

itsamb

Hi All,

Any one has any pointer.

Thanks,

Amit

Rick Poulin

I'm no database expert, but 'sa' credentials are often accompanied with access restrictions (e.g. only from localhost). I'd suggest you create a new local account, give it db_owner on your database, and try connecting with that.

itsamb

Thank you Rick for the input. That worked. Smiley Happy We created a another db user and with that user we are able to connect to database using the inet drivers.

But, now running in to another issue.

Below is the error in the log file.

DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'Glossary_Term')
DBD: 0 PK values retrieved from iwdeltracker for templatedata\Page\Glossary\data\EN\glossary.xml, /default/main/JetPrivilege/India/WORKAREA/shared
DBD: TTableSchemaHelper object for [GLOSSARY] found in cache.
DBD: ERROR:Exception occured: null

DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildWhereClauseEx(TDbSchemaGroupCfg.java:2566)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmt(TDbSchemaGroupCfg.java:2524)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmt(TDbSchemaGroupCfg.java:2478)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.SelectCurrentRows(TDbSchemaUpdateHelper.java:267)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:154)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:837)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:871)

at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:448)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:457)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1083)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:530)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)

at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/Page/Glossary/data/EN/Glossary.xml
DBD: ERROR eployment [glossary-deployment] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)

Then we checked in the database, but the DB internal tables IWTRACKER, IWDELTRACKER, IWOV_IDMAPS, IWTMP_LOB are not present in the database.
Can you please guide on how to create these tablesin the DB?

Or is it something with the DCR?

Thanks,

Amit

Adam Stoller

Those tables should be created automatically via the account used to access the DB through DataDeploy - which means that accounts requires the ability to create tables / schemas within the DB (as documented in the product manuals)

itsamb

Thanks Adam. The user had all the privileges to create the table. Issue was different.

We resolved it. The issue was that, when OD was not working, one of our developer deployed the DCR through a java class.

Next time when we tried to deploy the same DCR through DD, it was not getting referecne of that DCR in IWDELTRACKER table. Hence, it was not updating the record.

We created a fresh DCR and inserted and now its deploying to database. Also the tables are created now.

Thanks,

Amit