Unable to launch the application(Invalid login), Log file reports Diccache.dat file error

This error is commonly seen when Oracle DB is used.

Common Errors reported

1. Srvrtblcleanup errors
2. Can't read Diccache.dat file
3. Invalid username or password

Resolution Steps:

Add the following four params in regedit for

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\<Oracle driver>

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<DS name>

i)     ColumnSizeAsCharacter =1

ii)     ColumnsAsChar = 1

iii)     EnableScrollableCursors = 0

iv)     packetsize =0

Delete the existing diccache.dat file created in BIN folder and re-launch the application