cancel
Showing results for 
Search instead for 
Did you mean: 

WIS errors

Former Member
0 Kudos

Hi, I need some help in figuring out what some error messages are.

I get (WIS 00013)- SQL generation failed. when i try to grab a dimension and run a query on it.

I also got WIS 10901 that there is a database error.

Does this mean that there is a problem with my database? Is there no related table?

Thanks in advance!

p

Accepted Solutions (0)

Answers (1)

Answers (1)

denis_konovalov
Active Contributor
0 Kudos

What are the exact error messages ?

What is the exact product version and patch level you're using ?

OS ?

DB Drivers ?

Former Member
0 Kudos

I am using BOXIr2

WEBI

The exact message was

Database Error : [Microsoft OLE DB Provider for SQL Server] : the column prefix 'vwBO_TM_scenariobybay' does not match a table name or alias name used in the query.

denis_konovalov
Active Contributor
0 Kudos

If you do a refresh structure for the universe in question in designer - any messages ?

If you use ODBC instead - any change ?

How long it takes to get the error ?

If you put a filter or limit # or rows returned to 1 - will it complete ?

Former Member
0 Kudos

not sure how to do a refresh structure on the universe

but the error message come up right away

tried a filter/row limit and it still wont run the query,

I am wondering if there is something wrong with the DB itself, that there is not relation to a table that BO can detect

denis_konovalov
Active Contributor
0 Kudos

Open universe in Designer, go to View>Refresh structure - see what happens.

Former Member
0 Kudos

dont have access to that...ugghhhh so frustrating.

I dont even have access to see what is in the DB, see if a table was changed/deleted

Thanks soooo much for your help. Honestly, i learn so much from you guys, so glad you guys are an available resource

denis_konovalov
Active Contributor
0 Kudos

it's going to be tought without such access. As BOE admin you need access to all the data/tools BOE is using or treporting from to be able to manage/support this environment.