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