企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 533|回复: 1

"The server method 'CommitSandbox' failed" error ...

[复制链接]

75

主题

398

帖子

573

积分

高级会员

Rank: 4

积分
573
QQ
发表于 2014-3-18 00:41:00 | 显示全部楼层 |阅读模式
Hi,

my client is using Cognos TM1 10.1. They have built up an Application from Performance Modeler and all the end users should commit and submit data over the web. They are getting the following error while trying to commit over 15 records at a time - "The server method 'CommitSandbox' failed". They get the error message only when inserting data over the web. In Architect everything works fine and the performance is also good.

When they try to commit 2-5 records over the web, then it processes really slowly, however it manages to finish at the end. Committing approx 15 records is already too much for tm1 because after a minute or so it throws an error. I have a feeling that it might be something to do with server network settings but I am not sure. It seems like there's some kind of timeout after which the tm1 throws an error message.

Has anybody come across the similar situation?

Thanks,
Jaan
回复

使用道具 举报

66

主题

394

帖子

543

积分

高级会员

Rank: 4

积分
543
QQ
发表于 2014-3-18 02:24:21 | 显示全部楼层
Just to update my post, the function that is causing the delay is ServerSandboxMerge. After some minutes the server sends an error message because of timeout. If I let the server work as long at it needs, the function finishes after 10 minutes. I could temporarily solve the problem by reducing drastically the number of time periods in the time dimension. Now the function takes about 30 seconds. It is still too long as the system goes into production in October and therefore doesn't have many data in it. The time periods I deleted had zero values, so I was surprised that it actually affected the performance.
I couldn't find any reasonable explanation as to what the function exactly does except of "merging the sandbox data into base data". If I want to accelerate the run-time, the explanation doesn't help. Does it create some internal indexes before merging? Does it check all the fields of all the dependent cubes regardless of zero values? I saw that it performed also some disk writes during the merge. Does it mean that it logs the merges in parallel? If I use the base data only then all the calculations work just fine. The performance issues start with committing the sandbox. Maybe there's a simple design issue I wasn't aware of.

So, if anybody has a good reference or has come across a similar situation, I would still appreciate the feedback.

Regards,
Jaan
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-7-6 03:22 , Processed in 0.285360 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表