Skip to Content
0
Aug 11, 2016 at 03:15 PM

instmstr errors on sp_help_qpgroup

28 Views

Hi,

upgrading my ASE 16.0 SP02 PL02 to SP02 PL04 on Windows x64. During the execution of instmstr script I got the messages

Installing sp_help_qpgroup

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 291:

Invalid column name 'text'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 291:

Invalid column name 'sequence'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 291:

Invalid column name 'id'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 291:

Invalid column name 'id'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 291:

Invalid column name 'type'.

Executing only the "create or replace procedure sp_help_qpgroup" statement (attached) using isql leads into the same error:

D:\>isql -Usa -Psybase -ihelp_qpgroup.sql

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 266:

Invalid column name 'text'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 266:

Invalid column name 'sequence'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 266:

Invalid column name 'id'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 266:

Invalid column name 'id'.

Msg 207, Level 16, State 4:

Server 'RKHP450', Procedure 'sp_help_qpgroup', Line 266:

Invalid column name 'type'.

According to the "Line 266" entries the problem may exists in the query after

...if (@mode = "counts")...

I set text, sequence, id, and type column names within double quotes but this didn't help.

Many thanks

Robert

Attachments