Skip to Content
0
Former Member
Jan 30, 2015 at 04:23 PM

SMP 3.0 SP5 PL1 - Integration Gateway and SQL Server

14 Views

Hi,

I have a strange problem with integration gateway. I have 3 table on sql server, but for 2 I can see the entity on Odata Service created with Integration Gateway plugin for eclipse. For one table I receive a message "an exception occurred", with no more details.

Below I show the image of my environment and sql server table.

In particular, for table/entity BRAND I receive the error, while for tblPersone and Books all work.

The only difference is that for BRAND the key is a uniqueidentifier (and in the model I used the type Edm.Guid).

I'm using SMP 3.0 SP5 PL1 (pay no attention at model name). And on Eclipse Kepler I have updated all plugins.

I hope that some one have idea about the problem 😔😔

Let me know if need more details.

Thanks in advanced,

Elia.

SQL SERVER TABLES

ODATA MODEL

QUERY RESULT tblPersone (is OK)

QUERY RESULT for BRAND (is KO)