My Oracle Support Banner

A '>' Symbol Is Missing from the End of the HTML Results When Reviewing BLOB Field Contents in a P6 Database Table (Doc ID 2945804.1)

Last updated on MAY 01, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 20.12 to 20.12.13.0 [Release 20.12]
Primavera P6 Enterprise Project Portfolio Management - Version 21.12 to 21.12.13.0 [Release 21.12]
Primavera P6 Enterprise Project Portfolio Management - Version 22.12 to 22.12.3.0 [Release 22.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 23.1 to 23.4 [Release 23.1 to 23.4]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When running the query below against the P6 database, and expanding the TASK_MEMO BLOB field, there is a missing '>' symbol that is not at the end of the HTML results:

select * from task_memo where memo_id = 'xxxxxx'

This issue also occurs for the WBSMEMO table.

select * from wbs_memo where memo_id = 'xxxxxx'

EXPECTED BEHAVIOR

When running the above queries the trailing '>' should be at the end of the queries output.


The issue can be reproduced at will with the following steps:

  1. Migrate a P6 database from Oracle to SQL Server.
  2. Login to the migrated SQL Server database as 'sa'.
  3. Run the above queries.
  4. Expand the BLOB field and view the HTML output.
  5. See the trailing '>' is not at the end of the query output.

Changes

 The customer migrated from Oracle Database to SQL Server.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.