Update Rule formula -Very Very Urgent

[former_member358086]

I have a ODS .For a field in the update rules , I have combined first name and last name . I have used the formula CONCATENATE( /BIC/ZLD_FNM, /BIC/ZLD_LNM ).

When I checked the syntax. It is corrrect.

But when I am trying to activate update rules, it is showing the error as

"Empty or invalid formula 45HX958085BBNCY4WEXP4D10J"

Please suggest anything immediately.

[former_member185071 · Accepted solution]

Hi srikanth vangara

Did you checked those fields are avilable in Communication structure ....?

If the formula is syntactically corrrect means like what ever the state ment you had

place is correct.

but rules wise may its incorrect so plz make sure about remaining fields also...

Cheers

R M K

***Assigning pointz ez da only way of saying thankz in SDN ***

[Former Member]

Hi,

Check whether your update rule is having any other formula is there and verify it that also fine.

Regards,

Vivek V

[Former Member]

Hi Srikanth,

Delete the formula ,come out of the update rules and now again go to updaterules and create the formula and try to activate it

Regards

Sirisha

[Former Member]

Hi

Go and check all the fields in the UR i mean jst cross check that mite b there is no formula in one or the other field.

Also use check bfore activating the UR it will tell u if there are any errors further

Hope it helps

Thanks

Puneet

[former_member358086]

I have checked those fields. They are available in COmmunication Structure.

One more thing : Update rules are shown as active and the version is shown as Revised.

Is there anything related to this?

[Former Member]

Hi,

Just do a syntax check on the update rules, see are you gettinga any warnings or errors. Also do a syntax check in each formula as well.

Best Regards,

Rajani

[Former Member]

Hi Srikant,

Check the update rule for any formula, Activate it again and get it transported to Prod and check.

Regards.

[Former Member]

Hi,

You better check other characterstics and KFs' Mappings also.There may be a possible of having no formula/routine update rule but with mapping as formula/routine .

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi,

use a routine better:

CONCATENATE
  COMM_STRUCTURE-/BIC/ZLD_FNM
  COMM_STRUCTURE-/BIC/ZLD_LNM 
INTO RESULT.

hope this helps,

Olivier.