Skip to Content
0

Deployment issue with Refresh structure in IDT

Jul 07, 2017 at 01:35 PM

73

avatar image
Former Member

Hi Folks,

We have a strange issue. Whenever a column is added to DB, we refresh universe in IDT and publish. It works fine in our environment. We can pull that object in webi report and run report. But problem is when code is deployed to other envioronment.when i validate object or use it in universe query or report, We are getting error that column not found in table.Object is present in Database Table and Universe table.It gets fixed when universe is refreshed and without even publishing. Has anyone faced this issue and why it occurs?

It happens with only with multi source universe. Single source works fine.

10 |10000 characters needed characters left characters exceeded

Hi,

Do you have any row level or object level security within universe?.

Does these "Other Group" has enough access to those objects within that security group?.

Thanks,

Jothi

0
Former Member

Hi Jyothirmayee,

We don't have row level or object level security in universe.

Thanks,

Sheshidher

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arijit Das Jul 07, 2017 at 04:00 PM
0
It gets fixed when universe is refreshed and without even publishing

Do you get any message on what is changed after you refresh the universe ?

Does the issue persist after you restart SIA ?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

No we didn't got any new column while refreshing structure. Didn't tried restarting SIA

0