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

 Srinivasa Rao Ancha (SriniAncha)
Capgemini Sverige AB
Srinivasa Rao Ancha
Capgemini Sverige AB
SE
SriniAncha Member since 2016 19 posts
Capgemini Sverige AB
Posted: Feb 1, 2017
Last activity: Feb 1, 2017
Posted: 1 Feb 2017 1:31 EST
Last activity: 1 Feb 2017 8:01 EST
Closed

Unable to Open Work Object

Hi,

I am not able to open a particular work object using Obj-Open-by-Handle. activity is getting hung at obj-open-by-handle step it self, so not even able to trace.

Any suggestions, what could be the issue?

Thanks,

Srini

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Case Management
Data Integration

Posted: 8 years ago
Posted: 1 Feb 2017 1:38 EST
Arun Kumar Mahanty (Arun_Mahanty)
Pegasystems Inc.
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Srini,

Any exception in the logs check below article if you’re getting error related to non-existent table .

https://community.pega.com/support/support-articles/unable-open-work-objects

Thanks,

Arun

 

To see attachments, please log in.
Posted: 8 years ago
Posted: 1 Feb 2017 2:19 EST
Srinivasa Rao Ancha (SriniAncha)
Capgemini Sverige AB
Srinivasa Rao Ancha
Capgemini Sverige AB
SE

Hi Arun,

There is no exception written in logs, and this issue is only for one particular work object.

Thanks

To see attachments, please log in.
Posted: 8 years ago
Posted: 1 Feb 2017 1:41 EST
Dileep Kumar Balaga (DileepKumarBalaga)
Accenture Australia

Accenture Australia
AU

Hi Srini,

Can you please attach the screen shot of the error which you are getting or check the logs in pega after running the activity.

Thank you

To see attachments, please log in.
Posted: 8 years ago
Posted: 1 Feb 2017 2:18 EST
Srinivasa Rao Ancha (SriniAncha)
Capgemini Sverige AB
Srinivasa Rao Ancha
Capgemini Sverige AB
SE

Hi Deepak,

There is no exception written to logs. PFA the screen shot where it shows the Activity hung at first step it self.

it's happening for only one particualr work object (kind of corrupted object, not even able to open child objects from portal).

Thanks

To see attachments, please log in.
Posted: 8 years ago
Posted: 1 Feb 2017 5:25 EST
Haritha Damarla (Haritha12)
PEGA
Technical Solutions Engineer
Pegasystems Inc.
IN

According to SR notes,it says :

Show More

According to SR notes,it says :

Set includeSynonyms connection property below to true under tomcat datasource and check if the test connectivity works for that particular class.
<Resource
name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@hostname:port:sid"
username="<username>"
password="<password>"
connectionProperties="includeSynonyms=true"
maxActive="25"
maxIdle="5"
maxWait="10000"
/>
 


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 1 Feb 2017 8:01 EST
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Srini,

In JBoss server you can go to the domain.xml/standalone.xml/standalone-full.xml based on your type of usage and go to the data sources configuration and add the below configuration in it. If you are not sure about which file check with JBoss administrator.

 <connection-property name="includeSynonyms">true</connection-property>

If you have multiple datasources configured then need to add in corresponding data sources configuration then test the functionality by restarting the server.

Hope this will help you.

Regards

Mahesh

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