hardei
29th August 2007, 13:04
Hi Guys,
while installing service packs from 1 to 18. i am getting error.please find attached error file.

Thnx in advance..

Regards,
Hardei

Marioth
29th August 2007, 13:17
Hi Hardei,

The error says it all. You are missing tables. After installing new service packs always run session ttaad4230m000 - Create Tables and afterwards Convert to Runtime. This will solve a lot of problems for in the future.

Regards,

Mario

hardei
29th August 2007, 13:31
Mario,
Thanks for your reply.But i havent installed single sp on the server.while installing only i am getting error 506

kaukul
29th August 2007, 14:03
Still, you have to create table...are you able to login to system ?

hardei
29th August 2007, 14:29
Hi,
I can login to baan .but while creating tables i am getting error 251..for some of the tables..and when i check from GTM..i can see those tables

kaukul
29th August 2007, 14:53
Hi,

Your audit server setup is not correct. Go to $BSE/log/log.audit, where you can check for errors.

Go to session ttaad4110m000 and check that 2 entries are present with one having "Audit Trail" box checked.

Then, if required convert to runtime this data and then, logout and login to create tables...

Regards,
Kaustubh

kaukul
29th August 2007, 14:58
Attached..

hardei
29th August 2007, 15:12
Hi Kaustubh,
I checked in ttaad4110m000 having 2 entries with one having Audit Trail box checked

sukesh75
29th August 2007, 15:20
But i havent installed single sp on the server.while installing only i am getting error 506

Hardei,
What session were you running while you got the error? Did you take care of creating update vrc's and initializing pmc?

sk

kaukul
29th August 2007, 15:23
Check log.audit file in $BSE/log...that will give you hint.

Also, go to special of session ttaad4110m000 and run convert to runtime and relogin and then try to create tables again.

This should work...

hardei
29th August 2007, 15:28
HI,
Following error message i m getting
2007-08-28[20:59:45]:E:bsp: Errno 0 bdb_errno 0
2007-08-28[20:59:45]:E:bsp: Log_mesg: Table tdpst000550 has 20 audited columns
but no audit DD !! Probably handle_ddinfo had failed

kaukul
29th August 2007, 15:41
Seems your audit setup is not correct. Go to session ttaad4116m000 and check for audit setup. Then, go to special and convert to runtime the data.

After relogging try the process...

hardei
29th August 2007, 17:59
Hi,
we installed oracle,dumped the data from live server,company on live server is 100..which is not created on test server..test server we have created 550 company..this can be a prob for gicing errors while installing service packs?

jclju1
29th August 2007, 18:42
we installed oracle,dumped the data from live server,company on live server is 100..which is not created on test server..test server we have created 550 company..this can be a prob for gicing errors while installing service packs?
No, this can't be a problem. I think that you have to create RTDD for tools package, after that create missing tools table(s) and then try to continue with installation.

kaukul
30th August 2007, 06:32
Hi,
we installed oracle,dumped the data from live server,company on live server is 100..which is not created on test server..test server we have created 550 company

1. When you transferred data from live server the tables with suffix "100" must have got created on test server. You have to rename these to tables with suffix "550", if you want to use them on test server.

2. Have you attached company 550 to correct package combination?

hardei
30th August 2007, 12:00
Hello Frnds,
Problem is solved..First i ran toold service packs.i forgot to create tools tables 423,425 after running service packs...service packs are uploaded

thanks a lot for your help guys