jatin_sanghi
5th June 2006, 06:18
Hi all,

Last night we had a table reorganise for our company.

we are on LN6.1 SP2, sql server 2000 Sp3

after the reorganise, when we are trying to get to the dimensions from "group company parameters " we are getting the DB Error 308 error 1308 on table tfgld002. When i try to go through GTM it again gives the same error.

even if i try to drop the table i doesn't allow as the "connection to server lost message comes up"

This problem is happening only for companies we run the reorganise. in other companies it is running fine.

Please suggest something...as we are not able to make any financial transactions.


regards,
Jatin

dave_23
5th June 2006, 18:17
Reconfig failed to re-create your index.

Error 308 =
Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.

gcommand might be able to fix it

Create a file called gc1.txt:
#1 tfgld002 TCRI 9999 -p 0

Run the following command from a CMD prompt (on the server):
gcommand gc1.txt <company number>

bdbpre/bdbpost may work as well if bdbpre can get the data out.

good luck!

Dave