1. Shin Jungi
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 29 March 2024 07:30 AM UTC

[APPEON WEB] Inquiry about the cause of the warning message
1. When running locally, no error or warning message appears.
An error occurred in the attached image when distributing APPEON WEB.
It is a simple SQL statement, but in APPEON WEB, if the format of the number part does not match, this message appears once in a while, and even though the format is correct, the warning message continues to appear. Only this data window occurs.
After the warning window, you can view it normally.
[reference]
What part of the SQL statement should I change?
Even if I change almost every part, the same warning window appears.

 

SELECT
A.I_ORDER AS I_ORDER;
D.N_CUSTOM_PROJ AS N_CUSTOM_PROJ;
D.C_MAT AS C_ITEM;
A.C_MAT AS C_MAT;
B.N_MAT AS N_MAT,
B.N_SIZE AS N_SIZE;
B.C_GRADE AS C_GRADE,
C.C_LOCATION AS C_LOCATION,
C.C_STORE AS C_STORE,
CAST(A.Q_IN_QTY AS decimal) AS Q_IN_QTY;
CAST(ISNULL(AA.Q_OUT_QTY, 0) AS decimal) AS Q_OUT_QTY;
CASE
WHEN CAST(A.Q_IN_QTY AS decimal) - CAST(ISNULL(AA.Q_OUT_QTY, 0) AS decimal) > 0 THEN CAST(A.Q_IN_QTY AS decimal) - CAST(ISNULL(AA.Q_OUT_QTY, 0) AS decimal)
ELSE 0
END AS Q_INV;
A.I_FIELD
FROM
(SELECT
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT;
CAST(SUM(Q_QTY) AS decimal) AS Q_IN_QTY
FROM
TBL_I_INOUT (NOLOCK)
WHERE
F_INOUT = 'I'
GROUP BY
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT)A
LEFT JOIN
(SELECT
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT;
CAST(SUM(Q_QTY) AS decimal) AS Q_OUT_QTY
FROM
TBL_I_INOUT (NOLOCK)
WHERE
F_INOUT = 'O'
GROUP BY
I_FIELD,
I_ORDER;
C_MAT,
I_INOUT) AA
ON
A.I_FIELD = AA.I_FIELD
AND A.I_ORDER = AA.I_ORDER
AND A.C_MAT = AA.C_MAT
JOIN
TBL_B_MAT B (NOLOCK)
ON
A.C_MAT = B.C_MAT
JOIN
TBL_I_INOUT C (NOLOCK)
ON
A.I_FIELD = C.I_FIELD
AND A.I_ORDER = C.I_ORDER
AND A.C_MAT = C.C_MAT
AND A.I_INOUT = C.I_INOUT
JOIN
V_ORDER_ALL D (NOLOCK)
ON
C.I_FIELD = D.I_FIELD
AND C.I_ORDER = D.I_ORDER
AND C.S_ORDER = D.S_ORDER
WHERE
CAST((A.Q_IN_QTY - ISNULL(AA.Q_OUT_QTY, 0)) AS decimal) > 0
AND A.I_FIELD = :as_field
AND D.N_CUSTOM_PROJ LIKE :as_custom
AND A.I_ORDER LIKE :as_order
AND A.C_MAT LIKE :as_item
AND B.C_GROUP LIKE :as_group
AND A.C_MAT like :as_mat
AND B.N_MAT LIKE :as_nmat
AND ISNULL(B.N_SIZE,'') LIKE :as_size
AND ISNULL(B.N_SIZE,'') LIKE :as_size2
AND ISNULL(B.N_SIZE,'') LIKE :as_size3
AND C.C_LOCATION LIKE :as_location

attached image

Attachments (1)
Accepted Answer
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Monday, 1 April 2024 01:39 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Jungi,

This problem is probably not related to SQL, but related to the expressions used in the computed field or properties in the datawindow.
Please open a support ticket in the support portal and please provide a test case, Many thanks in advance.
https://www.appeon.com/standardsupport/

BTW, I have changed the category of this post to PowerServer 2020 or older.

Regards,
Kai

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 29 March 2024 15:32 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

What is your PowerServer version?

Comment
  1. Shin Jungi
  2. Friday, 29 March 2024 18:27 PM UTC
Hi Armeen Mazda



PowerServer 2017 build 1689.00 64 bit

Windows Server 2012 R2

Jboss



Thanks

Jungi
  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.