I get the warning “Server returned invalid line number (0)” when debugging a Sybase procedure, am I doing something wrong?

by Nov 4, 2011

I am not sure why I am getting the warning “Server returned invalid line number (0)” when debugging Sybase stored procedures.


Niels Gron over 11 years ago
The warning message you are getting “Server returned invalid line number (0)” is coming from the Sybase server. The reason is that the Sybase server loses track of the line number on nested ends. This is just a minor issue, but you should be able to continue to debug with no problems. We opened a case for this issue with Sybase in Sept 2009 as Sybase Case ID : 11377541 (CR# 480561). The response from Sybase engineering was :

“Not surprised. The query tree is built off of the source code, so various nodes of the query tree correspond to the various lines of source code. The nodes for nested ends exist, but don’t have a line number/source code attached. The debugger stops on the nodes, but finds no info to display, which isn’t very useful. ”

They don’t consider this a bug, nor do they have any plans on changing the behavior, but the behavior is minimal if you have latest EBFs of your Sybase server.