Analyst Publish Fails - invalid variant type

[mlringer]

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?

[shethsameer]

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.