Re:Assignment operation failes error

[Former Member]

when i execute an Assignment individually depending on some criteria it is working for one record.............

But when i try to do the same for multiple records at a time it is throwing the above mentioned error.

Can anyone clear me this.........cant Assignment run on multiple records at a time.

[former_member182007 · Accepted solution]

Hi,

As nisha suggested just check the previleges for user and function defined.

Otherwise go one by one record and execute the assigenment.

Hope it helps.

Rgds

Deepak

[Former Member · Accepted solution]

The same error for different assignment also

the assignment exp is:----

---

for the vendor account group XXX,i want to get set the region as STATIC

And for which i have written as...

Assignment : If(Account group.record=Account group[XXX],STATIC)

Table field : Region

where STATIC is a value in Region (which is drill down)

[Former Member · Accepted solution]

Hi Shifali,

You want to check, if for a given main table rec,a particular rec has account group field value as XXX then it should be replaced by Static.

Is this is the case then instead of validating the record,validate the rec field only.

If(Account group.Code=XXX,STATIC,Account group.Code)

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member · Accepted solution]

Hi,

As per your requirement both Account group and Region seem to be look up flat.So the expression would be

If(Account group.record=XXX,STATIC,Region)

Regards

Nisha

[Former Member · Accepted solution]

Hi Shifali,

If your region table is also lookup then your Assignment Expression would be:

If(Account group.record=Account group,region )

In short you need to select the Static value instead of typing in a similar way you did for Account group

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

I Selected value from Look ups only..........but showing the error...........?

[Former Member · Accepted solution]

Hi Shifali,

I was talking about the second part i.e. STATIC value because from your expression it seems that you have typed the value and not selected from the lookup.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

If(Account group.record=Account group[XXX],Region [STATIC] )

even though it is telling the same.

[Former Member · Accepted solution]

Hi Shifali,

Try to execute the assignment with Admin user. If your expression is correct then it may be rights issue.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Hi.

The assignment will also fail if some of the records are in a workflow. Please check this.

Regards, Anders

[Former Member · Accepted solution]

Hi Shifali,

In addition also verify whether Assignment field is the same of which you are assigning a value i.e. Region

First try to execute an assignment on one record only.

Regards,

Jitesh Talreja

[Former Member]

kindly check with the workflows

Edited by: Sainath Chutke on Oct 6, 2008 3:53 PM

[Former Member]

Hi,

Assignment can run on multiple records.

If an assignment fails for any of the selected records, the entire assignment fails and none of the records are assigned and you get the error.

So as per Jitesh's suggestion u can check the record causing error by selecting less no of records.

Also check the User who is running the assignment has sufficient previleges i.e table is not in Read only mode (under Tables and fields tab u can check)

Regards

Nisha

[Former Member]

Hi Shifali,

This happens because one of the record from multiple records is causing the issue. When you run the assignment on multiple records it will pick the individual record only and execute the assignment over it.

You need to find the record causing the error. Try by selecting less number of records.

Regards,

Jitesh Talreja