Anyone know what the fix is for this? We used to simply blow away the publish container and create a new one. I was thinking IBM Cognos had said there was something else we could do that would be less drastic, but I cannot recall what that is:
2011-10-07T15:35:34.625+00:00
Machine details: domain\jobserver
User details: domain\ServiceAcct_COG_PROD
Process ID / Thread ID: 1340 / 2680
Source: <SupplementalInfo><Source>Microsoft OLE DB Provider for SQL Server</Source><StackInfo><ErrorGuid>{3E4136A6-564F-42DA-8F14-05EF72C42D70}</ErrorGuid><StackPosition>9</StackPosition><PreviousUserDomain>domain</PreviousUserDomain><PreviousUserName>ServiceAcct_COG_PROD</PreviousUserName><PreviousComputerDomain>domain</PreviousComputerDomain><PreviousComputerName>jobserver</PreviousComputerName></StackInfo></SupplementalInfo>
Error Number: -2147217871
Line Number: 220
Description: Unable to get Job Item
The Job management step failed. An attempt has been made to mark the 'PUBLISH' Job as CANCELLED. Please rectify the problem and re-create a similar Job.
The call to 'JobBegin' on 'Publish_%v.Implementation' was not successful.
Unable to truncate table 'p_deptexpsap1..et_hr_report'
Unable to execute the statement.Query timeout expired, Error number -2147217871 was raised by Microsoft OLE DB Provider for SQL Server
The SQL was:
TRUNCATE TABLE p_deptexpsap1..et_hr_report
Query timeout expired
Any help is greatly appreicated!
It appears that it was related to our service account not having sufficient permissions on the publish container database. I need to probe further, since this publish container has been used in the past with no problems. This does not appear to be a Cognos issue.