1. Giuseppe moglia
  2. SnapDevelop
  3. Monday, 2 March 2020 17:21 PM

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

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 2 March 2020 18:45 PM
  2. SnapDevelop
  3. # 1
0
Votes
Undo

Hi Giuseppe;

  Please open a support ticket for this R2 Beta issue.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.