[Microsoft][ODBC Microsoft Access Driver] Syntax error

general discussion
1

Hi,

I have 2 different universe but connected to the same database (DB2).

When i run 2 different webi reports, (connect to 2 different universe), I receive the following error message in one of the report. Another report which using second/another universe is working fine

Error Message:-
“A database error occured. The database error text is: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression (WIS 10901)”

Any solutions please?

stupidcute (BOB member since 2009-08-19)

2

Problem solved. TQ

stupidcute (BOB member since 2009-08-19)

3

Hi,

Can you share the solution please?

In future, BOB members may find it useful.

Thanks.

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

4

Well, my problem is because in CMC under universe. I saw there are 2 same universe name inside and outside the folder.

Solution : - Reimport the universe and move the universe into folder.

stupidcute (BOB member since 2009-08-19)