Using Servoy 8.1.3 (developer and server) I get the below error when importing a solution onto the application server.
I am not sure how this can happen, is it a setting I am missing?
This is just a normal export - import…
[error] com.microsoft.sqlserver.jdbc.SQLServerException: The object name ‘dbo.svy_dw_hana.dbo.SVY_DAMEXP_LOG’ contains more than the maximum number of prefixes. The maximum is 2.
Any suggestions?
Additional info: the trace on the database contains the following information:
message The object name 'dbo.svy_dw_hana.dbo.SVY_DAMEXP_LOG' contains more than the maximum number of prefixes. The maximum is 2.
message Incorrect syntax near 'planning_key'.
batch_text alter table dbo.svy_dw_hana.dbo.SVY_DAMEXP_LOG add planning_key nvarchar(10) null
But this sql statement comes from the import file so I assume there is something wrong with the db information file or could it be something else?
More specifically, what could be wrong here?
The first ‘dbo’ on the table name looks wrong to me. For SQL Server the format is:
server_name.database_name.schema_name.object_name
Could be, but my issue is that this is straight from a Servoy export/import.
So my problem is, where do I look because this seems to have worked before
Even stranger, I have the same issue with S7.4…