var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Migrate to 11.50: Stored Procedure won't load.
I am in the process of migrating from 7.31 to 11.50 on HP-UX 11.11 PA Arch.
In the case of this particular instance we are doing this via dbexport / dbimport.
As part of the dbimport we are experiencing a failure loading 1 particular stored procedure.
The error we are getting is as follows:
> dbaccess spg stored_proc.sql
312: Cannot update system catalog (sysprocedures).
Error in line 2
Near character position 0
The error implies that it might be a space issue. We have cleared space & tried again, but still the same.
We have also installed the rest of the databases stored procs with no problems.
We have isolated the tables involved, created a test database in the same and another 11.50 instance and the same problem occurs.
However, when I bring it back to 7.31 it loads with no problems.
Does anyone have any thoughts.
All help / suggestions appreciated.
I have now created a reproducable sql and tested this against ids 11.50 on hpux & solaris and ids 10 on solaris.
All fail at this point.
The case has now been escalated to the Labs for resolution.
Can you post the stored procedure?