Re: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
hi yes, //progress.setTotal(sysQuery::countTotal(queryRun),2); has a bug it tries to join all records in inventtable with all the records in inventtxt table. We commented out this part and consistency check was fine. I am not happy with this though, if there is a bug in SysQuery then its going to affect somewhere else. regards harry "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: ok. How do you filter the records which ones have problemswhen you try to delete BOM lines and reload them. Anyway,Since its your system, you know it better :-) Coming to the consistency check, it took sometimes 20 - 40 hours to get the consistency report. We asked Microsoft what the heck its doing for 20 hours. Microsoft asked me to comment out the line in class SysConsistencyCheck/KernalCheckRecords //progress.setTotal(sysQuery::countTotal(queryRun),2); run it, it will take less than 1 hour. There should be a solution for every question. Morever, I advise you to use this tool. It saves you a lot of time. Just based on my exp, I am giving you hints. best of luck. "Philip R. Freimann" [EMAIL PROTECTED] wrote: We wanted to run a consistency check but it takes so long it's not practical. We are in the process of deleting all the BOM lines that do not match. They were mostly items that should have been deleted in the old system.--- In Axapta-Knowledge-Village@yahoogroups.com, "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Philip, I suggest you to do following. As you are aware, since we also migrated huge volume of SAP to axapta, we too have these kind of problems due to bad data. as per my experience , I suggest you to do the following. 1. As Jens mentioned you can write a simple job to get the info log of all the missing items. However, at the same time you may need to check reqItemTable, InventItemlocation etc ect for that missing items. 2. I strongly suggest to run consistency check for the whole company on all the modules. Its very important to run consistency check after you migrated the data. Eventhough consistency check will not tell everything, but defintely catch these kind of problems. Best of Luck. Thanks, subbuJens Strandberg [EMAIL PROTECTED] wrote: Exactly. Just create a small job that runs through all BOM lines and lookup each itemid. The ones, that do not exist in InventTable, will create problems. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 19:19 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages That's a possibility. We just converted and went live last month. How could I identify this? just match the BOM lines against InventTable items? --- In Axapta-Knowledge-Village@yahoogroups.com, "Jens Strandberg" [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error MessagesI have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? "Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated." Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKSVisit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS
[Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
Many thanks to you, Jens. You were absolutely correct. We had 1400 BOM lines that did not have an InventTable record. We removed them and now we have a good Forecast scheduling and Master scheduling run. /Philip --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h57gjvo/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123691273/A=2894350/R=0/SIG=10tj5mr8v/*http://www.globalgiving.com;Make a difference. Find and fund world-changing projects at GlobalGiving/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
We wanted to run a consistency check but it takes so long it's not practical. We are in the process of deleting all the BOM lines that do not match. They were mostly items that should have been deleted in the old system. --- In Axapta-Knowledge-Village@yahoogroups.com, Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Philip, I suggest you to do following. As you are aware, since we also migrated huge volume of SAP to axapta, we too have these kind of problems due to bad data. as per my experience , I suggest you to do the following. 1. As Jens mentioned you can write a simple job to get the info log of all the missing items. However, at the same time you may need to check reqItemTable, InventItemlocation etc ect for that missing items. 2. I strongly suggest to run consistency check for the whole company on all the modules. Its very important to run consistency check after you migrated the data. Eventhough consistency check will not tell everything, but defintely catch these kind of problems. Best of Luck. Thanks, subbu Jens Strandberg [EMAIL PROTECTED] wrote: Exactly. Just create a small job that runs through all BOM lines and lookup each itemid. The ones, that do not exist in InventTable, will create problems. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 19:19 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages That's a possibility. We just converted and went live last month. How could I identify this? just match the BOM lines against InventTable items? --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h76koat/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123598686/A=2894352/R=0/SIG=11fdoufgv/*http://www.globalgiving.com/cb/cidi/tsun.html;Help tsunami villages rebuild at GlobalGiving. The real work starts now/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
That's a possibility. We just converted and went live last month. How could I identify this? just match the BOM lines against InventTable items? --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12h6cj306/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123269518/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
Exactly. Just create a small job that runs through all BOM lines and lookup each itemid. The ones, that do not exist in InventTable, will create problems. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 19:19 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages That's a possibility. We just converted and went live last month. How could I identify this? just match the BOM lines against InventTable items? --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0 from another system. Our problem was that we had imported BOM lines pointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Philip R. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated. Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hcfo8ij/M=362131.6882500.7825259.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1123283030/A=2889190/R=0/SIG=10r90krvo/*http://www.thebeehive.org Put more honey in your pocket. (money matters made easy) Welcome to the Sweet Life - brought to you by One Economy/a./font ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Master Scheduling: Error Messages
Hi Philip, I suggest you to do following. As you are aware, since we also migrated huge volume of SAP to axapta, we too have these kind of problems due to bad data. as per my experience , I suggest you to do the following. 1. As Jens mentioned you can write a simple job to get the info log of all the missing items. However, at the same time you may need to check reqItemTable, InventItemlocation etc ect for that missing items. 2. I strongly suggest to run consistency check for the whole company on all the modules. Its very important to run consistency check after you migrated the data. Eventhough consistency check will not tell everything, but defintely catch these kind of problems. Best of Luck. Thanks, subbu Jens Strandberg [EMAIL PROTECTED] wrote: Exactly. Just create a small job that runs through all BOM lines and lookupeach itemid. The ones, that do not exist in InventTable, will createproblems./Jens-Oprindelig meddelelse-Fra: Axapta-Knowledge-Village@yahoogroups.com[mailto:[EMAIL PROTECTED] vegne af Philip R.FreimannSendt: 5. august 2005 19:19Til: Axapta-Knowledge-Village@yahoogroups.comEmne: [Axapta-Knowledge-Village] Re: Master Scheduling: Error MessagesThat's a possibility. We just converted and went live last month.How could I identify this? just match the BOM lines againstInventTable items?--- In Axapta-Knowledge-Village@yahoogroups.com, "Jens Strandberg"[EMAIL PROTECTED] wrote: Hello there, Have faced similar problem after converting data into Axapta 3.0from another system. Our problem was that we had imported BOM linespointing to items, that were not created in InventTable. This could be your situation too... /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne afPhilipR. Freimann Sendt: 5. august 2005 16:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] Master Scheduling: Error Messages I have the following error messages at the end of the Master scheduling run. There are no item specific error messages. These are the only messages. Can someone tell me what they mean? Do they mean the explosion did not complete? If so where did it stop or how much did it complete? "Master scheduling Cannot edit a record in Item table (InventTable) The record has never been selected. Item levels are not updated. Item coverage is updated." Thanks - we're new to Axapta Master scheduling. Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta.Yahoo! Groups Links__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.