I am trying to create a query in QaaWS but receive a getDocumentInformation exception (Error:WIS). I am able to create queries successfully but when I try to place a structure element into the Prompt area on QaaWS I get this message. The structure has two options - ‘This Year’ and ‘Last Year’. The funny thing is that the QaaWS was working before but now no longer work since we patched the BW system.
I know what you are thinking, QaaWS always has issues when you use a prompt where the input is a character. It only seems to like key figures. I got round this by creating a filter using the list of values option and then selecting ‘last year’ as the hard coded value and this seemed to work without any issues. Now when I reach the LoV screen the area where I choose either this year or last year is blank
Has anyone else had any experience of this?
I am trying to rebuild my model and get random messages when trying to generate the QaaWS
The datasource object key queryspecification.querybase.queryobjectsort.queryobjectsort.key is nota valid one of the given datasource (WQR 01201)
I sometimes get some text with the WIS 10901 ‘A database error has occurred. The database error text is: The MDX query SELECT {} on columns, crossjoin from query x failed to execute with the error unknown error’
There are a couple of issues when you query BW (either using universe against an infocube or a BEx query) that you need to keep in mind. The WIS 10901 is a catch-all error, so you won’t get much help from the error messages explained guide.
If you are using opendocument, you will get this error if you pass a description. You need to pass the key. The great thing about BW is that there are keys for everything.
You can also get this error if you don’t include a key figure in your query.
Also check if your BEx query has changed. This can also lead to wierd xml errors. Refresh your universe structure.
Is your prompt based on a BW field or a datastore object field? Stick with BW…
Thanks for responding to my post and for the advice.
Unfortunately I am using a structure that I created in the BW query so it does not have any corresponding key values. I know that QaaWS does not like these text values to be used in prompts so I used the ‘List of Values’ to hardcode a value into the QaaWS and produce multiple queries for each option. This seemed to work until a patch was applied to Business Objects
The only way I can see round this is creating a separate query for each value that I require (by restricting in the BEx query) but I can’t understand why the structure does not work.
(BOB member since 2002-08-15)