Skip to main content
Solved

Custom Object Data Migration issue


NiyomalN
Hero (Partner)
Forum|alt.badge.img+9

 I have created a migration job which is used to migrate data into some custom fields in a core table. this included some reference fields as well. I have mapped the objkey for those reference fields and everything seems ok. But when I execute the job, core method get executed and during the execution of the customer method I get the below error. any idea on this ?

"ORA-20105: Message.ATTRNOTFOUND: Attribute "SQL" does not exist in message "..."”

 

 

Best answer by NiyomalN

Hi Malindu,

 

Thank you for the response. I have found the issue. Issue was with a custom event that is referencing to some of the custom fields. I just disabled them and issue resolved!

 

and, the aforementioned error message was the complete error message. There wasn't any other information related to the error.

 

Thanks a lot.

 

Kind Regards!
Niyomal.

View original

4 replies

Malindu Fernando
Hero (Employee)
Forum|alt.badge.img+6

Hi @NiyomalN,

It is not possible to say what the exact cause is without more details on the error. Usually this error is produced when you have not configured an SQL query where there should be one. 

Would it be possible to post the complete error entry from the logs? The complete error message should contain information as to where this error is originating from.

Hope this helps!

Regards,
Malindu


NiyomalN
Hero (Partner)
Forum|alt.badge.img+9
  • Author
  • Hero (Partner)
  • 98 replies
  • Answer
  • January 8, 2022

Hi Malindu,

 

Thank you for the response. I have found the issue. Issue was with a custom event that is referencing to some of the custom fields. I just disabled them and issue resolved!

 

and, the aforementioned error message was the complete error message. There wasn't any other information related to the error.

 

Thanks a lot.

 

Kind Regards!
Niyomal.


Forum|alt.badge.img+10
  • Sidekick (Customer)
  • 107 replies
  • January 8, 2022

Hi @NiyomalN , 

 

i would like to know the steps for creating migration job for custom fields.

Kindly share the steps.


NiyomalN
Hero (Partner)
Forum|alt.badge.img+9
  • Author
  • Hero (Partner)
  • 98 replies
  • June 16, 2023
m.arif wrote:

Hi @NiyomalN , 

 

i would like to know the steps for creating migration job for custom fields.

Kindly share the steps.

 Hi, there are different types of custom objects that can be added to IFS and each type has different approach when migrating into IFS please see the attached document 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings