Skip to main content

 I am creating an Excel Migration job that will set hundreds of Requisition Authorisation Rules to ‘Planned’.

This is very much like the topic I raised and got a very good answer that worked well: Excel Migration - Delete User Sites | IFS Community. On this occasion the same principles are not working for me.

Here is the job...

For the Action on Seq 10 I have toggled InLoop and NoExecution.

For Seq 20, I set these attributes…

My source mapping looks like this - I allowed the default Source Columns and assume I don’t need to do anything with the first 4 Method columns…

Having tried many variations, the latest result is set to null upon execution…

In the debug Trace, I see this error…

It looks like it is trying to grab every column and insert the values into the Attr_ variable.

I’m out of ideas now

Hi @BABPAULS 

one thing I can see is that you have added apostrophs/quotations to column sequence 50 in the method list attribute screen. Please remove these characters so that only the value DO is in the Fixed Value column. If you would you this in the source mapping screen then ‘DO’ is correct but not in the method list attribute screen.

 

The 2nd thing I recognize that seq 10 is set to “NoExecution”. Set it to “In Loop”, otherwise the OBJID and OBJVERSION will not be inherit to seq 20.

/Jens

Thanks Jens for the quick response.

Unfortunately, I am getting the same result as before - null in the Result column and the trace is showing this error again…

11^720827921^APPLICATION^TRACE^Application^TRACE >>>>>>>>>>>>>>>>>>>>>>> JOB ABORTED - OTHERS
11^720827921^APPLICATION^TRACE^Application^OTHERS ORA-00972: identifier is too long
11^720827921^APPLICATION^TRACE^Application^ORA-06512: at "IFSAPP.INTFACE_METHOD_LIST_API", line 5119 ORA-06512: at "IFSAPP.INTFACE_METHOD_LIST_API", line 5126 ORA-06512: at "IFSAPP.INTFACE_METHOD_LIST_API", line 5144 ORA-06512: at "IFSAPP.INTFACE_METHOD_LIST_API", line 5150 ORA-06512: at "IFSAPP.I

Hi @BABPAULS 

Ok, only an idea and can you try the following please:

Copy your migration job to another job id. It seems that the length of the job id is too long.

Can you try with a job id which only has a length of maximum 20 characters please?

/Jens

Brilliant! That has worked.

Thank you so much for your speedy assistance, very much appreciated

Hi @BABPAULS

Perfect and you’re welcome.

I think the length of the job id is not allowed to have more than 22 characters in that case (for procedures EXCEL_MIGRATION and MIGRATE_SOURCE_DATA).

Have a wonderful day.

Cheers,

Jens

 

Reply


Terms & ConditionsCookie settings