| Author |
Message
|
| Lisa |
 Posted: Tue Jul 23, 2013 7:19 am Post subject: WSRR Install Error - Could not find stored procedure 'CRTST' |
 |
|
Master
Joined: 07 Jun 2002
Posts: 287
Location: NJ
|
Hi All,
I have installed WSRR v 8.0 trial version and SQL Server Express v10.5 on my laptop. I'm running Windows 7 Enterprise.
I manually created the database and other related database objects; but I see the following error in my ffdc log directory.
Caused by: java.sql.BatchUpdateException: Could not find stored procedure 'CRTST'.
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteBatch(WSJdbcPreparedStatement.java:1035)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:838)
at com.ibm.athene.TripleStoreImpl.assertStatements(TripleStoreImpl.java:802)
Has anyone seen this error before and how did you resolve the issue? I have dropped the database and re-ran the .sql scripts a couple of times.
Thanks |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Tue Jul 23, 2013 7:25 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
The SP might be created, but are you sure all the execute privs have been granted?
Have you satisfied this requirement?
| Quote: |
| You must install the stored procedures for Javaâ„¢ Transaction API (JTA) in addition to the JDBC drivers for WSRR if you want to work with the Microsoft SQL Server. |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Lisa |
| Posted: Tue Jul 23, 2013 7:29 am Post subject: |
|
|
Master
Joined: 07 Jun 2002
Posts: 287
Location: NJ
|
Thanks for the response!
I move the correct xa*.dll file to the SQL Server Express BINN directory along with xa_install.sql.
I followed the instructions and ran the xa_install.sql script.
I have double checked the privs for wsrr (user id) and everything appears in order. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 23, 2013 7:38 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Look in the stderr file generated by the wsrr runtime. You may have to hunt for it, $INSTALL/common/log would be where I would start.
You need more information, as to the exception being generated, by the runtime access to the database stored proc. It says 'cannot find'. Another thing to check is the database dbo parm. We need to somehow determine what the object predicates are so we can use ISQL to follow the same path and see what the WSRR runtime sees.
Alternately, you could download a DB2 trial.
Have you applied the latest FixPack ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| dogorsy |
| Posted: Tue Jul 23, 2013 7:55 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| another thing to check is the schema name in use. It could well be that the SP was created with one schema ( for example, the userid you used to create the objects ), and the program is trying to use another. |
|
| Back to top |
|
|
| Lisa |
| Posted: Tue Jul 23, 2013 11:04 am Post subject: |
|
|
Master
Joined: 07 Jun 2002
Posts: 287
Location: NJ
|
All,
Thanks for your suggestions; however, I downloaded DB2 express and create wsrr profile without any issue. Everything is working fine.
I'm still don't understand why wsrr is not working with sql server:(
Thanks |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 23, 2013 12:07 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Lisa wrote: |
| I'm still don't understand why wsrr is not working with sql server:( |
Its not uncommon for WebSphere products to have limited or unsupported capability with MS products.
For WMB, XA transactions are not supported with MS SQLServer; only Oracle and DB2 support XA transactions when connecting from WMB. Not that it would be too difficult from a technical feasibility perspective to support XA transactions on SQLServer...
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
