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

Rate this page:

(0 users)Average rating

Add comments

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

Translate my page

Machine Translation

Content navigation