DataCollection for Dcmoves not processing. No error messages at all.

I'm trying to implement a restocking procedure inside CSI. I'm using the DataCollection forms as they offer integrity checking as well as abuild in mechanism for users to fix Quantity Moves that had/have errors. I've got my record created inside the dcmove_mst table & the schedule task is running every minute to process the moves. However; nothing is happening. No errors messages. No move. Nothing. I had this working once before (Infor said to change the trans_type from M to 1) but deleted the schedule task/job until I was ready to test the automation. Now it just sits there like a log.

Has anyone gotten this to work? The rest of this project is all completed & ready for testing but it can't go forward without the moves being processed. I *really* don't want to use a stored procedure to do this as I wanted to queue up all the moves first and then process them.

Find more posts tagged with

Syteline Development

Accepted answers

All comments

Legacy Contributor

I just set this up for a customer a couple of weeks ago, but they were on SyteLine 8.03. Please describe the steps you followed in detail to set up the data collection service, and I will compare to my notes and see if you missed any steps. There is a step where you have to edit a .bat file that runs the service, and put the configuration and automation username and password in it, to connect to SyteLine and process the transactions. That is my guess (without seeing the setup myself) where I think you are likely going astray.

Stephen Cena

Thank you. I'm on 9.01.01 right now. He's how I'm going about it:

1. I have a form that looks at the SLitemLocs table w/ my UET's & locates all the Items that need to be moves to a Transit location.

2. For each Item in the Collection, I create an SLDcmove entry in my IDO Extension Class:
             foreach (IDOItem vItem in lItemsToRestock.Items)
            {
                lItem = new IDOUpdateItem();

                Debug("inside for loop - Restocking.");
                Debug(a+ ": " + vItem.PropertyValues[vItemIndex] + " qty to move: " + vItem.PropertyValues[vQtyToRestockIndex]);

                #region Add all properties for a SLDcmoves object & add it to the list to be processed
                lItem.Action = UpdateAction.Insert;
                lItem.Properties.Add("TransDate", lTimeOfProcess);
                lItem.Properties.Add("EmpNum", pEmployee);
                lItem.Properties.Add("TransType", 1);
                lItem.Properties.Add("Item", (vItem.PropertyValues[vItemIndex]).ToString());
                lItem.Properties.Add("ItemDescription", (vItem.PropertyValues[vItemDescIndex]).ToString());
                lItem.Properties.Add("UM", (vItem.PropertyValues[vItmUMIndex]).ToString());
                lItem.Properties.Add("Whse", pWarehouse);
                lItem.Properties.Add("Loc1", (vItem.PropertyValues[vRestockFromLocIndex]).ToString());
                lItem.Properties.Add("Loc2", pLocationPrefix + " TRANSIT");
                lItem.Properties.Add("QtyMoved", (vItem.PropertyValues[vQtyToRestockIndex]).ToString());

                lRequest.Items.Add(lItem);
                #endregion

                #region Add the Transit location to the SLItemLocs object
                lItem = new IDOUpdateItem(UpdateAction.Update, vItem.ItemID);
                lItem.Properties.Add("ilocUf_qvi_RestockTransitLoc", pLocationPrefix + " TRANSIT");
                lRequest2.Items.Add(lItem);
                #endregion
            }

            try
            {
                Debug("There are " + lRequest.Items.Count() + " items to add");
                lResponse = Context.Commands.UpdateCollection(lRequest);
                lResponse2 = Context.Commands.UpdateCollection(lRequest2);
            }
            catch (Exception e)
            {
                Debug(e.ToString());
            }

            Debug("Update executed");

3. When I check the dcmoves_mst table, I see the following:

site_ref trans_num termid trans_date emp_num trans_type item whse loc1 lot1 loc2 lot2 qty_moved stat override u_m NoteExistsFlag RecordDate RowPointer ErrorMessage CanOverride CreatedBy UpdatedBy CreateDate remote_site_lot_process create_loc InWorkflow document_num uf_pref_type
QVI 1 NULL 2019-09-12 09:26:22.170 816 1 303668 MAIN WHB 36 E2 NULL 18 TRANSIT NULL 6.00000000 NULL 0 EA 0 2019-09-12 09:26:22.223 FED21344-7411-4209-BFF6-5D8A4C7C03CC NULL 0 admsjc admsjc 2019-09-12 09:26:22.223 B 0 0 NULL NULL

4. I have the DataCollection form set up to Auto-Post Quantity Move. There is an ActiveBG task for it & I can see the job executing every minute inside SQL Server.

The last time I had problems, all I did was change the entry for trans_type from M to 1 & that seemed to fix it. The only other thing I noticed, is emp_num doesn't hold a valid employee #. I thought the userID was the employee number. However, setting the emp_num to NULL didn't cause an error or the record to get processed.

I'll post any additional code/screenshots/videos/cat pics if they will help.

Thanks!

Legacy Contributor

The guide I used is the "Intermec Equipment Installation Guide 8.03" to setup Data Collection. Based on the guide I read for 9.01, it seems like it was written for SaaS environments where they do the behind the scenes configuration for you. But I think there are other steps required that the Intermec guide covers. They could have changed how it works in 9.01 as well, but unfortunately I have no actual install experience there.

Stephen Cena

Legacy Contributor

In that case, it may be event system based in 9.01. If that is the case, you may want to look at the Event Status and Event Handler Status forms and see if there are any records related to the Data Collection process. Also there is a Validate Data Collection Transactions form to reset the status of the records in the Data Collections tables. You might want to set that up to run every day. user Id I believe is the user initials from the users form.

Stephen Cena

-Checked the Event forms. No entries since 2018 (my last project that used the AES)

-Ran Validate Data Collections. Re-validated all entries. Entry is still sitting in dcmoves_mst.

Stephen Cena

I deleted the BGTask & tried to recreate it. Now I'm getting "Task Name is invalid".

Copyright © 2025 Infor. All rights reserved.