Column PasswordQuery does not exist.

While I am trying to open Person object I am getting the following error:

[810019] Could not create single object for table Person.
[810306] Error during execution of 'OnLoaded' in logic module 'VI.DB.Entities.EntityScriptLogic'.
[810186] Error executing script for event OnLoaded.
[810222] Error executing script 'Person_OnLoaded'.
[810271] Column PasswordQuery does not exist.

Can you please advise how to fix it?

Version: 8.1.4

Top Replies

kamil brzakala over 3 years ago in reply to kamil brzakala +2 verified

Ok, I have found a workaround.

In Person schema -> Script (OnLoaded) I have commented out these two lines:

Base.Columns("PasswordQuery").CanEdit = False
Base.Columns("PasswordAnswer").CanEdit…

Parents

0 Trevor Pike over 3 years ago

Hi,

It sounds like you are using the Password reset portal. Have you defined the questions and answers?

Trevor
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 kamil brzakala over 3 years ago in reply to Trevor Pike

Hi, Well that portal was never installed. The issue appeared right after version upgrade from 7.1 to the latest.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
+1 kamil brzakala over 3 years ago in reply to kamil brzakala

Ok, I have found a workaround.

In Person schema -> Script (OnLoaded) I have commented out these two lines:

Base.Columns("PasswordQuery").CanEdit = False
Base.Columns("PasswordAnswer").CanEdit = False

BTW, maybe these columns are in use with a module which I don't have installed.
Cancel
Up +2 Down

Reply

Reject Answer

Cancel
0 Markus Weiss-Ehlers over 3 years ago in reply to kamil brzakala

These two lines seem to be part of a customization of the Person.OnLoaded script. The OOTB script does not contain these lines in 8.1.4.

The mentioned columns have been removed from the Person table as OneIM now supports to provide more than one PasswordQuery and Answer per Person.

This has nothing to do with an uninstalled module.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 Markus Weiss-Ehlers over 3 years ago in reply to kamil brzakala

These two lines seem to be part of a customization of the Person.OnLoaded script. The OOTB script does not contain these lines in 8.1.4.

The mentioned columns have been removed from the Person table as OneIM now supports to provide more than one PasswordQuery and Answer per Person.

This has nothing to do with an uninstalled module.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data