7.3.1 Import Error - Can't Modify

[bobcusick1332964082]

Guys,

I'm getting this error when trying import:

Code: Select all

[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...

[bobcusick1332964082]

Just to also clarify - I also created a brand new repository - and still, no good. It wouldn't import.

[bobcusick1332964082]

OK! There was a problem with the view.

The DBA modified the view to have BLANKS as columns... something like this:

Code: Select all

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!