baanspider
19th August 2008, 18:27
Hi
did anyone face this before?
After migrating ttadv380/381/382 to new server, i cannot find my queries in ttadv381 anymore.
Please help
thanks n regards
NPRao
19th August 2008, 19:51
After migrating ttadv380/381/382 to new server, i cannot find my queries in ttadv381 anymore.
How did you migrate them between 2 environments? Did you use ttiex1280m000 and ttiex1285m000? Were there any entries in ttadv381 in the source system?
baanspider
20th August 2008, 03:39
Hi
I used create seq dump and create table from seq dump sessions for the migration.
I noticed too that in the old server, I could see the some records in ttadv381 but some records is missing.
What I mean is if I use the session ttadv3181m000, the record is shown here but when I use ttaad4100, the records are not there. Why so weird?
Where else should I check?
thanks n regards
mark_h
21st August 2008, 00:26
Isn't the query information in company 0? The tables and the text fields. Do you copy company 000 also?
baanspider
21st August 2008, 03:32
yes i copied all three tables in 000
and the text field were also copied from 000
baanspider
21st August 2008, 03:34
I have another DR server and I just noticed that the SQL queries are all there in ttadv3180m000 and ttadv3181m000 but ttadv381 in co 000 is completely empty. why?
It must be keeping it somewhere else.
rgds
NPRao
21st August 2008, 03:44
baanspider,
To give you a simple answer for your issues -
You have use ttiex1280m000 and ttiex1285m000 and do the process the right way.
By executing the table import/export data with the text numbers you might have lost the text field number reference for the field ttadv380 (.selc)