Webi LOV error

building reports webintelligence
1

I’m using default bo webi report
Average Number of Users Logged In.
It does not show list of values. When i press refresh values it gives:

Invalid database field type : LPAD(YEAR(WA_SESSION.SESN_START), 4, ‘0’) (WIS 10903) (Error: INF ).

Cant seem to find out why this is happening.
When I import database using import wizart into dev server then thewebi lov works.

XIR2 MySql

tannx :estonia: (BOB member since 2006-02-20)

2

Check the field type in universe for the object vers database field type

pkommidi (BOB member since 2006-03-10)

3

Mysql 3.51.24 odbc driver caused problem.
Works fine with version 3.51.12

tannx :estonia: (BOB member since 2006-02-20)