Cannot execute BW query: Nested Exception (Invalid_Variable_Values)

[Former Member]

When i try to deploy a VC model (Input form --> BEx Query --> Table), I am getting the below error:

<u><i><b>Cannot execute BW query: Nested Exception

Failure to execute native function.

Invalid_Variable_Values</b></i></u>

Did anyone come across the above error??

Thanks in Advance.

[MG3]

Hi RK

In addition to the info in the link provided above, it is important that you pass the value in the <u><b>exact format</b></u> as the variable expects.

Thanks

Manoj

[Former Member]

Thanks Manoj.

There is one mandatory input on the input form (numc 10):

VC: I tried '1', 1, 0000000001, '0000000001'. -- none of them work

BEx: i tried 1 -- it works

Thanks.

[Former Member]

Yes, of course. Many people before you, so that we created an FAQ section just for that question

https://wiki.sdn.sap.com/wiki/display/VC/InvalidVariableValues+error

[Former Member]

Mario,

Thanks for the link.

I already went thru the wiki links before posting this thread.

There is one mandatory input on the input form (numc 10):

VC: I tried '1', 1, 0000000001, '0000000001'. -- none of them work

BEx: i tried 1 -- it works

Thanks.

[Former Member]

Problem solved.

Input form was passing values to "input" instead of "variables". I did not notice that for some reason until i went thru the "variables -Visual composer" doc.

Thanks.

[Former Member]

Hi RK,

I have similar problem for the mandatory input variable.

When i give the input using Value Help also iam getting the same message

"An error returned form the back-end system: Nested Exception. Failure

to execute native function. Nested Exception. INVALID_VARIABLE_VALUES"

Could you let me know how you have resolved the issue in brief which i think i could also implement in this case.

Thanks

Venkat

[former_member191571]

Venkat,

For BI Query in VC, there are two things : Input and Variables

When there are variables in the query and you connect the Input form to Input section of BI Query, you get this error.

So you have to make connection between Input form and Variables of BI Query.

This should resolve the error of Invalid variable values.

[Former Member]

Hi experts,

We have similar error. But only for the ordinary users. And this only happens the first time they run VC reports (after they log-on to their PC). The same problem does not appear, the next time they run the report.

This is not a problem for us few who have SAP ALL. The users have complete roles and authourization to run the queries. they are able to run the reports directly from BW. We also trace the user authorization when they run VC but we do not find anything. This is a mystery for us until now.

Is there anyone who can help us?

Thanks in advance.

Best Regards,

Rose

[saptechnicalteam_rcs]

Hi Rose

Not sure if it would help you but we had the same kind of behavior lately : indeed one user ran his VCI query without any error but another user with exactly the same authorization faced a "Invalid_variable_values".

I finally managed to figure out what happened : the date format is user's personal settings was different (one in DD.MM.YYYY and the other MM.DD.YYYY). So you perhaps need to check out the user personal settings for your different users, a formatting display difference could result in this error message

Regards

François