Webi timestamp error

[Former Member]

Hi

when i try to run a report with a data parameter and i am getting this following error

A database error occured. The database error text is: (CS) "Unexpected behavior : Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]" . (WIS 10901)

I have change the object format at the universe as well and but still doesn't work

Now i am using this function   CONVERT(DATE, ActivityDate, 102)

but no luck again

[Former Member]

Amar,

Use the format as DD/Mmm/YYYY

[Former Member]

Hi Amar,

Which value are you passing to parameter?

Is it constant or from lov or result from other query?

And what is your back end database?

Regards,

Aashutosh

[Former Member]

the value are constant using the calendar  and when i Try to use the LOV it shows me the error, i mentioned in previous post.

Back end database is SQL server and date is in mm/dd/yyyy format

regards

amar

[Former Member]

Hi Amar,

If you have MS Sql server database access then try querying against the table from which you are referring date object definition.

Alternatively, you can get SQL which is used by BO to list down LOV values and try executing that at database level and see if you get any error. While connecting to database, use same user id and password you used in universe connection. This will help us to identify if there are any data quality issues are there or not.

Regards,

Aashutosh