Error while patching Tc11.2.3.1_a01_patch_5

[GaneshDasmale]

Hello Team,

I was having TC11.2.3 environment which im trying to upgrade to Tc11.2.3.1_a01_patch_5

But Im getting below error while patching.

let me know if you have any idea about this

***
*** CANCELLED
***
=====================================================
Installation interrupted due the following reason:

UPDATE MANAGER FAILURE: PatchingAction: Patch task failed while processing feature, 'Teamcenter Foundation': com.teamcenter.install.tceng.base.DatabaseSteps.revisioningCheck()
Time: Tue Nov 28 06:02:09 CET 2017
=====================================================

=====================================================
CommentStore
=====================================================
Configuration update failed: gtc00: Patch task failed while processing feature, 'Teamcenter Foundation': com.teamcenter.install.tceng.base.DatabaseSteps.revisioningCheck()
Severity: 1 (Severe)

An internal error occured which has caused processing to stop.
Severity: 1 (Severe)

TC_DATA was not completely updated as a part of this process. Only the SOA definitions were updated leaving the remainder of this step to be completed manually. Please consult the appropriate Teamcenter Server installation guide to obtain information regarding updating TC_DATA directories.
Severity: 3 (Information)

=====================================================
Copying file C:\splmlocal\gtc00\appl\tc112\install\configuration.xml to C:\splmlocal\gtc00\appl\tc112\install\configuration1711280602.xml

[GaneshDasmale]

Normally it should execute like below

Running com.teamcenter.install.tceng.base.DatabaseSteps

select count(*) from USER_TAB_COLUMNS where UPPER(TABLE_NAME)='PPOM_OBJECT' AND UPPER(COLUMN_NAME)='AREV_CATEGORY'
Return result: 1
select count(*) from PPOM_OBJECT where aoid IS NOT NULL AND arev_category IN (10,20,25,30,40) and rownum <= 1
Return result: 0
Completed method [revisioningCheck] in class [com.teamcenter.install.tceng.base.DatabaseSteps].
Setting up Teamcenter shell

But in my case, it is as below

Running com.teamcenter.install.tceng.base.DatabaseSteps

An error occurred during execution. Stack trace follows...
java.lang.Class.getMethod(Unknown Source)
com.teamcenter.install.tem.tasks.JavaTask.execute(JavaTask.java:205)
com.teamcenter.install.tem.tasks.Task.execute(Task.java:135)
com.teamcenter.install.tem.tasks.blocks.CodeBlock.execute(CodeBlock.java:201)
com.teamcenter.install.tem.tasks.blocks.CodeBlock.execute(CodeBlock.java:181)
com.teamcenter.install.tem.patch.Patch.processPatchTasks(Patch.java:1089)
com.teamcenter.install.tem.patch.Patch.processPatchTasks(Patch.java:776)
com.teamcenter.install.tem.patch.Patch.finish(Patch.java:437)
com.teamcenter.install.tem.patch.Patch.begin(Patch.java:285)
com.teamcenter.install.tem.director.actions.PatchingAction.execute(PatchingAction.java:47)
com.teamcenter.install.tem.director.DirectorScript.execute(DirectorScript.java:143)
com.teamcenter.install.tem.director.Director.run(Director.java:134)
java.lang.Thread.run(Unknown Source)
***
*** CANCELLED
***
=====================================================
Installation interrupted due the following reason:

UPDATE MANAGER FAILURE: PatchingAction: Patch task failed while processing feature, 'Teamcenter Foundation': com.teamcenter.install.tceng.base.DatabaseSteps.revisioningCheck()

[GaneshDasmale]

That issue is resolved now, but I'm getting a new error which shows its unable to connect SQL Server.

is there any thing by whch i can test its connection?

[RandyEllsworth]

The easiest way to test the connection is by running "install -ayt" in a Tc command window. You'll see "Site is already installed" if the connection to the DB is good. Anything else is not good.

[GaneshDasmale]

Thanks all its was firewall issue on MS SQL Server, after changing the firewall settings it was able to connect.