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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. 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 II
(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

 

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