how to concatenate % or $ with Procedure column

[aamuktha]

hi

 here is the issue....
 
             i need to concat % to a procedure column..

i have used concat function on table column it is working fine.But the same function is not working with Procedure column.

is it bug in cognos??


for example 

                     EMP is a table

                         CONCAT(EMP.SAL,%)    IT IS WORKING FINE.
                   
                   PKG_EMP IS A PROCEDURE

                        CONCAT(PKG_EMP.SAL,%)  IS N0T VALIDATING . IT IS GIVING ERROR.


PLEASE SUGGEST ME .


THANKS
aamuktha

[JoeBass]

I tried this (with SQL Server) and also got a strange problem.  The calculation validates fine (Using reportnet function to cast) Cast([Datasource].[QuerySubject].[Field], char) + '%',  but, when I run the report, I get an error that complains the string has been right-truncated. 

What is the error you are getting?

[mrcool]

hi

this is the error getting

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'.
UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "double" and "character" UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "double" and "character" UDA-SQL-0460 A general exception has occurred during local processing.
 Is it a bug in Report net

it is coming only for procedure column.


thanks
s

[JoeBass]

It is complaining about the difference in data types.  Have you tried casting the number as a string? 

[mrcool]

hi


this is the error when Iam using cast function...Iam getting this error only while running the report,not when validating...Report is getting validated without errors...

UDA-EE-0092 Data exception occurred. String data has been right truncated.

UDA-SQL-0460 A general exception has occurred during local processing.

UDA-CUR-0000 Unable to fetch the row.

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(190): QSException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): QSException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): QSException:

WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(785): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE

[JoeBass]

Thats the same scenario I mentioned above.  Sounds buggy.

[BIsrik]

u can't create calculation on the procedure query subject..

Srik

[BIsrik]

Refer page 15 of Frame work manager user guide...

Srik

[aamuktha]

hi

Thanks for your reply


aamuktha

[BIsrik]

can u plz update the status of the topic..

Srik

[aamuktha]

hi

came to know that it is not possible with procedure column.May be it is bug with cognos.But not sure...........


aamuktha