If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 8.4 Analyst Publish Error

Started by bladeless, 19 Oct 2011 05:14:05 AM

Previous topic - Next topic

bladeless

Hello,
i have a problem:
I changed DList(respectively and DCube) and trying to Publish that changes, but I get this error:

Could not create an items table for DList {Name};42S01 :[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'it_dimension_0' in the database.;Error context: CREATE TABLE {Name}. .it_dimension_0 ( itemid char(38) NOT NULL ,dimensionid char(38) NOT NULL ,itemname varchar(500) NULL ,displayname varchar(500) NULL disporder not NULL ,itemiid int NOT NULL PRIMARY KEY CLUSTERED( itemiid )ON [PRIMARY]) ON [PRIMARY];CREATE TABLE {Name}..it_dimension_0 (itemid char(38) NOT NULL .dirnensionid char(38) NOT NULL ,itemname varchar(500) NULL .displayname varchar(500) NULL .disporder int NULL , itemiid int NOT NULL PRIMARY KEY CLUSTERED( itemiid )ON [PRIMARY]) ON [PRIMARY]

Very similar to http://www-01.ibm.com/support/docview.wss?uid=swg21347079
But this issue does not help (( I have version 8.4.

Please help!!!

Rutulian

Hi Bladeless,

It looks like your dimensions are being renamed to generic names like 'it_dimension_0', and so when you try to publish a different set of dimensions it comes up with the same generic name for a different dimension.

You could either manually clear out the publish container by dropping all its contents (losing your last publish), or look into renaming your dimensions to have names which Analyst can publish.  Are you in a non-european characterset?  It's possible that adding a couple of numeric or european-alpha characters to the beginning of each dimension (different ones for each dimension) would allow your publish to go through, though this could cause you other annoyances.

I'd also advise checking your patch level, it's always worth being up to date and 8.4 has a couple of fix packs out.

R

bladeless

Thank you for your advices.

I did this:
In CAC Synchronize->Save->Publish in appropriate Application