Search found 6 matches

by kbana
Wed Mar 30, 2011 6:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW *KEY_ERR or #N/A
Replies: 3
Views: 5318

Re: DBRW *KEY_ERR or #N/A

great thanks... still weird as these aliases have not changed for over a year now. And the server has not been restarted, it just suddenly stopped working. The upgrade took place over a month ago. The alias is for an element called SandBox4 (alias to Scenario4) in the Version Dimension. My gutt feel...
by kbana
Wed Mar 30, 2011 4:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW *KEY_ERR or #N/A
Replies: 3
Views: 5318

Re: DBRW *KEY_ERR or #N/A

Hi All again,

Just discovered that when I turn off an alias on one of the dimensions the slice works.
This alias is unique and only applies to that dimension's elements.

Still weird.

Cheers
by kbana
Wed Mar 30, 2011 4:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW *KEY_ERR or #N/A
Replies: 3
Views: 5318

DBRW *KEY_ERR or #N/A

Hi All, This is weird. I can enter the values in the cube and it works fine - the cube accepts the manually input values, but when I slice to Excel or manually build the same I receive *KEY_ERR from the DBRW instead of the values, if I try to type over this, I receive "T1) Write Access Denied&q...
by kbana
Mon Feb 21, 2011 12:44 am
Forum: Useful code, tips and tricks
Topic: New TI Process & Chore Command-Line Execution Utility
Replies: 21
Views: 76447

Re: New TI Process & Chore Command-Line Execution Utility

Hi Mike, Apologies, I have been away and didn't notice your question prior to going away. Anyway - I read the other post and we are using SQL Server (not Oracle) - hence, unrelated. I'm not sure what SQL driver we were using, but it was an old one, updating the driver did the trick. The server is mu...
by kbana
Fri Oct 22, 2010 4:15 am
Forum: Useful code, tips and tricks
Topic: New TI Process & Chore Command-Line Execution Utility
Replies: 21
Views: 76447

Re: New TI Process & Chore Command-Line Execution Utility

Hi Mike, Thank you for your reply! We got it running, stupidly it was the ODBC driver - sometimes the TIs would run and sometimes they would crash. Testing with non-ODBC TIs was successful, we are puzzled though, as ODBC has been running fine for over a month and suddenly started crashing (and only ...
by kbana
Fri Oct 22, 2010 2:48 am
Forum: Useful code, tips and tricks
Topic: New TI Process & Chore Command-Line Execution Utility
Replies: 21
Views: 76447

Re: New TI Process & Chore Command-Line Execution Utility

Hi Mike, This is great, however, it keeps crashing our 64bit server 9.5.0 (moving to 9.5.1 soon) and using CAM security Name Space authentication. The first message reads; "Successfully connected to TM1 server" couple of minutes later it comes up with 85: SystemServerConnectionInvalid and ...