问:
bind variables not allowed for data definition operations
CREATE VIEW GMIS_FIN AS
SELECT NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
201, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR-CD"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
207, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Car MVH"
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
206, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"CAR AVH-H"
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
301, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"PRO-SV"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
204, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"Car-Others"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
501, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
701, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
702, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
601, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
602, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
303, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0)),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
203, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR speaker"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
202, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"Car AVH-L"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
402, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"TAD SPKRS"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
404, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"TAD Elect"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
105, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"B-Ray"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
305, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:CSV
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
106, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Compo-Spk"
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
403, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"MP-Pro"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
205, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR DVH"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
208, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:NAVI
/ 100),
0),
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
208, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:NAVI
/ 100,
DECODE (
ABAL_DIVN_CODE,
205, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR DVH"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
ABAL_DIVN_CODE,
403, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"MP-Pro"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
106, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Compo-Spk"
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
305, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:CSV
/ 100,
DECODE (
ABAL_DIVN_CODE,
105, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"B-Ray"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
ABAL_DIVN_CODE,
404, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"TAD Elect"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
\,
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
301, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"PRO-SV"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
206, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"CAR AVH-H"
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
207, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Car MVH"
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
201, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR-CD"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE ( ABAL_MAIN_ACNT_CODE,
40100, 1,
40125, 1,
40126, 1.75,
40700, 2,
40725, 2,
40750, 2,
40760, 2,
40775, 2,
40800, 3,
40900, 3,
40150, 3,
40175, 3,
40200, 3,
41300, 3,
41350, 3,
42000, 4,
42100, 4,
42200, 4,
42125, 1.75,
42350, 6,
41800, 5,
42800, 6,
43860, 5,
40250, 7,
45100, 7,
45300, 7,
46500, 7,
47000, 7,
47600, 7,
47500, 7,
40850, 3,
48600, 7,
45101, 7,
48200, 7,
48175, 7,
6),
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
209, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:SSD
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0),
DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE),
MAIN_ACNT_SHORT_NAME,
ABAL_CAL_YEAR,
ABAL_CAL_MONTH,
ABAL_MAIN_ACNT_CODE
FROM FM_MAIN_ACCOUNT  , FS_CUR_ACNT_BAL O179130
WHERE (( MAIN_ACNT_CODE =  ABAL_MAIN_ACNT_CODE))
ORDER BY DECODE ( ABAL_MAIN_ACNT_CODE,
40100, 1,
40125, 1,
40126, 1.75,
40700, 2,
40725, 2,
40750, 2,
40760, 2,
40775, 2,
40800, 3,
40900, 3,
40150, 3,
40175, 3,
40200, 3,
41300, 3,
41350, 3,
42000, 4,
42100, 4,
42200, 4,
42125, 1.75,
42350, 6,
41800, 5,
42800, 6,
43860, 5,
40250, 7,
45100, 7,
45300, 7,
46500, 7,
47000, 7,
47600, 7,
47500, 7,
40850, 3,
48600, 7,
45101, 7,
48200, 7,
48175, 7,

ASC,
ABAL_MAIN_ACNT_CODE ASC;

```<code>

The code is very lengthy so decided to call the code using view but got an error. so looking for some alternative solution
</code>```

Body:
CREATE VIEW GMIS_FIN AS
SELECT NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
201, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR-CD"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
207, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Car MVH"
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
206, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"CAR AVH-H"
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
301, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"PRO-SV"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
204, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"Car-Others"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
501, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
701, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
702, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
601, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
602, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
303, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0)),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
203, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR speaker"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
202, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"Car AVH-L"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
402, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"TAD SPKRS"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
404, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"TAD Elect"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
105, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"B-Ray"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
305, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:CSV
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
106, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Compo-Spk"
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
403, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"MP-Pro"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
ABAL_DIVN_CODE,
205, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR DVH"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100),

NVL (
( DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
208, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:NAVI
/ 100),
0),
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
208, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:NAVI
/ 100,
DECODE (
ABAL_DIVN_CODE,
205, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR DVH"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
ABAL_DIVN_CODE,
403, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"MP-Pro"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
106, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Compo-Spk"
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
305, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:CSV
/ 100,
DECODE (
ABAL_DIVN_CODE,
105, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"B-Ray"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
ABAL_DIVN_CODE,
404, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"TAD Elect"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
\,
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
301, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"PRO-SV"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
206, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"CAR AVH-H"
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
207, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:"Car MVH"
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
201, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

:"CAR-CD"

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))
/ 100,
DECODE ( ABAL_MAIN_ACNT_CODE,
40100, 1,
40125, 1,
40126, 1.75,
40700, 2,
40725, 2,
40750, 2,
40760, 2,
40775, 2,
40800, 3,
40900, 3,
40150, 3,
40175, 3,
40200, 3,
41300, 3,
41350, 3,
42000, 4,
42100, 4,
42200, 4,
42125, 1.75,
42350, 6,
41800, 5,
42800, 6,
43860, 5,
40250, 7,
45100, 7,
45300, 7,
46500, 7,
47000, 7,
47600, 7,
47500, 7,
40850, 3,
48600, 7,
45101, 7,
48200, 7,
48175, 7,
6),
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
209, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),

(DECODE (
(DECODE ( ABAL_DIVN_CODE,
'', 0,
ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0))

:SSD
/ 100,
DECODE (
(DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE)),
0, NVL ( ABAL_LC_MTD_DR * 1, 0)

NVL ( ABAL_LC_MTD_CR * 1, 0),
0),
DECODE ( ABAL_DIVN_CODE, '', 0,  ABAL_DIVN_CODE),
MAIN_ACNT_SHORT_NAME,
ABAL_CAL_YEAR,
ABAL_CAL_MONTH,
ABAL_MAIN_ACNT_CODE
FROM FM_MAIN_ACCOUNT  , FS_CUR_ACNT_BAL O179130
WHERE (( MAIN_ACNT_CODE =  ABAL_MAIN_ACNT_CODE))
ORDER BY DECODE ( ABAL_MAIN_ACNT_CODE,
40100, 1,
40125, 1,
40126, 1.75,
40700, 2,
40725, 2,
40750, 2,
40760, 2,
40775, 2,
40800, 3,
40900, 3,
40150, 3,
40175, 3,
40200, 3,
41300, 3,
41350, 3,
42000, 4,
42100, 4,
42200, 4,
42125, 1.75,
42350, 6,
41800, 5,
42800, 6,
43860, 5,
40250, 7,
45100, 7,
45300, 7,
46500, 7,
47000, 7,
47600, 7,
47500, 7,
40850, 3,
48600, 7,
45101, 7,
48200, 7,
48175, 7,

ASC,
ABAL_MAIN_ACNT_CODE ASC;

The code is very lengthy so decided to call the code using view but got an error. so looking for some alternative solution


来源: stackexchange

问:
Rundeck liquibase.exception.DatabaseException
Rundeck was running fine (service active). Version 3.4.10 (no man neither -version command, can't be sure...)

Now it doesn't work (service crashes). The error is
Network Error (tcp_error) "Connection refused"

What I have tried : removed all database files /var/lib/data/rundeck/rundeckdb.mv.db and /var/lib/data/rundeck/rundeckdb.trace.db => it works, however I need my data...

I have tried to copy the DB from an other working rundeck server but I have the same error (however, with an active service this time).
in Service logs : liquibase.exception.DatabaseException: Error executing SQL UPDATE PUBLIC.DATABASECHANGELOGLOCK SET LOCKED=TRUE ...

How to open my H2 database with linux command line without java JBoss or related technology ?

ContentLicense: CC BY-SA 4.0


问:
Return documents based on field bitwise AND operator
I have a model which has a field 'permissions', and I would like to retrieve all the documents from my table whose field 'permissions' meets a certain condition based on a bitwise AND operator. For example, what I am doing currently is the following in my typescript codebase:

```<code>let users: User[] = await this.userModel.find();

users = users.filter( // I would like to get rid of this filter (do the filtering directly through mongo)
    (user) => user.permissions & 2 > 0 // bitwise AND operator
);
</code>```

However, I would like to do the operation directly through mongo, so I don't need to get all the users inside my table and then filter them out from my typescript code.

Body:
I have a model which has a field 'permissions', and I would like to retrieve all the documents from my table whose field 'permissions' meets a certain condition based on a bitwise AND operator. For example, what I am doing currently is the following in my typescript codebase:

let users: User[] = await this.userModel.find();

users = users.filter( // I would like to get rid of this filter (do the filtering directly through mongo)
    (user) => user.permissions & 2 > 0 // bitwise AND operator
);

However, I would like to do the operation directly through mongo, so I don't need to get all the users inside my table and then filter them out from my typescript code.


问:
Failed to get D-Bus connection: Operation not permitted
I have installed hadoop and spark in docker but i can start the services , i can start the services by running dockerfile in privileged mode but due to some reason i  can not use privileged  mode

I have tried multiple options like docker-systemctl-replacement script from here   also tried from  here but none of method is working

note : I am using amazon linux base image


问:
Execution failed for task ':app:compileDebugKotlin'
I was spending time in doing this debugging. It mentioned that some of the file in kotlin is having problem. However, I have tries out a lot of ways to solve it like upgrading the kotlin version and include permission_handler: any. However I still unable to solve the problem and to find available solution in the Internet.

Error

Launching lib\main.dart on AOSP on IA Emulator in debug mode...
Running Gradle task 'assembleDebug'... Warning: Mapping new ns
http://schemas.android.com/repository/android/common/02 to old ns
http://schemas.android.com/repository/android/common/01 Warning:
Mapping new ns
http://schemas.android.com/repository/android/generic/02 to old ns
http://schemas.android.com/repository/android/generic/01 Warning:
Mapping new ns http://schemas.android.com/sdk/android/repo/addon2/02
to old ns http://schemas.android.com/sdk/android/repo/addon2/01
Warning: Mapping new ns
http://schemas.android.com/sdk/android/repo/addon2/03 to old ns
http://schemas.android.com/sdk/android/repo/addon2/01 Warning: Mapping
new ns http://schemas.android.com/sdk/android/repo/repository2/02 to
old ns http://schemas.android.com/sdk/android/repo/repository2/01
Warning: Mapping new ns
http://schemas.android.com/sdk/android/repo/repository2/03 to old ns
http://schemas.android.com/sdk/android/repo/repository2/01 Warning:
Mapping new ns http://schemas.android.com/sdk/android/repo/sys-img2/03
to old ns http://schemas.android.com/sdk/android/repo/sys-img2/01
Warning: Mapping new ns
http://schemas.android.com/sdk/android/repo/sys-img2/02 to old ns
http://schemas.android.com/sdk/android/repo/sys-img2/01 Warning:
unexpected element (uri:"", local:"extension-level"). Expected
elements are <{}codename>,<{}layoutlib>,<{}api-level> Warning: Errors
limit exceeded. To receive all errors set com.sun.xml.bind logger to
FINEST level. Warning: unexpected element (uri:"",
local:"base-extension"). Expected elements are
<{}codename>,<{}layoutlib>,<{}api-level> e:
C:\Users\wesle\AndroidStudioProjects\Aipetnion\android\app\src\main\kotlin\com\example\aipetnion\Application.kt:
(9, 1): Class 'Application' is not abstract and does not implement
abstract member public abstract fun registerWith(p0: PluginRegistry):
Unit defined in
io.flutter.plugin.common.PluginRegistry.PluginRegistrantCallback e:
C:\Users\wesle\AndroidStudioProjects\Aipetnion\android\app\src\main\kotlin\com\example\aipetnion\Application.kt:
(13, 51): Unresolved reference: setPluginRegistrant e:
C:\Users\wesle\AndroidStudioProjects\Aipetnion\android\app\src\main\kotlin\com\example\aipetnion\Application.kt:
(17, 5): 'registerWith' overrides nothing

FAILURE: Build failed with an exception.

What went wrong: Execution failed for task ':app:compileDebugKotlin'.

Compilation error. See log for more details

Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

Get more help at https://help.gradle.org

BUILD FAILED in 25s Exception: Gradle task assembleDebug failed with
exit code 1

pubspec.yaml

```<code>name: aipetnion
description: A new Flutter project.
version: 1.0.0+1

environment:
  sdk: ">=2.12.0 <3.0.0"

dependencies:

  audioplayers: ^0.20.1
  cloud_firestore: ^2.4.0
  cupertino_icons: ^1.0.2
  draw_graph: ^1.0.0
  file_picker: ^4.0.0
  firebase_core_platform_interface: 4.5.1
  firebase_analytics: ^5.0.2
  firebase_auth: ^3.0.1
  firebase_core: ^1.6.0
  firebase_storage: ^10.0.1
  firebase_messaging: ^10.0.8
  fl_chart: ^0.36.3
  flutter:
    sdk: flutter
  font_awesome_flutter: ">= 4.7.0"
  get_it: ^7.2.0
  google_fonts: ^2.1.0
  material_design_icons_flutter: ^5.0.5955-rc.1
  percent_indicator: ^3.0.1
  shared_preferences: ^2.0.6
  syncfusion_flutter_charts: ^20.1.50
  syncfusion_flutter_datepicker: ^20.1.50
  flutter_local_notifications: ^8.1.1+2
  timezone: ^0.8.0
  workmanager: ^0.4.1
  youtube_plyr_iframe: ^2.0.7
  cached_network_image: ^3.1.0
  string_validator: ^0.3.0
  http: ^0.13.3
  syncfusion_flutter_datagrid: ^20.1.50
  syncfusion_flutter_gauges: ^20.1.50
  syncfusion_flutter_core: ^20.1.50
  json_conditional: ^2.0.0+1
  intl: ^0.17.0
  translator: ^0.1.7
  auto_size_text: ^3.0.0
  platform: ^3.1.0
  permission_handler: any

dev_dependencies:
  flutter_test:
    sdk: flutter

flutter:

  uses-material-design: true

  assets:
    - assets/images/authentication/
    - assets/images/dashboard/
    - packages/timezone/data/2021a.tzf
</code>```

app\build

```<code>    def localProperties = new Properties()
def localPropertiesFile = rootProject.file('local.properties')
if (localPropertiesFile.exists()) {
    localPropertiesFile.withReader('UTF-8') { reader ->
        localProperties.load(reader)
    }
}

def flutterRoot = localProperties.getProperty('flutter.sdk')
if (flutterRoot == null) {
    throw new GradleException("Flutter SDK not found. Define location with flutter.sdk in the local.properties file.")
}

def flutterVersionCode = localProperties.getProperty('flutter.versionCode')
if (flutterVersionCode == null) {
    flutterVersionCode = '1'
}

def flutterVersionName = localProperties.getProperty('flutter.versionName')
if (flutterVersionName == null) {
    flutterVersionName = '1.0'
}

apply plugin: 'com.android.application'
apply plugin: 'com.google.gms.google-services'
apply plugin: 'kotlin-android'
apply from: "$flutterRoot/packages/flutter_tools/gradle/flutter.gradle"

android {
    compileSdkVersion 33

    sourceSets {
        main.java.srcDirs += 'src/main/kotlin'
    }

    defaultConfig {
        configurations.all {
            resolutionStrategy { force 'androidx.core:core-ktx:1.6.0' }
        }
        // TODO: Specify your own unique Application ID (https://developer.android.com/studio/build/application-id.html).
        applicationId "com.example.aipetnion"
        minSdkVersion 23 //the plugin don't support version lower lower than 23
        targetSdkVersion 30
        versionCode flutterVersionCode.toInteger()
        versionName flutterVersionName
        multiDexEnabled true
    }

    buildTypes {
        release {
            signingConfig signingConfigs.debug
            minifyEnabled true
            useProguard true
            proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'), 'proguard-rules.pro'
        }
    }
}

flutter {
    source '../..'
}

dependencies {
    implementation "org.jetbrains.kotlin:kotlin-stdlib-jdk7:$kotlin_version"
    implementation platform('com.google.firebase:firebase-bom:28.4.1')
    implementation 'com.google.firebase:firebase-analytics'
    implementation 'com.google.firebase:firebase-firestore'
    implementation 'com.google.firebase:firebase-messaging'
    implementation 'com.google.firebase:firebase-auth'
    implementation 'com.android.support:multidex:1.0.3'
</code>```

android\build.gradle

```<code>    buildscript {
    ext.kotlin_version = '1.6.10'
    repositories {
        google()
        jcenter()
    }

    dependencies {
        classpath 'com.android.tools.build:gradle:4.1.0'
        classpath 'com.google.gms:google-services:4.3.8'
        classpath "org.jetbrains.kotlin:kotlin-gradle-plugin:$kotlin_version"

    }
}

allprojects {
    repositories {
        google()
        jcenter()
    }
}

rootProject.buildDir = '../build'
subprojects {
    project.buildDir = "${rootProject.buildDir}/${project.name}"
    project.evaluationDependsOn(':app')
}

task clean(type: Delete) {
    delete rootProject.buildDir
}
</code>```

Body:
I was spending time in doing this debugging. It mentioned that some of the file in kotlin is having problem. However, I have tries out a lot of ways to solve it like upgrading the kotlin version and include permission_handler: any. However I still unable to solve the problem and to find available solution in the Internet.

Error

Launching lib\main.dart on AOSP on IA Emulator in debug mode...
Running Gradle task 'assembleDebug'... Warning: Mapping new ns
http://schemas.android.com/repository/android/common/02 to old ns
http://schemas.android.com/repository/android/common/01 Warning:
Mapping new ns
http://schemas.android.com/repository/android/generic/02 to old ns
http://schemas.android.com/repository/android/generic/01 Warning:
Mapping new ns http://schemas.android.com/sdk/android/repo/addon2/02
to old ns http://schemas.android.com/sdk/android/repo/addon2/01
Warning: Mapping new ns
http://schemas.android.com/sdk/android/repo/addon2/03 to old ns
http://schemas.android.com/sdk/android/repo/addon2/01 Warning: Mapping
new ns http://schemas.android.com/sdk/android/repo/repository2/02 to
old ns http://schemas.android.com/sdk/android/repo/repository2/01
Warning: Mapping new ns
http://schemas.android.com/sdk/android/repo/repository2/03 to old ns
http://schemas.android.com/sdk/android/repo/repository2/01 Warning:
Mapping new ns http://schemas.android.com/sdk/android/repo/sys-img2/03
to old ns http://schemas.android.com/sdk/android/repo/sys-img2/01
Warning: Mapping new ns
http://schemas.android.com/sdk/android/repo/sys-img2/02 to old ns
http://schemas.android.com/sdk/android/repo/sys-img2/01 Warning:
unexpected element (uri:"", local:"extension-level"). Expected
elements are <{}codename>,<{}layoutlib>,<{}api-level> Warning: Errors
limit exceeded. To receive all errors set com.sun.xml.bind logger to
FINEST level. Warning: unexpected element (uri:"",
local:"base-extension"). Expected elements are
<{}codename>,<{}layoutlib>,<{}api-level> e:
C:\Users\wesle\AndroidStudioProjects\Aipetnion\android\app\src\main\kotlin\com\example\aipetnion\Application.kt:
(9, 1): Class 'Application' is not abstract and does not implement
abstract member public abstract fun registerWith(p0: PluginRegistry):
Unit defined in
io.flutter.plugin.common.PluginRegistry.PluginRegistrantCallback e:
C:\Users\wesle\AndroidStudioProjects\Aipetnion\android\app\src\main\kotlin\com\example\aipetnion\Application.kt:
(13, 51): Unresolved reference: setPluginRegistrant e:
C:\Users\wesle\AndroidStudioProjects\Aipetnion\android\app\src\main\kotlin\com\example\aipetnion\Application.kt:
(17, 5): 'registerWith' overrides nothing

FAILURE: Build failed with an exception.

What went wrong: Execution failed for task ':app:compileDebugKotlin'.

Compilation error. See log for more details

Try: Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

Get more help at https://help.gradle.org

BUILD FAILED in 25s Exception: Gradle task assembleDebug failed with
exit code 1

pubspec.yaml

name: aipetnion
description: A new Flutter project.
version: 1.0.0+1

environment:
  sdk: ">=2.12.0 <3.0.0"

dependencies:

  audioplayers: ^0.20.1
  cloud_firestore: ^2.4.0
  cupertino_icons: ^1.0.2
  draw_graph: ^1.0.0
  file_picker: ^4.0.0
  firebase_core_platform_interface: 4.5.1
  firebase_analytics: ^5.0.2
  firebase_auth: ^3.0.1
  firebase_core: ^1.6.0
  firebase_storage: ^10.0.1
  firebase_messaging: ^10.0.8
  fl_chart: ^0.36.3
  flutter:
    sdk: flutter
  font_awesome_flutter: ">= 4.7.0"
  get_it: ^7.2.0
  google_fonts: ^2.1.0
  material_design_icons_flutter: ^5.0.5955-rc.1
  percent_indicator: ^3.0.1
  shared_preferences: ^2.0.6
  syncfusion_flutter_charts: ^20.1.50
  syncfusion_flutter_datepicker: ^20.1.50
  flutter_local_notifications: ^8.1.1+2
  timezone: ^0.8.0
  workmanager: ^0.4.1
  youtube_plyr_iframe: ^2.0.7
  cached_network_image: ^3.1.0
  string_validator: ^0.3.0
  http: ^0.13.3
  syncfusion_flutter_datagrid: ^20.1.50
  syncfusion_flutter_gauges: ^20.1.50
  syncfusion_flutter_core: ^20.1.50
  json_conditional: ^2.0.0+1
  intl: ^0.17.0
  translator: ^0.1.7
  auto_size_text: ^3.0.0
  platform: ^3.1.0
  permission_handler: any

dev_dependencies:
  flutter_test:
    sdk: flutter

flutter:

  uses-material-design: true

  assets:
    - assets/images/authentication/
    - assets/images/dashboard/
    - packages/timezone/data/2021a.tzf

app\build

    def localProperties = new Properties()
def localPropertiesFile = rootProject.file('local.properties')
if (localPropertiesFile.exists()) {
    localPropertiesFile.withReader('UTF-8') { reader ->
        localProperties.load(reader)
    }
}

def flutterRoot = localProperties.getProperty('flutter.sdk')
if (flutterRoot == null) {
    throw new GradleException("Flutter SDK not found. Define location with flutter.sdk in the local.properties file.")
}

def flutterVersionCode = localProperties.getProperty('flutter.versionCode')
if (flutterVersionCode == null) {
    flutterVersionCode = '1'
}

def flutterVersionName = localProperties.getProperty('flutter.versionName')
if (flutterVersionName == null) {
    flutterVersionName = '1.0'
}

apply plugin: 'com.android.application'
apply plugin: 'com.google.gms.google-services'
apply plugin: 'kotlin-android'
apply from: "$flutterRoot/packages/flutter_tools/gradle/flutter.gradle"

android {
    compileSdkVersion 33

    sourceSets {
        main.java.srcDirs += 'src/main/kotlin'
    }

    defaultConfig {
        configurations.all {
            resolutionStrategy { force 'androidx.core:core-ktx:1.6.0' }
        }
        // TODO: Specify your own unique Application ID (https://developer.android.com/studio/build/application-id.html).
        applicationId "com.example.aipetnion"
        minSdkVersion 23 //the plugin don't support version lower lower than 23
        targetSdkVersion 30
        versionCode flutterVersionCode.toInteger()
        versionName flutterVersionName
        multiDexEnabled true
    }

    buildTypes {
        release {
            signingConfig signingConfigs.debug
            minifyEnabled true
            useProguard true
            proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'), 'proguard-rules.pro'
        }
    }
}

flutter {
    source '../..'
}

dependencies {
    implementation "org.jetbrains.kotlin:kotlin-stdlib-jdk7:$kotlin_version"
    implementation platform('com.google.firebase:firebase-bom:28.4.1')
    implementation 'com.google.firebase:firebase-analytics'
    implementation 'com.google.firebase:firebase-firestore'
    implementation 'com.google.firebase:firebase-messaging'
    implementation 'com.google.firebase:firebase-auth'
    implementation 'com.android.support:multidex:1.0.3'

android\build.gradle

    buildscript {
    ext.kotlin_version = '1.6.10'
    repositories {
        google()
        jcenter()
    }

    dependencies {
        classpath 'com.android.tools.build:gradle:4.1.0'
        classpath 'com.google.gms:google-services:4.3.8'
        classpath "org.jetbrains.kotlin:kotlin-gradle-plugin:$kotlin_version"

    }
}

allprojects {
    repositories {
        google()
        jcenter()
    }
}

rootProject.buildDir = '../build'
subprojects {
    project.buildDir = "${rootProject.buildDir}/${project.name}"
    project.evaluationDependsOn(':app')
}

task clean(type: Delete) {
    delete rootProject.buildDir
}


问:
Scala spark-sql: Sbt build fails
I am trying to get my build.sbt working, but when I press reload all sbt projects in Intellij it fails:

Extracting structure failed: Build status: Error sbt task failed, see log for details

My build.sbt:

```<code>scalaVersion := "2.12.17"

name := "hello-world"

libraryDependencies ++= Seq(
    "org.scala-lang.modules" %% "scala-parser-combinators" % "2.1.1",
    "com.microsoft.azure" % "spark-mssql-connector_2.12" % "1.2.0",
    "org.apache.spark" % "spark-core_2.12" % "3.1.3",
    "org.apache.spark" % "spark-sql_2.12" % "3.1.3"
)
</code>```

I am trying with this configuration since I want to try the Apache Spark Connector for SQL Server and Azure SQL. (https://github.com/microsoft/sql-spark-connector)

Anyone know why it fails? I don't get any details.

When I comment "org.apache.spark" % "spark-sql_2.12" % "3.1.3" the build is successful.

Title: Scala spark-sql: Sbt build fails

Body:
I am trying to get my build.sbt working, but when I press reload all sbt projects in Intellij it fails:

Extracting structure failed: Build status: Error sbt task failed, see log for details

My build.sbt:

scalaVersion := "2.12.17"

name := "hello-world"

libraryDependencies ++= Seq(
    "org.scala-lang.modules" %% "scala-parser-combinators" % "2.1.1",
    "com.microsoft.azure" % "spark-mssql-connector_2.12" % "1.2.0",
    "org.apache.spark" % "spark-core_2.12" % "3.1.3",
    "org.apache.spark" % "spark-sql_2.12" % "3.1.3"
)

I am trying with this configuration since I want to try the Apache Spark Connector for SQL Server and Azure SQL. (https://github.com/microsoft/sql-spark-connector)

Anyone know why it fails? I don't get any details.

When I comment "org.apache.spark" % "spark-sql_2.12" % "3.1.3" the build is successful.


问:
React MAterial UI - How to add MoreVertIcon in DataGrid?
I am implementing a functionality as shown similarly in the link

https://mui.com/x/react-data-grid/#mit-version

My confusion now is how to add MoreVertIcon at the end column of each row as shown in the code https://mui.com/material-ui/react-menu/#max-height-menu

Each row in the grid should have last column with the MoreVertIcon. Since the data is loaded from the array or JSON data, where will be best place to add this?

I tried like this but I get error in the <DataGrid> tag.

```<code>  <DataGrid
        rows={customers}
        columns={columns}
        pageSize={16}
        rowsPerPageOptions={[5]}
        getRowId={(row: any) => row.name}
        autoPageSize={true}
        rowHeight={45}
        onRowClick={handleCustomerClick}
        hideFooterSelectedRowCount={true}>

<div>
      <IconButton
        aria-label="more"
        id="long-button"
        aria-controls={open ? 'long-menu' : undefined}
        aria-expanded={open ? 'true' : undefined}
        aria-haspopup="true"
        onClick={handleClick}
      >
        <MoreVertIcon />
      </IconButton>
      <Menu
        id="long-menu"
        MenuListProps={{
          'aria-labelledby': 'long-button',
        }}
        anchorEl={anchorEl}
        open={open}
        onClose={handleClose}
        PaperProps={{
          style: {
            maxHeight: ITEM_HEIGHT * 4.5,
            width: '20ch',
          },
        }}
      >
        {options.map((option) => (
          <MenuItem key={option} selected={option === 'Pyxis'} onClick={handleClose}>
            {option}
          </MenuItem>
        ))}
      </Menu>
    </div>

        </DataGrid>

</code>```

Body:
I am implementing a functionality as shown similarly in the link

https://mui.com/x/react-data-grid/#mit-version

My confusion now is how to add MoreVertIcon at the end column of each row as shown in the code https://mui.com/material-ui/react-menu/#max-height-menu

Each row in the grid should have last column with the MoreVertIcon. Since the data is loaded from the array or JSON data, where will be best place to add this?

I tried like this but I get error in the <DataGrid> tag.

  <DataGrid
        rows={customers}
        columns={columns}
        pageSize={16}
        rowsPerPageOptions={[5]}
        getRowId={(row: any) => row.name}
        autoPageSize={true}
        rowHeight={45}
        onRowClick={handleCustomerClick}
        hideFooterSelectedRowCount={true}>

      <IconButton
        aria-label="more"
        id="long-button"
        aria-controls={open ? 'long-menu' : undefined}
        aria-expanded={open ? 'true' : undefined}
        aria-haspopup="true"
        onClick={handleClick}
      >
        <MoreVertIcon />
      </IconButton>
      <Menu
        id="long-menu"
        MenuListProps={{
          'aria-labelledby': 'long-button',
        }}
        anchorEl={anchorEl}
        open={open}
        onClose={handleClose}
        PaperProps={{
          style: {
            maxHeight: ITEM_HEIGHT * 4.5,
            width: '20ch',
          },
        }}
      >
        {options.map((option) => (
          <MenuItem key={option} selected={option === 'Pyxis'} onClick={handleClose}>
            {option}
          </MenuItem>
        ))}
      </Menu>

        </DataGrid>


问:
How to use a struct method as an handler in Axum?
This works where the handler is a stand alone function

```<code>use axum::{
    routing::{get, post},
    http::StatusCode,
    response::IntoResponse,
    Json, Router,
};
use std::net::SocketAddr;

#[tokio::main]
async fn main() -> () {

    // build our application with a route
    let app = Router::new()
        // `GET /` goes to `root`
        .route("/", axum::routing::get(root));

    let addr = SocketAddr::from(([127, 0, 0, 1], 3000));
    axum::Server::bind(&addr)
        .serve(app.into_make_service())
        .await
        .unwrap();

}

// basic handler that responds with a static string
async fn root() -> impl IntoResponse {
    let person = Person {
        age: 20,
        name: "John".to_string()
    };
    (StatusCode::OK, Json(person))
}
</code>```

but in my project, I need to have the logic of the handler as part of a struct impl. I tried doing that but it fails. Code and error is below

```<code>use axum::{
    routing::{get, post},
    http::StatusCode,
    response::IntoResponse,
    Json, Router,
};
use std::net::SocketAddr;

mod http {
    pub struct ServerLogic {
    }

    impl ServerLogic {
        pub fn new() -> Self {
            Self {}
        }
        pub fn hello(&self) -> impl axum::response::IntoResponse {
            (axum::http::StatusCode::OK, axum::Json("Hello, world!"))
        }
    }
}

#[tokio::main]
async fn main() -> () {

    // build our application with a route
    let app = Router::new()
        // `GET /` goes to `root`
        .route("/", axum::routing::get(crate::http::ServerLogic::new().hello));

    let addr = SocketAddr::from(([127, 0, 0, 1], 3000));
    axum::Server::bind(&addr)
        .serve(app.into_make_service())
        .await
        .unwrap();

}
</code>```

Error

```<code>error[E0615]: attempted to take value of method `hello` on type `ServerLogic`
   --> src/main.rs:104:72
    |
104 |         .route("/", axum::routing::get(crate::http::ServerLogic::new().hello));
    |                                                                        ^^^^^ method, not a field
    |
help: use parentheses to call the method
    |
104 |         .route("/", axum::routing::get(crate::http::ServerLogic::new().hello()));
    |                                                                             ++

</code>```

How do I get to use the method of a struct as an handler?

Body:
This works where the handler is a stand alone function

use axum::{
    routing::{get, post},
    http::StatusCode,
    response::IntoResponse,
    Json, Router,
};
use std::net::SocketAddr;

#[tokio::main]
async fn main() -> () {

    // build our application with a route
    let app = Router::new()
        // `GET /` goes to `root`
        .route("/", axum::routing::get(root));

    let addr = SocketAddr::from(([127, 0, 0, 1], 3000));
    axum::Server::bind(&addr)
        .serve(app.into_make_service())
        .await
        .unwrap();

}

// basic handler that responds with a static string
async fn root() -> impl IntoResponse {
    let person = Person {
        age: 20,
        name: "John".to_string()
    };
    (StatusCode::OK, Json(person))
}

but in my project, I need to have the logic of the handler as part of a struct impl. I tried doing that but it fails. Code and error is below

use axum::{
    routing::{get, post},
    http::StatusCode,
    response::IntoResponse,
    Json, Router,
};
use std::net::SocketAddr;

mod http {
    pub struct ServerLogic {
    }

    impl ServerLogic {
        pub fn new() -> Self {
            Self {}
        }
        pub fn hello(&self) -> impl axum::response::IntoResponse {
            (axum::http::StatusCode::OK, axum::Json("Hello, world!"))
        }
    }
}

#[tokio::main]
async fn main() -> () {

    // build our application with a route
    let app = Router::new()
        // `GET /` goes to `root`
        .route("/", axum::routing::get(crate::http::ServerLogic::new().hello));

    let addr = SocketAddr::from(([127, 0, 0, 1], 3000));
    axum::Server::bind(&addr)
        .serve(app.into_make_service())
        .await
        .unwrap();

}

Error

error[E0615]: attempted to take value of method `hello` on type `ServerLogic`
   --> src/main.rs:104:72
    |
104 |         .route("/", axum::routing::get(crate::http::ServerLogic::new().hello));
    |                                                                        ^^^^^ method, not a field
    |
help: use parentheses to call the method
    |
104 |         .route("/", axum::routing::get(crate::http::ServerLogic::new().hello()));
    |                                                                             ++

How do I get to use the method of a struct as an handler?


问:
display value of input field to another input field after submitting form in html
I've created a form in which I put values in input field and submit the form. But now I have to display those values into another input field after submitting the form. The other input field id is min2 which is outside the form.</p>
```<code>
/* begin snippet: js hide: false console: true babel: false

 language: lang-js */

    <script>
       const num3rs = val => val.toLocaleString('en-IN', {
        maximumFractionDigits: 0
    });
       document.getElementById("userInput3").addEventListener("input", function () {
                this.value = num3rs(+this.value.replace(/\D/g, ""))
                document.getElementById("min1").value = this.value

            })
       $("searchform").submit(function(){
      document.getElementById('userInput3').value = this.value;
      document.getElementById('min2').value = this.value;
    });
    </script>

<!-- language: lang-html -->

    <form class="searchform">

       <input  name="Input.minp" id="Input.price.min" asp-for="Input.minp" />
       <input  id="userInput3" placeholder="min" style="height :30px;width:90px; border-style:solid ;border-color: black;border-radius:5px; margin-left:20px;margin-top:5px;">
        <button type="submit" class="searchButton" id="searchButton" >
        submit
       </button>
    </form>
    <input id="min2" style="height :30px;width:70px; border:none;outline:none; margin-left:30px;" readonly>

<!-- end snippet -->

</code>```

Body:
I've created a form in which I put values in input field and submit the form. But now I have to display those values into another input field after submitting the form. The other input field id is min2 which is outside the form.

/* begin snippet: js hide: false console: true babel: false

 language: lang-js */

    <form class="searchform">

       <input  name="Input.minp" id="Input.price.min" asp-for="Input.minp" />
       <input  id="userInput3" placeholder="min" style="height :30px;width:90px; border-style:solid ;border-color: black;border-radius:5px; margin-left:20px;margin-top:5px;">
        <button type="submit" class="searchButton" id="searchButton" >
        submit
       </button>
    </form>
    <input id="min2" style="height :30px;width:70px; border:none;outline:none; margin-left:30px;" readonly>


问:
Detect the button action in the WebView in iOS swift
how do you know when user clicks the button in the webview iOS swift

when he click the camera button in the remote url provided by backend team asks the permission and upload photo
2)after submit button cliked close the webpage and navigate to native screen

Can you please solve this issue


问:
Spring boot MongoRepository query to match default query if main query does not match
I've a collection in which I have multiple records, as below,

Name
age

Abcd
100

pqrs
200

none
000

User will give the name, and my method will fetch data and return age, fetching based on "Name", as below,

```<code>res = mongoRepository.findByName(userName);
</code>```

but I want to fetch data for Name "none" if the name provided by user is not present in collection. So currently I'm doing as below,

```<code>res = mongoRepository.findByName(userName);

if (res1 == null){
   res = mongoRepository.findByName("none");
}
</code>```

But is there any way to do this in single call ?

Please note, I can not hardcode data for "none" in code, I must fetch it from DB.

Thanks for any help.

Body:
I've a collection in which I have multiple records, as below,

Name
age

Abcd
100

pqrs
200

none
000

User will give the name, and my method will fetch data and return age, fetching based on "Name", as below,

res = mongoRepository.findByName(userName);

but I want to fetch data for Name "none" if the name provided by user is not present in collection. So currently I'm doing as below,

res = mongoRepository.findByName(userName);

if (res1 == null){
   res = mongoRepository.findByName("none");
}

But is there any way to do this in single call ?

Please note, I can not hardcode data for "none" in code, I must fetch it from DB.

Thanks for any help.


问:
tableView with huge dataSource ( about million rows)
I have a tableview with dataSource that is constantly updated with data on 100 new rows, i.e. there is a method with a cycle consisting of a million iterations, it collects data in a group of 100 elements and gives array in a callback and thereby adds elements to the datasource. I need to make sure that the tableView does not freeze when scrolling, how can I do this and when should I reload tableView?

in viewDidLoad I have:

```<code>server.subscribeToDeals { deals in //every time deals consists of 100 elements
            self.model.append(contentsOf: deals) //dataSource expands
}
</code>```

I tried to use UITableViewDiffableDataSource but tableView still freeze when scrolling

Body:
I have a tableview with dataSource that is constantly updated with data on 100 new rows, i.e. there is a method with a cycle consisting of a million iterations, it collects data in a group of 100 elements and gives array in a callback and thereby adds elements to the datasource. I need to make sure that the tableView does not freeze when scrolling, how can I do this and when should I reload tableView?

in viewDidLoad I have:

server.subscribeToDeals { deals in //every time deals consists of 100 elements
            self.model.append(contentsOf: deals) //dataSource expands
}

I tried to use UITableViewDiffableDataSource but tableView still freeze when scrolling


问:
How can I load the browser to another URL using Vue + Laravel Jetstream?
I am running a portal using Laravel Jetstream. There is a user profile page where, If I click on the "Dashboard" link, the page needs to be redirected to a separate route by loading the browser. But now, when I am clicking on the "Dashboard" link, the browser is not loading and is redirecting to the same page.

resources/js/Layouts/Applayout.vue

```<code><jet-nav-link :href="route('dashboard')">
        Dashboard
</jet-nav-link>
</code>```

routes/web.php

```<code>Route::get('/dashboard', [DashboardController::class,'index'])->name('dashboard');
</code>```

Below is the page showing when I am clicking on dashboard link. I need to redirect to localhost:8000/dashboard.

Body:
I am running a portal using Laravel Jetstream. There is a user profile page where, If I click on the "Dashboard" link, the page needs to be redirected to a separate route by loading the browser. But now, when I am clicking on the "Dashboard" link, the browser is not loading and is redirecting to the same page.

resources/js/Layouts/Applayout.vue

<jet-nav-link :href="route('dashboard')">
        Dashboard
</jet-nav-link>

routes/web.php

Route::get('/dashboard', [DashboardController::class,'index'])->name('dashboard');

Below is the page showing when I am clicking on dashboard link. I need to redirect to localhost:8000/dashboard.


问:
Slack app installation fails with "This app is requesting more permissions than what your Org Admin has granted for your organization."
Once I select the channel in the app installation flow, the following error message appears.

```<code>This app is requesting more permissions than what your Org Admin has granted for your organization.

Please reach out to your Org Admin to request that they update this app. Learn more about why you are seeing this message.
</code>```

I'm the admin of the workspace where I'm trying to install the app. What else am I missing?

Return uri is something like
xyz.com/slack/oauth/callback?error=invalid_channel

Update: Strangely, this error comes only for the first time. If I try again, installation completes successfully.

Body:
Once I select the channel in the app installation flow, the following error message appears.

This app is requesting more permissions than what your Org Admin has granted for your organization.

Please reach out to your Org Admin to request that they update this app. Learn more about why you are seeing this message.

I'm the admin of the workspace where I'm trying to install the app. What else am I missing?

Return uri is something like
xyz.com/slack/oauth/callback?error=invalid_channel

Update: Strangely, this error comes only for the first time. If I try again, installation completes successfully.


问:
Console shows errors in System.Linq.Enumerable and Bee.TundraBackend when build an android app
I have this error when build my android app in Unity. I have remove the build cache folders and Bee folder but the error persists when build again. Can anyone help me? We don't find what we are doing wrong.</p>
```<code>Internal build system error. BuildProgram exited with code 3.
System.NullReferenceException: Object reference not set to an instance of an object.
at System.Linq.Enumerable.WhereArrayIterator`1.Select[TResult](Func`2 selector)
at System.Linq.Enumerable.Select[TSource,TResult](IEnumerable`1 source, Func`2 selector)
at Bee.TundraBackend.TundraBackend.AddDependency(NPath from, IEnumerable`1 to, DependencyKind kind)
at Bee.NativeProgramSupport.Lumping.SetupLumps(ArtifactLocationPolicy artifactLocationPolicy, List`1 inputInstructions, Int32 idealFilesPerLump)+MoveNext()
at System.Collections.Generic.LargeArrayBuilder`1.AddRange(IEnumerable`1 items)
at System.Collections.Generic.SparseArrayBuilder`1.AddRange(IEnumerable`1 items)
at System.Collections.Generic.SparseArrayBuilder`1.ReserveOrAdd(IEnumerable`1 items)
at System.Linq.Enumerable.Concat2Iterator`1.ToArray()
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Bee.NativeProgramSupport.NativeProgram.ProduceObjectFileProductionInstructions(NativeProgramConfiguration config, ArtifactLocationPolicy artifactLocationPolicy, ObjectFileProducer[] objectFileProducers, NPath[]& additionalObjectFiles, NPath[]& foundHeaders)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfigurationImpl(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfiguration(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupLibraryDependencies(NativeProgramConfiguration config, ToolChain toolchain, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfigurationImpl(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfiguration(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at PlayerBuildProgramLibrary.PlayerBuildProgramBase.SetupIl2CppBuild() in /Users/bokken/build/output/unity/unity/Editor/IncrementalBuildPipeline/PlayerBuildProgramLibrary/PlayerBuildProgramBase.cs:line 369
at PlayerBuildProgramLibrary.PlayerBuildProgramBase.SetupPlayerBuild() in /Users/bokken/build/output/unity/unity/Editor/IncrementalBuildPipeline/PlayerBuildProgramLibrary/PlayerBuildProgramBase.cs:line 171
at AndroidPlayerBuildProgram.AndroidPlayerBuildProgram.SetupPlayerBuild()
at PlayerBuildProgramLibrary.PlayerBuildProgramBase.RunBuildProgram() in /Users/bokken/build/output/unity/unity/Editor/IncrementalBuildPipeline/PlayerBuildProgramLibrary/PlayerBuildProgramBase.cs:line 165
at PlayerBuildProgramTypeWrapper.Run(String[] args)
at Program.Main(String[] args)
UnityEngine.GUIUtility:ProcessEvent (int,intptr,bool&) (at /Users/bokken/build/output/unity/unity/Modules/IMGUI/GUIUtility.cs:189)

BuildFailedException: Incremental Player build failed!
UnityEditor.Modules.BeeBuildPostprocessor.PostProcess (UnityEditor.Modules.BuildPostProcessArgs args) (at /Users/bokken/build/output/unity/unity/Editor/Mono/Modules/BeeBuildPostprocessor.cs:604)
UnityEditor.Modules.DefaultBuildPostprocessor.PostProcess (UnityEditor.Modules.BuildPostProcessArgs args, UnityEditor.BuildProperties& outProperties) (at /Users/bokken/build/output/unity/unity/Editor/Mono/Modules/DefaultBuildPostprocessor.cs:28)
UnityEditor.Android.AndroidBuildPostprocessor.PostProcess (UnityEditor.Modules.BuildPostProcessArgs args, UnityEditor.BuildProperties& outProperties) (at <51e10b9352934e7f80981b508a072fc6>:0)
UnityEditor.PostprocessBuildPlayer.Postprocess (UnityEditor.BuildTargetGroup targetGroup, UnityEditor.BuildTarget target, System.Int32 subtarget, System.String installPath, System.String companyName, System.String productName, System.Int32 width, System.Int32 height, UnityEditor.BuildOptions options, UnityEditor.RuntimeClassRegistry usedClassRegistry, UnityEditor.Build.Reporting.BuildReport report) (at /Users/bokken/build/output/unity/unity/Editor/Mono/BuildPipeline/PostprocessBuildPlayer.cs:370)
UnityEngine.GUIUtility:ProcessEvent(Int32, IntPtr, Boolean&) (at /Users/bokken/build/output/unity/unity/Modules/IMGUI/GUIUtility.cs:189)
</code>```

Body:
I have this error when build my android app in Unity. I have remove the build cache folders and Bee folder but the error persists when build again. Can anyone help me? We don't find what we are doing wrong.

Internal build system error. BuildProgram exited with code 3.
System.NullReferenceException: Object reference not set to an instance of an object.
at System.Linq.Enumerable.WhereArrayIterator`1.Select[TResult](Func`2 selector)
at System.Linq.Enumerable.Select[TSource,TResult](IEnumerable`1 source, Func`2 selector)
at Bee.TundraBackend.TundraBackend.AddDependency(NPath from, IEnumerable`1 to, DependencyKind kind)
at Bee.NativeProgramSupport.Lumping.SetupLumps(ArtifactLocationPolicy artifactLocationPolicy, List`1 inputInstructions, Int32 idealFilesPerLump)+MoveNext()
at System.Collections.Generic.LargeArrayBuilder`1.AddRange(IEnumerable`1 items)
at System.Collections.Generic.SparseArrayBuilder`1.AddRange(IEnumerable`1 items)
at System.Collections.Generic.SparseArrayBuilder`1.ReserveOrAdd(IEnumerable`1 items)
at System.Linq.Enumerable.Concat2Iterator`1.ToArray()
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Bee.NativeProgramSupport.NativeProgram.ProduceObjectFileProductionInstructions(NativeProgramConfiguration config, ArtifactLocationPolicy artifactLocationPolicy, ObjectFileProducer[] objectFileProducers, NPath[]& additionalObjectFiles, NPath[]& foundHeaders)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfigurationImpl(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfiguration(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupLibraryDependencies(NativeProgramConfiguration config, ToolChain toolchain, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfigurationImpl(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at Bee.NativeProgramSupport.NativeProgram.SetupSpecificConfiguration(NativeProgramConfiguration config, NativeProgramFormat format, ObjectFileProducer[] objectFileProducers)
at PlayerBuildProgramLibrary.PlayerBuildProgramBase.SetupIl2CppBuild() in /Users/bokken/build/output/unity/unity/Editor/IncrementalBuildPipeline/PlayerBuildProgramLibrary/PlayerBuildProgramBase.cs:line 369
at PlayerBuildProgramLibrary.PlayerBuildProgramBase.SetupPlayerBuild() in /Users/bokken/build/output/unity/unity/Editor/IncrementalBuildPipeline/PlayerBuildProgramLibrary/PlayerBuildProgramBase.cs:line 171
at AndroidPlayerBuildProgram.AndroidPlayerBuildProgram.SetupPlayerBuild()
at PlayerBuildProgramLibrary.PlayerBuildProgramBase.RunBuildProgram() in /Users/bokken/build/output/unity/unity/Editor/IncrementalBuildPipeline/PlayerBuildProgramLibrary/PlayerBuildProgramBase.cs:line 165
at PlayerBuildProgramTypeWrapper.Run(String[] args)
at Program.Main(String[] args)
UnityEngine.GUIUtility:ProcessEvent (int,intptr,bool&) (at /Users/bokken/build/output/unity/unity/Modules/IMGUI/GUIUtility.cs:189)

BuildFailedException: Incremental Player build failed!
UnityEditor.Modules.BeeBuildPostprocessor.PostProcess (UnityEditor.Modules.BuildPostProcessArgs args) (at /Users/bokken/build/output/unity/unity/Editor/Mono/Modules/BeeBuildPostprocessor.cs:604)
UnityEditor.Modules.DefaultBuildPostprocessor.PostProcess (UnityEditor.Modules.BuildPostProcessArgs args, UnityEditor.BuildProperties& outProperties) (at /Users/bokken/build/output/unity/unity/Editor/Mono/Modules/DefaultBuildPostprocessor.cs:28)
UnityEditor.Android.AndroidBuildPostprocessor.PostProcess (UnityEditor.Modules.BuildPostProcessArgs args, UnityEditor.BuildProperties& outProperties) (at <51e10b9352934e7f80981b508a072fc6>:0)
UnityEditor.PostprocessBuildPlayer.Postprocess (UnityEditor.BuildTargetGroup targetGroup, UnityEditor.BuildTarget target, System.Int32 subtarget, System.String installPath, System.String companyName, System.String productName, System.Int32 width, System.Int32 height, UnityEditor.BuildOptions options, UnityEditor.RuntimeClassRegistry usedClassRegistry, UnityEditor.Build.Reporting.BuildReport report) (at /Users/bokken/build/output/unity/unity/Editor/Mono/BuildPipeline/PostprocessBuildPlayer.cs:370)
UnityEngine.GUIUtility:ProcessEvent(Int32, IntPtr, Boolean&) (at /Users/bokken/build/output/unity/unity/Modules/IMGUI/GUIUtility.cs:189)


问:
If I run this command through make file it says "No such file or directory"
```<code>SHELL := /bin/bash

    ENV_TYPE:=dev
    USER:=$(shell id -u)

    generate-client-win:
    docker run --rm -v ${PWD}:/local openapitools/openapi-generator-cli generate -i /local/openapi.spec.yaml -c /local/openapi.config.yaml -g dart-dio -o /local/dart-dio-client
</code>```

My make file looks like above and I am trying to run in from PowerShell in windows.

If I run the command manually in the powershell it runs fine, but I am trying to run it through make file and I enter:

```<code>make generate-client-win
</code>```

Then I get the following error:

```<code>[main] ERROR o.o.c.config.CodegenConfigurator - /local/openapi.config.yaml (No such file or directory)
[main] ERROR o.o.c.config.CodegenConfigurator - /local/openapi.config.yaml (No such file or directory)
Exception in thread "main" java.lang.RuntimeException: Unable to deserialize config file: /local/openapi.config.yaml
</code>```

I assure that the files are there in the directory from where I am running this make file.

Body:
SHELL := /bin/bash

    ENV_TYPE:=dev
    USER:=$(shell id -u)

    generate-client-win:
    docker run --rm -v ${PWD}:/local openapitools/openapi-generator-cli generate -i /local/openapi.spec.yaml -c /local/openapi.config.yaml -g dart-dio -o /local/dart-dio-client

My make file looks like above and I am trying to run in from PowerShell in windows.

If I run the command manually in the powershell it runs fine, but I am trying to run it through make file and I enter:

make generate-client-win

Then I get the following error:

[main] ERROR o.o.c.config.CodegenConfigurator - /local/openapi.config.yaml (No such file or directory)
[main] ERROR o.o.c.config.CodegenConfigurator - /local/openapi.config.yaml (No such file or directory)
Exception in thread "main" java.lang.RuntimeException: Unable to deserialize config file: /local/openapi.config.yaml

I assure that the files are there in the directory from where I am running this make file.


问:
Deleted logs are not rewritten to Elasticsearch
I'm using Logstash to read log files and send to Elasticsearch. It works fine in a streaming mode, creating everyday a different index and writing logs in real time.

The problem is, yesterday at 3pm I occasionally deleted the index. It restored automatically and continued writing logs. However, I have lost the logs related to 12am - 3pm.

In order to rewrite the log from the beginning, I deleted the sincedb file, also added ignore_older => 0 in the Logstash configuration. After that, I deleted the index again. But it continues streaming, ignoring old data.

My current configuration of logstash:

```<code>input {
      file {

        path => ["/someDirectory/Logs/20221220-00001.log"]
        start_position => "beginning"
        tags => ["prod"]
        ignore_older => 0
        sincedb_path => "/dev/null"
        type => "cowrie"
      }
}

filter {
        grok {
           match => ["path", "/var/www/cap/cap-server/Logs/%{GREEDYDATA:index_name}" ]
        }
}

output {
       elasticsearch {
          hosts => "IP:9200"
          user => "elastic"
          password => "xxxxxxxx"
          index => "logstash-log-%{index_name}"
       }
}
</code>```

I would appreciate for any help.

I'm also attaching Elasticsearch configuration:

```<code># Lock the memory on startup:
#
#bootstrap.memory_lock: true
#
# Make sure that the heap size is set to about half the memory available
# on the system and that the owner of the process is allowed to use this
# limit.
#
# Elasticsearch performs poorly when the system is swapping the memory.
#
# ---------------------------------- Network -----------------------------------
#
# By default Elasticsearch is only accessible on localhost. Set a different
# address here to expose this node on the network:
#
network.host: 0.0.0.0
#
# By default Elasticsearch listens for HTTP traffic on the first free port it
# finds starting at 9200. Set a specific HTTP port here:
#
http.port: 9200
#
# For more information, consult the network module documentation.
#
# --------------------------------- Discovery ----------------------------------
#
# Pass an initial list of hosts to perform discovery when this node is started:
# The default list of hosts is ["127.0.0.1", "[::1]"]
#
#discovery.seed_hosts: ["host1", "host2"]
#
# Bootstrap the cluster using an initial set of master-eligible nodes:
#
#cluster.initial_master_nodes: ["node-1", "node-2"]
#
# For more information, consult the discovery and cluster formation module documentation.
#
# ---------------------------------- Various -----------------------------------
#
# Require explicit names when deleting indices:
#
discovery.type: single-node
xpack.security.enabled: true
xpack.security.transport.ssl.enabled: true
#action.destructive_requires_name: true
</code>```

Note, that after all configuration changes, logstash and elasticsearch have been restared.

Body:
I'm using Logstash to read log files and send to Elasticsearch. It works fine in a streaming mode, creating everyday a different index and writing logs in real time.

The problem is, yesterday at 3pm I occasionally deleted the index. It restored automatically and continued writing logs. However, I have lost the logs related to 12am - 3pm.

In order to rewrite the log from the beginning, I deleted the sincedb file, also added ignore_older => 0 in the Logstash configuration. After that, I deleted the index again. But it continues streaming, ignoring old data.

My current configuration of logstash:

input {
      file {

        path => ["/someDirectory/Logs/20221220-00001.log"]
        start_position => "beginning"
        tags => ["prod"]
        ignore_older => 0
        sincedb_path => "/dev/null"
        type => "cowrie"
      }
}

filter {
        grok {
           match => ["path", "/var/www/cap/cap-server/Logs/%{GREEDYDATA:index_name}" ]
        }
}

output {
       elasticsearch {
          hosts => "IP:9200"
          user => "elastic"
          password => "xxxxxxxx"
          index => "logstash-log-%{index_name}"
       }
}

I would appreciate for any help.

I'm also attaching Elasticsearch configuration:

# Lock the memory on startup:
#
#bootstrap.memory_lock: true
#
# Make sure that the heap size is set to about half the memory available
# on the system and that the owner of the process is allowed to use this
# limit.
#
# Elasticsearch performs poorly when the system is swapping the memory.
#
# ---------------------------------- Network -----------------------------------
#
# By default Elasticsearch is only accessible on localhost. Set a different
# address here to expose this node on the network:
#
network.host: 0.0.0.0
#
# By default Elasticsearch listens for HTTP traffic on the first free port it
# finds starting at 9200. Set a specific HTTP port here:
#
http.port: 9200
#
# For more information, consult the network module documentation.
#
# --------------------------------- Discovery ----------------------------------
#
# Pass an initial list of hosts to perform discovery when this node is started:
# The default list of hosts is ["127.0.0.1", "[::1]"]
#
#discovery.seed_hosts: ["host1", "host2"]
#
# Bootstrap the cluster using an initial set of master-eligible nodes:
#
#cluster.initial_master_nodes: ["node-1", "node-2"]
#
# For more information, consult the discovery and cluster formation module documentation.
#
# ---------------------------------- Various -----------------------------------
#
# Require explicit names when deleting indices:
#
discovery.type: single-node
xpack.security.enabled: true
xpack.security.transport.ssl.enabled: true
#action.destructive_requires_name: true

Note, that after all configuration changes, logstash and elasticsearch have been restared.


问:
Macro in PublishedSearchResult Content throw ArgumentNullException
I work with Umbraco version 8.9.1. I have a simple macro video to add local video (in Umbraco Media) in place of public url video. I also use a Search (IPublishedContentQuery) that return me a IEnumerable of PublishedSearchResult. It works well except when I use my macro video in a field, then the field (here body) throw an error : System.ArgumentNullException.

Apparently it's the mapping that cannot be done. The property is in the item.Content.Property and the item.Content.HasValue(property) return true.

```<code>public List<IPublishedProperty> CheckTheValues(PublishedSearchResult item, string searchValue)
{
    foreach (var property in item.Content.Properties) // return me "body"
        {
            if (!item.Content.HasValue(property.Alias)) // HasValue return true
                continue;
            var contentValue = item.Content.Value(property.Alias); // throw System.ArgumentNullException
            ...
        }
}
</code>```

I suppose that's because the mapping cannot translate the macro in something known but it's awkward because I have the html code in my cache like <?UMBRACO_MACRO ... />.

Is there a way to add an alternative content to the macro (not on the video tag), I think about alt property that exists on html img to write an alternative text if the image doesn't exists ?
If not, is there a way to force to get the html code ? (to get the tag umbraco_macro in place of an error)
If not, is there a way to ignore the "not understand" part tags of the content "body" ? so return all except this macro tag.
If not, except with a try catch continue, is there a proper way to ignore this result from my search ?
Thanks a lot !

Body:
I work with Umbraco version 8.9.1. I have a simple macro video to add local video (in Umbraco Media) in place of public url video. I also use a Search (IPublishedContentQuery) that return me a IEnumerable of PublishedSearchResult. It works well except when I use my macro video in a field, then the field (here body) throw an error : System.ArgumentNullException.

Apparently it's the mapping that cannot be done. The property is in the item.Content.Property and the item.Content.HasValue(property) return true.

public List<IPublishedProperty> CheckTheValues(PublishedSearchResult item, string searchValue)
{
    foreach (var property in item.Content.Properties) // return me "body"
        {
            if (!item.Content.HasValue(property.Alias)) // HasValue return true
                continue;
            var contentValue = item.Content.Value(property.Alias); // throw System.ArgumentNullException
            ...
        }
}

I suppose that's because the mapping cannot translate the macro in something known but it's awkward because I have the html code in my cache like <?UMBRACO_MACRO ... />.

Is there a way to add an alternative content to the macro (not on the video tag), I think about alt property that exists on html img to write an alternative text if the image doesn't exists ?
If not, is there a way to force to get the html code ? (to get the tag umbraco_macro in place of an error)
If not, is there a way to ignore the "not understand" part tags of the content "body" ? so return all except this macro tag.
If not, except with a try catch continue, is there a proper way to ignore this result from my search ?
Thanks a lot !


问:
Keycloak - null pointer exception after adding jpa-entity provider

Iam trying to add new table in keycloak version: 13, extended jpaentity provider factory and jpaentity provider classes. deployment is sucess. But after login to keycloak when im selecting any realm showing this error.


问:
selenium python can't scrape video url
I am trying to scrape vidro url from this page. see the picture below

but the video element div are not showing on selenium chrome browser and I also tried Firefox.

here is my code:

```<code>from selenium.webdriver.support.wait import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC

from selenium.webdriver.chrome.service import Service as ChromiumService
from webdriver_manager.chrome import ChromeDriverManager
from webdriver_manager.core.utils import ChromeType

from selenium_stealth import stealth
import requests, csv, time

options = webdriver.ChromeOptions()
options.add_argument("start-maximized")
options.add_experimental_option("excludeSwitches", ["enable-automation"])
options.add_experimental_option('useAutomationExtension', False)
driver = webdriver.Chrome(options=options,service=ChromiumService(ChromeDriverManager(chrome_type=ChromeType.CHROMIUM).install()))
url = "https://grabagun.com/firearms/handguns/semi-automatic-handguns/glock-19-gen-5-polished-nickel-9mm-4-02-inch-barrel-15-rounds-exclusive.html"
driver.get(url)
</code>```

I also tried chrome default profile but didn't work.

```<code>options.add_argument("user-data-dir=C:\\Users\\JHONE\\AppData\\Local\\Google\\Chrome\\User Data")
driver = webdriver.Chrome(options=options,executable_path="C:\\Users\\chromedriver.exe")
</code>```

why the product video section not showing ?what is prevention to show the video section when using selenium?

Title: selenium python can't scrape video url

Body:
I am trying to scrape vidro url from this page. see the picture below

but the video element div are not showing on selenium chrome browser and I also tried Firefox.

here is my code:

from selenium.webdriver.support.wait import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC

from selenium.webdriver.chrome.service import Service as ChromiumService
from webdriver_manager.chrome import ChromeDriverManager
from webdriver_manager.core.utils import ChromeType

from selenium_stealth import stealth
import requests, csv, time

options = webdriver.ChromeOptions()
options.add_argument("start-maximized")
options.add_experimental_option("excludeSwitches", ["enable-automation"])
options.add_experimental_option('useAutomationExtension', False)
driver = webdriver.Chrome(options=options,service=ChromiumService(ChromeDriverManager(chrome_type=ChromeType.CHROMIUM).install()))
url = "https://grabagun.com/firearms/handguns/semi-automatic-handguns/glock-19-gen-5-polished-nickel-9mm-4-02-inch-barrel-15-rounds-exclusive.html"
driver.get(url)

I also tried chrome default profile but didn't work.

options.add_argument("user-data-dir=C:\\Users\\JHONE\\AppData\\Local\\Google\\Chrome\\User Data")
driver = webdriver.Chrome(options=options,executable_path="C:\\Users\\chromedriver.exe")

why the product video section not showing ?what is prevention to show the video section when using selenium?


问:
Not able to shield the applications in DeviceActivityMonitor class
I'm trying to shield and block apps on child device by using schedule.
By using user defaults I am able to read the applicationToken and applicationCategories in intervalDidStart() but I am not able to shield or block the applications or category.

Please note that I am able to shield the app instantly but in DeviceActivityMonitor class I am not able to shield the apps.

Note: I am running the application on same device.


问:
How to resolve the error "SemanticError: Missing yield clause."?
as titled, NebulaGraph version: v3.2.0, when I execute the statement:

```<code>find all path from "bob" to "candy" over follow;
</code>```

Error report: SemanticError: Missing yield clause.

How to resolve this?

Body:
as titled, NebulaGraph version: v3.2.0, when I execute the statement:

find all path from "bob" to "candy" over follow;

Error report: SemanticError: Missing yield clause.

How to resolve this?


问:
react-native: turn RTL off in one screen
I'm trying to add RTL with i18n to my React-native(expo-CLI) app and I have OTP (one Time Password) screen that has a 4-number input.

the problem is when RTL is true the input rotates, for example, the OTP is 4378, when the user types the OTP to the input the result shown is 8734, is there any way I can turn off RTL on this screen?

screenshot when RTL is OFF:

screenshot when RTL is On:

I tried the I18nManager.allowRTL(false) and did not work


问:
How to set a default values in multi select dynamically using magento 2 UI Component
I tried to set a default value in staticly.

below code is working fine.

```<code><argument name="data" xsi:type="array">
        <item name="config" xsi:type="array">
                <item name="default" xsi:type="string">1,5,6</item>
        </item>
</argument>
</code>```

I need to set a default value dynamically in UI component.

Have any idea about that?

I need to set a default value dynamically in UI component.

Body:
I tried to set a default value in staticly.

below code is working fine.

<argument name="data" xsi:type="array">
        <item name="config" xsi:type="array">
                <item name="default" xsi:type="string">1,5,6</item>
        </item>
</argument>

I need to set a default value dynamically in UI component.

Have any idea about that?

I need to set a default value dynamically in UI component.


问:
Websocket connection to colyseus by hand: no messages
I'm trying to connect by hand to Colyseus. I am trying now with node but I don't understand why I can't get past the first message.
Here is the code:

```<code>var WebSocket = require('ws');
var XMLHttpRequest = require('xhr2');
var xhr = new XMLHttpRequest()
var myurl = "http://localhost:2567/matchmake/joinOrCreate/my_room"
var res = '';
var socket = '';
let data = `{ "Id": 123}`;

xhr.open("POST", myurl);
xhr.setRequestHeader("Accept", "application/json");
xhr.setRequestHeader("Content-Type", "application/json");

xhr.onreadystatechange = function () {
  if (xhr.readyState === 4) {
    console.log(xhr.status);
    console.log(xhr.responseText);
    res = JSON.parse(xhr.responseText);
    var processId = res['room']['processId'];
    var roomId = res['room']['roomId'];
    var sessionId = res['sessionId'];
    var wsurl = "ws://localhost:2567/"+processId+"/"+roomId+"?sessionId="+sessionId;
    socket = new WebSocket(wsurl);
    socket.onmessage = (event) =>  {
        console.log('Message from server ', event.data);
    };
  }
};

xhr.send(data);
</code>```

I can see the first message, but when I "broadcast" a message by changing something on the server state, nothing appears. If I connect with the official library, I do see messages going back and forth.

Am I missing something?

Body:
I'm trying to connect by hand to Colyseus. I am trying now with node but I don't understand why I can't get past the first message.
Here is the code:

var WebSocket = require('ws');
var XMLHttpRequest = require('xhr2');
var xhr = new XMLHttpRequest()
var myurl = "http://localhost:2567/matchmake/joinOrCreate/my_room"
var res = '';
var socket = '';
let data = `{ "Id": 123}`;

xhr.open("POST", myurl);
xhr.setRequestHeader("Accept", "application/json");
xhr.setRequestHeader("Content-Type", "application/json");

xhr.onreadystatechange = function () {
  if (xhr.readyState === 4) {
    console.log(xhr.status);
    console.log(xhr.responseText);
    res = JSON.parse(xhr.responseText);
    var processId = res['room']['processId'];
    var roomId = res['room']['roomId'];
    var sessionId = res['sessionId'];
    var wsurl = "ws://localhost:2567/"+processId+"/"+roomId+"?sessionId="+sessionId;
    socket = new WebSocket(wsurl);
    socket.onmessage = (event) =>  {
        console.log('Message from server ', event.data);
    };
  }
};

xhr.send(data);

I can see the first message, but when I "broadcast" a message by changing something on the server state, nothing appears. If I connect with the official library, I do see messages going back and forth.

Am I missing something?


问:
Load Symfony subscriber from package
I am currently developing a library that will be used to intercept incoming exceptions, log them, and pass the to a separate micro-service for handling logs. So inside of the composer lib I am developing I need to have a event subscriber that will listen for exceptions and if the class that throws the exceptions extend our interface log it. Currently I have the interface

```<code>namespace LogLibrary;

interface ExceptionLoggerInterface
{
}
</code>```

And the event subscriber

```<code>final class ExceptionSubscriber implements EventSubscriberInterface
{
    public function __construct()
    {
        $this->logger = new LoggerService();
    }

    public static function getSubscribedEvents(): array
    {
        return [
            KernelEvents::EXCEPTION => ['logException', 0],
        ];
    }

    public function logException(ResponseEvent|ExceptionEvent $event): void
    {
       dd($event);
       $exception = $event->getThrowable();

       if ($exception instanceof ExceptionLoggerInterface) {
          $this->logger->logError($exception);
       }
    }
}
</code>```

And finally on any class from where I have to catch exception I have this

```<code>class UpdatePinCodeController implements ExceptionLoggerInterface
{...}
</code>```

The problem is to actually make the subscriber work. I have the default doctribe setup, autowire is true, I followed the docs extensively. Any help on how to register the subscriber without actually writing anything in the services.yaml file?

Title: Load Symfony subscriber from package

Body:
I am currently developing a library that will be used to intercept incoming exceptions, log them, and pass the to a separate micro-service for handling logs. So inside of the composer lib I am developing I need to have a event subscriber that will listen for exceptions and if the class that throws the exceptions extend our interface log it. Currently I have the interface

namespace LogLibrary;

interface ExceptionLoggerInterface
{
}

And the event subscriber

final class ExceptionSubscriber implements EventSubscriberInterface
{
    public function __construct()
    {
        $this->logger = new LoggerService();
    }

    public static function getSubscribedEvents(): array
    {
        return [
            KernelEvents::EXCEPTION => ['logException', 0],
        ];
    }

    public function logException(ResponseEvent|ExceptionEvent $event): void
    {
       dd($event);
       $exception = $event->getThrowable();

       if ($exception instanceof ExceptionLoggerInterface) {
          $this->logger->logError($exception);
       }
    }
}

And finally on any class from where I have to catch exception I have this

class UpdatePinCodeController implements ExceptionLoggerInterface
{...}

The problem is to actually make the subscriber work. I have the default doctribe setup, autowire is true, I followed the docs extensively. Any help on how to register the subscriber without actually writing anything in the services.yaml file?


问:
Twilio - getUnreadMessagesCount returns null
SDK Versions

Node - 3.76.1

JavaScript - "@twilio/conversations": 2.1.0

We create conversations and add participants to them on the server side and return the conversation id on the client side. One of the participants sends the chat message in the conversations. Then on the other participant's side, we get the conversation object by sid and just call the getUnreadMessagesCount method which always returns null.

But once we open the actual chat screen, where we list the chat messages in the conversation and listen to the number of events, one chat message will be listed. And if we go back to the previous screen and then participant 1 sends another chat message getUnreadMessagesCount will return 1 which is correct.

I cannot figure out why it won't work the first time, does anyone have any idea? What am I doing wrong?

I fetched the conversation object by sid and called the getUnreadMessagesCount function.

This should, according to documentation, return the number of unread messages count but it returns null.


问:
Compare a subset from a List<T> to properties
I have a form that is filled by an ItemID, ItemLot, and Quantity
I fill the ID, lot, and quantity and hit return.
Class Item has many properties beside these mentioned here.

I have a query that finds lots in a transaction table where an item lot could be present several times since an item with a single lot could be received at multiple dates

List <Item> Lots = ItemService.GetLots(FormTextBox.ID)
In order to return a lot I filter by lot using this
List <Item> l = Lots.FindAll(p => p.ItemLot == FormTextBox.Lotno)

In order to be able to return part or all of these items in my possession to the supplier so I have to compare the sum of quantities of a lot in List l to the Quantity I entered in the form.

Any ideas how to filter l or any better idea altogether?


问:
multiprocessing on dataframe
I have this ipynb script to apply a function from a different python script on my dataframe. The "predict_tautomers.py" file contains a function called "get_taut_data".

my script:

import pandas as pd
import multiprocessing as mp
import numpy as np
import predict_tautomers

train_set=pd.read_csv("data/df_train_set.csv", nrows=3)

def parallelize_function(df):
    df["tautomer_dict"] = df["smiles"].apply(predict_tautomers.get_taut_data)
    return df

def parallelize_dataframe(df, func):
    num_processes = 2
    df_split = np.array_split(df, num_processes)
    with mp.Pool(num_processes) as p:
        df = pd.concat(p.map(func, df_split))
        p.map(func, df_split)
    return df

train_set = parallelize_dataframe(train_set, parallelize_function)
```
<p>However, running this code gives me this attribute error.</p>
<p>the error:</p>
```Process SpawnPoolWorker-15:
Traceback (most recent call last):
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
    self.run()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 108, in run
    self._target(*self._args, **self._kwargs)
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/pool.py", line 114, in worker
    task = get()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/queues.py", line 367, in get
    return _ForkingPickler.loads(res)
AttributeError: Can't get attribute 'parallelize_function' on <module '__main__' (built-in)>
Process SpawnPoolWorker-16:
Traceback (most recent call last):
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
    self.run()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 108, in run
    self._target(*self._args, **self._kwargs)
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/pool.py", line 114, in worker
    task = get()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/queues.py", line 367, in get
    return _ForkingPickler.loads(res)
AttributeError: Can't get attribute 'parallelize_function' on <module '__main__' (built-in)>
```
<p>Edit: The "predict_tautomers" script I am importing contains functions with multiprocessing which looks like this:</p>
<pre class="lang-py prettyprint-override"><code>def predict_by_smi(smi, fmax,  num_confs):
    pmol = pybel.readstring("smi", smi)
    blocks = gen_confs_set(smi, num_confs)
    params = zip(blocks, [fmax for i in range(len(blocks))])

    pool = Pool()
    score = pool.map(predict_multicore_wrapper, params)
    pool.close()

def predict_by_smis(smis, fmax, num_confs):
    params = []
    for idx, smi in enumerate(smis):
        blocks = gen_confs_set(smi, num_confs)
        for block in blocks:
            params.append([idx, smi, block, fmax])

    pool = Pool()
    score = pool.map(predict_multicore_wrapper, params)
    pool.close()
</code>```

Title: multiprocessing on dataframe

Body:
I have this ipynb script to apply a function from a different python script on my dataframe. The "predict_tautomers.py" file contains a function called "get_taut_data".

my script:

import pandas as pd
import multiprocessing as mp
import numpy as np
import predict_tautomers

train_set=pd.read_csv("data/df_train_set.csv", nrows=3)

def parallelize_function(df):
    df["tautomer_dict"] = df["smiles"].apply(predict_tautomers.get_taut_data)
    return df

def parallelize_dataframe(df, func):
    num_processes = 2
    df_split = np.array_split(df, num_processes)
    with mp.Pool(num_processes) as p:
        df = pd.concat(p.map(func, df_split))
        p.map(func, df_split)
    return df

train_set = parallelize_dataframe(train_set, parallelize_function)

However, running this code gives me this attribute error.

the error:

Process SpawnPoolWorker-15:
Traceback (most recent call last):
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
    self.run()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 108, in run
    self._target(*self._args, **self._kwargs)
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/pool.py", line 114, in worker
    task = get()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/queues.py", line 367, in get
    return _ForkingPickler.loads(res)
AttributeError: Can't get attribute 'parallelize_function' on <module '__main__' (built-in)>
Process SpawnPoolWorker-16:
Traceback (most recent call last):
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 314, in _bootstrap
    self.run()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/process.py", line 108, in run
    self._target(*self._args, **self._kwargs)
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/pool.py", line 114, in worker
    task = get()
  File "/Users/michel_lim/miniconda3/envs/moltaut2/lib/python3.10/multiprocessing/queues.py", line 367, in get
    return _ForkingPickler.loads(res)
AttributeError: Can't get attribute 'parallelize_function' on <module '__main__' (built-in)>

Edit: The "predict_tautomers" script I am importing contains functions with multiprocessing which looks like this:

def predict_by_smi(smi, fmax,  num_confs):
    pmol = pybel.readstring("smi", smi)
    blocks = gen_confs_set(smi, num_confs)
    params = zip(blocks, [fmax for i in range(len(blocks))])

    pool = Pool()
    score = pool.map(predict_multicore_wrapper, params)
    pool.close()

def predict_by_smis(smis, fmax, num_confs):
    params = []
    for idx, smi in enumerate(smis):
        blocks = gen_confs_set(smi, num_confs)
        for block in blocks:
            params.append([idx, smi, block, fmax])

    pool = Pool()
    score = pool.map(predict_multicore_wrapper, params)
    pool.close()


问:
How to check if a Google PubSub subscription got created after its context has been cancelled
During a Google PubSub CreateSubscription the context gets cancelled. This results in the CreateSubcription function returning the following error: rpc error: code = Canceled desc = context canceled

Most of the time the Subscription will still get created, but sometimes (although I have yet to see it happen) it may not, depending on at what point the Context got cancelled.

What I want to do is delete any potential subscription that may have been created.

My current solution is to try and create the Subscription again, with a new Context and PubSub Client. It will either create, or return an error, if the Subscription already exists.

Another solution is to poll to see if the Subscription exists via the PubSub subscription Exists function, and if it exists then delete it, or if after a set amount of time it does not exist then assume the subscription never got created.

Both ideas don't seem that good, is there a more idiomatic way of achieving this?


问:
Using GROUP BY on a Dataset in VB.NET
This should be simple but it's not working as intended

I have a flat text file that is imported to a Dataset table, I just need to count occurences of a UserDefined3 column so in SQL it would be

SELECT UserDefined3, COUNT(UserDefined3)
FROM MRDF
GROUP BY UserDefined3

but I'm not sure how to do this in VB.NET acting on a DataTable

Title: Using GROUP BY on a Dataset in VB.NET


问:
echo product quantity in cart woocommerce
I want to display product quantity in the cart, on a single product page as text.

This is currently what I'm using in functions.php, I want to display the quantity number between.

add_action('woocommerce_before_add_to_cart_form', 'gripsquantity', 5);
function gripsquantity(){
    echo 'Choose ';
    echo 'Grips';
}
```

So it will be "choose 3 grips" or "choose 1 grip" depending on the product quantity in the cart

Body:
I want to display product quantity in the cart, on a single product page as text.

This is currently what I'm using in functions.php, I want to display the quantity number between.

add_action('woocommerce_before_add_to_cart_form', 'gripsquantity', 5);
function gripsquantity(){
    echo 'Choose ';
    echo 'Grips';
}

So it will be "choose 3 grips" or "choose 1 grip" depending on the product quantity in the cart


问:
ipython tab completion only to show imported functions from a module, not other imported modules
I like the tab completion in ipython to see which functions are available in an imported module. I am aware that imports in a module could be hidden from view in the tab completion if those imports were done with an underscore like import os as _os. Is there a way to avoid seeing imported modules if the imports were done without an underscore like import os only?

Example:

with_underscore.py:

```<code>import os as _os

def list(path):
    _os.listdir(path)
</code>```

without_underscore.py:

```<code>import os

def list(path):
    os.listdir(path)
</code>```

After importing the two modules into ipython

```<code>
[1]: import with_underscore
[2]: import without_underscore
</code>```

tab completion without_underscore.<tab> would yield list os, tab completion with_underscore.<tab> would yield list only, which is what I want. How could I get only list with tab completion without the underscore importing approach?

Body:
I like the tab completion in ipython to see which functions are available in an imported module. I am aware that imports in a module could be hidden from view in the tab completion if those imports were done with an underscore like import os as _os. Is there a way to avoid seeing imported modules if the imports were done without an underscore like import os only?

Example:

with_underscore.py:

import os as _os

def list(path):
    _os.listdir(path)

without_underscore.py:

import os

def list(path):
    os.listdir(path)

After importing the two modules into ipython

[1]: import with_underscore
[2]: import without_underscore

tab completion without_underscore.<tab> would yield list os, tab completion with_underscore.<tab> would yield list only, which is what I want. How could I get only list with tab completion without the underscore importing approach?