Skip to Content
0
Former Member
Jun 09, 2008 at 09:34 PM

Issue calling stored procedure on SQL server 2005 from XI 3.0

10 Views

Hi

We are facing a strange issue when XI executes a stored procedure in SQL server 2005. The underlying SQL statement generated by XI ( which we got tracing the xi sql call on the sql server ) when it executes the stored procedure contains a double quote on the timestamp parameter field - instead of a single quote for other datatypes .

This is causing a syntax error on the stored procedure call on the sql side - and this is not even seen by XI ( message is marked as successfull by XI in Adapter Engine ) . Anybody face this issue before ? Any resolutions ?