Question

1
Replies
78
Views
Close popover
Venkata Suman Palukuru (Suman Palukuru)
Tata Consultancy Services Ltd
Lead System Architect
Tata Consultancy Services Ltd
US
Suman Palukuru Member since 2015 62 posts
Tata Consultancy Services Ltd
Posted: November 29, 2017
Last activity: April 6, 2018
Closed

Upgrade estimator - Facing issues while importing jar and calculating efforts

hi,

I am facing issue when importing jar file. Import wizard is trying to execute the alter script " ALTER TABLE PGDDBDA1.EFFORTESTIMATES MODIFY pzPVStream BLOB;" and in the logs I see the below error. So I have skipped the step while doing import.

Below are my questions:

1) Why is the alter script getting executed , when the pzPVSStream is already a BLOB in the database

2) For time being I skipped the step to execute the alter script and was able to import the jar.I was able to launch the UpgradeEstimator portal successfully , but when I click on Effort Estimates , I am getting 'Cannot render' text on the screen.Screen shot attached for the same and below is the error

PFA tracer file as well for the issue "Can not render section" , I see lot of unable to find prpc:sso access group. Please change the xlsx extension to xml file , to view the tracer file

Pega version is Pega 7.1.6 and database is Oracle

2017-11-29 16:15:57,239 [la01d.nam.nsroot.net] [ STANDARD] [ ] (ternal.util.SchemaImporterTool) ERROR - SQL : ALTER TABLE PGDDBDA1.EFFORTESTIMATES MODIFY pzPVStream BLOB
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 22859 99999 ORA-22859: invalid modification of columns
From: (A5C1EC2305476E13A9AD9696EC96C8781)
SQL: ALTER TABLE PGDDBDA1.EFFORTESTIMATES MODIFY pzPVStream BLOB
Caused by SQL Problems.
Problem #1, SQLState 99999, Error code 22859: java.sql.SQLException: ORA-22859: invalid modification of columns
System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.