Problem:

ORA error occurred in the server log, while upgrading from 6.0 to 2005

Resolution:

• Product Name: StarTeam
• Product Version: 2005
• Product Component: Server
• Platform/OS Version: Windows

Description:

The following ORA error occurred in the server log, while upgrading from 6.0 to 2005:

"15 00000004 2005-06-28 08:59:16 Exception handled at CStServer::Run: Class = CDBException, Code = 4294967295(0xffffffff)
Msg = ORA-01013: user requested cancel of current operation

[Table Name] = ViewMember
[Function Name] = CStDbObjectSet::Query
[ODBC Error] = State:S1T00,Native:1013,Origin:[Oracle][ODBC][Ora]"

Answer/Solution:

Error: ORA-01013: user requested cancel of current operation

This is an Oracle database server error. This error can be generated in response to timeout errors.

Timeouts (whether explicitly or implicitly specified or reported) are a frequent cause of ORA-01013. This can be difficult to identify because a timeout may not be explicitly reported as part of the error.

Workaround:
- Disable the "Enable Query Timeout" flag in the ODBC Driver Configuration of the driver.

- Change the CPTIMEOUT in the system registry key under: HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIOracle to "0".

Note: This error can seen when a database monitor is running against an Oracle database. You can change the value of the timeout for the monitor. Either increase the value of CPTIMEOUT or set the value to 0. If you choose to set the value to 0, be aware that this may cause monitors to skip.

Author:Rajini Billahalli