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
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