Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
gizzel123
Contributor

Unable to extend temp segment by 128 in tablespace TEMP

Hi All,

I am creating a QVD with the SQL Script. Previously it  was loading fine, but now it has started failing throwing this error:

unable to extend temp segment by 128 in tablespace TEMP.


Please advise.


Thanks.

3 Replies
Highlighted
rajkumarb
Contributor II

Re: Unable to extend temp segment by 128 in tablespace TEMP

Highlighted
MVP
MVP

Re: Unable to extend temp segment by 128 in tablespace TEMP

You should contact the DBA of the SQL database as the SQL query seems to have a problem executing due to not enough temporary space for some reason. This might be because of sorting, indexing, joins which we could only guess at since we don't see your SQL query. But your DBA should be able to analyze the query and change either the query, extend the tablespace TEMP or create the right indexes so it will execute successfully again.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Unable to extend temp segment by 128 in tablespace TEMP

That is an oracle error that has nothing to do with your qvd or qlikview. Contact your local friendly oracle database administrator. He/she can increase the size of the TEMP tablespace, but perhaps can also help you create a more efficient query to retrieve the data you need.


talk is cheap, supply exceeds demand