Robot gets struck while running the execute query for the larger data

News Knowledge Base
1

Robot gets struck while running the execute query for the larger data.

Task #1: Update Oracle Database Connection String

Objective: Incorporate the (ENABLE=BROKEN) setting into the OracleDatabaseConnectionString.

  • Connection String Before:

Server=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[HOST])(PORT=[PORT])))(CONNECT_DATA=(SERVICE_NAME=[SERVICENAME])(SERVER=DEDICATED)));User Id=[USERNAME];Password=[PASSWORD];

  • Connection String After:

Server=(DESCRIPTION=(ENABLE=BROKEN)(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[HOST])(PORT=[PORT])))(CONNECT_DATA=(SERVICE_NAME=[SERVICENAME])(SERVER=DEDICATED)));User Id=[USERNAME];Password=[PASSWORD];

Task #2: Create KeepAliveTime Registry Setting

Objective: Establish the KeepAliveTime Registry Setting on each robot server.

Steps:

  1. Open Registry Editor as Administrator: Type "regedit" into the Search textbox.
    • Right-click on Registry Editor App and choose "Run as administrator."
  2. Navigate to Registry Path: Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
  3. Create a New DWORD Value: Right-click on the Parameters folder.
    • Select "New" > "DWORD Value."
    • Rename the new key to "KeepAliveTime."
  4. Modify KeepAliveTime Value: Right-click on the "KeepAliveTime" parameter.
    • Click "Modify."
    • Enter the desired time value in milliseconds (1000 = 1 second) in the "Value data" field.
    • Set the Value to 90000.
  5. Apply Changes and Restart: Click "OK" to confirm changes.
    • Exit the Registry Editor.
    • Restart your computer to activate the KeepAliveTime setting.

By following these steps, users can update the Oracle Database Connection String and configure the KeepAliveTime Registry Setting on their Robot servers. If any issues arise or if additional assistance is needed, raise UiPath support ticket. .