Error when trying to list accounts??

  • CryptoGuy
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
5 years 9 months ago #22348 by CryptoGuy
Error when trying to list accounts?? was created by CryptoGuy
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.

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
5 years 9 months ago #22350 by VK
Replied by VK on 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

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

  • CryptoGuy
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
5 years 9 months ago #22352 by CryptoGuy
Replied by CryptoGuy on 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.


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
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
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
5 years 9 months ago #22353 by VK
Replied by VK on topic Error when trying to list accounts??
Hi
thanks for sharing the solution!

Cheers
VK

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

Time to create page: 0.045 seconds