Question

1
Replies
75
Views
Suman Palukuru Member since 2015 60 posts
Tata Consultancy Services Ltd
Posted: 2 years ago
Last activity: 2 years 9 months ago
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-GeneralProblem executing SQL to update database schema2285999999ORA-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
Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn