Skip to main content
R
RK_1080583710-Marble
10-Marble
November 9, 2023
Question

SQL Exception in starting windchill

  • November 9, 2023
  • 1 reply
  • 1208 views

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

 

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
November 9, 2023

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
HelesicPetr22-Sapphire II
22-Sapphire II
November 9, 2023

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

    R
    RK_1080583710-MarbleAuthor
    10-Marble
    November 21, 2023

    Hi , 

     

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

     

    Thanks,

    Ramsha

      Terms & ConditionsAccessibility statement