COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: mlringer on 18 Nov 2009 01:24:54 PM

Title: Analyst Publish Fails - invalid variant type
Post by: mlringer on 18 Nov 2009 01:24:54 PM
I have recently moved my production analyst libraries to test. I am trying to publish from Analyst to an Oracle DB. All of the connections seem to be working but manual or macro based give me this error:

invalid variant type

any ideas?
Title: Re: Analyst Publish Fails - invalid variant type
Post by: shethsameer on 18 Nov 2009 03:01:09 PM
This is probably due to the field incompatency. Fields including date, blob will need extra care. Make sure your test environment data store is similar to that of production (i.e. Tablespace, Temp, etc..) and try again.