Question

Error 9220 when Registering a New External Table in Admin Console

Version 9 Laserfiche

Updated May 29, 2018

asked on April 8, 2014

I'm on LF 9.1, and I have created a new table in SQL for my development database. I want to use this new table for dynamic fields in my template. I'm getting an error when trying to register a new external table. The name of my table that I created is customer_information_database. When I try to register, I get the following:

Error Code: 9220
Error Message: Invalid Laserfiche external table name. The maximum length of the name should not exceed 63 characters and should contain only letters (a-z/A-Z), numbers or underscores. [9220]

------------ Technical Details ------------

LFSO:
    Call Stack: (Exception)
        CLFQueryExternalDB::Create
    Additional Details:
        HRESULT: 0xc0042404 (LFSession::ProcessResponse, LFSession.cpp:3815)
         (LFSO/9.1.1.453)
LFAdmin.dll (9.1.1.486):
    Call Stack: (Current)
        CExternalTable1PropPage::OnApply
    Call History:
        CExternalTable1PropPage::OnInitDialog
        CExternalTable1PropPage::OnApply
        CExternalTable1PropPage::OnApply

Tried to look this up on the support site and read the following:

This documentation is specific to version 9.1. You can find the most up-to-date help files for the latest version at Current Online Laserfiche Product Help Files.

When I follow the link, it just takes me in a loop back to the above statement. Anyone seen this and know what the problem is?

0 0

Answer

SELECTED ANSWER

replied on April 8, 2014

When registering the new external table in the Laserfiche Administration Console, please make sure that the alias you are using follows those rules regarding not exceeding 63 characters and only containing letters, numbers, or underscores.

1 0

Replies

replied on April 8, 2014

Well that answered it... it worked. But I thought that the alias could be anything we wanted, per #6 of this article:

http://www.laserfiche.com/support/webhelp/Laserfiche/9.0/en-US/AdminGuide/LFAdmin.htm#Manage_External_Table.htm?Highlight=external%20tables

Is this an issue or change with 9.1, or has this always been the case and the article needs to be corrected?

0 0

replied on April 8, 2014

You're right, it needs to be added to that page. I'll make sure that happens--thank you for pointing it out!

0 0

replied on April 8, 2014

Thanks for reporting this to us. There are two issues here:

The error message you get should be changed to clarify that the alias is the invalid item and needs to follow the specified rules.
The documentation needs to be changed as the alias cannot be any name.

As for the actual table name, it should accept any valid name that the DBMS allows for. One thing to note is that if the table name contains spaces, you'll need to enclose the name in double quotes when registering the external table in Laserfiche.

0 0

replied on May 29, 2018

Lol. I was frowning for 25 minutes wondering why it tells me my table name is wrong when it is 100%!!

Thanks guys - Cheers

0 0

You are not allowed to follow up in this post.

Question

Question

Error 9220 when Registering a New External Table in Admin Console

Answer

Replies

Sign in to reply to this post.