Analyst Publish Failure

[jonathan.webb@raytheon.co]

Hi all,

We've had a problem with an Analyst Publish macro for a while now. In fact, we have 2 virtually identical Analyst Publish macros and they both fail in the same way but I'll just refer to one of them.

It runs correctly the first time (i.e. creates the database, tables etc). On subsequent runs, it appears to be running very quickly, in reality, nothing is happening. Looking at the PlanningErrorLog, we get the message Unexpected error occured during the publish process. with no further details. It is not causing any of our downstream tasks to fail or not run. If we drop the database and run the publish macro from Analyst, it runs successfully.

Running the publish manually from Analyst, we get the same issue - we got a pop up saying 'Publish Successful' immediately after making the selections and submitting the publish.

To attempt a workaround, I tried to script dropping the database prior to running one of our large Contributor macros (which includes a step to run this Analyst Publish macro), but the database wasn't even created when running via Contributor, and this does cause our process to fail later (as we attempt to read back from the published database).

In terms of workload, it's publishing a single cube to a dedicated database. All database connections test successfully. It's a table publish, creating columns from the dimension for publish, including calculations, prefixing columns with data type, including zeroes, and generating new object names.

We are running Cognos 10.1 (no fix packs), with SQL 2008 R2 as our database server. Our Contributor publishes are working as expected. My userid has syadmin access to the SQL Server, as does our service account which we run our macros from in the admin console.

I hope someone can help!

Cheers,
Jon