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
질문됨 6달 전132회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠