Temp File - “sqla0001.tmp”
Hi All,
We had recently upgraded our NBU OpsCenter server from v7.5.0.6 to v7.6.0.2, As per Symantec recommendation/steps we had performed the upgradation activity and it was successful one.
Post the upgradation, I could see there is a temp file “sqla0001.tmp” created in the C:\ drive which occupies 10 GB of space, this resulted in creating a P2 incident daily which the drive space is occupied by the temp file. Also its taking a long time to generate the reports manually.
As per the tech note http://www.symantec.com/business/support/index?page=content&id=TECH152870 I have changed the location of this file from C:\ drive to D:\ drive (OpsCenter software is installed in this drive)and this file was having more than 70 GB of free space, However after changing the path this file grows massively and created a temp file as “sqla0001.tmp” in D:\ drive which occupies 57+ GB of space. This resulted P2 incident for space crunch in D: drive.
Also i do not have any idea why this file has grown rapidly from 10+ GB to 50+GB.
Could someone help me out to fix this issue, it would be appreciated if this temp file is disabled/not created in any of the directory.
Kindly help me on this , Thanks !