Exibir origem

01. DADOS GERAIS

Produto:
Linha de Produto:
Segmento:
Módulo:
Função:	Preparação da Separação - WMS60001
País:	Brasil
Ticket:	-
Requisito/Story/Issue (informe o requisito relacionado) :	DLOGWMSOL-17891

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
  -------------------------------------------------------*/

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

WMS6325

Inclua uma Solicitação de Carga para um item que deve ser expedido do armazém e sem controle de dimensional.

WMS60001

Gere o plano da Solicitação de Carga incluída anteriormente.
Gere a onda do plano.
O processamento da onda deve ocorrer com sucesso.

04. DEMAIS INFORMAÇÕES

Não se aplica.

05. ASSUNTOS RELACIONADOS

Documento de Referência

Preparação da Separação - WMS60001