• 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 (1)

Resolved Getting Error converting datatype nvarchar to int error

  1. New
  2. 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

Publicar una app Cloud
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 17 October 2024 20:30 PM UTC
  2. PowerServer
  3. # 1

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
Kirankumar Chavadi
  1. Kirankumar Chavadi
  2. Friday, 18 October 2024 00:58 AM UTC
Hello Chris



below are the details

we are using PB2022 R3 3356, DBMS - SQL Server 2019 and OS - Win 2010



we have a compoiste dw and this issue is thrown by on of the child dw which has below SP definition as code behind

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



This works in client/Server setup and not in aPOwerServer
  1. Helpful
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
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.