Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2015-02-27 : 09:38:00
|
| HI All,We are facing a weird problem in our application.We have TIBCO as our MT and sql 2012 in compatibility mode 90 as backend.We have a issue where in TIBCO says SP is not returning a output for a SP "sometimes" and when we run the same proc form ssms, it returns.The SP is as simple as "select col1 form table where id= @input".And we checked the trace..the input was valid..our trace doesn't hold the output of a SP.Has anyone faced any issue like this with TIBCO(not accepting SP output sometimes)..the JDBC driver it uses is version 4.I cant start the trace on outputs too,as the the data is too huge to handle :(Any help would be appreciated..the last option I have resorted to start the trace within the SP(to log the output in a dummy table just to prove that its not a "DB issue" as they say it in the IT world:)Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-27 : 12:16:11
|
| We used Tibco extensively at my last job and never encountered that issue.When you say you ran a trace, are you referring to a SQL Profiler trace? If so, what do you mean it doesn't hold the output? Which events did you add to the trace? Show us the stored procedure call that's in the trace.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQLServer and TIBCO