XQE-PLN-0269 Error 'rpad' function is invalid. HELP!!!

[lorenmario]

Hello!

I'm in big trouble here, I migrated several reports Cognos7 for Cognos10, some reports are showing a strange warning:
XQE-PLN-0269 The argument at position 3 of 'rpad' function is invalid in the expression 'rpad ([AESBI] [Economic Activity] [Original NCEA Code],.. 5, 0)'; is expected of the following types: 'string'.

Have googled and honestly have no idea what might be causing this error. The report it´s a simple crosstab, runs normally, but when I validate this error appears, and the user will complain.

Is it a problem with the Framework?

I took a look at the model, this field appears as Character lenght 16, precision 5, Scale 0.
Does this have something to do?

Prints the report attached, and xml too.
Please help me!

[lorenmario]

The xml attachment.

[MFGF]

Hello!

I'm in big trouble here, I migrated several reports Cognos7 for Cognos10, some reports are showing a strange warning:
XQE-PLN-0269 The argument at position 3 of 'rpad' function is invalid in the expression 'rpad ([AESBI] [Economic Activity] [Original NCEA Code],.. 5, 0)'; is expected of the following types: 'string'.

Have googled and honestly have no idea what might be causing this error. The report it´s a simple crosstab, runs normally, but when I validate this error appears, and the user will complain.

Is it a problem with the Framework?

I took a look at the model, this field appears as Character lenght 16, precision 5, Scale 0.
Does this have something to do?

Prints the report attached, and xml too.
Please help me!

Hi,

rpad is a native Oracle function - right?

Looking at this page: http://www.techonthenet.com/oracle/functions/rpad.php
it seems that the third argument the function is expecting to be passed should be a string. The syntax you posted above looks really strange - you have an item [AESBI] [Economic Activity] [Original NCEA Code] as the first argument, you appear to have .. 5 as the second argument (is the .. a typo?) and you appear to have 0 as the third argument. The error message is telling you that the third argument needs to be a string not a number (0).  Try putting the 0 in single quotes in the expression - ie ,'0' and see if this makes the error disappear. I'm guessing you want to append zeros to the right hand end of the data item rather than spaces?

Cheers!

MF.

[lorenmario]

Hi friend, thank you for your answer!

I'm using [AESBI] [Economic Activity] [Original NCEA Code] field in my report, but don´t have argument or parameter, I dragged the field and put the crosstab, there when I validate this error message appears:

XQE-PLN-0269 The argument at position 3 of 'rpad' function is invalid in the expression 'rpad ([AESBI] [Economic Activity] [Original NCEA Code], 5, 0)'; is expected of the Following types: 'string'.


But nowhere in the report that expression appears! I Don´t know why this , 5, 0 is pointing Cognos, I did not put it in the report!
So what have neither edit, or test, because this expression is not used in the report.

Do you understand me?

My report is a crosstab, the lines I use this field, in columns using the Month, and an indicator. ONLY.

There are 4 filters, but none uses this field ...

I do not know what else to do ... any suggestions?

Thanks!

[lorenmario]

Hello!

I open the framework and saw that within the Economic Activity table, the field problem appears as calculated, and the expression is just this:

rpad ([AESBI] [Economic Activity] [Original NCEA Code], 5, 0)

From what you told me, rpad function asks for a string argument, but 0 is a numeric item, so the error appears.

Placed between the '0'.

Now I will test.