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
preguntada hace 6 meses132 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas