Babelfish upgrade errors from Aurora 13.8 with Babelfish 1.4.0 to Aurora 14.6 with Babelfish 2.3.0

0

Customer is receiving these errors while attempting to upgrade their database - this is an in-place upgrade where everything is currently working under version Aurora 13.8 with Babelfish 1.4.0

Some examples of the error are:

  • Errors with numeric >= integer and numeric + integer operators where operator is not unique. Recreate with select 5::numeric >= 5::integer

  • call dbo.u_RecordUserActivity( 'b2c2661c-fed8-4c51-ba2d-1bf577cc1a6e', 136442, 'PaymentImport', 36); fails when called from Postgres with database "" does not exist

  • f_pa_batch_create fails with “nondeterministic collations are not supported for substring searches Where: PL/tsql function

  • f_pa_batch_create fails with “nondeterministic collations are not supported for substring searches Where: PL/tsql function f_getactionid(sys."varchar") line 6 at assignment PL/tsql function

-u_recordclientactivity(integer,uniqueidentifier,sys."varchar",datetime,integer,sys."varchar") line 7 at assignment SQL statement "call u_recordclientactivity(client_id, user_id, 'Batch - Create', NULL, batch_id, 'Batch')" PL/pgSQL function p_pa_batch_initialize(integer,integer,uniqueidentifier,text,datetime) line 107 at C”

AWS
asked 6 months ago128 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions