Invalid Defined Tenant
Jeff Smith asked 6 years ago
Has anyone seen this error and any advice on how to resolve?
thanks!
thanks!
Answers
Lorren Zemke answered 6 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
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 6 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?
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 6 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>