After update Cognos Express 9.5 to 10.2.1 do not work excel

Post Reply
Slava79
Posts: 24
Joined: Thu Nov 21, 2013 7:30 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2007

After update Cognos Express 9.5 to 10.2.1 do not work excel

Post by Slava79 »

Hello

1. We have updated Cognos Express 9.5 to 10.2.1
2. IF open in TM1WEB one Excel form with buttons (button run TI) and then open second Excel form with buttons (button run TI) - TM1WEB generate Error message
"Message from webpage Invalid Argument"
Attachments
error.jpg
error.jpg (48.14 KiB) Viewed 5477 times
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: After update Cognos Express 9.5 to 10.2.1 do not work ex

Post by EvgenyT »

Found this mate:

Cryptic:

tm1xl: An invalid argument was encountered

Cause:

You pressed an action button when the active cell in Excel begins with an IF formula.

Starter for 10 if anyone can come up with the why...



Original post:

http://www.tm1forum.com/viewtopic.php?f=21&t=2009
Slava79
Posts: 24
Joined: Thu Nov 21, 2013 7:30 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2007

Re: After update Cognos Express 9.5 to 10.2.1 do not work ex

Post by Slava79 »

Thank you.
Excel forms dont have any formulas - only button.
Slava79
Posts: 24
Joined: Thu Nov 21, 2013 7:30 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2007

Re: After update Cognos Express 9.5 to 10.2.1 do not work ex

Post by Slava79 »

tarry9
Posts: 3
Joined: Tue Mar 04, 2014 11:03 am
OLAP Product: tm1
Version: 9.5.2
Excel Version: 2007

Re: After update Cognos Express 9.5 to 10.2.1 do not work ex

Post by tarry9 »

I also faced the same issue . IF I open TM1WEB one Excel form and then open second Excel form with action button, TM1WEB generate Error message
"Message from webpage Invalid Argument"

My Excel sheet doesnot have any formula. Also if i go with the below suggested point to change the compatibilty mode of IE8, that also doesnot help me and still giving the same error message.

Any suggestion??
moby91
MVP
Posts: 227
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: After update Cognos Express 9.5 to 10.2.1 do not work ex

Post by moby91 »

So the Action button in the first websheet shall navigate / jump to the second websheet ?
If so, what happens when you click the OK button of the error message ?
Does the error message pop up again ?
And after you click the OK button of the second error message you navigate / jump from the first to the second websheet ?

And you are using the MSIE 8 web browser ?


If so, you have been hit by the open software defect logged as APAR PI13089:

https://www-304.ibm.com/support/entdocv ... wg1PI13089
PI13089: USING TM1 WEB 10.2.0.1.2 AN ACTION BUTTON TO NAVIGATE TO ANOTHER WEBSHEET RETURNS ERROR MESSAGE "INVALID ARGUMENT"

APAR status
OPEN

Error description
Using TM1 Web 10.2.0.1.2 an Action Button to navigate to another websheet returns error message "Invalid argument"
A websheet has an Action Button to navigate to another websheet.
When using TM1 Web 10.2.0.1.2 on MSIE 8 web browser, in an english environment a click on the Action Button returns the english error message:
Message from webpage
Invalid argument
twice before to navigate to the other websheet succeeds.
In a german environment the german error message:
Meldung von Webseite
Ungültiges Argument
is returned twice.
When using TM1 Web 10.2.0.1.2 on the Firefox ESR 17 web browser everything works, a click on the Action Button to navigate to another websheet does not return an error message.
tarry9
Posts: 3
Joined: Tue Mar 04, 2014 11:03 am
OLAP Product: tm1
Version: 9.5.2
Excel Version: 2007

Re: After update Cognos Express 9.5 to 10.2.1 do not work ex

Post by tarry9 »

Thanks for the reply,

yes, I am using MSIE8 web Browser. Also, The same template works fine in Chrome. So it seems that issue is with IE8 only.

Thank you for the Defect Log ID :)
Post Reply