Error After Updating and Migration

More
9 months 3 weeks ago #25715 by bcurr
Have migrated from 32bit to 64bit (all ODBC/connections are updated and working fine)
Moved from 9.2.11.8 to 9.3.6.15

Whenever I tried to make changes under any IMPORTS and update back to the repository, I get an error:
Insufficient key column information for updating or refreshing

This does not happen anywhere else.

I have tried with a blank repository and migration wizard
I have tried with the old repository and manually updating using the updates from here:
www.etl-tools.com/repository-database-updates.html
The same issue occurs either way
Attachments:
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
9 months 3 weeks ago #25716 by admin
What is your repository type?

 

Mike
ETL Architect
The following user(s) said Thank You: bcurr

Please Log in or Create an account to join the conversation.

More
9 months 3 weeks ago #25717 by bcurr
Repository is in mysql
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
9 months 3 weeks ago #25718 by admin

Please Log in or Create an account to join the conversation.

More
9 months 3 weeks ago #25719 by bcurr
I did indeed and I configured to make sure all settings matched.

As mentioned all other areas seem to write back to the repository fine, it is only IMPORTS
I have also tried to create a brand new import object and this has the same issue
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
9 months 3 weeks ago #25720 by admin
In your case most likely some of the primary keys are missing. so the software does not know which row to update/refresh = you get the error

Please check OBJECTS and  OBJECTS_TREE tables

Mike
ETL Architect
The following user(s) said Thank You: bcurr

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save