Source - Target Diff / Difference tool for packages

  • 14Views
  • Last Post 16 September 2020
  • Topic Is Solved
0
votes
Bart Jonk posted this 11 September 2020

I'm currently trying to solve errors of the type : 

"An exception has occurred during initialization: Updating field with name Buying Role does not exist in schema table"

It would be really helpful if you could show the ALL missing fields in the target tables given the (current) source definition. 

 

 

Order By: Standard | Newest | Votes
0
votes
Bart Jonk posted this 16 September 2020

Hi Mariia, 

Great! that really helped. Based on the info in the error from the new runtime, I created new fields in my target using ALTER TABLE statements: 

...
Alter table hubspot."Contacts" add column "Country/Region" text;    
... etc.

The only thing I ran into was that I created one statement with the wrong data type. What if you would be able to generate the statements? 

It could even be possible to execute them as well...   


0
votes
Mariia Zaharova posted this 15 September 2020

Hello Bart,

 

More detailed error messages are already available for packages with the "Use new runtime" option.

 

Best regards,

Mariia

0
votes
Mariia Zaharova posted this 13 September 2020

Hello Bart,

 

Thank you for your suggestion. We will definitely consider implementing it and inform you about the results as on as possible.

 

Best regards,

Mariia

Close