9.5.2 FP2 critical bug: mass data clearance across cubes

[moby91]

You mentioned about IBM providing a simple fix that has to do with an IF clause in the server code. What exactly is that?

I really don't remember the details, but it would have been as simple as IBM devs preparing a HotFix and sending it to us in the form of a small archive containing some files that we just replaced on the server. I haven't seen the problem since, either with that model/version or with any later ones, even though this issue does not seem to be mentioned on any official Fix List.

Edit: My secret spies have just returned with some intelligence strongly suggestive of this issue having been fixed in 9.5.2 FP3.

Could this be the software defect logged as APAR PM63560 and (according to the Fix List) fixed in the Hotfix 3 for TM1 9.5.2 FP2 ?

PM63560
Customer losing data due to rollback

When it is the software defect logged as APAR PM63560, to my knowledge the product fix is included in TM1 9.5.2 FP3 and 10.1 RP1.

[qml]

Could this be the software defect logged as APAR PM63560 and (according to the Fix List) fixed in the Hotfix 3 for TM1 9.5.2 FP2 ?

Yes, it looks like this is the one. I've gone through the fix list a few times now and didn't see it. Thanks.

[Darkhorse]

Hi QML

Would you be able to to tell me for our ability to refereance the problem which hot fix fixed it (the Dev ref code) and what IBM called the bug?

thanks

[Duncan P]

Could this be the software defect logged as APAR PM63560 and (according to the Fix List) fixed in the Hotfix 3 for TM1 9.5.2 FP2 ?

PM63560
Customer losing data due to rollback

Yes, it looks like this is the one.

I'm not sure what other information you would need.

[harrytm1]

Thank you so much to all your posts, especially to qml!

Unfortunately, IBM Fix Central has been undergoing maintenance since last Friday, so I was unable to download the files. Will try later.

To qml,
As much as you can remember, is the fix applied on the server or on the client? The reason I asked is because the customer is currently in the middle of budgeting process. Thus, it is tough for the fixes to be applied on users' PC due to the number of users and the need to submit data. Server is easier as we can just down it for 30 minutes.

[qml]

As much as you can remember, is the fix applied on the server or on the client?

You just need to upgrade the server using either the specific HotFix or, better yet, FP3. It would be a good idea to upgrade the clients to FP3 too, but that is not essential and can happen at a later date.

[Tm1andTm1]

What I understand from your post is that, a massive data is deleted by the user. I means user is overwriting the data.

This not because of any bug with TM1,
It is only because your excel in which you are using DBS and DBSS function is not properly placed and mapped to particular cell.

Hi all,

Wish to check if you have experienced the following bug which happened recently.

We have a budgeting model with HR, Capex, Profit and Loss and Balance Sheet cubes etc. The number of users accessing TM1 concurrently can be as high as 20 or more as they are using it for budget submission. The total user base is more than 50 contributors. It is currently on TM1 version 9.5.2 FP2.

The main methods of submission are through DBSend templates and data spreading in cube views.

It was reported that massive amount of data was missing across multiple cubes such as Headcount, New Capex, P&L. It spans not only to the budget version that they are using now, but also on actuals.

We looked t the transaction logs and found that data was deleted (both numeric and string) in several cubes at the exact same time by one User ID. This user belongs to an User Group that has access to the affected cubes and he was using DBSend templates to send capex data just seconds before that.

From the logs, his ID was writing data in the New Capex cube and then suddenly, at the same timestamp, it began to clear both numeric and string data in the same cube, as well as other cubes. Obviously, he couldn't have physically done so as there are more than 600 thousands of transactions under his ID at exact same time.

We still couldn't find the cause the triggered this mass data deletion event. In the end, we had to painstakingly use the "Backout" function in Transaction Query GUI to restore the deleted data batch by batch.

Has anyone experienced similar issue in 9.5.2 FP2 or even 10.1/10.2 versions? Any idea if this was fixed in later version, especially 10.2? I couldn't find this bug in the fix lists unless I missed it. I will push for an upgrade to 10.2 if it is confirmed that it is fixed in 10.2.

We are at wit's end, so any suggestion and advice will be greatly appreciated! Many thanks in advance!

harry

[Darkhorse]

Sorry all the reason I asked for a reference was because I cannot find the APAR PM63560 in here

http://www-01.ibm.com/support/docview.w ... wg27036823

Which is where you are pointing too

[paulsimon]

Still seems to be happening in 10.1.1

[BrianL]

Still seems to be happening in 10.1.1

What version of 10.1? There was an issue prior to 10.1 RP1 where a ChangeSetUndo call made without specifying a changeset ID would start undoing everything in the transaction log. Perhaps this is related to the thread cancel issue you mentioned in a different thread?

[paulsimon]

Hi Brian

The exact build number on the TM1sd.exe is 10.1.10200.39014. Not sure how that relates to RP1? The software was installed before I got here but from what I can tell it is vanilla 10.1.1 with no fix packs. Whether 10.1.1 is what you mean by 10.1 with RP1 I don't know. Wouldn't it be nice if IBM could standardise their version naming? Anyone I managed to work around the problem. It will be interesting to see if the same solution works for other lock up situations and not just ChangeSetUndo.

Regards

Paul Simon

[BrianL]

The exact build number on the TM1sd.exe is 10.1.10200.39014. Not sure how that relates to RP1?

As I understand it, that's 10.1 RP1 FP2 and should have the bug fix I mentioned. Glad to hear you've got a workaround at least.