Skip to main content
Menu
Solved

Migration failed ORA-20111: UserFinance.RECNOTEXIST: Access denied! User is not connected to Company

  • December 24, 2024
  • 5 replies
  • 305 views
S
Sidekick (Customer)
Forum|alt.badge.img+4

Dear all,
Recently, when I tried to use the Migration Job to update the content in the database, I encountered an error message after execution:

"Insert into FA_OBJECT_TAB failed - ORA-20111: UserFinance.RECNOTEXIST: Access denied! User 145409 is not connected to Company."

However, I have confirmed that my account has been set up with the relevant company configuration, and most permissions are fully enabled.

Does anyone know how to resolve this issue?

Best answer by StevenHsu

Dear ​@eqbstal ,

Yes, I tried to update the description of the object.

 

I found that I need to remove the column name row and the migration job to execute it successfully.

But the error message is quite strange and not really related to the actual cause of the issue.
The error message indicates a permission-related problem, but the actual issue was with reading the data content from the file.

 

The issue has been resolved. Thank you for your response!

View original
Did this topic help you find an answer to your question?

5 replies

eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • eqbstal
  • Superhero (Partner)
  • 693 replies
  • December 24, 2024

​@StevenHsu At moments that I got this message, there was one step missing. I had forgotten to add the user via Accounting Rules > User Related Data > Users per User Group (this is the IFS Cloud path, but think it is the same in IFS10).

You might have to check if the user group is connected to an open ledger period.

 

 

Thanks for using the community, it helps me. I hope I can help you.
T
1 person likes this
  • T
    truth_trump
S
Sidekick (Customer)
Forum|alt.badge.img+4
  • StevenHsu
  • Author
  • Sidekick (Customer)
  • 17 replies
  • December 24, 2024

 

 Hi ​@eqbstal ,

I've check the setting that you mentioned. But still get the same error message.

 

eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • eqbstal
  • Superhero (Partner)
  • 693 replies
  • December 24, 2024

You wrote 'Migration Job to update the content in the database’, but the message states 'Insert into FA_OBJECT_TAB’. So are you updating or inserting a fixed asset?

Thanks for using the community, it helps me. I hope I can help you.
eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • eqbstal
  • Superhero (Partner)
  • 693 replies
  • December 24, 2024

​@StevenHsu Does your user have full access to other parts of IFS. It might have to with a view that the user is not entitled to.

Thanks for using the community, it helps me. I hope I can help you.
S
Sidekick (Customer)
Forum|alt.badge.img+4
  • StevenHsu
  • Author
  • Sidekick (Customer)
  • 17 replies
  • Answer
  • December 25, 2024

Dear ​@eqbstal ,

Yes, I tried to update the description of the object.

 

I found that I need to remove the column name row and the migration job to execute it successfully.

But the error message is quite strange and not really related to the actual cause of the issue.
The error message indicates a permission-related problem, but the actual issue was with reading the data content from the file.

 

The issue has been resolved. Thank you for your response!

Reply


Terms & ConditionsCookie settingsAccessibility statement

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