Skip to content
+1-888-319-3663

COMMUNITY FORUM

Invalid Defined Tenant

Jeff Smith asked 4 years ago
Has anyone seen this error and any advice on how to resolve?
 
thanks!
Answers
Lorren Zemke Staff answered 4 years ago
Jeff,
I am assuming your destination is Dynamics GP but the process will be similar for Dynamics CRM/SQL Tables/SQL Procedures.
Go to the Companies button on the destination. Click on the Define button.
Make sure the script is valid and the logic is valid as well.
Also, make sure the databases/organizations that are selected, if any, are correct.
Lorren
Jeff Smith answered 4 years ago
Lorren, 
All of my integrations on this one work except for the two that case start with “F” Here is the company define logic we use…
Select Case _F6
 
Case “F590”
Return “CO”
Case “X067”
Return “CBI”
Case “X064”
Return “CCC”
Case “X065”
Return “CCO”
Case “X066”
Return “ABO”
Case “X068”
Return “CFM”
Case “X416”
Return “AC”
Case “X985”
Return “ET”
Case “X999”
Return “COBO”
Case “F649”
Return “CHQ”
 
Case Else
 
Return String.Empty
 
End Select
 
Any other suggestions?
Mark Anderson Staff replied 4 years ago

Jeff, I am assuming your case statement has a value that is not listed so the "Case Else" statement processes and you get an Empty database name. Try the case on _F6.TRIM() instead of _F6 to trim any trailing spaces. If that does not work, add a test company database name in your "Case Else" and see if the gets rid of your "Invalid tenant" message<br><br>Also validate the Company Databases you are returning are accurate.<br>


If you would like to submit an answer or comment, please sign in to the eOne portal.