-
Giuseppe moglia
- SnapDevelop
- Monday, 2 March 2020 05:21 PM UTC
Hi Guys
I've a table "flusso_ccic" and a datastore in PB2019 R2 on it
No column identity, just the key from some columns
I converted to a Model on Snap Develop R2 and Retrieve works fine, but If I try to Run a Create from a rest Client the query from the profiler is strange, it contains a scope_identity where the column is not an identity...
By the way my ws goes in exception with this message:
"Fail to get identity value from database."
Here the table script:
CREATE TABLE [dbo].[flusso_ccic](
[ccic_t_codif] [varchar](2) NOT NULL,
[ccic_c_raggr] [varchar](30) NOT NULL,
[ccic_struttura] [numeric](8, 0) NOT NULL,
[ccic_flg_alt] [varchar](1) NOT NULL,
[ccic_n_ciclo] [numeric](8, 0) NOT NULL,
[ccic_c_ditta] [varchar](2) NOT NULL,
[ccic_dt_ins] [datetime] NULL,
[ccic_utente_ins] [varchar](5) NULL,
[ccic_dt_um] [datetime] NULL,
[ccic_utente_um] [varchar](5) NULL,
[ccic_n_db] [numeric](6, 0) NOT NULL,
[ccic_esp_rev_part] [varchar](2) NULL,
CONSTRAINT [ccic_chiave] PRIMARY KEY CLUSTERED
(
[ccic_t_codif] ASC,
[ccic_c_raggr] ASC,
[ccic_struttura] ASC,
[ccic_flg_alt] ASC,
[ccic_n_ciclo] ASC,
[ccic_c_ditta] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[flusso_ccic] ADD DEFAULT ((0)) FOR [ccic_struttura]
GO
ALTER TABLE [dbo].[flusso_ccic] ADD DEFAULT ((0)) FOR [ccic_n_ciclo]
GO
ALTER TABLE [dbo].[flusso_ccic] ADD DEFAULT ((0)) FOR [ccic_n_db]
GO
And here the query from SQL Profiler:
exec sp_executesql N'INSERT INTO [flusso_ccic] ([ccic_t_codif], [ccic_c_raggr], [ccic_flg_alt], [ccic_n_ciclo], [ccic_c_ditta], [ccic_dt_ins], [ccic_utente_ins], [ccic_dt_um], [ccic_utente_um], [ccic_esp_rev_part])
VALUES (@pp0, @pp1, @pp2, @pp3, @pp4, @pp5, @pp6, @pp7, @pp8, @pp9);
SELECT [ccic_struttura], [ccic_n_db]
FROM [flusso_ccic]
WHERE @@ROWCOUNT = 1 AND [ccic_t_codif] = @pp0 AND [ccic_c_raggr] = @pp1 AND [ccic_struttura] = scope_identity() AND [ccic_flg_alt] = @pp2 AND [ccic_n_ciclo] = @pp3 AND [ccic_c_ditta] = @pp4;
',N'@pp0 nvarchar(4000),@pp1 nvarchar(4000),@pp2 nvarchar(4000),@pp3 decimal(4,1),@pp4 nvarchar(4000),@pp5 datetime2(7),@pp6 nvarchar(4000),@pp7 datetime2(7),@pp8 nvarchar(4000),@pp9 nvarchar(4000)',@pp0=N'01',@pp1=N'C00001',@pp2=N'A',@pp3=130.0,@pp4=N'01',@pp5='2020-03-02 17:59:21.5921000',@pp6=N'1',@pp7='2020-03-02 17:59:27.5927000',@pp8=N'1',@pp9=N'aa'
In attachment the dw exported
Anyone can help me?
Thanks in advance
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.