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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQLServer and TIBCO

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -