Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Variables not getting assigned

651718Sep 19 2008 — edited Oct 7 2008
Hello Everyone,

I am facing problem in assigning a value to a ODI Global Variable through Scenario.

I am putting down the steps which I have taken,

i.) Created a Global Variable(MAX_RECORDS), with a
default value untouched(i.e I haven't entered anything),
datatype Alphanumeric,
Action Type - NotPersistant
Refreshing Command as SELECT #MAX_RECORDS FROM DUAL (I have entered the variable name using expression editor).

2.) Created a Project Variable(FILE_NAME), a refreshing variable with the refreshing command SELECT CONCAT(#MAX_RECORDS,'FILE.txt') FROM DUAL
3.) Then an interface which loads a flat file from a table. The file name will depend on the variable FILE_NAME.(which have been correctly set in the Model Datastore).

4.) In the package the flow is as follows,

MAX_RECORDS(a declare variable) ---> MAX_RECORDS(a set variable) ---> MAX_RECORDS(a refresh variable) ---> FILE_NAME(a refresh variable) --> Interface

5.) A scenario has been generated using the above package with the startup parameter as GLOBAL.MAX_RECORDS
6.) On launching the scenario from the Designer, it prompted a for the GLOBAL.MAX_RECORDS which I have passed as 3

But the scenario failed with the error 'java.lang.Exception: Variable has no value: GLOBAL.MAX_RECORDS'

Any help would really be helpful and appreciated. Please let me know if the problem stated is not clear.

Thanks,
Saravanan

Comments

Please provide the following information so we can help:

What version of SQL Developer are you using?

What are the results of opening the properties for the connection and doing a test?

Does the navigation tree open correctly?

Are you having trouble with all of your Oracle connections?

When running those queries are they using the same connection as the export?

Provide the details of the NPE when using the Export Wizard.

Exactly what steps are you taking to do the export? (eg, from the Navigator/tools...)

Are there any other errors in the SQL Developer log?

Joyce Scapicchio

SQL Developer Team

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2008
Added on Sep 19 2008
5 comments
2,581 views