Migration Issue

general discussion
1

Hi All,

I have a migration issue in the universe when i started migrating
the 6.5 universe to xir3…

These are the codes in both version. the object gets parsed in 6.5
but not in XI

6.5

exists
  (select 'x'
   from dimle.xd_day_dt b
   where  b.CAL_DT between @Prompt('1. Enter Begin Date (mm/dd/yyyy)', 'D', , mono,constrain) and @Prompt('2. Enter End Date (mm/dd/yyyy)', 'D', , mono,constrain)
  AND DIMLE.XD_DAY_DT.Day_dt_dim = b.day_dt_dim
  )

xir2

exists
  (select 'x'
   from dimle.xd_day_dt b
   where  b.CAL_DT between @Prompt('1. Enter Begin Date (mm/dd/yyyy)', 'D', , mono,constrain) and @Prompt('2. Enter End Date (mm/dd/yyyy)', 'D', , mono,constrain)
  AND DIMLE.XD_DAY_DT.Day_dt_dim = b.day_dt_dim
  )

i get a invalid definition unv 0023 when i try to parse in xi…
can anybody please help me with this.

Thanks In Advance

[Moderator Edit: Added code formatting - Andreas]

rekha (BOB member since 2008-06-08)

2

Maybe it’s not the root of the problem but the keyword in @prompt function is constrained and not constrain.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

then can you please tell what could be the issue…i had no issues migrating
universes earlier…i dont know whats wrong with this universe…

rekha (BOB member since 2008-06-08)

4

Hi

The syntax is correct and its parsing on my machine, could you try it once by replacing it again…?

CYCLE.ORD_DATE between @Prompt(‘1. Enter Begin Date (mm/dd/yyyy)’, ‘D’, , mono,constrain) and @Prompt(‘2. Enter End Date (mm/dd/yyyy)’, ‘D’, , mono,constrain)

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

5

I tried parsing it and it works fine in 6.5 and in XIR3 i get the
error…

Parse failed : Invalid definition (unv0023) error parsing free/constrained /primary-key parameter (5th parameter)

can you help with this error…

rekha (BOB member since 2008-06-08)

6

I have already written: Change the 5th parameter of @prompt function from constrain to constrained

Marek Chladny :slovakia: (BOB member since 2003-11-27)

7

I changed it to constrained and its still not working…

rekha (BOB member since 2008-06-08)

8

I get the same error when migrating from 6.1.3 to XI 3.1.
Does anyone know anything about this?

My code is:
((@Select(BUT\But Name)=@Prompt(‘Organisation Name’,‘A’,‘BUT\But Name’,mono,free)
or
@Select(BUT\But Rc Code)=@Prompt(‘Organisation RC Code’,‘N’,‘BUT\But Rc Code’,mono,free))
and
@Select(BUT\But Start Date)<=@Prompt(‘Evaluation End Date’,‘D’,mono,free)
and
nvl(@Select(BUT\But End Date),to_date(‘31/12/2999’,‘dd/mm/yyyy’)) >= @Prompt(‘Evaluation Start Date’,‘D’,mono,free))

The object is actually a condition. It parses OK in 6.1.3 and in XI I get the error: Parse failed: Invalid definition (UNV0023).

gratzy (BOB member since 2009-01-26)

9

Hi All,

Any update or workaround further on this issue.? It would be great help to other memebers if you can share the workaround.

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

10

Have you tried to debug it by simplifying the object, eliminating between and prompt function parameters? That’s what I usually do in the situations like this.

icotler :us: (BOB member since 2002-08-19)

11

This is the best way to identify the problem in the code and if its not helps, i would suggest to re-create the formula again on the object.

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)