You are viewing limited content. For full access, please sign in.

Question

Question

Forms-"An error occurred while importing this process from the Solution Template [LFF2607-CannotimportProcessFromBPL]"

Forms Version 11 Business Processes
Updated July 8, 2022
asked on July 1, 2022

Hello,

Customer is trying to import various Solution Templates in Forms. When they do try to use the Import Process in the Forms Designer, they get the following error:

"An error occurred while importing this process from the Solution Template [LFF2607-CannotimportProcessFromBPL]"
 

They have tried at least 4-6 different templates with the same outcome.

They are able to download the process.

They are on Forms Version 11.0.2106.10367

Anyone else seeing this issue?

Appreciate the feedback,

Jeff Curtis

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on July 7, 2022 • Show version history

Hey Jeff,

Thanks for the poke. 

The Inner Exception error shows a clear SQL permissions issue.

Inner exception: System.Data.SqlClient.SqlException

Message: The EXECUTE permission was denied on the object 'Forms_IdList', database 'LFForms', schema 'dbo'.

Start by verifying that the account Forms is using to connect to its LFForms database has the db_owner database-level role there.

Some of the best troubleshooting advice I ever got (thanks @████████!) was "Read the stack trace until you find a line that shows where the error is really coming from".

Though they can look intimidating, and most of the lines of most of them are gibberish to me, there's a reasonably clear error message hiding in plain sight in there a good portion of the time. Even when there's not, looking at the function calls can usually help point me in the right direction for further troubleshooting (e.g., seeing something fail at "Login(username, password, repository)" points toward some kind of authentication error).

1 0

Replies

replied on July 1, 2022

Hi Jeff,

Is there a corresponding detailed error message in the Forms event log? If so, can you paste it here including the full stack trace?

0 0
View 1 previous reply
replied on July 1, 2022

Hey Sam,

Attached the full stack trace from Forms->Admin Event Log at the time of the error.

Thanks,

Jeff

Forms Error 070122.txt (3.07 KB)
Download
0 0
replied on July 7, 2022

Hey Sam,

Checking back with you to see if you had a chance to look at the Stack Trace.

Thanks,

Jeff Curtis

0 0
APPROVED ANSWER SELECTED ANSWER
replied on July 7, 2022 • Show version history

Hey Jeff,

Thanks for the poke. 

The Inner Exception error shows a clear SQL permissions issue.

Inner exception: System.Data.SqlClient.SqlException

Message: The EXECUTE permission was denied on the object 'Forms_IdList', database 'LFForms', schema 'dbo'.

Start by verifying that the account Forms is using to connect to its LFForms database has the db_owner database-level role there.

Some of the best troubleshooting advice I ever got (thanks @████████!) was "Read the stack trace until you find a line that shows where the error is really coming from".

Though they can look intimidating, and most of the lines of most of them are gibberish to me, there's a reasonably clear error message hiding in plain sight in there a good portion of the time. Even when there's not, looking at the function calls can usually help point me in the right direction for further troubleshooting (e.g., seeing something fail at "Login(username, password, repository)" points toward some kind of authentication error).

1 0
replied on July 8, 2022

Hey Sam,

Thanks for the Pointer as the DB Account in the Forms Configuration did not have the db_owner roll assigned.

Updated that and was successfully able to download a BP from the Solutions Library.

Appreciate the help,

Jeff Curtis

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...