cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Translate the entire conversation x

SQL Exception in starting windchill

RK_10805837
10-Marble

SQL Exception in starting windchill

Hello,

I have updated the current windchill installation 12.0 with CPS15 with the modules ESI and project link. However, when installing through PSI I didnt select create database schema option and now I get the SQL exception of the table does not exist. 

The Server Manager, Method Server and Backgroung Method Server logs are generated but the windchill doesnt start. I am attaching the error snapshot here. Kindly provide resolutions if any,

 

Thanks,

Ramsha

 

3 REPLIES 3
avillanueva
22-Sapphire III
(To:RK_10805837)

So, is this a new installation? Just clarifying that you were not simply adding modules or upgrading to CPS15. If this is a new installation, you should be able to recreate the database and schema separately. 

This is covered in help documentation here:

https://support.ptc.com/help/wnc/r12.0.2.0/en/#page/Windchill_Help_Center%2FWCInstall_CreateDataSchema.html

 

HelesicPetr
22-Sapphire II
(To:avillanueva)

Or 

if it is new installation and you know you did something wrong, remove the current installation and start new installation instead of trying to correct the actual one.

It is easier.

 

PetrH

Hi , 

 

The error was due to few sequences which were not correct. After running some SQL queries , the problem was resolved.

 

Thanks,

Ramsha

Announcements



Top Tags