Support

Customer Information

Company Name LINCOLN FOODSERVICE PRODUCTS INCORPORATED
Customer Number 108756

Call Details

Note: It may take a few minutes for recent changes to be visible. Refresh Data

Number 5311076
Status Closed
Priority Critical
Change call priority
Escalation Status Not Available
Escalate this call
ITAR No
Created Date 10-Aug-2006
Last Updated 15-Aug-2006
Closed Date 15-Aug-2006
Call Type Technical Support
Caller Name JETT, LAWRENCE (ljett@lincolnfp.com)
Assignee Name VASUDEVAN, SANDHYA
Description Successfully completed Data Migration.MethodServer times out after rebooting the Windchill server.
Resolution Refer call notes for queries.Resolved

Affected Products

Product Windchill PDMLink
Module Migration (Product to Product)
Release 8.0
Datecode M020

Workstation Keywords

Category Type Value

None Available


Related Documents

Type Number Status Description

None Available


Notes

To add a note to this call please use the following link.
Date Description
15-Aug-2006 From: Vasudevan, Sandy
Sent: Tuesday, August 15, 2006 1:42 PM
To: 'ljett@lincolnfp.com'
Subject: RE: C5311076 - PTC Technical Support


Hi Lawrence,

Thanks for your patience.Could you please try this.Log in as system or sys and execute this command.

show parameters spfile

If your output looks like this: %ORACLE_HOME%\DATABASE\SPFILE% ORACLE_SID%.ORA
then please execute the following: Please note this will use about 600M of memory.You can change it according to your system memory.

alter system set sga_max_size=430M scope=spfile;
alter system set db_cache_size=275M scope=spfile;
alter system set shared_pool_size=100M scope=spfile;
alter system set large_pool_size=10M scope=spfile;
alter system set java_pool_size=1M scope=spfile;
alter system set optimizer_index_caching=90 scope=spfile;
alter system set optimizer_index_cost_adj=10 scope=spfile;
alter system set db_file_multiblock_read_count=4 scope=spfile;
alter system set pga_aggregate_target=100000000 scope=spfile;
If the output is blank:
update or edit the init<sid>.ora file with:....(sid is your database service name..can be found in db.properties: wt.pom.serviceName )
sga_max_size=430M
 db_cache_size=275M
 shared_pool_size=100M
 large_pool_size=10M
 java_pool_size=1M
 optimizer_index_caching=90
 optimizer_index_cost_adj=10
 db_file_multiblock_read_count=4
 pga_aggregate_target=100000000

Please restart your database.Let me know if this works for you.
Thanks,
Sandy
15-Aug-2006 New Call Note
Source = web
By = Jett, Lawrence(ljett@lincolnfp.com)
------
Sending another file. I found more files that contain init.ora in the file name:

Found them under:

D:\oracle\ora92\database

& the names pertain to my wind sid.

I will attach another zip to this call. the zip will also contain the last init.ora.#### that I attached to this call.

It was located in:

D:\oracle\admin\wind\pfile

Through all them, maybe we can see where we can get my windchill running. Please obtain dba to help with this, since this call has been too many days in the queue.

We connect maybe 1-2 times a days & each time, nothing is resolved & some emails/calls are not answered very quickly.

Please place a higher urgency to this call Please.

Thanks
Lawrence Jett (Larry)
ljett@lincolnfp.com
260-459-8212
14-Aug-2006 New Call Note
Source = web
By = Jett, Lawrence(ljett@lincolnfp.com)
------
I ran the sql command line to flush shared pool (I imagine thats was its purpose).

Thge log seemed to show same error:

Mon 8/14/06 10:00:47: main: Nested exception is: java.sql.SQLException: ORA-04031: unable to allocate 1272 bytes of shared memory ("shared pool","unknown object","Typecheck heap","kkotp : kkoiqd")

I will attach a zip with the new logs, along with my wt.properties & db.properties file, in case settings there are causing the problem.

I also included the tools scripting that the data migration team had me run to tune oracle or windchill. the zip is wc_dp_tools.zip. Thats about the only customization I have ever done to my windchill &/or oracle.

It got me through my migration, but might be halting me now. At least I hope it got me through my migration. Irt showed success in migration, but who knows what the data will look like.

I have many hours ahead of me to get my windchill at a funtion state, so please make this a priority, maybe even higher than urgent.

Thanks for all your Help.

Lawrence Jett (Larry)
ljett@lincolnfp.com
260-459-8212.
11-Aug-2006 Hi Lawrence,
Ref:Successfully completed Data Migration.MethodServer times out after rebooting the Windchill server.
Could you run this command from the SQL prompt logging in as the system user?
Alter system flush shared_pool; Then restart tomcat,apache and windchill.Please let me know if this resolves the issue.
Thanks,
Sandy
Associate Technical Support Engineer
PTC
10-Aug-2006 New Call Note
Source = web
By = Jett, Lawrence(ljett@lincolnfp.com)
------
Method Server Log states (in 1 area):

Thu 8/10/06 10:57:40: main: Nested exception is: java.sql.SQLException: ORA-04031: unable to allocate 1272 bytes of shared memory ("shared pool","SELECT 'com.ptc.core.meta.se...","Typecheck heap","kkotp : kkoiqd")

A this in another area:

Thu 8/10/06 10:57:40: Thread-12: Nested exception is: java.sql.SQLException: ORA-04031: unable to allocate 4176 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","library cache")

My light research leans towards shared pool size.

The data migration team had me set autoextend to on. They specified it need to be set back to "off" after migration. Does this matter now, or is that a whole different area.

I did run the oracle tune-up sql scriptiong to complete optional steps 13 & 14 of the data migration, so I dont know if shared pool size matters:

With the search thgat I did do, I ran some sql queries to view the database:

SELECT * FROM V$SGASTAT

select *
from v$sgastat
order by upper(name)

I will provide the output of those queries &
my servermanager & methodserver logs within a zip & attach it to this call.

Lawrence Jett (Larry)
260-459-8212

File Upload Summary

To add data to this call please use the following links based on file size.
Date Name Size (bytes) Description
15-Aug-2006 c5311076_03_244148 16733 Uploaded by Lawrence Jett (ljett@lincolnfp.com) Please see message for 08-15-06
14-Aug-2006 c5311076_02_243571 1596286 Uploaded by Lawrence Jett (ljett@lincolnfp.com) See 08/14/06 message for zip content.
10-Aug-2006 c5311076_242446 1106610 Uploaded by Lawrence Jett (ljett@lincolnfp.com) sql query output files (htm/txt) & all logs update today in the wt area (including servermanager & methodserver)