stored procedure not processing inputs with version 9.5

In an upgraded Livelink 9.5 environment with SQL database. It appears that I am unable to run a stored procedure LiveReport that passes an input into the stored procedure. This stored proc works fine in 9.2 and if I hard code a variable in a sql statement in 9.5 I can run the LiveReport that executes the stored procedure. This can also be run from SQL Query Analizer. This appears to be any Stored Procedure that passes an input.Runs in 9.2 But not in 9.5sp_llkAllObjectTypeCountsPerProjectID %1Run in 9.5 sp_llkAllObjectTypeCountsPerProjectID 0001Livelink is returning the following error:Livelink Error: Error processing request. [[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'sp_llkAllObjectTypeCountsPerProjectID'. - sp_llkAllObjectTypeCountsPerProjectID :A1] Thank you for your help,Chris Jones504-654-3458Northrop Grumman

Find more posts tagged with

Comments

Chad Latka

Chris:I'm having the same if not similar issue. I tried changing ownership to all Livelink database objects to dbo. at last resort thinking it was related to permissions.Query analyzer on dev database: [ update sysobjects set uid = 1 where uid != 3 ] Did anyone answer you or did you find a solution ? Thanks,Chad LatkaNorthrop Grumman504-654-3386

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

First, ensure that SET NOCOUNT ON is already turned on in the stored procedure(s).

Next, trying calling out exec in front of the stored procedure.

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, May 29, 2009 7:57 PM
To: eLink Recipient
Subject: Chris

Chris		Posted by northo01user2 (Latka, Chad) on 2009/05/29 19:52
In reply to: stored procedure not processing inputs with version 9.5		Posted by northo01admin (Jones, Chris) on 2006/09/14 13:40

Chris:
I'm having the same if not similar issue. I tried changing ownership to all Livelink database objects to dbo. at last resort thinking it was related to permissions.

Query analyzer on dev database: [ update sysobjects set uid = 1 where uid != 3 ]

Did anyone answer you or did you find a solution ?

Thanks,
Chad Latka
Northrop Grumman
504-654-3386