Niv119/03/2024 16:53:16100PREPROD2:YWPUNLALL
Clone : PREPROD2
Call 1
Page : E:\WEB\Applications\PREPROD2\index_actions.php
Ligne : 2
Fonction : Cryptée

Call 2
Page : \
Ligne :
Fonction : unknown

Call 3
Page : E:\WEB\Applications\PREPROD2\index_actions.php
Ligne : 63
Fonction : unLockAll(100)

Call 4
Page : E:\WEB\Applications\PREPROD2\framework\php_fonctions\php_fonctions_X3.php
Ligne : 227
Fonction : Run(YWPUNLALL, 100 )

<?xml version="1.0" encoding="UTF-8"?> <PARAM> <GRP ID="PARAM" > <FLD NAME="SUSER" TYPE="Integer">100</FLD> </GRP> </PARAM>

index_actions.php

array(1) {
  [PARAM] = array(1) {
        [SUSER] = string(3) "100"
  }
}

-- TechnicalInfos --

index_actions.php

array(17) {
  [busy] = bool(false)
  [changeLanguage] = bool(false)
  [changeUserId] = bool(false)
  [flushAdx] = bool(false)
  [loadWebsDuration] = float(-1)
  [nbDistributionCycle] = int(-1)
  [poolDistribDuration] = float(-1)
  [poolEntryIdx] = int(-1)
  [poolExecDuration] = float(-1)
  [poolRequestDuration] = float(-1)
  [poolWaitDuration] = float(-1)
  [processReportSize] = int(-1)
  [reloadWebs] = bool(false)
  [resumitAfterDBOpen] = bool(false)
  [rowInDistribStack] = NULL
  [totalDuration] = float(4)
  [traceRequestSize] = int(0)
}

No Pool- PREPROD2

index_actions.php

array(4) {
  [AutomaticLineValue] = string(0) ""
  [codeope] = string(3) "100"
  [mdpasse] = string(3) "100"
  [act] = string(6) "logope"
}

Niv119/03/2024 16:53:16100
Clone : PREPROD2Page : E:\WEB\Applications\PREPROD2\framework\php_fonctions\php_fonctions_X3.php
Ligne : 238
Fonct : unLockAll
Lien : /PREPROD2/index_actions.php?AutomaticLineValue=
&codeope=100
&mdpasse=100
&act=logopeYWPUNLALLNo Pool- PREPROD2
<?xml version="1.0" encoding="UTF-8"?> <PARAM> <GRP ID="PARAM" > <FLD NAME="SUSER" TYPE="Integer">100</FLD> </GRP> </PARAM> Niv119/03/2024 16:59:45100PREPROD2:YWPUNLALL
Clone : PREPROD2
Call 1
Page : E:\WEB\Applications\PREPROD2\PC1_01.php
Ligne : 2
Fonction : Cryptée

Call 2
Page : \
Ligne :
Fonction : unknown

Call 3
Page : E:\WEB\Applications\PREPROD2\PC1_01.php
Ligne : 19
Fonction : unLockAll(100)

Call 4
Page : E:\WEB\Applications\PREPROD2\framework\php_fonctions\php_fonctions_X3.php
Ligne : 227
Fonction : Run(YWPUNLALL, 100 )

<?xml version="1.0" encoding="UTF-8"?> <PARAM> <GRP ID="PARAM" > <FLD NAME="SUSER" TYPE="Integer">100</FLD> </GRP> </PARAM>

PC1_01.php

array(1) {
  [PARAM] = array(1) {
        [SUSER] = string(3) "100"
  }
}

-- TechnicalInfos --

PC1_01.php

array(17) {
  [busy] = bool(false)
  [changeLanguage] = bool(false)
  [changeUserId] = bool(false)
  [flushAdx] = bool(false)
  [loadWebsDuration] = float(-1)
  [nbDistributionCycle] = int(-1)
  [poolDistribDuration] = float(-1)
  [poolEntryIdx] = int(-1)
  [poolExecDuration] = float(-1)
  [poolRequestDuration] = float(-1)
  [poolWaitDuration] = float(-1)
  [processReportSize] = int(-1)
  [reloadWebs] = bool(false)
  [resumitAfterDBOpen] = bool(false)
  [rowInDistribStack] = NULL
  [totalDuration] = float(7)
  [traceRequestSize] = int(0)
}

No Pool- PREPROD2

Niv119/03/2024 16:59:45100
Clone : PREPROD2Page : E:\WEB\Applications\PREPROD2\framework\php_fonctions\php_fonctions_X3.php
Ligne : 238
Fonct : unLockAll
Lien : /PREPROD2/PC1_01.phpYWPUNLALLNo Pool- PREPROD2
<?xml version="1.0" encoding="UTF-8"?> <PARAM> <GRP ID="PARAM" > <FLD NAME="SUSER" TYPE="Integer">100</FLD> </GRP> </PARAM> Niv119/03/2024 17:20:10100PREPROD2:SQL
Clone : PREPROD2
Call 1
Page : E:\WEB\Applications\PREPROD2\SM1_actions.php
Ligne : 2
Fonction : Cryptée

Call 2
Page : \
Ligne :
Fonction : unknown

Call 3
Page : E:\WEB\Applications\PREPROD2\SM1_actions.php
Ligne : 40
Fonction : affDetSTK(REF00081,5,0, )

Call 4
Page : E:\WEB\Applications\PREPROD2\SM1_fonctions.php
Ligne : 63
Fonction : require(E:\WEB\Applications\WMS_SPE\PREPROD2\SM1_fonctions_spe.php)

Call 5
Page : E:\WEB\Applications\WMS_SPE\PREPROD2\SM1_fonctions_spe.php
Ligne : 57
Fonction : getAll( SELECT STO.LOT_0 STO_LOT, STO.SLO_0 STO_SLO, STO.QTYSTU_0 STO_QTYSTU, STO.CUMALLQTY_0 STO_CUMALLQTY, STO.STA_0 STO_STA, STO.LOC_0 STO_LOC, STO.PALNUM_0 STO_PALNUM, STL.Y_TYPEFCT_0 TYPEFCT, ITM.ITMDES2_0 DES, ITM.STU_0 STU, STO.STOCOU_0 STOCOU, STLOT.SHLDAT_0 SHLDAT, SUM(STA.QTYSTU_0) STA_QTYSTU_ALL FROM PREPROD2.STOCK STO LEFT JOIN PREPROD2.STOALL STA ON ( STO.STOCOU_0 = STA.STOCOU_0 AND STO.STOFCY_0 = STA.STOFCY_0) INNER JOIN PREPROD2.ITMMASTER ITM ON ( STO.ITMREF_0 = ITM.ITMREF_0) INNER JOIN PREPROD2.STOLOC STL ON ( STO.STOFCY_0 = STL.STOFCY_0 AND STO.LOC_0 = STL.LOC_0) LEFT JOIN PREPROD2.STOLOT STLOT ON ( STLOT.ITMREF_0 = STO.ITMREF_0 AND STLOT.LOT_0 = STO.LOT_0 AND STLOT.SLO_0 = STO.SLO_0) WHERE STL.LOCCAT_0 <= 2 AND STO.ITMREF_0='REF00081' AND STO.STOFCY_0='CR1' AND STO.STA_0 like 'A%' AND STLOT.SHLDAT_0 >= '19/03/2024' GROUP BY STO.LOT_0, STO.SLO_0, STO.QTYSTU_0, STO.CUMALLQTY_0, STO.PALNUM_0, STO.STA_0, STO.LOC_0, ITM.ITMDES2_0, ITM.STU_0, STL.Y_TYPEFCT_0, STO.STOCOU_0, STLOT.SHLDAT_0 ORDER BY STO.LOeC_0, STO.PALNUM_0, STO.LOC_0)

Call 6
Page : E:\WEB\Applications\PREPROD2\framework\php_classes\BBPdoManager.class.php
Ligne : 269
Fonction : execRequete( SELECT STO.LOT_0 STO_LOT, STO.SLO_0 STO_SLO, STO.QTYSTU_0 STO_QTYSTU, STO.CUMALLQTY_0 STO_CUMALLQTY, STO.STA_0 STO_STA, STO.LOC_0 STO_LOC, STO.PALNUM_0 STO_PALNUM, STL.Y_TYPEFCT_0 TYPEFCT, ITM.ITMDES2_0 DES, ITM.STU_0 STU, STO.STOCOU_0 STOCOU, STLOT.SHLDAT_0 SHLDAT, SUM(STA.QTYSTU_0) STA_QTYSTU_ALL FROM PREPROD2.STOCK STO LEFT JOIN PREPROD2.STOALL STA ON ( STO.STOCOU_0 = STA.STOCOU_0 AND STO.STOFCY_0 = STA.STOFCY_0) INNER JOIN PREPROD2.ITMMASTER ITM ON ( STO.ITMREF_0 = ITM.ITMREF_0) INNER JOIN PREPROD2.STOLOC STL ON ( STO.STOFCY_0 = STL.STOFCY_0 AND STO.LOC_0 = STL.LOC_0) LEFT JOIN PREPROD2.STOLOT STLOT ON ( STLOT.ITMREF_0 = STO.ITMREF_0 AND STLOT.LOT_0 = STO.LOT_0 AND STLOT.SLO_0 = STO.SLO_0) WHERE STL.LOCCAT_0 <= 2 AND STO.ITMREF_0='REF00081' AND STO.STOFCY_0='CR1' AND STO.STA_0 like 'A%' AND STLOT.SHLDAT_0 >= '19/03/2024' GROUP BY STO.LOT_0, STO.SLO_0, STO.QTYSTU_0, STO.CUMALLQTY_0, STO.PALNUM_0, STO.STA_0, STO.LOC_0, ITM.ITMDES2_0, ITM.STU_0, STL.Y_TYPEFCT_0, STO.STOCOU_0, STLOT.SHLDAT_0 ORDER BY STO.LOeC_0, STO.PALNUM_0, STO.LOC_0)

Call 7
Page : E:\WEB\Applications\PREPROD2\framework\php_classes\BBPdoManager.class.php
Ligne : 162
Fonction : setError(Erreur PDO à la ligne 156 dans E:\WEB\Applications\PREPROD2\framework\php_classes\BBPdoManager.class.php

SQLSTATE[HY000]: General error: 904 OCIStmtExecute: ORA-00904: "STO"."LOEC_0": invalid identifier (ext\pdo_oci\oci_statement.c:157))
Paramètres :

act=getlisteSTK&besoin=5&qtyprep=0&dloc=%20&article=REF00081&mfgnum=OFCR123060001&mfglin=1000&bomseq=60

Connection :

(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.162)(PORT = 1521)))(CONNECT_DATA=(SERVICE_NAME=ROYV12)))

Dernière requête tentée :

SM1_actions.php

string(1439) "	SELECT
						STO.LOT_0 STO_LOT,
						STO.SLO_0 STO_SLO,
						STO.QTYSTU_0 STO_QTYSTU,
						STO.CUMALLQTY_0 STO_CUMALLQTY,
						STO.STA_0 STO_STA,
						STO.LOC_0 STO_LOC,
						STO.PALNUM_0 STO_PALNUM,
						STL.Y_TYPEFCT_0 TYPEFCT,
						ITM.ITMDES2_0 DES,
						ITM.STU_0 STU,
						STO.STOCOU_0 STOCOU,
						STLOT.SHLDAT_0 SHLDAT,
						SUM(STA.QTYSTU_0) STA_QTYSTU_ALL
					FROM
						 PREPROD2.STOCK STO
						LEFT  JOIN PREPROD2.STOALL STA        ON ( STO.STOCOU_0 = STA.STOCOU_0
														  AND STO.STOFCY_0 = STA.STOFCY_0)
						INNER JOIN PREPROD2.ITMMASTER ITM ON ( STO.ITMREF_0 = ITM.ITMREF_0)
						INNER JOIN PREPROD2.STOLOC STL        ON ( STO.STOFCY_0 = STL.STOFCY_0
														  AND STO.LOC_0 = STL.LOC_0)
						LEFT  JOIN PREPROD2.STOLOT STLOT  ON ( STLOT.ITMREF_0 = STO.ITMREF_0
														  AND STLOT.LOT_0 = STO.LOT_0
														  AND STLOT.SLO_0 = STO.SLO_0)
					WHERE
						STL.LOCCAT_0 <= 2 AND
						STO.ITMREF_0='REF00081' AND
						STO.STOFCY_0='CR1' AND
						STO.STA_0 like 'A%'
						
						
						AND STLOT.SHLDAT_0 >= '19/03/2024'
					GROUP BY
						STO.LOT_0,
						STO.SLO_0,
						STO.QTYSTU_0,
						STO.CUMALLQTY_0,
						STO.PALNUM_0,
						STO.STA_0, 
						STO.LOC_0,
						ITM.ITMDES2_0,
						ITM.STU_0, 
						STL.Y_TYPEFCT_0,
						STO.STOCOU_0,
						STLOT.SHLDAT_0
					ORDER BY 
						STO.LOeC_0,
						STO.PALNUM_0,
						STO.LOC_0"

Type d'erreur :

Erreur PDO à la ligne 156 dans E:\WEB\Applications\PREPROD2\framework\php_classes\BBPdoManager.class.php

SQLSTATE[HY000]: General error: 904 OCIStmtExecute: ORA-00904: "STO"."LOEC_0": invalid identifier (ext\pdo_oci\oci_statement.c:157)