DLOGWMSOL-17891 DT Inconsistência na geração da onda pela rotina WMS60001

01. DADOS GERAIS

02. SITUAÇÃO/REQUISITO

Na execução do processamento da onda pela rotina de Preparação da Separação (WMS60001), a mesma cancela o processo, apresentando a seguinte inconsistência nos bancos Informix e SQL Server:

The cursor or statement is not available. in file C:\bamboo\xml-data\build-dir\TP11-OF20310-TECXWIN64\logix\logixsql.cpp at line 55
 on [email protected](WMSR72.4GL) 25/05/2023 07:43:03 line : 547[build: 7.00.210324P-20230228]

• • SVN Revision: 38079[platform: x64][appversion: 20.3.1.4][environment: LOGIX_ATUAL][thread: 14260][dbthread: 67][rpodb: Top][localfiles: SQLITE][remark: [APP] PROCESS: WMS60001 | PARENT PROCESS: MENU | USER: admlog | COMPANY: 11 | SLOTID: 0 | DEBUG MODE: ON][threadtype: RmtSockThread]Called from [email protected](WMSR71.4GL) 13/12/2022 09:30:16 line : 1354Called from [email protected](WMSR71.4GL) 13/12/2022 09:30:16 line : 384Called from [email protected](WMS60003.4GL) 13/12/2022 09:30:14 line : 764Called from [email protected](WMS60003.4GL) 13/12/2022 09:30:14 line : 2334Called from [email protected](WMS60003.4GL) 13/12/2022 09:30:14 line : 1267Called from {|| If(&("_4GL_wms60003_processa_operacao()") == 0,.F.,.T.) }(LCOMPONENT.PRW) 20/04/2023 16:45:31 line : 1145Called from LPROGRESSPOPUP:INITEVENT(LPROGRESSPOPUP.PRW) 20/04/2023 16:45:31 line : 354Called from {|| SELF:INITEVENT(), IF(SELF:OPOPUP <> NIL,SELF:OPOPUP:SETPROPERTY("ACTIVATE",0),) }(LPROGRESSPOPUP.PRW) 20/04/2023 16:45:31 line : 244Called from LFORM:EXECUTEINITEVENT(LFORM.PRW) 20/04/2023 16:45:31 line : 621Called from {|| SELF:EXECUTEINITEVENT() }(LPOPUPDIALOG.PRW) 20/04/2023 16:45:31 line : 57Called from ::MSDIALOG:ACTIVATECalled from LPOPUPDIALOG:ACTIVATEPOPUPDIALOG(LPOPUPDIALOG.PRW) 20/04/2023 16:45:31 line : 57Called from LPOPUPDIALOG:SETPROPERTY(LPOPUPDIALOG.PRW) 20/04/2023 16:45:31 line : 34Called from LPROGRESSPOPUP:INITPROGRESS(LPROGRESSPOPUP.PRW) 20/04/2023 16:45:31 line : 340Called from LPROGRESSPOPUP:GETPROPERTY(LPROGRESSPOPUP.PRW) 20/04/2023 16:45:31 line : 209Called from GET_PROPERTY(FREEFORM.PRW) 20/04/2023 16:45:31 line : 580Called from [email protected](LPROGRESSPOPUP.4GL) 20/04/2023 16:45:31 line : 82Called from [email protected](WMS60003.4GL) 13/12/2022 09:30:14 line : 1202Called from [email protected](WMS60003.4GL) 13/12/2022 09:30:14 line : 463Called from {|| If(&("_4GL_wms60003_confirm_gerar_onda()") == 0,.F.,.T.) }(LCOMPONENT.PRW) 20/04/2023 16:45:31 line : 1145Called from EXECUTEMENUITEMEVENT(LOPERATIONMETADATA.PRW) 20/04/2023 16:45:37 line : 2587Called from LOPERATIONMETADATA:EXECUTECONFIRMEVENT(LOPERATIONMETADATA.PRW) 20/04/2023 16:45:37 line : 2321{{{}Called from {|| self:oOperation:executeConfirmEvent(aMenubar[9])     }
    }}(LMENUBARMETADATA.PRW) 20/04/2023 16:45:37 line : 278
    Called from LMENUBAR:RUNACTION(LMENUBAR.PRW) 20/04/2023 16:45:31 line : 293
    Called from {|| SELF:OPARENT:RUNACTION(SELF:CNAME) }(LMENUBUTTON.PRW) 20/04/2023 16:45:31 line : 70
    Called from ::MSDIALOG:ACTIVATE
    Called from LDIALOG:ACTIVATE(LDIALOG.PRW) 20/04/2023 16:45:31 line : 295
    Called from LDIALOG:SETPROPERTY(LDIALOG.PRW) 20/04/2023 16:45:31 line : 148
    Called from SET_PROPERTY(FREEFORM.PRW) 20/04/2023 16:45:31 line : 520
    Called from [email protected](WMS60001.4GL) 13/12/2022 09:30:18 line : 130
    Called from [email protected](WMS60001.4GL) 13/12/2022 09:30:18 line : 61
    Called from {|| _4GL_wms60001() }(LTHREAD.PRW) 20/04/2023 16:45:31
    Called from LOGIXEXECUTE(LTHREAD.PRW) 20/04/2023 16:45:31 line : 958
    -------------------------------------------------------*/

Configuração da geração da onda:

03. SOLUÇÃO

Efetuada alteração no SQL preparado do cursor cq_item_dimensional, onde está sendo incluído o valor fixo 0 (zero) no select e no group by. 

Exemplo de Utilização

04. DEMAIS INFORMAÇÕES

• Não se aplica.

05. ASSUNTOS RELACIONADOS

Documento de Referência

• Preparação da Separação - WMS60001