Import error com.microsoft.sqlserver.jdbc.SQLServerException

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Import error com.microsoft.sqlserver.jdbc.SQLServerException

Postby IT2Be » Tue Aug 15, 2017 12:40 pm

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?
Marcel J.G. Trapman (IT2BE)
SAN partner - Freelance Java and Servoy
Servoy Components - IT2BE Plug-ins and Beans for Servoy
ServoyForge - Open Source Components for Servoy
User avatar
IT2Be
Servoy Expert
 
Posts: 4766
Joined: Tue Oct 14, 2003 7:09 pm
Location: Germany

Re: Import error com.microsoft.sqlserver.jdbc.SQLServerExcep

Postby IT2Be » Tue Aug 22, 2017 2:18 pm

Additional info: the trace on the database contains the following information:

Code: Select all
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?
Marcel J.G. Trapman (IT2BE)
SAN partner - Freelance Java and Servoy
Servoy Components - IT2BE Plug-ins and Beans for Servoy
ServoyForge - Open Source Components for Servoy
User avatar
IT2Be
Servoy Expert
 
Posts: 4766
Joined: Tue Oct 14, 2003 7:09 pm
Location: Germany

Re: Import error com.microsoft.sqlserver.jdbc.SQLServerExcep

Postby AlanBourke » Tue Aug 22, 2017 5:58 pm

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
-------------------------------------------------------------------------------------------
Servoy SAN Developer
User avatar
AlanBourke
 
Posts: 198
Joined: Tue Aug 02, 2011 3:32 pm
Location: Dublin, Ireland

Re: Import error com.microsoft.sqlserver.jdbc.SQLServerExcep

Postby IT2Be » Tue Aug 22, 2017 6:24 pm

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...
Marcel J.G. Trapman (IT2BE)
SAN partner - Freelance Java and Servoy
Servoy Components - IT2BE Plug-ins and Beans for Servoy
ServoyForge - Open Source Components for Servoy
User avatar
IT2Be
Servoy Expert
 
Posts: 4766
Joined: Tue Oct 14, 2003 7:09 pm
Location: Germany


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 5 guests

cron