Retail Predictive Application Server (MOSC)

MOSC Banner

RPAS date function mace caught Exception: IllegalParse: Parse

edited Feb 19, 2015 6:39AM in Retail Predictive Application Server (MOSC) 4 commentsAnswered ✓

Hi,

I am trying to load a measure with a date through a rule with the use of date function in master domain like this:

mace -d . -run -expression "daytoexport = date("20150218","%Y%m%d")"

Now executing mace in domain

mace caught Exception: IllegalParse: Parse of - daytoexport = date(20150218,%Y%m%d) resulted in syntax error at -11.

mace exited with status: 4

The specs for the measure daytoexport

SPECS FOR MEASURE: PGAPPDATE01

------------------------------

label:              Profile Approval Date 01 week->dow Final

type:               4 (date)

baseint:            str_item

navalue:            0001/01/01 00:00:00.000

defagg:             AMBG

defspread:          REPL

allowedaggs:        ''

range:              01011700:12312200

refreshable:        true

db:                 data/pgappdate01

insertable:         true

basestate:          1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center