ISTech Support Forum - fileloc for ISARTXN.B12-4 ...when changing part#s

Welcome, Guest. Please Login.

	05/04/24 at 13:38:11 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›

Pages: 1

fileloc for ISARTXN.B12-4 ...when changing part#s (Read 3860 times)

Laura Oliver Active Member Posts: 984 Gender:	fileloc for ISARTXN.B12-4 ...when changing part#s 12/11/13 at 18:47:00 Trying to change a part number in system manager and got this errror .... A record was not found in fileloc for ISARTXN.B12-4 I have not needed to change a part number since our server upgrade in July 2012. Also we use company B12 as our main DBA. Any and all help appreciated. Thanks Laura
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Laura Oliver Active Member Posts: 984 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #1 - 04/06/15 at 14:17:38 Hello, I never got this fixed. I was once again trying to change a part number in SM-J-L and I keep getting this error message: " A record was not found in fileloc for file ISARATXN.B12-4 Any and all help appreciated. Thanks Laura
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #2 - 04/07/15 at 08:43:31 Hi, I opened that table but it is empty. Could you verify if the table exist on your system? Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #3 - 04/07/15 at 09:06:47 The file would only have entries if you ship serialized items and have archived invoices for serialized items.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Laura Oliver

Active Member

Posts: 984
Gender: female

Re: fileloc for ISARTXN.B12-4 ...when changi
Reply #4 - 04/10/15 at 09:42:59

Kelloggs,
You are always so helpful. I am going to go try to figure out how to "open the table". We do serialize a few parts. So if I can figure out how to open the table, I assume I will see serialized archived parts based on what Lynn said.

I will try re-indexing too, but I am always scared to re-index, because I don't understand it. I think I can reindex just that file.

Just out curiosity.... what does the "-4" denote at the end of ISARATXN.B12-4 ?
Thanks,
Laura

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #5 - 04/10/15 at 10:53:52 If you serialized parts you have that table. The problem must be something else Sorry I coundn't help Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Laura Oliver Active Member Posts: 984 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #6 - 04/10/15 at 11:03:15 How would I know if I have that table? Where do I look for the tables? I have no idea what UT-H (print file layout) does. but I thought the table may be found in UT-H. But ISARATXN doesn't show up in UT-H. Thanks Laura
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Laura Oliver Active Member Posts: 984 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #7 - 04/10/15 at 11:14:08 Nor is ISARATXN.B12 found in Maintain database. But I do see ISARTXNB.B12 in maintain data base for future reference: I think I left out an A in the subject when I started this thread. ISARATXN.B12-4 is correct. The error message I get when changing a part number does say ISARATXN.B12
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: fileloc for ISARTXN.B12-4 ...when changi
Reply #8 - 04/10/15 at 12:36:40

Quote from Laura Oliver on 04/10/15 at 11:14:08:

Nor is ISARATXN.B12 found in Maintain database.

so you are missing a table ?
if that is the case you can use TAS-E to create that table.

If you aren't sure what to do please contact Lynn for support

undecided

Kelloggs

PD: becareful with the TAS-E program it will erase all your data if you are not careful

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Laura Oliver Active Member Posts: 984 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #9 - 04/16/15 at 05:42:01 Thanks,
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Laura Oliver

Active Member

Posts: 984
Gender: female

Re: fileloc for ISARTXN.B12-4 ...when changi
Reply #10 - 06/23/15 at 14:23:02

Yes, I am missing ISARATXN.B12. It is not in the 12 folder. (which is where our current company data is)
But I do have ISARATXN.B in the default folder.

Rather than creating that table in the dangerous TAS-E, can I just copy the ISARATXN.B and rename it?

I bet I can't, because I assume that TAS-E creates it with the most up todate data.

Thanks
Laura

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com

IP Logged

Laura Oliver Active Member Posts: 984 Gender:	Re: fileloc for ISARTXN.B12-4 ...when changi Reply #11 - 06/23/15 at 14:57:47 Back in 2013 Lynn suggested . Quote from Lynn_Pantic on 11/01/13 at 10:50:35: UT-A, T7DDCHECK (Evo) or DDCHECK (DBA). It looks like the update didn't do everything it needed to. http://www.istechforum.com/YaBB.pl?num=1383320968/1#1 Maybe this will work instead of TAS-E
Back to top	Laura D. Oliver classic DBA since 1997 EVO on Amazon server as of 5-2022 DIXIE PRECISION INC. Birmingham, Alabama (205)- 841-8400 www.dixieprecision.com IP Logged

Laura Oliver

Active Member

Posts: 984
Gender: female

Re: fileloc for ISARTXN.B12-4 ...when changi
Reply #12 - 06/23/15 at 16:00:26

Success!

I tried to run ddcheck several time in dba, but kept getting the error .... Tb5wdba.exe has stopped. A problem caused the program to close.

So I ran T7ddcheck in evo and got a 11 page report of files that don't exist. All but one of the million errors were from a test company long deleted. I then went to delete the previously deleted play company but it was not found when I pushed F2. But I manually typed in the company extension and the program acted like it deleted the supposedly previously deleted company. Even though It could not found in the search box the old deleted company was obviously there.. I reran t7ddcheck and this time got a single error. I then went and ran ddcheck in dba and got the same one error report.
So It appears that the remnant dormant files from the previously deleted company were not allowing me to change the name of part numbers.

Hope this helps someone in the future.

Laura's ipad

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com

IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›