pointer out of range error-report studio

[sachin]

Hi,

In one of our scheduled repors, we saw this error message. I've no clue what this means and if any of you could give me some information on what this means or atleast from which tier(service) is this referencing to (by UT-DEF??) it will be really helpful.

RSV-DR-0002 Unable to execute this request.
UT-DEF-0037 azs_offset: pointer out of range.
UT-DEF-0037 azs_offset: pointer out of range.
UT-DEF-0037 azs_offset: pointer out of range.
UT-DEF-0037 azs_offset: pointer out of range.
UT-DEF-0037 azs_offset: pointer out of range.
Trace back:
WPBIBusMethod.cpp(190): WPDataRetrievalException: CCL_CAUGHT: WPBIBusMethod::run
WPReportExecutionMethod.cpp(174): WPDataRetrievalException: CCL_RETHROW:

WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(169): WPDataRetrievalException: WPExecuteRequestThread::checkException
WPEngine.cpp(1012): WPDataRetrievalException:
WPController.cpp(263): WPDataRetrievalException: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(320): WPDataRetrievalException: CCL_RETHROW: LWDataRetrievalEngine::prepare
LWDataRetrievalEngine.cpp(1842): WPDataRetrievalException: CCL_THROW: LWDataRetrievalEngine::runQSQuery
Source/CQERequest.cpp(799): QSException: CCL_THROW: CQE

Thanks a bunch
Sachin

[bdybldr]

Sachin,
Please provide more details.  What type of report are you developing?  Where you creating a calculation at the time you received this error.  If so, please post your calculation.  What was your last activity prior to receiving this error?

Thanks.

[sachin]

I do have calculation on characters for concatination, for ex: [carrier] + trim(cast_char([date])) +trim(cast_chat([flightnum])), there are 3 calculation of this nature and one more that does a count((of what i've typed) for [flightnum]).

it gets better, this report runs perfectly fine some days and sometimes it gives an error saying : Pointer out of range.

Today when i tried to validate the report i got this new one.

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'. UDA-SQL-0524 An unexpected request tree node type was encountered during the code generation phase of the PREPARE operation. UDA-SQL-0205 An unexpected error has occurred during the PREPARE operation.
RSV-RND-0052 Failed to validate the layout due to missing metadata information for query 'FlightMaster'.

there are filters in the report which makes sure none of these column written abve have null or missing value.
Let me know if your comments.

thanks
sachin

[sachin]

I do have calculation on characters for concatination, for ex: [carrier] + trim(cast_char([date])) +trim(cast_chat([flightnum])), there are 3 calculation of this nature and one more that does a count((of what i've typed) for [flightnum]).

it gets better, this report runs perfectly fine some days and sometimes it gives an error saying : Pointer out of range.

Today when i tried to validate the report i got this new one.

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'. UDA-SQL-0524 An unexpected request tree node type was encountered during the code generation phase of the PREPARE operation. UDA-SQL-0205 An unexpected error has occurred during the PREPARE operation.
RSV-RND-0052 Failed to validate the layout due to missing metadata information for query 'FlightMaster'.

there are filters in the report which makes sure none of these column written abve have null or missing value.
Let me know if your comments.

thanks
sachin

[bdybldr]

I would suggest as a first step that you validate each of your calculations.  In my experiences, the "Failed to validate layout..." error is caused by invalid expressions.  In most cases you tried to use a function that is not available in the database that drives your report.  What is your db?

[sachin]

am using sql server 2000 and the invalidate error, as you said, is due to the previous error which stumped me totally. i just need to know this, can do a count([char]) and set its aggregation to TOTAL in Tabular  Model?

sachin

[bdybldr]

The answer is yes.  You can total a count of a char field, you just can't total a char field.

[bdybldr]

I wonder if there's some significance to the number of "Pointer out of range" errors.  How many calculations do you have because the error is displayed 5 times.  Did you validate all calculations?  What was the result?

Can you post all of your calc so we can look at them?

[sachin]

the error was due to a calculation for [int1] defined as count([char1] for [char2]) with its aggregation  set to TOTAL. there was also a filter in tabuilar Model saying [int1]>?number prompt?.

i removed the for and also changed the "total" aggregation to "Calculated" since the Aut-Aggregation property of the Tabular Model is set to NO, my row-level data will not be affected. then instead of the "for [char2]" for counting on grouped item [char2], i added [char2] in the cube-level grouping so reportnet autmatically calculates fact total based on the grouped column. this was done at query level(cube-level). sincce this will be shown only on the summary row, i added a list summary for [char2] and placed [int1] there. hope you are still with me. then, i added [int1]>?number prompt? filter at the cube-level to handle the filtering.

let me know if my explanation isnt clear.

sachin