Skip to Main Content
Forums

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!

Using refresh variable on interface

561241Oct 15 2008 — edited Oct 15 2008
I have a variable (myTestVariable) which is a refresh variable. I want to use this as the filter on an interface. How do I do that ?

I have set the filter as my_column_name > #myTestVariable. I ran the interface and see this exception

com.sunopsis.sql.SnpsMissingParametersException: Missing parameter
at com.sunopsis.sql.SnpsQuery.completeHostVariable(SnpsQuery.java)
at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)
at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(SnpSessTaskSqlI.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.g.y(g.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Unknown Source)

Edited by: user558238 on Oct 15, 2008 1:23 AM

Comments

Levi Pereira
Windows XP is not a little old?

Have you tried to search on Google ASM + Windows XP + Install ...

I am absolutely sure you would find this link:
http://www.databasejournal.com/features/oracle/article.php/3571371/Oracle-10g-Automatic-Storage-Management-ASM-Part-2-Sample-Implementation.htm

Always use documentation or Google It.

Regards,
Levi Pereira
585179
Hi,

Have a read note "How To Setup ASM (10.2) on Windows Platforms [ID 469082.1]" or "How to setup ASM on Windows [ID 331796.1]"


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

Post Details

Locked on Nov 12 2008
Added on Oct 15 2008
#business-intelligence-applications, #data-integrator, #filter, #system-management-and-integration, #variable
6 comments
548 views