Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 12 total |
Verify Table problem. |
Wed, Jun 6 2018 4:51 AM | Permanent Link |
Ian Branch | Hi Team,
A small issue. Working in EDB Mgr. Given I have the following tables - LineItems, ALineItems & _ALineitems, all exactly the same structure and with data in them, I am testing using "VERIFY TABLE xxxxxxxxx". Works for for LineItems & _ALineItems however it falls over with ALineItems with the following error.. "ElevateDB Error #401 The table alineitems does not exist in the schema Default" Ummm. Not sure what's missing. I can see, open & edit it in its DB in EDB Mgr. It opens and appears in my App. Yet I get the error message. Is ALineItems reserved somewhere? Thoughts/suggestions appreciated. Regards & TIA, Ian |
Wed, Jun 6 2018 6:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
When something like that has happened to me its usually because I'm running the SQL fom the wrong context. In EDBManager look at the bottom right hand side. There are four items: Session name Database Mode (insert/overwrite) Position (eg 1:1) Make sure the session name and database are right. I often find that I'm in the configuration database Roy Lambert |
Wed, Jun 6 2018 3:16 PM | Permanent Link |
Ian Branch | Hi Roy,
IN EDBMgr, all tables are created at the same time with the same parameters.. Session - Default Database - DBiWorkflow Insert. 1:1 Haven't created any other sessions than the Default. Attached is a screenshot. Interestingly, if I use the 'EDBMgr 'Verify Table' Task for table it doesn't give any error. If I try to do it in SQL. NG. I have no doubt it is something simple but what? Regards, Ian Attachments: Screenshot_2.jpg |
Wed, Jun 6 2018 5:13 PM | Permanent Link |
Malcolm Taylor | Is it my eyesight or is the actual name of the table: "ALineiItems"?
Note the lowercase i before the Uppercase I But it could be my eyes. |
Wed, Jun 6 2018 5:36 PM | Permanent Link |
Ian Branch | Hi Malcolm,
Yes, the name is ALineItems. Capital A, L & I. It is the Archive equivalent of LineItems. Hence the 'A'. _ALineItems is the long term archive of ALineItems. Rough usage is.. Line Items - Current data. ALineitems - Completed LineItems more than 6 months old. _ALineItems - ALineItems more than 12 months old. All have the same table structure. Regards, Ian |
Wed, Jun 6 2018 5:40 PM | Permanent Link |
Ian Branch | Correction, in the image it is in fact a lower case i between e & t. Shouldn't make any difference though.
|
Wed, Jun 6 2018 6:44 PM | Permanent Link |
Ian Branch | AH HA!
Hi Malcolm, Didn't see what you saw - ALineiItems. 'iI' in there. Deleted the 'i' in the table name. All good now. Great spotting. Regards, Ian |
Wed, Jun 6 2018 6:56 PM | Permanent Link |
Malcolm Taylor | Ian Branch wrote:
> Didn't see what you saw - ALineiItems. I have learned that Tim is not inclined to tell porkies. If he says the table or whatever is not in the schema .. we should believe him and start looking for typos, the wrong context, etc. |
Thu, Jun 7 2018 3:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Malcolm
Well done - I think I need a bigger font even though I've just got new specs! Roy Lambert |
Thu, Jun 7 2018 4:57 AM | Permanent Link |
Malcolm Taylor | Roy Lambert wrote:
> Malcolm > > > Well done - I think I need a bigger font even though I've just got > new specs! > > Roy Lambert You didn't have the benefit of the screenshot so covered the usual context issue. Given the screenshot and with context eliminated, it had to be the classic 'Fools Gold' scenario .. it looks like 'ALineItems' so it must be 'ALineItems'. <bg> Now, how many times have I fallen into that one? |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |