DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
zuhairkhan
Participant



Joined: 01 Nov 2010
Posts: 13

Points: 272

Post Posted: Wed Jun 01, 2016 12:59 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
the dev team complained that they are unable to logon to standardization rules designer , so did some research and found i have to create the tables in the srduser schema , after creating(tables on XMETA db) although i was able to logon to the standardization rules designer , I am getting below error every time i try to open or edit the default rule sets.Our repository is a separate db2 database.

Any ideas why this error , i am able to create and edit new rule sets!.

error:
A revision was not created for the rule set.

[jcc][t4][102][10040][3.58.135] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4228, SQLSTATE=null.


websphere logs show :

---- Begin backtrace for Nested Throwables
com.ibm.db2.jcc.am.uo: Error for batch element #178: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;SRDUSER.CLASS_VALUE_ENTRY, DRIVER=3.58.135
at com.ibm.db2.jcc.am.ed.a(ed.java:672)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.t4.fb.a(fb.java:461)
at com.ibm.db2.jcc.t4.fb.a(fb.java:69)
at com.ibm.db2.jcc.t4.t.a(t.java:57)
at com.ibm.db2.jcc.t4.vb.a(vb.java:223)
at com.ibm.db2.jcc.am.an.a(an.java:2907)
at com.ibm.db2.jcc.am.an.c(an.java:4708)
at com.ibm.db2.jcc.am.an.a(an.java:4255)
at com.ibm.db2.jcc.am.an.c(an.java:4098)
at com.ibm.db2.jcc.am.an.executeBatch(an.java:2427)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:840)
at com.ibm.iis.qualitystage.rulesconsole.services.ruleset.server.impl.RuleSetRevisionBean.internal_insertBaseClassValues(RuleSetRevisionBean.java:2747)
at com.ibm.iis.qualitystage.rulesconsole.services.ruleset.server.impl.RuleSetRevisionBean.internal_createRevision(RuleSetRevisionBean.java:2235)
at com.ibm.iis.qualitystage.rulesconsole.services.ruleset.server.impl.RuleSetRevisionBean.createRevision(RuleSetRevisionBean.java:1798)
at com.ibm.iis.qualitystage.rulesconsole.services.ruleset.server.EJSRemoteStatelessRuleSetRevision_6bb092ad.createRevision(Unknown Source)
at com.ibm.iis.qualitystage.rulesconsole.services.ruleset.server._RuleSetRevisionRemote_Stub.createRevision(_RuleSetRevisionRemote_Stub.java:487)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.is.binding.rest2.Servlet.callOperation(Servlet.java:447)
at com.ibm.is.binding.rest2.Servlet.processRequest(Servlet.java:370)
at com.ibm.is.binding.rest2.Servlet.doRequest(Servlet.java:275)
at com.ibm.is.binding.rest2.Servlet.doGet(Servlet.java:206)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1219)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1027)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:522)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:311)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:282)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
stuartjvnorton
Participant



Joined: 19 Apr 2007
Posts: 517
Location: Melbourne
Points: 3850

Post Posted: Wed Jun 01, 2016 6:12 pm Reply with quote    Back to top    

How did you set it up?

Like this?

http://www-01.ibm.com/support/docview.wss?uid=swg21617260
http://www-01.ibm.com/support/docview.wss?uid=swg21614129
Rate this response:  
Not yet rated
BharathiR
Participant



Joined: 17 Apr 2012
Posts: 10

Points: 138

Post Posted: Tue Sep 06, 2016 2:56 am Reply with quote    Back to top    

I am facing the same issue, If this is resolved could you please share the details on the resolution?

_________________
Bharathiraja S
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42753
Location: Denver, CO
Points: 220316

Post Posted: Tue Sep 06, 2016 7:17 am Reply with quote    Back to top    

Idea Is your error exactly the same? If not, could you post the details of your error please?

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours