Error when trying to list accounts??

  • CryptoGuy
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 17
  • Thank you received: 1

CryptoGuy created the topic: Error when trying to list accounts??

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.
#22348

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 654
  • Thank you received: 93

VK replied the topic: Error when trying to list accounts??

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.

Cheers
VK
#22350

Please Log in or Create an account to join the conversation.

  • CryptoGuy
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 17
  • Thank you received: 1

CryptoGuy replied the topic: Error when trying to list accounts??

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
#22352
The following user(s) said Thank You: VK

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 654
  • Thank you received: 93

VK replied the topic: Error when trying to list accounts??

Hi
thanks for sharing the solution!

Cheers
VK
#22353

Please Log in or Create an account to join the conversation.

Time to create page: 0.242 seconds