Error creating new item in RMS 3.

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Error creating new item in RMS 3. RMS Rookie 12-17-2008  RE: Error creating new item in RMS 3. jocelynp 12-17-2008  Re: Error creating new item in RMS 3. RMS Rookie 12-19-2008  Re: Error creating new item in RMS 3. Craig 12-19-2008  Re: Error creating new item in RMS 3. Boggie 12-24-2008
Posted by RMS Rookie on December 17, 2008, 1:23 pm Please log in for more thread options I get the following error when I try to add some new items. "The Item Lookup Code must be unique". If we search for the item, no records are found. All items are active, (we got this error initially when some items had been made inactive and we tried to add the same ILC as a new item). There are 11,000 items in the msde SQL 2000 database and the usage percentage is about 94%. The database has been re-indexed with no change in this error. Can the database be compacted to remove any excess data? Is there potential damage to the database if we delete old items? How can the database be repaired if there is damage? Thanks for you help in advance. Kent Smith Posted by jocelynp on December 17, 2008, 11:17 pm Please log in for more thread options Kent - What is version of RMS are you running? When you talk about the db size, are you referring to HQ or SO? Because 11,000+ items is not a large item db, I am wondering if your db's log file was truncated at inception. Do you know? Did you create your environment? As for your items - have you done an extensive db search against your ILC? Is it possible that you have the item already used in an an alias? -- Jocelyn "RMS Rookie" wrote: > I get the following error when I try to add some new items. > > "The Item Lookup Code must be unique". > > If we search for the item, no records are found. > > All items are active, (we got this error initially when some items had been > made inactive and we tried to add the same ILC as a new item). > > There are 11,000 items in the msde SQL 2000 database and the usage > percentage is about 94%. > > > The database has been re-indexed with no change in this error. > Can the database be compacted to remove any excess data? > > Is there potential damage to the database if we delete old items? > > How can the database be repaired if there is damage? > > Thanks for you help in advance. > > Kent Smith > > > > > Posted by RMS Rookie on December 19, 2008, 1:46 am Please log in for more thread options "Jeff @ Check Point Software" wrote: > Rookie, > > Try using the Find button and select All. As Jocelyn mentioned, its probably an Alias, which is at the very bottom on the Find button list. > > 94% means that the last time the database grew, you have used 94% of that. You need to be more concerned with the database size, which can be a maximum of 2 gig for MSDE, 4 gig for SQL 2005 Express, both which shipped free with RMS. The size is unlimited with all other versions of SQL Server. To find out what version you have, look in Add/Remove Programs in the Control Panel. > > -- > > Jeff > Check Point Software > > Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS) > ===================================================== > > You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to > see and download the file attachment(s). If you are not using a reader, follow > the link below to setup Outlook Express. Click on "Open with newsreader" > under the MS Retail Management System on the right. > > http://tinyurl.com/75bgz > ===================================================== > > > I get the following error when I try to add some new items. > > "The Item Lookup Code must be unique". > > If we search for the item, no records are found. > > All items are active, (we got this error initially when some items had been > made inactive and we tried to add the same ILC as a new item). > > There are 11,000 items in the msde SQL 2000 database and the usage > percentage is about 94%. > > > The database has been re-indexed with no change in this error. > Can the database be compacted to remove any excess data? > > Is there potential damage to the database if we delete old items? > > How can the database be repaired if there is damage? > > Thanks for you help in advance. > > Kent Smith > > > > > Q1 When you talk about the db size, are you referring to HQ or SO? A1 Store Operations. Because 11,000+ items is not a large item db, I am wondering if your db's log file was truncated at inception. Q2 Do you know A2 No. Q3 Did you create your environment? A3 The original RMS SO was installed about 2 or 3 years ago and I performed that original install. Q4 As for your items - have you done an extensive db search against your ILC? A4 Yes. Both with SOM and also directly via Admin SQL query. Q5 Is it possible that you have the item already used in an an alias? A5 I don't belive so, When I run an Alias report, the result is no records. Try using the Find button and select All. As Jocelyn mentioned, its probably an Alias, which is at the very bottom on the Find button list. Anwer: I have tried this and have not found any alias, substitute, or other record with the same ILC. 94% means that the last time the database grew, you have used 94% of that. You need to be more concerned with the database size, which can be a maximum of 2 gig for MSDE, 4 gig for SQL 2005 Express, both which shipped free with RMS. The size is unlimited with all other versions of SQL Server. To find out what version you have, look in Add/Remove Programs in the Control Panel. Answer: I am using SO version 1.3.1002. I am still stumped. Thanks for your suggestions. Posted by Craig on December 19, 2008, 9:33 am Please log in for more thread options You want to get off version 1.3.1002 as soon as you can. There is a known bug in that build that will screw up your pricing. I don't remember the exact issue, just that it's very bad. Craig > > > "Jeff @ Check Point Software" wrote: > >> Rookie, >> >> Try using the Find button and select All. As Jocelyn mentioned, its >> probably an Alias, which is at the very bottom on the Find button list. >> >> 94% means that the last time the database grew, you have used 94% of >> that. You need to be more concerned with the database size, which can be >> a maximum of 2 gig for MSDE, 4 gig for SQL 2005 Express, both which >> shipped free with RMS. The size is unlimited with all other versions of >> SQL Server. To find out what version you have, look in Add/Remove >> Programs in the Control Panel. >> >> -- >> >> Jeff >> Check Point Software >> >> Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS) >> ===================================================== >> >> You must be using Outlook Express/Windows Mail or some other type of >> newsgroup reader to >> see and download the file attachment(s). If you are not using a reader, >> follow >> the link below to setup Outlook Express. Click on "Open with newsreader" >> under the MS Retail Management System on the right. >> >> http://tinyurl.com/75bgz >> ===================================================== >> >> >> I get the following error when I try to add some new items. >> >> "The Item Lookup Code must be unique". >> >> If we search for the item, no records are found. >> >> All items are active, (we got this error initially when some items had >> been >> made inactive and we tried to add the same ILC as a new item). >> >> There are 11,000 items in the msde SQL 2000 database and the usage >> percentage is about 94%. >> >> >> The database has been re-indexed with no change in this error. >> Can the database be compacted to remove any excess data? >> >> Is there potential damage to the database if we delete old items? >> >> How can the database be repaired if there is damage? >> >> Thanks for you help in advance. >> >> Kent Smith >> >> >> >> >> > Q1 When you talk about the db size, are you referring to HQ or SO? > A1 Store Operations. > > > > Because > 11,000+ items is not a large item db, I am wondering if your db's log file > was truncated at inception. > > Q2 Do you know > A2 No. > > Q3 Did you create your environment? > A3 The original RMS SO was installed about 2 or 3 years ago and I > performed > that original install. > > Q4 As for your items - have you done an extensive db search against your > ILC? > A4 Yes. Both with SOM and also directly via Admin SQL query. > > Q5 Is it possible that you have the item already used in an an alias? > A5 I don't belive so, When I run an Alias report, the result is no > records. > > Try using the Find button and select All. As Jocelyn mentioned, its > probably > an Alias, which is at the very bottom on the Find button list. > > Anwer: I have tried this and have not found any alias, substitute, or > other > record with the same ILC. > > > 94% means that the last time the database grew, you have used 94% of that. > > You need to be more concerned with the database size, which can be a > maximum > of 2 gig for MSDE, 4 gig for SQL 2005 Express, both which shipped free > with > RMS. The size is unlimited with all other versions of SQL Server. > > > To find out what version you have, look in Add/Remove Programs in the > Control Panel. > > Answer: I am using SO version 1.3.1002. > > I am still stumped. > > Thanks for your suggestions. > > > > > > Posted by Boggie on December 24, 2008, 9:43 am Please log in for more thread options Do you have any inactive items? Cheers "Craig" wrote: > You want to get off version 1.3.1002 as soon as you can. There is a known > bug in that build that will screw up your pricing. I don't remember the > exact issue, just that it's very bad. > Craig > > > > > > > "Jeff @ Check Point Software" wrote: > > > >> Rookie, > >> > >> Try using the Find button and select All. As Jocelyn mentioned, its > >> probably an Alias, which is at the very bottom on the Find button list. > >> > >> 94% means that the last time the database grew, you have used 94% of > >> that. You need to be more concerned with the database size, which can be > >> a maximum of 2 gig for MSDE, 4 gig for SQL 2005 Express, both which > >> shipped free with RMS. The size is unlimited with all other versions of > >> SQL Server. To find out what version you have, look in Add/Remove > >> Programs in the Control Panel. > >> > >> -- > >> > >> Jeff > >> Check Point Software > >> > >> Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS) > >> ===================================================== > >> > >> You must be using Outlook Express/Windows Mail or some other type of > >> newsgroup reader to > >> see and download the file attachment(s). If you are not using a reader, > >> follow > >> the link below to setup Outlook Express. Click on "Open with newsreader" > >> under the MS Retail Management System on the right. > >> > >> http://tinyurl.com/75bgz > >> ===================================================== > >> > >> > >> I get the following error when I try to add some new items. > >> > >> "The Item Lookup Code must be unique". > >> > >> If we search for the item, no records are found. > >> > >> All items are active, (we got this error initially when some items had > >> been > >> made inactive and we tried to add the same ILC as a new item). > >> > >> There are 11,000 items in the msde SQL 2000 database and the usage > >> percentage is about 94%. > >> > >> > >> The database has been re-indexed with no change in this error. > >> Can the database be compacted to remove any excess data? > >> > >> Is there potential damage to the database if we delete old items? > >> > >> How can the database be repaired if there is damage? > >> > >> Thanks for you help in advance. > >> > >> Kent Smith > >> > >> > >> > >> > >> > > Q1 When you talk about the db size, are you referring to HQ or SO? > > A1 Store Operations. > > > > > > > > Because > > 11,000+ items is not a large item db, I am wondering if your db's log file > > was truncated at inception. > > > > Q2 Do you know > > A2 No. > > > > Q3 Did you create your environment? > > A3 The original RMS SO was installed about 2 or 3 years ago and I > > performed > > that original install. > > > > Q4 As for your items - have you done an extensive db search against your > > ILC? > > A4 Yes. Both with SOM and also directly via Admin SQL query. > > > > Q5 Is it possible that you have the item already used in an an alias? > > A5 I don't belive so, When I run an Alias report, the result is no > > records. > > > > Try using the Find button and select All. As Jocelyn mentioned, its > > probably > > an Alias, which is at the very bottom on the Find button list. > > > > Anwer: I have tried this and have not found any alias, substitute, or > > other > > record with the same ILC. > > > > > > 94% means that the last time the database grew, you have used 94% of that. > > > > You need to be more concerned with the database size, which can be a > > maximum > > of 2 gig for MSDE, 4 gig for SQL 2005 Express, both which shipped free > > with > > RMS. The size is unlimited with all other versions of SQL Server. > > > > > > To find out what version you have, look in Add/Remove Programs in the > > Control Panel. > > > > Answer: I am using SO version 1.3.1002. > > > > I am still stumped. > > > > Thanks for your suggestions. > > > > > > > > > > > > > Similar Threads Posted Error when creating new SKU's in RMS, Row cannot be located for u September 18, 2008, 7:31 am Creating Add In Using VB 6 Error - Could not create object October 18, 2009, 1:30 pm MS Store Operations v1.2 error creating new customer June 9, 2007, 1:58 pm Error -2147217900 Creating matrix items February 9, 2009, 2:23 pm set item tax for each store when creating item in HQ January 24, 2007, 7:13 pm POS (Not RMS) Item Not Found After Creating January 15, 2008, 3:31 pm Bug in creating new item in Purchase order module? January 8, 2008, 10:47 pm Allow existing items lookup when creating a Kit with New Item Wiza July 14, 2005, 3:41 pm error: item was not comitted MS POS January 3, 2007, 10:30 pm Item Search Error July 30, 2009, 11:40 pm