We have been noticing this issue recently in some servers. TNS fix 20 is the latest fix installed, other servers having the same fix level is working fine. I tried checking the console after uninstalling TNSfix20, still got the same issue with the previous fix too.
I was just importing some partner profiles and processing rules while checking the functionalities affected by this behaviour.
One more error observed while starting the console from CMD using console.bat:
“Exception in thread “Thread-2” Exception in thread “AWT-EventQueue-0” Exception in thread “AWT-EventQueue-0” Exception in thread “AWT-EventQueue-0” java.lang.ArrayIndexOutOfBoundsException: 512”
Check JDBC Pools related to TN,it should be good other wise problem is with database
2)Try to open TN table and see content of profiles table,if feel every thing is fine
Lastly,if it is non production box,try to connect these pools to Sandbox/testbok where fix hasn’t installed,if it is good problem with current TN only.Contant SAG support
Checked the TN DB pools, They are fine. Checked by changing the TN DB schema: console works fine if the affected machine is connected using the working server TN DB schema. Seeing same issue when reverted back to the original TN DB schema. It seems issue is with the TN schema.
You found the issue is schema.Now you can check with DBA for any fixs happened in database
Ask them possibilty of roll back to TN database schema to working date or try to catalog on working & non working,you can find some more information on the issue related to schema
Let me know if you resolved it and how it has happened
This issue is now resolved. Issue was because of many duplicate entries of extended Profile fields belonging to a particular field group. After deleting the duplicate entries from the respective tables, the console started working fine.