DD to Exceute storeprocedue

vijay1240

Hi All,
i have the DD file which invokes StoreProcedure



After executing the deployment:
iwodstart.bat db/QA/qa_store.xml -k iwdd=store-Proc -k iwdd-op=do-sql -k user-op=execute_my_procedure


I am getting the following error


DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
DBD: Setting up consumer TDbAgent
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [192.168.2.204:1433;databaseName=QA_globalwebcontent]
DBD: iwdd-op=do-sql
DBD: ERROR:Exception occured while executing deployment [store-Proc]: null
DBD: ERROR:
java.lang.NullPointerException
at java.util.regex.Matcher.getTextLength(Matcher.java:1127)
at java.util.regex.Matcher.reset(Matcher.java:284)
at java.util.regex.Matcher.(Matcher.java:205)
at java.util.regex.Pattern.matcher(Pattern.java:879)
at com.microsoft.sqlserver.jdbc.JDBCCallSyntaxTranslator.translate(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(Unknown Source)
at com.interwoven.dd100.dd.TDbAgent.ExecuteProcedure(TDbAgent.java:3404)
at com.interwoven.dd100.dd.TDbAgent.DoSql(TDbAgent.java:3087)
at com.interwoven.dd100.dd.TCommand.Do(TCommand.java:253)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:146)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)


DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Rollback database [192.168.2.204:1433;databaseName=QA_globalwebcontent]...
DBD: Deployment[store-Proc] Table[NOT_USED]

Any help is appreciated