Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micros Res 3700 5.4 EM packet error

Status
Not open for further replies.
dwwillia

dwwillia

IS-IT--Management
Nov 28, 2015
20
CA
Anyone have any ideas on how to troubleshoot the following error we get when trying to receive an EM packet to a local store? Any help would be appreciated :)

Capture_crwhyx.png
 
Sort by date Sort by votes
podria agregar el archivo log.xml que se encuentra en \micros\res\em\etc
 
Upvote 0 Downvote
<EVENT DATETIME="2016-10-15 13:02:04" ID="1">Receiving file "D:\MICROS\RES\EM\TRANSPORT\RECEIVE\S1_D10_C1_P910.MPZ" [1 of 1]</EVENT>
<EVENT DATETIME="2016-10-15 13:02:04" ID="2">Indexing Package File.</EVENT>
<EVENT DATETIME="2016-10-15 13:02:04" ID="3">Package File Index Completed.</EVENT>
<EVENT DATETIME="2016-10-15 13:02:04" ID="4">Fetched package from file.</EVENT>
<EVENT DATETIME="2016-10-15 13:02:19" ID="5">Pass 1 completed. Processed 2064 packets.</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="6">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1882">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1882</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1882</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1882</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">516</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">1</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="7">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1883">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1883</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1883</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1883</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">475</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">2</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="8">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1884">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1884</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1884</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1884</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">39</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">3</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="9">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1885">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1885</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1885</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1885</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">14</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">4</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="10">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1886">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1886</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1886</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1886</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">12</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">5</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="11">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1887">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1887</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1887</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1887</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">457</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">6</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="12">
<FAILED_PACKET>
<PACKET SOURCE="5.4" ACTION="SET_DATA" PUBLISHER="MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1889">
<combo_side_def>
<PATH_ELEMENT ISNULL="0">629*1889</PATH_ELEMENT>
<DISPLAY_ELEMENT ISNULL="0">629*1889</DISPLAY_ELEMENT>
<COMBO_SIDE_SEQ ISNULL="0">1889</COMBO_SIDE_SEQ>
<COMBO_GRP_SEQ ISNULL="0">500</COMBO_GRP_SEQ>
<COMBO_SEQ ISNULL="0">629</COMBO_SEQ>
<SIDE_NUM ISNULL="0">7</SIDE_NUM>
<OVERRIDE_LEVEL ISNULL="0">1</OVERRIDE_LEVEL>
<MLVL_MASK ISNULL="0">2</MLVL_MASK>
</combo_side_def>
</PACKET>
</FAILED_PACKET>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="13">Pass 2 completed. Processed 0 packets.</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="14">Receive failed to process ( 7) packets.</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="15">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="16">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1882','516','629','1','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="17">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1882".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="18">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="19">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="20">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1883','475','629','2','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="21">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1883".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="22">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="23">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="24">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1884','39','629','3','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="25">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1884".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="26">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="27">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="28">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1885','14','629','4','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="29">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1885".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="30">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="31">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="32">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1886','12','629','5','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="33">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1886".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="34">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="35">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="36">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1887','457','629','6','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="37">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1887".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="38">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="39">UMT 2: Exception trapped in "OpenExecute()" with error message "[Sybase][ODBC Driver][Adaptive Server Anywhere]No primary key value for foreign key 'CFK2COMBO_SIDE_DEF' in table 'combo_side_def'".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="40">UMT 2: SQL Access Error in "OpenExecute()" executing "call MICROS.spem_POS_combo_side_def('SET_DATA',NULL,'1889','500','629','7','1','2')".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="41">UMT 2: Error receiving data for configuration item "MICROS_RES_POS\COMBO_MEAL_GRP\629\629*1889".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="42">
UMT 2:
<STATUS>
<CODE>7</CODE>
<TEXT>EXCEPTION</TEXT>
</STATUS>
</EVENT>
<EVENT DATETIME="2016-10-15 13:02:20" ID="43">UMT 2: Critical error encountered when processing package ID "910" sent from "My Corporate Sit".</EVENT>
<EVENT DATETIME="2016-10-15 13:02:23" ID="44">Log Session (3170) ended.</EVENT>
 
Upvote 0 Downvote
una opcion si tiene otros servidores en donde el paquete funciono correctamente o incluso de su servidor EM es extraer los datos mediante un archivo .txt de las tablas combo_def y combo_side_def , puede realizar la busqueda y exportacion asi:

SELECT * FROM "micros"."combo_def" where combo_seq='629' ; output to 'c:\combodef.txt'

SELECT * FROM "micros"."combo_side_def" where combo_seq='629' ; output to 'c:\comboside.txt'


y agregarlos manual mente en la tabla combo_side_def y combo_def de el servidor que tiene problema,en el mismo orden ya que debe existir primero en la combo def para permitirle crear en el side_def si hace falta la informacion en otra tabla le mostrara un mensaje de forenkey si es asi tambien validar que el item este creado en la tabla mi_def :

input into "micros"."combo_def" from c:\combodef.txt

input into "micros"."combo_side_def" from c:\comboside.txt


*..otra opcion es en las mismas tablas que le menciono arriba ingresar manual mente los datos solamente haciendo click derecho y agregar un nuevo registro en ellas .

click derecho add row
y llenar todos los campos

*.. otra opcion es crear manual mente mediante el posconfigurator- menu items

esto dependera si el servidor local donde tiene el problema le permite agregar items, debera crearlo con la misma informacion que en su servidor EM para evitar conflictos a futuro

espero le ayudenestos consejos a solucionar

saludos









 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimFromCanada
  • Locked
  • Question
RE: MICROS RES 3700: IFS error 1
Replies
8
Views
904
pradeepckmeta
P
B
  • Locked
  • Question
MICROS RES 3700 - Desperate!
Replies
4
Views
889
bdavidson024
B
RickysRestaurants
  • Locked
  • Question
Micros 3700 Res 4.11
Replies
2
Views
343
RickysRestaurants
RickysRestaurants
JimFromCanada
  • Locked
  • Question
MICROS RES 3700: IFS error status -21 / IFS_ADAPTER_ERROR
Replies
3
Views
275
JimFromCanada
JimFromCanada
kareem.akram
  • Question
Micros 3700 Emailer Program
Replies
0
Views
166
kareem.akram
kareem.akram

Part and Inventory Search

Sponsor

Back
Top