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.

Symptoms

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

ERROR
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.


STEPS
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.

Question
How many characters long can a SAS identifier have?

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.