Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Arun Somasundaram (Arun-VS)
Macquarie Group

Macquarie Group
AU
Arun-VS Member since 2016 2 posts
Macquarie Group
Posted: Mar 19, 2017
Last activity: Mar 24, 2017
Posted: 19 Mar 2017 21:16 EDT
Last activity: 24 Mar 2017 9:30 EDT
Closed
Solved

Response not recieved for the Class issue - Pega 7 Upgrade

Hi everybody,

I am currently upgrading few apps from 6.2 SP2 to 7.2.2. I am using installation and upgrade assistant (IUA) to complete the upgrade process. When the IUA executed one of the targets "Optimize Newly Exposed Columns" in the setupDatabase.xml file, it could not proceed further and is waiting for the response from the class "Rule-Obj-Flow" with a job id. I believe it run into trouble while populating the new columns for the class "Rule-Obj-Flow". I let the IUA open for about 6 hours to see if it could progress but in vain. I am keen to know if anyone of you have encountered this issue while doing the upgrade and the fix that you may have implemented.

Any help is very much appreciated!

I have attached both IUA logs and resume.properties file. The message can be found at the end of the IUA logs.txt file. The constant message that is written to the log is below:

[java] 2017-03-19 22:35:08,001 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job <BootStrap Commit> Started [Rule-Obj-Property # JobID # 95]
[java] 2017-03-19 22:35:09,001 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job <BootStrap Commit> Completed [Rule-Obj-Property # JobID # 95]
[java] 2017-03-19 22:35:09,009 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job Completed [Rule-Obj-Property # JobID # 95]

Show More

Hi everybody,

I am currently upgrading few apps from 6.2 SP2 to 7.2.2. I am using installation and upgrade assistant (IUA) to complete the upgrade process. When the IUA executed one of the targets "Optimize Newly Exposed Columns" in the setupDatabase.xml file, it could not proceed further and is waiting for the response from the class "Rule-Obj-Flow" with a job id. I believe it run into trouble while populating the new columns for the class "Rule-Obj-Flow". I let the IUA open for about 6 hours to see if it could progress but in vain. I am keen to know if anyone of you have encountered this issue while doing the upgrade and the fix that you may have implemented.

Any help is very much appreciated!

I have attached both IUA logs and resume.properties file. The message can be found at the end of the IUA logs.txt file. The constant message that is written to the log is below:

[java] 2017-03-19 22:35:08,001 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job <BootStrap Commit> Started [Rule-Obj-Property # JobID # 95]
[java] 2017-03-19 22:35:09,001 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job <BootStrap Commit> Completed [Rule-Obj-Property # JobID # 95]
[java] 2017-03-19 22:35:09,009 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job Completed [Rule-Obj-Property # JobID # 95]

From here the message starts popping up continuously, see below -->

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <1799899>
[java] 2017-03-19 23:05:03,388 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <1799899>

[java] 2017-03-19 22:35:09,009 [ pool-1-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Job Completed [Rule-Obj-Property # JobID # 95]

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <1799899>

[java] 2017-03-19 23:05:03,388 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <1799899>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <3599797>

[java] 2017-03-19 23:35:03,286 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <3599797>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <5399694>

[java] 2017-03-20 00:05:03,183 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <5399694>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <7199592>

[java] 2017-03-20 00:35:03,081 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <7199592>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <8999490>

[java] 2017-03-20 01:05:02,979 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <8999490>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <10799387>

[java] 2017-03-20 01:35:02,876 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <10799387>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <12599285>

[java] 2017-03-20 02:05:02,774 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <12599285>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <14399183>

[java] 2017-03-20 02:35:02,672 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <14399183>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <16199124>

[java] 2017-03-20 03:05:02,613 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <16199124>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <17999061>

[java] 2017-03-20 03:35:02,550 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <17999061>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <19798957>

[java] 2017-03-20 04:05:02,446 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <19798957>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <21598855>

[java] 2017-03-20 04:35:02,344 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <21598855>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <23398753>

[java] 2017-03-20 05:05:02,242 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <23398753>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <25198621>

[java] 2017-03-20 05:35:02,110 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <25198621>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <26998519>

[java] 2017-03-20 06:05:02,008 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <26998519>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <28798417>

[java] 2017-03-20 06:35:01,906 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <28798417>

[java] Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <30598314>

[java] 2017-03-20 07:05:01,803 [ pool-2-thread-1] [ STANDARD] [ ] ( internal.util.MoveLog) INFO - Response not recieved for the Class <Rule-Obj-Flow> JobID <86>.Time elapsed (milliseconds) <30598314>


Show Less
To see attachments, please log in.
Updates

Accepted Solution

Posted: 7 years ago
Posted: 22 Mar 2017 7:55 EDT
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Arun,

After analyzing your shared documents noticed that you are using below driver version,

 Driver: Microsoft SQL Server JDBC Driver 3.0 3.0.1301.101

But the Pega documentation specifies that this version wont be supported and it will cause the problems with Pega 7 internal system date values as shown in attachment.

Reference support document here.

Regards

Mahesh

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 22 Mar 2017 8:05 EDT
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Arun,

Adding to the above point, noticed another issue in your JDBC URL as per your log file it gives the below url,

JDBC URL-> jdbc:sqlserver://mod_saas_uat:50260;DatabaseName=pega_rules_uat2;useNTLMv2=true;useLOBs=false

But the Pega recommendation of the JDBC URL syntax is as follows,

JDBC URL-> jdbc:sqlserver://server:port;DatabaseName=database;selectMethod=cursor;sendStringParametersAsUnicode=false

Reference document available here.

Suggestion: So if you upgrade to latest supported driver version of the jar file and also try to modify the JDBC URL as per Pega recommended. Then you can resume the upgrade process and let us know the end result.

Hope this two changes can resolve your issue and will let you know if i find any other issues with your configuration.

Regards

Mahesh

To see attachments, please log in.
Posted: 7 years ago
Posted: 23 Mar 2017 21:52 EDT
Arun Somasundaram (Arun-VS)
Macquarie Group

Macquarie Group
AU

That's right I overlooked at the JDBC driver version section of the 7.2.2 platform support guide. It was unfortunate I used the exact JDBC driver version that is known to cause issues in Pega 7. Also I copied the JDBC URL from one of the existing UAT environments which was not suggested. 

Solution

I used one of the latest version of the type 4 JDBC driver for MS SQL and updated the JDBC URL then resumed the upgrade and it did not help. It failed again at the same step on resume since some changes were already made by the upgrade process. I had to restore the whole database from production. Re-run all the upgrade procedures from the beginning and it worked just fine.

Thanks Mahesh for your thoughts, I really appreciate it. 

To see attachments, please log in.

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