IBM Support What's New?

AW: Syntax error on load management

Technote (troubleshooting)


Problem(Abstract)

A new custom dimension load was failing with the follow error in load management - UDA-SQL-0358

Line 3: Syntax error near "FROM".

Symptom

UDA-SQL-0358
Line 3: Syntax error near "FROM".


Cause

The cause of this error is not having at least one item in the custom dimension set as a Business Key.

Environment

Windows

Diagnosing the problem

In the Properties of the dimension elements for the Item Type property
- one of the dimension elements must have the Business Key type
assigned

Resolving the problem

In the Properties of the dimension elements for the Item Type property
- one of the dimension elements must have the Business Key type
assigned. Define an element as key and re-run the load for the dimension

Document information

More support for: Cognos Analytic Applications
Adaptive Warehouse

Software version: 10.1

Operating system(s): Windows

Reference #: 1621381

Modified date: 2013-03-26