nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

IWOV_IDMAPS issue

Adam Stoller

Environment[indent]Upgrading (on new servers) from TS 6.2.1 / OD 6.1 to TS & OD 7.4.1 on Windows
MS SQLServer 2008R2[/indent]
Issue[indent]I'm trying to test the new server by running a workflow that runs a deployment - in this case a DataDeploy deployment. The deployment fails with the following error in the log file:

Connected to jdbc:inetdae:sqlserver:1433?database=DBName&sql7=true
DBD:   Driver         i-net UNA 2000
DBD:   Version        4.18
DBD: Connected to [sqlserver:1433?database=DBName]
DBD: Building mappings cache...
DBD:
DBD: *******************************************************
DBD: SQLException occured in TIdentifierMappingTable::BuildMappingCache()
DBD: Exception Message: [SQLSERVER]Invalid object name 'IWOV_IDMAPS'.
DBD: Vendor Error Code: 208
DBD: SQL state: S0002
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [SQLSERVER]Invalid object name 'IWOV_IDMAPS'.
                at com.inet.tds.e.a(Unknown Source)
                at com.inet.tds.g.if(Unknown Source)
                at com.inet.tds.g.a(Unknown Source)
                at com.inet.tds.g.for(Unknown Source)
                at com.inet.tds.b.new(Unknown Source)
                at com.inet.tds.b.executeQuery(Unknown Source)
                at com.interwoven.dd100.dd.TIdentifierMappingTable.BuildMappingCache(TIdentifierMappingTable.java:668)
                at com.interwoven.dd100.dd.TIdentifierMappingTable.(TIdentifierMappingTable.java:122)
                at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:286)
                at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
                at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
                at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
                at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
                at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
                at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:108)
                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)
…

What I find interesting (strange perhaps) is that on this SQLSERVER - there is the target DBName that does not have any IWOV_IDMAPS table in it, but there is an "IWCommon" database (on their QA DB server, "Common" on their PROD DB server) that does have the IWOV_IDMAPS and other "internal" tables within it.
I see nothing in the DD config file, nor the dbschema.cfg file it uses, that references anything with the word "common" in it.

So:

I can try to provide more information if there's something specific that would help clarify the situation - as I'm really quite stumped by this right now.

Find more posts tagged with

Comments

nipper

That is strange because IDMAPS was in 6.0.2 all the way through 7.4

Did they have DAS configured on 6.X ? How about now ? Does your user have the permissions to create a new table ? It looks like it should create that table if it is not there.

From what I see there is a script in od-home/examples/etc that will allow you to create/override the tables for iwtracker, iwdeltracker and iwov_idmaps.

You could have the DBA run this:
CREATE TABLE IWOV_IDMAPS
(
TYPE INT NOT NULL,
SHORTID VARCHAR(255) NOT NULL,
LONGID VARCHAR(255) NOT NULL
)

But it still doesn't explain why it is not there already.

Rick Poulin

[QUOTE=ghoti]

1/3- As nipper said, this is supposed to get created automagically when DD detects that it's not already there, so yea, your DD user would need the create-table priviledge.2/4- I'm not convinced that IWCommon is an internal table (for DD, at least). I've certainly never seen it before in conjunction with that product.

Adam Stoller

Doh!

User-error - it turns out that there were a lot of tables associated with the target database - and that the 'owner' of the IWOV_IDMAPS database (and IWDELTRACKER) was not "dbo" - so it showed up in the list after all the "dbo.****" tables - and I simply didn't scroll down far enough.

As the user who owned the tables was not the user being used to connect to the database (probably something which changed at some point and nobody's been using their DEV environment for some time) - I was getting that error.

We made sure the user I was using was added with nearly full rights on those tables - and the error went away.

The "Common" and / or "IWCommon" databases that I saw were apparently used for some other project that is now (apparently) obsolete - so the fact that I saw the tables there was the proverbial red-herring.

(Topic_40277)OS_BIRT_2.6.2_JavascriptExample.rptdesign

Adam Stoller

Okay - I'm not done yet. We gave the account owner privileges on the table but the table is still named ****.IWOV_IDMAPS instead of dbo.IWOV_IDMAPS.

The first time I do a deployment - it seems to work.
The next time I do a deployment - it fails with:

DBD: *******************************************************
DBD: SQLException occured in TIdentifierMappingTable::BuildMappingCache()
DBD: Exception Message: [JXMSSQLQ1]Invalid object name 'IWOV_IDMAPS'.
DBD: Vendor Error Code: 208
DBD: SQL state: S0002
DBD: *******************************************************

I'm going to see if I can get the DBA to "fix"' the tables to be dbo.**** even though he's hesitant to do so.

Can anyone else shed some light on this? Is the fully-qualified-name of the table likely to be the issue?