JAMS Install - Database Error: "Profile Name is Not Valid"

Follow

During JAMS installation, users may encounter a database error, "Profile Name is Not Valid," similar to the message below:

Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Error SQL72014: .Net SqlClient Data Provider: Msg 14607, Level 16, State 1,
Procedure sysmail_verify_profile_sp, Line 42 profile name is not valid

 


Why am I seeing this error?

The error occurs when the database instance has a database creation email trigger set, and one of the following is true:

  • The user creating the database is not authorized to access the mail profile referenced in the database trigger.
  • The mail profile specified for the database trigger does not exist.

 


Where will I find the error message?

Navigate to the DBUpdate.log file located at C:\Program Files\MVPSI\JAMS\Scheduler\ by default. Right-click on the file, and open with Notepad or a code editor. Search for "An error occurred" (omitting the quotes).

Below is a sample of the error block within a DBUpdate.log file. Your error message may vary.

Profile_Name_is_Not_Valid_10.05.18.png

 


How do I resolve this error?

  • Ensure that the user who creates the database is authorized to access the mail profile associated with the database trigger.
  • Verify a mail profile exists or create a mail profile to specify in the database trigger.

If the above does not resolve this error, you may try re-installing the database on a different server that has the appropriate configuration. MVP highly recommends contacting a Customer Success Engineer prior to taking this action.

 

 

Have more questions? Submit a request

Comments