Skip to main content
Contact a Moderator

Discussion

5
Replies
243
Views
 Sanjeev Gupta (SanjeevG0708) TD
TD
CA
SanjeevG0708 Member since 2015 1 post
TD
Posted: September 16, 2015
Last activity: April 6, 2018
Posted: 16 Sep 2015 11:20 EDT
Last activity: 6 Apr 2018 19:26 EDT
Closed

Schema Object migration script failed

Hi ,

We have successfully(as per logs) completed rule migration and Rule upgrade, both the scripts completed without any issues.But we are getting error while running migrate script for migration and generation of Schema objects. Did anyone face this issue? what could be the reason for it?

Error:

BUILD FAILED
C:\Pega718\scripts\migrateSystem.xml:501: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:766)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1244)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:420)
at com.pega.pegarules.util.anttasks.CheckForUncommittedHotfixes.execute(CheckForUncommittedHotfixes.java:43)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)
at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:154)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.Main.runBuild(Main.java:851)
at org.apache.tools.ant.Main.startAnt(Main.java:235)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)

Total time: 6 seconds
Exiting with Error



**Moderation Team has archived post**


This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Updates
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.
Posted: 6 years ago
Posted: 16 Sep 2015 11:49 EDT
Dhevendra Earva (earvd) PEGA Director, Cloud Engineering
Pegasystems Inc.
IN

Could you please make sure that in migratesystem.properties files you are mentioned both source and target databse connection details along with respective soruce and trarget rules and data schema names.

 

Thanks,

Dhev
Posted: 6 years ago
Posted: 16 Sep 2015 13:48 EDT
Sudharsan Raman (sudharsan) PEGA Principal Software Engineer - Customer Success
Pegasystems Inc.
IN

It seems like you have some uncommitted hotfixes in the 5.5 instance. Is it possible for you check the status of the hotfixes in data schema ?
Posted: 6 years ago
Posted: 7 Dec 2015 9:07 EST
Umamaheshwar Reddy Midthuru (Mahesh Midthuru) PEGA Principal Engineer, Technical Support, Customer Service
Pegasystems Inc.
US

Hi Sudarshan,

 

How can we commit the HFs in 55 version, as we dont have update manager?

 

Regards,

Mahesh
Posted: 6 years ago
Posted: 16 Sep 2015 13:54 EDT
Sanjeev Gupta (SanjeevG0708) TD
TD
CA

Thank you for your comments.

There was a problem with migratesystem.properties file. New Rules Schema wasn't configured properly. It's working now.
Posted: 5 years ago
Posted: 2 Sep 2016 4:59 EDT
Smriti Parmar (SmritiP9) Larsen & Toubro Infotech
Larsen & Toubro Infotech
IN

What change you did in this fiel. Did you change target and source rule schema name. One of the pnd article suggesting to give old 5.5 chema name as target rule schema.?? Plsadvise

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice