TM1.Audit.PostProcessor Error

Post Reply
User avatar
mattgoff
MVP
Posts: 518
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

TM1.Audit.PostProcessor Error

Post by mattgoff »

Anyone seen errors like this? I'm also opening a ticket with Cognos, but I'm curious to hear if others have seen it as it's a new one to me. I do (obviously) have the audit log turned on with a 60 min writeback timer, but it's been on for a long time and we just started seeing these errors. No changes made to TM1 lately, although I did just have to have IT tune AV settings as there were locking problems on ASCIIOutput writes.

Code: Select all

2011-06-27 15:15:29.581   TM1.Audit.PostProcessor   Error copying Scenario.dim
2011-06-27 16:15:29.489   TM1.Audit.PostProcessor   Error copying Cost_Center.dim
2011-06-27 18:15:29.304   TM1.Audit.PostProcessor   Error copying Scenario.dim
2011-06-28 09:15:29.494   TM1.Audit.PostProcessor   Error copying Scenario.dim
I bounced the server too-- it's been a month or so, so good to clean out the cobwebs....

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
User avatar
Mike Cowie
Site Admin
Posts: 484
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: TM1.Audit.PostProcessor Error

Post by Mike Cowie »

Matt:

Looks like IBM's already posted an explanation?

https://www-304.ibm.com/support/docview ... s=swgimgmt

Apparently you just work at too high a rate of speed... multiple dimension updates in under a minute! ;)

Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
User avatar
mattgoff
MVP
Posts: 518
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: TM1.Audit.PostProcessor Error

Post by mattgoff »

From support:
The reason for the mesages is that you will have had more than one process making a change to the same dimension within one minute.

What is happening is that after the dimension change process finishes an audit process runs to record these changes. This audit process wakes up every minute to process all the auditing for the preceding minute. It sees the first dimension change and writes a file Scenario.dim.<timestamp> it then sees the second change to the same dimension and again tries to write another file Scenario.dim.<timestamp>. If when it tries to write the second file, for the second dimension change, the timestamp is the same as the first it will fail to write it as it already exists. The issue is that the timestamp is only calculated to the second.

The dimension change itself is not affected only the audit trail is affected.

The recommended way to avoid this happening is to try and separate dimension changes that change the same dimension by more than a minute.
Classic.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
User avatar
mattgoff
MVP
Posts: 518
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: TM1.Audit.PostProcessor Error

Post by mattgoff »

Mike Cowie wrote:Apparently you just work at too high a rate of speed... multiple dimension updates in under a minute! ;)
I know! I should really plan all of my TI scripts to work as if they were a human hand-calculating the data to accommodate logging. WTF.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
Post Reply