Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    833

    Unanswered: upgrade from 11.9.2 to 12.5 and currupted default values

    Hi,

    after having upgraded the server from 11.9.2 to 12.5 some default values defined for tables are throwing msgno 154 and 11031 in embedded sql stmts. (variable not allowed in default , execution of default bla failed because error of parsing the source text in syscomments.

    what is even more confusing : all defaults stored in syscomments show the wanted values ...

    any hints and help is highly appreciated.

    regards

    osy45

  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97
    A common advice for upgrades is to re-create
    all triggers, stored procedures and views. You
    should try; it looks like it could solve the problem.

    Remember that defncopy may help in extracting
    stored procedures' source. But this doesn't make
    all the job; proper grant and sp_procxmode SQL
    commands must be executed after defncopy-in.

    Regards,
    Mariano Corral

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •