Dashboard 4.1 - Date parameters in QAAWS Error

system · December 8, 2015, 4:04pm

Hi. Hoping someone can help. I have a dashboard developed in 4.1 which gets its data from two QAAWS. These use date parameters which are captured in the dashboard and fed back via the data providers.

I’m getting the following error - An internal error occurred while calling ‘answerPromptsEx’ API. (Error: ERR_WIS_30270)

I have googled and see it is an error associated with date parameters and was a symptom of a bug in BO4.0, but we’re running 4.1.

Can anyone help please?

Thanks

tfl_mark (BOB member since 2015-12-08)

system · December 8, 2015, 9:18pm

For Xcelsius/Dashboards I’d convert the date prompts to a character type to avoid these issues. Especially if you have a geographically distributed user base that could have different date syntaxes. There are just too many layers for this “date” parameter value to be passed through ( Dashboard > http>qaaws> universe > sql and back).

Not a fix, but a workaround.

Shobhit_Acharya (BOB member since 2005-08-11)

system · December 9, 2015, 9:39pm

My solution is generally to use date parts. Since most of my dashboards report at either the year or month level, I don’t both passing actual dates. I just create a universe object for the year (or month or whatever) and compare to that.

It can be a little work, but avoiding the date format nightmare is worth it.

Lugh (BOB member since 2009-07-16)

system · December 10, 2015, 9:32am

Thanks for the advice all. Its not ideal as the dashboard in question allows users to select a specific date from the calendar component, so I think a work around will be complicated, but will see what I can come up with and let you know.

tfl_mark (BOB member since 2015-12-08)

system · December 11, 2015, 6:01pm

Have you used a spreadsheet component to see how the date looks when previewing the dashboard? For example, perhaps when you set up the query, you enter the date prompt with 12/9/2015 and the query returns results. But when the Calendar component puts a date in the cell in Excel at runtime, perhaps it is being read as 12/09/2015 … or 12/9/15 … or perhaps even as an Excel date, like 42095. By using the spreadsheet component to see what’s actually happening in the cell, this may help provide a better solution. Let us know what you find.

~Roxanne

RoxanneP (BOB member since 2006-08-07)

system · January 11, 2016, 7:44am

I would suggest to pass the date parameter in below format:
A1=“01/01/2016 13:22:34”
=“DATETIME(”&YEAR(A1)&","&MONTH(A1)&","&DAY(A1)&","&HOUR(A1)&","&MINUTE(A1)&","&SECOND(A1)&")"

Just concatenate the parts of date in a cell with above format.

Looks like below in URL:

…&lsSFrom%20Date=DateTime(2015,8,18,21,36,23)&lsSTo%20Date=DateTime(2015,8,19,20,36,23)…

Hope this will help.

vijesh.chandra (BOB member since 2009-05-29)