SRF compiles takes too long after on mssql

hi everyone, I have done a repository migration using repimexp.exe. first I exported the development repository, then I renamed the target test repository and then I imported the exported development file into test. I got no errors on export or import, I can see all then changes I made in the target environment, but when I try do a full compile the process takes too long, even if I leave it over night, it does not complete. am I missing a step anywhere? like a ddl synch or something? I only see that tables were exported and imported, I do not see where indexes and triggers etc... are being dropped and recreated or just recreated... I know there are couple of other ways to do a migration, but I really want to know what did miss in this migration and how can I look at what is going on given that siebdev.log is not showing anything.thanks
rouba

Popular White Paper On This Topic

My friend
Please check SIEBEL_LOG_EVENTS parameter on the machine where you are doing
compile from. This is in My Computer, Properties->Advanced->Environment
Variables section
If it is set to very high it will compile for a long time. reduce it.

thanks, I was not generating logs earlier, but I just set it to 4 in fact to try and see what is going on. also if I open the older repository, the one that was there before, the compile process takes about 22 minutes. so I am thinking the problems lies within the new migrated repository.
thanks
rouba

Hi Rouba El-Ali, i too am having a similar issue. We did a DB refresh from Prod to Dev. Prior to that I did an export of the existing repository and reimported after the DB refresh was completed. When I try to compile, it takes over 1+ hrs to finish. I opened an SR with Oracle and waiting on their response. When I hear back from them, I will let u know.

Hi Rouba El-Ali, i too am having a similar issue. We did a DB refresh from Prod to Dev. Prior to that I did an export of the existing repository and reimported after the DB refresh was completed. When I try to compile, it takes over 1+ hrs to finish. I opened an SR with Oracle and waiting on their response. When I hear back from them, I will let u know.

ok, yes please post their reply, but I did do a second repository migration, the same exact steps as the first one and this time everything compiled within 20 minutes, I think the action of refreshing lower environments with production could be causing this issue when not using the migration utility or one of the other applications that apply schema changes as well as moving the repository, I am just brain storming here :)

Hi Rouba El-Ali,
Repository migration from source to target is step by step process hopefully you might have followed it correctly.
1. Export the repository from the source
2. Import the repository into the target with different name other the Siebel Repository (EG : Siebel Rep2008sep15)
3. Flip the repository using Siebel Tools connected to the target env.
4. Execute the Bumpver.sql (Assuming you have oracle DB at the backend.DB2 DB has similar steps with an additional step of creating CTL file).
5. Run the DDLSYNCH
6. One can copy the fully compiled SRF from Source to target or do a full compile again in the target env.
7. Generate the GENB files & copy it to Webservers.
8. Stop Servers in a sequence (Webservers,Siebel App servers (No need to stop Gateway)),replace the SRF,start the servers in the reverse order.
9. Validate.
Hope this helps.
Thanks & Regards,
M.Prabu Shanker.

Hi Rouba, Oracle asked us to bump up loging on the SIEBEL_LOG_EVENTS (which was already done) and we analyzed the file. We noticed there were to queries taking 30 mins. We sent those to our DBA and asked us to remove any old siebel respository files. Doing that, speed up our compile. You may want to try that as well if you keep any old compiles.
Thanks.