Guys,
I’m getting this error when trying import:
[info] Added column with name 'study_source_type' to table 'v_ctms_study_gold' in server 'ctms_devtest_02'.
[info] Added column with name 'sponsor_protocol_no' to table 'v_ctms_study_gold' in server 'ctms_devtest_02'.
[error] java.sql.SQLException: Cannot alter 'v_ctms_study_gold' because it is not a table.
However, I didn’t change this. The view was altered by the DBA in the database itself.
It seems that Servoy thinks that I added the column - and now it won’t let me proceed.
IDEAS???
This is pretty critical…
Just to also clarify - I also created a brand new repository - and still, no good. It wouldn’t import.
OK! There was a problem with the view.
The DBA modified the view to have BLANKS as columns… something like this:
SELECT field1, field2, '' AS field3, '' AS field4 FROM table
This was because we modified a different instance of the table and used application.switchServer at startup - and the application would not recognize the altered schema without putting in those “fake” columns.
However, Servoy registered it as a “change” and would NOT let me import no matter what because it was trying to alter a VIEW and it would FAIL.
In the end, I copied the 2nd instance, renamed it - and pointed the staging to that server as the “main” connection - and was able to get it to work.
What a cluster! ![:roll:]( "Rolling Eyes")