on 06-25-2015 3:19 PM
Hi Vinay,
Removing IDT from picture, when you simply write a SQL joining these tables against database directly, does the query executes properly or do you receive any error?
This will help us in troubleshooting on which level does the issue exist.
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How many columns do you have in each of these tables? Since this is a Database error, use MS SQL server studio and try to create a simple query with the same join. If you get the same error (for sure you will) try selecting only top N rows to see if it works.
"Arithmetic Overflow" error occurs when the limits of the data types used are breached.
The issue could be that you are exceeding the # of rows (defined by the integer type limits) while creating the joins.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinay,
It seems like your schema is not updated in IDT.
So I will suggest you to go to Action tab and click on Refresh structure to refer all the tables structure.
After refresh please check your code again.
Thanks,
Swapnil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I dont think WERKS underwent any change in the data type, other then my Data Services job which updates the MARC and Faield fact table where WERKS is part of those tables. But that's data refresh nothing more then that.
With that being said, have published the Universe in the repository and my WEBi reports are working fine.
So, just curious shall i move the Universe to QA or will there any negative impact??
Hi,
It seems issue with Plant and Werks data type.Check the data type of these objects in the SQL server.
Use bigint instead of int data type in database and then try in universe.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.