Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Executing Stored Procedure Fails with 'Stored Procedure doesn't exist' message [DNET517] #499

Closed
firebird-automations opened this issue Aug 23, 2013 · 11 comments

Comments

@firebird-automations
Copy link

Submitted by: Cecil Martin (rabbitdogs)

Attachments:
SP_ERROR.zip
SP_JOBQ_ADD.PNG

When executing a stored procedure, the provider returns an error stating the stored procedure doesn't exist. Error occurs when trying to execute command as type StoredProcedure or Text. Following are stack trace messages:

Using fbcommandbuilder.deriveparameters to derive parameters for stored procedure:

Error:
Stored procedure doesn't exist.

Stack Trace:
at FirebirdSql.Data.FirebirdClient.FbCommandBuilder.DeriveParameters(FbCommand command) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommandBuilder.cs:line 71
at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime execTime, String theUser, Int32 JobId, Int32 JobsId) in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 376
at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line 44

And for executing as "execute procedure sp_jobq_add(?,?,?,?,?,?)":

Error:
Dynamic SQL Error
SQL error code = -204
Procedure unknown
SP_JOBQ_ADD

Stack Trace:
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 520
at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime execTime, String theUser, Int32 JobId, Int32 JobsId) in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 396
at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line 44

@firebird-automations
Copy link
Author

Commented by: Cecil Martin (rabbitdogs)

Attached are database and project files

@firebird-automations
Copy link
Author

Modified by: Cecil Martin (rabbitdogs)

Attachment: SP_ERROR.zip [ 12364 ]

@firebird-automations
Copy link
Author

Modified by: Cecil Martin (rabbitdogs)

environment: Windows 8 Pro 64 bit, Visual Studio 2012 => Windows 8 Pro 64 bit, Visual Studio 2012. TARGET = NET4.0

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Calling your library and it works fine. The ExecuteNonQuery does not throw any exception. Though the "rv = CType(cm.Parameters.Item("@O_JOBQ_ID").Value, Guid)" does. Given that the error is from server and not client, I would say the SP really isn't in your database.

@firebird-automations
Copy link
Author

Commented by: Cecil Martin (rabbitdogs)

The database file sent to you is an exact copy of the database I'm using. If the ExecuteNonQuery worked against the database in the attachment, the SP should be in the database I'm using as well. Also, I can see the SP in the database. Everything executes correctly on Windows 7, .NET 4.0, WS 2003, and VS2010. I'm going to look into the Windows firewall. That may be the cause of the problem, though it does not make sense that the firewall would block on the http://ADO.NET provider and not communication with IBExpert, RazorSQL, etc... Will post my findings.

@firebird-automations
Copy link
Author

Commented by: Cecil Martin (rabbitdogs)

I have un-installed and re-installed Firebird-2.5.2.26540_0_x64 and get the same results when trying to execute. Stopping the Windows firewall gets same results when trying to execute. Attached file is a screen capture showing the SP does indeed exist in DB. I'm open to trying any suggestion you may have.

@firebird-automations
Copy link
Author

Modified by: Cecil Martin (rabbitdogs)

Attachment: SP_JOBQ_ADD.PNG [ 12366 ]

@firebird-automations
Copy link
Author

Commented by: Cecil Martin (rabbitdogs)

Executing SP from IBExpert works as expected. The only errors encountered are through http://ADO.NET provider.

@firebird-automations
Copy link
Author

Modified by: Cecil Martin (rabbitdogs)

priority: Critical [ 2 ] => Blocker [ 1 ]

@firebird-automations
Copy link
Author

Commented by: Cecil Martin (rabbitdogs)

Problem resolved. Typographical error. Sorry for the hassle. Please close.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants