Topic
1 reply Latest Post - ‏2012-07-25T10:56:49Z by babinag
babinag
babinag
91 Posts
ACCEPTED ANSWER

Pinned topic Db inconsistency error.

‏2012-07-24T12:00:27Z |
Hi.
Some error occured in catalog export script:

CWCUS0001E:Message: Too many values returned by GenCtgItdItemDetail.getByIdVersion(...). 2012-07-24 15:46:29,763 ERROR: CWCUS0001E:com.ibm.ccd.common.gendb.GenCtgItdItemDetailTable.getByIdVersion(Unknown Source) com.ibm.ccd.content.common.Item.populateDetailByIdVersion(Unknown Source) com.ibm.ccd.content.common.Item.getByIdVersion(Unknown Source) com.ibm.ccd.content.common.Catalog.getItemById(Unknown Source) com.ibm.ccd.api.extensionpoints.DefaultArgumentMappings$1.getByID(Unknown Source) com.ibm.ccd.api.collection.PIMObjectIterator.hasNext(Unknown Source) ...


this code resulted an error:



public 

boolean catalogExport(CatalogExportFunctionArguments inArgs) 
{ 

try 
{ 
//... 

for (Item item : inArgs.getItems()) 
{ processItem(item, sb); 
} 
//...


Seems some primaryKeys are not so primary. How to resolve this problem?
Does anyone encountered this sort of error?
Or i have to open PMR?
Updated on 2012-07-25T10:56:49Z at 2012-07-25T10:56:49Z by babinag
  • babinag
    babinag
    91 Posts
    ACCEPTED ANSWER

    Re: Db inconsistency error.

    ‏2012-07-25T10:56:49Z  in response to babinag
    Solved.

    Seems, problem was in one item, that was incorrectly saved(maybe version id column did not changed properly while saving). Dunno how this happened, but i've founded that item, manually saved it in UI, and problem disappears.

    This helps(google cache) find WPC00032110 there

    I have made report that checked each item in search query(one search for each item pk). When error occurs, item pk and its display name(to richsearch after for save) was logged.

    
    select item from catalog(
    'Item Catalog') where item.pk = 
    'nextPk'