No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


U2000 report server can not generate report due to the abnormal tempdb

Publication Date:  2012-07-25 Views:  112 Downloads:  0

Issue Description

Customer T complain that U2000V1R2C01SPC100 report server can not generate any report, the result is empty.

Alarm Information


Handling Process

1.Check the performance graphic in U2000 performance monitoring management, the graphic can come.
2.In U2000 administartion > NMS Security > NMS User Management i can find report user have enough right.
3.I find the U2000 report an alarm "Tempdb is full", check its status in U2000 system monitor, the Usage of Tempdb is 100%.
4.Restart the U2000 and databse, space of the tempdb is released,report server can generate report too, but I find the usage of Tempdb grow very quikly when i generate a report in report server.
5.FSE told me they upgrade the U2000 from spc003 to spc100 on last week, but do not upgrade the report server.I confirm this is the root cause.
6.Report server will get data from the U2000 database, many reading operations can not finished because of the inconsistent version between report and U2000, these operation will cost the tempdb.
7.upgrade the report server to corresponding version with U2000, the problem resolve.

Root Cause

1.There are not performance data in the U2000 performance management.
2.Do not add enough right to the report user in U2000 User management.
3.Database of U2000 is abnormal.


Pls upgrade the report server when you upgrade the U2000.