TM1 Forum

Hello,
I have built a customer dimension based on customer ID which has some 16K elements; this has worked fine and performed well until now. This week I have added a more user friendly alias using dbsa spreadsheet statements to match elements to names from a SQL extract from Sage. This seemed to work OK until I stopped and restarted the service. After the service restarted every time anyone switches to the alias the TM1 service on the server hangs. I have recreated this issue on a second server too. If I clear all of the alias values out using the dbsa then the dimension works again.
The alias contains combinations of customer names from around Europe so there are extended charachters.

Has anyone come across an issue like this?

Try running SaveDataAll() before restarting the service.

Hello,

I have tried that already but it made no difference.

Sounds like a proper bug that you should report to support.

The only thing I can think to check is that the aliases are unique. Usually if two elements have the same alias then TI simply doesn't load it the second time and spits an error, but perhaps your system isn't handling it very well.

Martin