Skip to main content
Question

IAL scheduling error

  • November 8, 2020
  • 2 replies
  • 387 views

Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 2 replies

Hi,

When I am trying to schedule an IAL in IFS10, the background job is showing error details as “Table not found. Redeploy the scripts manually                    ORA-20105: IalObject.REPTABNOTEXIST”

When the same IAL is configured as Live data, then there is no issue in fetching data.

Could anyone help in resolving this error? 

Thanks in advance!

2 replies

  • Superhero (Employee)
  • 1432 replies
  • November 9, 2020
naija wrote:

Hi,

When I am trying to schedule an IAL in IFS10, the background job is showing error details as “Table not found. Redeploy the scripts manually                    ORA-20105: IalObject.REPTABNOTEXIST”

When the same IAL is configured as Live data, then there is no issue in fetching data.

Could anyone help in resolving this error? 

Thanks in advance!

Can you see anything in the Oracle Alert Log?

How many Failed Executions to you have?
 

What is your Information Access Layer (IAL) - Maximum occurrences of erroneous schedule jobs system parameter set to? 

 

If it is 0, try setting it to -1 and then go to the IAL and RMB - > Reset Failed Executions and it should run again.


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 2 replies
  • November 19, 2020

This issue got resolved. I was using pipeline table query for creating IAL and was getting error while scheduling the IAL. When added the exception NO_DATA_NEEDED in pipeline table API, the error disappeared. Thank you.


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