Getting Error converting datatype nvarchar to int error while retrieving a datawindow source from SP
this is a composite datawindow.
we don't have any nvarchar datatype as an argument to the SP
- You are here:
-
Home
-
Q&A
-
Q&A
-
PowerServer
- Getting Error converting datatype nvarchar to int error
-
Kirankumar Chavadi
- PowerServer
- Thursday, 17 October 2024 19:38 PM UTC
Comment
- Kirankumar Chavadi
- Friday, 18 October 2024 07:12 AM UTC
we have but those are not passed to the child dw Stored Proc.
PROCEDURE dbo.sp_name @ord_dtl_int_id int, @usr_int_id int, @lab_fg varchar(1), @area_ext_id varchar(20), @ety datetime, @mdu_int_id int, @du_int_id int, @u_int_id int, @ou_int_id int
we think @mdu_int_id int is causing the issue
PROCEDURE dbo.sp_name @ord_dtl_int_id int, @usr_int_id int, @lab_fg varchar(1), @area_ext_id varchar(20), @ety datetime, @mdu_int_id int, @du_int_id int, @u_int_id int, @ou_int_id int
we think @mdu_int_id int is causing the issue
- Kirankumar Chavadi
- Friday, 18 October 2024 07:12 AM UTC
but could not figure out why, this value is returned from parent DW SP and it is of int type
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.
However, you are not allowed to reply to this question.
That looks & sounds like the SP should work either way. Could it be that the SS that is used for the WebApi declarations differers from the App execution because PS connection is pointing to a different SS instance - thus slightly different schema?
Regards ... Chris
1) SS connection settings of SQLCA that the App & EXE are using (any PowerServer over-rides)?
2) The type of SS DB Client being used & it's settings in PowerServer