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
gefragt vor 6 Monaten132 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen