Question
Capgemini Sverige AB
SE
Last activity: 1 Feb 2017 8:01 EST
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***
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
Capgemini Sverige AB
SE
Hi Arun,
There is no exception written in logs, and this issue is only for one particular work object.
Thanks
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
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
Capgemini Sverige AB
SE
Where can we set includeSynonym=true as additinoal jdbc property?
Pegasystems Inc.
IN
According to SR notes,it says :
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"
/>
Capgemini Sverige AB
SE
Hi Haritha,
But we are using JBoss in our application.
Thanks
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