OBIEE 11.1.1.5 : NQS temp files fill the disk space
935931May 8 2012 — edited May 15 2012Hi guys,
I've a big issue with muliti-database query.
My RPD has two Connection Pools: Oracle's one for dimensions and Teradata's one for facts.
The problem is in running queries that involve both Connection Pools: the temp files come to occupy more then 5GB, running out of disk space dedicated.
The strange thing is that in development environment all is right... but in production environment, where I've a cluster of 3 bi_server, I've this issue.
In development obiee querys Teradata tables otherwise in production it queries Teradata view. The amount of data is not very large, but for reasons unknown to me I've to put fact table into a teradata DB.
Could I probably solve this increasing the disk space?
Do I need to specify particular join between fact and dimensions or other implementations in repository?
SOS!
Thanks in advance!
Regards,
Tom