Hi all,
I've a test enviornment, whenever I try to list accounts (e.g ACCOUNT L) , I get the following error :
"ERROR IN EXEXCUTION OF SELECT COMMAND"

I'm running R18 TAFJ.

How to fix this ?


Thanks.

Hi
what if you type LIST Fxxx.ACCOUNT (e.g. FBNK.ACCOUNT) in command prompt or however it's called in TAFJ?

Probably it will give you the exact error.
Usually it has something to do with @ dictionary entry containing wrong field among others.

In that case rebuilding SS record might help.

VK wrote: Hi
what if you type LIST Fxxx.ACCOUNT (e.g. FBNK.ACCOUNT) in command prompt or however it's called in TAFJ?

Probably it will give you the exact error.
Usually it has something to do with @ dictionary entry containing wrong field among others.

In that case rebuilding SS record might help.

Hi VK,

The problem is solved now, thanks. Here what happened :
So when I listed the accounts in DBTools using "LIST-ITEM FBNK.ACCOUNT", it was fine.
Then changed mode from "JQL" to "SQL" ( I'm using SQL Server as the backend database) and tried "SELECT * FROM V_FBNK_ACCOUNT"
the same error occurred again and fortunately it had the hint for fix :)
It said "clr options not enabled" , enable clr config.

After a little google search, here the sql command that solved it, so it may help maybe anyone facing this issue.

-- show advanced options
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO

-- enable clr enabled
EXEC sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

-- check if it has been changed
EXEC sp_configure 'clr enabled'
GO

-- hide advanced options
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO

Hi
thanks for sharing the solution!