• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Getting Error converting datatype nvarchar to int error

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Getting Error converting datatype nvarchar to int error

  1. Issue
0
Votes
Undo
  1. Kirankumar Chavadi
    Kirankumar Chavadi
  2. PowerServer
  3. Thursday, 17 October 2024 19:38 PM UTC

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

Upgrading to PS2022
Failed to parse the statement ‘My_Package_1.sp_my_...
Responses (2)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 18 October 2024 06:26 AM UTC
  2. PowerServer
  3. # 1

Hi.

Ok. You don't have any nvarchar as argument. But what about the values returned by the stored procedure? Is it possible you are using any nvarchar there?

Andreas.

Comment
Kirankumar Chavadi
  1. Kirankumar Chavadi
  2. 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

  1. Helpful
Kirankumar Chavadi
  1. Kirankumar Chavadi
  2. 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
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 17 October 2024 20:30 PM UTC
  2. PowerServer
  3. # 2

Hi Kirankumar;

  Unfortunately, you have not given us a lot of other key information to go on, such as ...

  • PB Version & Build
  • DBMS Version & build
  • O/S Version & build
  • SP Definition
  • How is the PB App using / calling the SP
  • Does this SP work OK in development or is the issue only in the production App EXE
  • Does the SP call work OK in Client/Server mode
  • Is the SP called via inline SQL, DW or via an  External API call
  • etc

Regards .. Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 18 October 2024 01:34 AM UTC
Hi Kirankumar;

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. Helpful
Kirankumar Chavadi
  1. Kirankumar Chavadi
  2. Friday, 18 October 2024 12:50 PM UTC
we are using the same SS for building and later connecting from APP, so there is no possibility of pointing to difference SS

  1. Helpful 1
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 18 October 2024 17:37 PM UTC
In that case, what could be crucial to know ...

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
  1. Helpful
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.