Skip to main content

Postcode related error in population script log

In this article, we explain how to resolve a postcode-related error in the Population script log.

Y
Written by Yusef Abulaynain
Updated over 3 weeks ago

If you see the following error in your population script log:

"Error: ORA-12899: value too large for column "FW"."DM_HSC_DEMOGRAPHICS"."POSTCODE" (actual: 9, maximum: 8)"

It happens because the POSTCODE column only stores up to 8 characters. You can run the query below to find any records where the postcode is longer than 8 characters.

For Oracle

SELECT person_id, post_code
FROM dm_addresses
WHERE LENGTH(post_code) > 8;

For SQL

SELECT person_id, post_code
FROM dm_addresses
WHERE LEN(post_code) > 8;

The size of the DM_HSC_DEMOGRAPHICS.POSTCODE column will be increased in the upcoming 25.3 Reports Repository release.

Did this answer your question?