Import failed Contributor 8.3 vers 10.1.1

[TEVAMANA]

hi all,

I got a colleague struggling to finish a migration from Cognos Contributor 8.3 to 10.1.1

here's the PMR he opened, I know Cognos BI but I never work on Planning so I can't help, if someone experienced this issue and can help, thanks a lot:


Problem Description: Import of Deployment fails                         
Error Messages:                                                         
Unable to get columns for table 'applicationstate'~~~~Unable to get     
attribute for column 'versionid'~~~~Type mismatch                       
                                                                       
Unable to import application                                           
'datastores/clarsrvfin01/applications/decs_ctb_ca_83' - the application
may be corrupted, you should restore it from a database backup.~~Caused
by:                                                                     
com.cognos.ep.planningnetworkindex.exceptions.InteroperabilityException:
org.jawin.COMException: d: Unable to get columns for table             
'applicationstate'~~~~Unable to get attribute for column 'versionid'   
Environment:                                                           
planning 10.1.1 FP2                                                     
sql server 2008 R2                                                     
Summary:                                                               
IBM Cognos Planning 10.1.1FP2 - Import of Deployment fails             
from 8.3 to 10.1.1                                                     
Collected Files: planningerrolog.csv + application                     
Resources Checked: na                                                   
Next Steps: investigating   

[kakkaduan]

Hi,

I remember having some issues when doing the import/upgrade in the new environment which for me was caused by one of the applications included in the deploymentpackage was not fully reconciled at the time when the package was created.

Do you still have the 8.3 environment up and running? If so, try checking the application which uses the database: decs_ctb_ca_83 and see if it's fully reconciled.

BR
Jakob