My Oracle Support Banner

Data Model Loading Failing Even When A Table SAS Name Is Less Than 32 Characters Long (Doc ID 2403431.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4 to 2.4.7 [Release 2.4]
Information in this document applies to any platform.


Data model with the table having SAS name of length 30 characters is failing in Data Loading.

In DMW SAS log:
ERROR: Invalid macro name LOAD_macro_name. It should be a valid SAS identifier no longer than 32 characters.
ERROR: A dummy macro will be compiled.

The issue can be reproduced at will with the following steps:
1. Have a table with SAS name of 32 characters length within a data model.
2. Install the data model.
3. Load the data.

How many characters long can a SAS identifier have?


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

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

In this Document

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